12
Lessons
48h
Duration
English
Language
Share This Class:
OBJECTIVES
- 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