Skip to content

Database Application Development Training


EduCBA

Summary

Price
£12 inc VAT
Study method
Online
Course format What's this?
Video
Duration
5 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
Additional info
  • 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:

  1. An understanding of databases and web application development
  2. An interest in learning about how to create your own database
  3. A moderately fast computer with more than 10 GB of space to set up a server
  4. A understanding of how web applications work
  5. 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.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.