• The study of database design and management of a database is an essential component of the business IT world today.
  • Through this course the participant will gain a background in database design.
  • The participant will work with entity-relationship diagrams (ERD) to learn and implement the basic database design. Using Oracle SQL, the participants will apply the design principles to actually create and develop a working database.
  • This course is designed to help participants integrate theoretical material with practical knowledge to implement a database.
  • Participants will also use SQL commands to query single and multiple tables.
  • Single and group functions will also be used to enhance queries. Subqueries will be used to enhance data retrieval.
  • Data manipulation of data will also be covered to change the data in the database.
  • We will discuss the connection of an application program to the database to store and retrieve data.

Learning Path

  • Install SQL Developer 21
  • Configure the database connection
  • Activity 
     Display connected user name
     Display system date
  • Apply normalization principles to DB design
  • Design tables
  • Reading Chapter# 1
  • Activity 
     Design tables based on design criteria
  • Use the basic SELECT statement
  • Queries with a single table
  • Reading Chapter# 2
  • Activity 
     Create queries based on a given request
  • Create database tables with and without constraints
  • Reading Chapter# 3 and 4
  • Activity 
     Create tables with or without constraints
  • Perform DML operations on data with TCL commands
  • Reading Chapter# 5
  • Activity
     Perform DML operations against data in tables
  • Build queries with criteria to restrict rows
  • Reading Chapter# 8
  • Activity 
     To create queries with conditions or restrictions
  • Build queries using more than one table
  • Reading Chapter# 9
  • Activity 
     Access data from multiple tables
     Display results of given lab queries
  • Build queries using single-row functions
  • Reading Chapter# 10
  • Activity 
     To create queries using single-row functions
     Create tables with single-row functions
  • Build queries using aggregate functions
  • Reading Chapter# 11
  • Activity 
     To create queries using single-row functions and aggregate functions
  • Build queries using subqueries
  • Reading Chapter# 12
  • Activity 
     Create queries with the use of subqueries
  • Build views
  • Reading Chapter# 13
  • Activity
     Create views based on queries
  • Introduction to the Explain Plan
  • Activity 
     To show the explain plan for several queries