Oracle Database 19c & 21c - SQL Database
The Oracle Database 19c & 21c SQL Database course provides a comprehensive foundation in Structured Query Language (SQL) using Oracle Database 19c (Long-Term Release) and Oracle Database 21c (Innovation Release). Oracle Database is developed by Oracle Corporation and is one of the world's most widely used enterprise-grade relational database platforms. SQL is the core language used to store, retrieve, manipulate, and secure data within Oracle databases. This course is designed to build strong practical SQL skills, covering data querying, data manipulation, schema objects, constraints, joins, subqueries, views, indexes, and basic performance considerations. It aligns with real-world database usage and provides a solid foundation for database administration, application development, data analysis, and Oracle certification pathways. Course Objectives By the end of this course, participants will be able to: Understand relational database concepts and Oracle architecture basics Write SQL queries to retrieve and manipulate data Use Oracle SQL functions and expressions Create and manage database objects Apply data integrity and constraints Understand differences and enhancements in Oracle 19c and 21c Prepare for Oracle SQLrelated roles and certifications
Course Curriculum
1
- Database concepts and terminology
- Relational database fundamentals
- Overview of Oracle Database 19c and 21c
- SQL vs PL/SQL (overview)
2
- SQL language structure
- SELECT statement syntax
- Filtering data with WHERE
- Sorting results with ORDER BY
3
- Character functions
- Numeric functions
- Date and time functions
- Conversion functions
- NULL handling
4
- GROUP BY and HAVING clauses
- Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
- Data grouping techniques
5
- Inner joins
- Outer joins
- Self joins
- Cross joins
- Using joins to combine multiple tables
6
- Single-row and multi-row subqueries
- Correlated subqueries (overview)
- UNION, UNION ALL, INTERSECT, MINUS
7
- INSERT statements
- UPDATE statements
- DELETE statements
- MERGE operations
- Transaction control (COMMIT, ROLLBACK, SAVEPOINT)
8
- Creating tables
- Modifying tables
- Dropping and truncating tables
- Data types in Oracle 19c & 21c
9
- NOT NULL, UNIQUE, PRIMARY KEY
- FOREIGN KEY
- CHECK constraints
- Enforcing referential integrity
10
- Creating and using views
- Index concepts and usage
- Creating and managing sequences
- Performance considerations (overview)
11
- Oracle SQL syntax and extensions
- Pseudocolumns (ROWNUM, ROWID)
- Common Table Expressions (CTEs)
- Enhancements in Oracle 21c
12
- Users and schemas
- Privileges and roles
- Basic data security concepts
13
- Writing efficient SQL
- Avoiding common SQL mistakes
- Basic execution plan concepts
- SQL optimization principles
14
- Hands-on query exercises
- Real-world database scenarios
- Data analysis and reporting tasks
- Query troubleshooting
15
- Review of key SQL concepts
- Practice questions and exercises
- Oracle SQL certification overview
- Career pathways in database and data roles
16
- Instructor-led classroom or virtual training
- Hands-on lab sessions
- Practical SQL exercises and demonstrations
17
- Aspiring database administrators
- Application developers
- Data analysts and BI professionals
- IT professionals working with databases
- Students and professionals new to Oracle SQL
18
- Basic computer literacy
- No prior database experience required
- Familiarity with IT concepts is beneficial
19
- Hands-on SQL exercises
- Quizzes and knowledge checks
- Practical lab assessments
This course includes
- 19+ Activity Modules
- 40 hours + lessons
- Lifetime access
- Certificate of completion
- Available on desktop and mobile
Some of Our Partners
