Oracle SQL Mastery: From Novice to Certified Database Pro

Course Program

Section 1: Database Concepts & Terminologies

• What is a Database?
• What is Oracle Database?
• Introduction to DBMS
• Traditional File System vs DBMS
• DBMS Terminologies
• What is SQL and RDBMS?
• What is a Database Table?
• Pluggable Database and Oracle’s Multitenant Architecture
• What is a Database Schema?
• Database Administrator (DBA)

Section 2: Installing and Setting Up the Required Tools

Section 3: Getting Started with Oracle Database | Basic CRUD Operations

Section 4: DQL | Retrieving Data from Oracle Database in Depth

Section 5: DQL | Filtering Data Using Oracle SQL

Section 6: DDL | Creating and Defining Your Own Tables in Oracle Database

Section 7: DML | Manipulating Your Tables in Oracle Database

Section 8: DQL | Working with Multiple Tables in Oracle Database

Section 9: Built-In Functions in Oracle SQL

Section 10: Sorting and Grouping Your Data in Oracle Database

Section 11: Working with Multiple Queries Using Oracle SQL | Set Operations

Section 12: Working with Multiple Queries Using Oracle SQL | Subqueries

Section 13: Views in Oracle SQL

Section 14: Constraints in Oracle Database

Section 15: Extra Information – Source Code and Other Stuff