Database Application Development Training
EduCBA
Summary
- Exam(s) / assessment(s) is included in price
Overview
Interested in learning everything about website development? You cannot miss out on database application development if that’s the case. Databases are an organized means of storing, retrieving and managing information, and form the backbone of a website. This is not for those who want to simply use a CMS to build a simple website. It is also not for those simply interested for good website design. This course delves into the world of hardcore database application development training.
About Databases And Database Applications
The world of databases can be rather confusing, but this course makes it a lot easier. When you develop a database-dependent website or an ecommerce site, data management becomes a critical part of the website development process. Before you look at the more flashy elements of your website, you need to set up your database so that your site retrieves the right data at the right time and puts it up in the right place.
To understand the working of a database, think of a basic Excel file with its usual rows and columns. The columns have specific information types and fields. In case of an ecommerce site, it would contain information types like product price, name, color and other fields. The rows contain the actual information for the columns. Now, if you want your customers to search and sort the different products by fields such as manufacturer/designer, color and price, you need to create a table that includes all those fields.
Visit your favorite ecommerce site and take a look at all the amazing options they have for sorting through mountains of data. That critical ability is what makes them so popular. If you plan on making a site like that or any site that uses lots of data, database application development is absolutely vital. It sounds like hard work and it is hard work, but it is what separates a good site from the rest.
And what if you lack the data in the first place? Well, limited data only lets you do so much. You can still make a great-looking site, but you would limit the ability of a website visitor to browse your site and find the product they want.
As you can see, great data forms the foundation for a good website and user experience. This course helps you learn everything about database application development, from the basics to coding.
Database management systems (DBMS) are software programs that enable a computer to perform these functions of adding, storing, deleting, modifying and retrieving data. Relational database management systems (RDBMS) follow a relational model for tables and relationships. Oracle and Microsoft Access are among the most popular DBMS right now.
This course focuses on one particular DBMS: Oracle 11g.
Oracle Database 11g is a beginner-level database with a small footprint. It is free to develop, distribute and deploy. It is also easy to download and simple to register. For a newbie web developer, this is the perfect starter database to work on XML, .NET, PHP, Java, Python and other languages.
The Oracle 11g is installable on host machines of any size, with any number of CPUs. An Oracle database is an RDBMS, which has object-oriented features like polymorphism, inheritance and user-defined types. It also uses the concept of database schemas, which are collections of logical data structures also known as schema objects. This enables that physical data storage is independent from logical data structures.
All the data operations that are performed in Oracle 11g or any other Oracle database use SQL statements. SQL is a language that offers an interface between user and the database. It is non-procedural, which means that users can specify the result that they want rather than how to derive it.
This course focuses on the use of PL/SQL, which is a procedural extension to the SQL used for Oracle. PL/SQL is integrated with the database, which enables you to use Oracle database SQL functions, data types and statements. One major benefit of PL/SQL is that it allows you to store application logic within the database. With this server-side programming, you can deploy the inbuilt functionality anywhere.
Description
Oracle Database Architecture
An Oracle database requires a server for information management and to manage the huge amounts of data present in an online environment. In Oracle, a database server consists of one database and one or more ‘instances’. An instance and database are very closely connected, which is why both terms can be used interchangeable in normal parlance. However, a database instance is different in that it is a set of memory structures for managing database files.
Course Description
With the basics of databases clear, here is a look at what you get to learn with this course:
Section 1: Introduction
We start with the downright basics, exploring what databases are in greater detail and what is the role of database applications. We look into how databases help run websites, and their critical role in the overall online experience you are trying to build. The section concludes with a discussion of all the languages used for database development, including SQL, Java, Python and more. The key language to learn here would be SQL.
1. Course Overview
2. What Is Database And Application
3. Languages Used For Development
Section 2: Oracle Environment
Next, we get introduced to the DBMS that you will be using extensively for the rest of this course: Oracle. We explore the structure of an Oracle database, which we very briefly touched upon in the previous segment. We go further into database and database instance structures, storage structure and the application architecture which will be the computing environment where the database application connects to the Oracle database. The section covers the languages and tools used for working on Oracle, with a special focus on the most important language: SQL.
4. Environment For Oracle Database
5. Languages And Tools For Oracle Database
6. Structured Query Language
7. Advantages Of SQL
Section 3: Properties
Now, we have ended the basics. You should be familiar with the fundamentals of databases and the tools and languages to be used. With that clear, this section jumps into further details regarding databases an SQL properties and database application operations. It introduces the key concept of Atomicity, Consistency, Isolation, Durability (ACID) properties for databases.
8. Database, SQL Properties
9. ACID property
10. Case Study for Atomic Property
11. Database Application Operation
Section 4: Creation of Database
With the theory complete, we begin with the first step for database application development training: creating a database. We learn how to use tablespaces, which are logical file storage locations for an Oracle database. Tablespaces are closely related to databases and datafiles, and are key to understand how data is stored and utilized.
12. Creation of Database
13. Creation of database user tablespace
14. Creation of database user tablespace continued
15. Creation of Tables
16. Creation of Tables continued
Section 5: Data Types & Constraints
In an SQL statement, each column constant and value has a data type associated with specific format for storage, constrains and valid value range. In this section, we explore the various inbuilt data types in an Oracle database, such as character, numeric, DATE, LOB and others. Constraints here are key to enforcing a relationship between two tables.
17. Data Types
18. Data Types continued
19. Types Of Constraint
20. Define Constraint
21. Foreign Key Constraint
22. Not null, unique and check constraint
23. Creating and Altering Table example
24. Displaying and droping the table columns and table
Section 6: Triggers
In this section, we cover database triggers, which are procedures stored in a database and executed, or fired, implicitly when a table is modified. We get an introduction to triggers and their use in database applications as a way to develop a customized database management system, to improve security and information auditing, and more.
25. What is Trigger
26. Designing Triggers
27. Naming and creating Triggers
28. Types of Trigger and restrictions
29. Compiling Triggers
30. Examples of Trigger Application
Section 7: Stored Procedures
While the above sections covered using SQL to interact with a database, this section covers using PL/SQL, a third-generation language with expected namespace and procedural constructs. You can use PL/SQL to create and use database-stored procedures as building blocks for various applications.
31. Stored Procedure
32. Stored Procedure Creation with Example
33. Calling Procedure and features
34. Return value of procedure and restriction
What Are The Requirements?
As you can see from the overall course structure, this course covers more than just the fundamentals of database application development. As such, there are some prerequisites if you want to succeed in this course:
- An understanding of databases and web application development
- An interest in learning about how to create your own database
- A moderately fast computer with more than 10 GB of space to set up a server
- A understanding of how web applications work
- Knowledge about SQL, especially hands-on coding knowledge
Target Audience For This Training
This database application development training course is suited for just about anyone interested in learning this topic, and with the aptitude for coding and understanding data logic. The course is also suited for database administrators looking to expand their skillset and learn more about Oracle databases and how to use them.
While the course goes into detail about creating, using and managing Oracle databases for developing database applications, it does not explore SQL alone in that much detail. And if you have a little background knowledge about this vast, powerful and important web development language, you will get to learn a lot more from this course.
FAQs
- What am I going to get from this course?
Once you complete this course, you will get a very clear understanding of the Oracle 11g database, and its use in web application development. You will learn how to create one, and learn some key elements of the language and tools for managing such databases, including SQL, constraints, data types and triggers.
- I do not have any experience in coding. Would this course be suitable?
If you are looking to learn more about the fundamentals of Oracle databases, then this course should be suitable. You would complete it knowing the inner workings of an Oracle 11g database and PL/SQL. However, you may not be able to put that knowledge onto an actual project unless you explore more about SQL, and learn to code. It is highly advisable that you learn how to code using SQL, before or after completing this course. Although before would be better, since it gives you a better foundation.
- Does this go into details about managing Oracle databases?
The course focuses the fundamental elements of Oracle databases, which is itself a vast area of study. What you get from this course is a complete theoretical and baseline operational understanding of Oracle databases. This alone can help you in two ways. For one, it helps you understand how databases in general are managed and created. Secondly, it gives you the tools and knowledge to create your own database, and to get into the wonderful world of Oracle.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.