The Oracle 19c SQL Fundamentals course is designed to provide participants with a comprehensive understanding of SQL and its usage in Oracle Database 19c. The course covers essential topics related to SQL, including querying and manipulating data, creating database objects, and managing database transactions. Participants will gain hands-on experience through practical exercises and labs, enabling them to apply their knowledge effectively in real-world scenarios.
To benefit fully from this course, participants should have a basic understanding of relational database concepts and some familiarity with Oracle Database. Prior knowledge of SQL is not required but would be beneficial.
The course employs a combination of theoretical instruction and hands-on practical exercises. Participants will receive detailed explanations of concepts and techniques, followed by opportunities to apply their learning in a lab environment. The course is delivered through instructor-led sessions, allowing participants to interact, ask questions, and engage in discussions.
Introduction to Oracle Database 19c
Overview of Oracle Database architecture
Introduction to SQL and its role in Oracle Database
Retrieving Data using the SELECT Statement
Basic SELECT statement syntax
Filtering data using the WHERE clause
Sorting data using the ORDER BY clause
Using logical operators in queries
Filtering and Manipulating Data
Advanced filtering using the WHERE clause
Working with NULL values
Combining multiple conditions with logical operators
Using the IN and BETWEEN operators
Manipulating string and numeric data
Joining Multiple Tables
Understanding table relationships
Using inner joins
Employing outer joins to retrieve unmatched data
Introduction to aggregate functions (SUM, AVG, COUNT, etc.)
Grouping data using the GROUP BY clause
Filtering grouped data with the HAVING clause
Using the ROLLUP and CUBE operators
Inserting data into tables
Updating existing data
Deleting data from tables
Controlling transactions with COMMIT and ROLLBACK
Creating Database Objects
Introduction to database objects (tables, views, indexes, etc.)
Creating tables and defining constraints
Creating and managing views
Creating and using sequences
Managing Database Transactions
Using the SAVEPOINT statement
Implementing data consistency and integrity
By the end of the course, participants will:
- Understand the fundamental concepts of SQL and its role in Oracle Database 19c.
- Be proficient in retrieving, filtering, and manipulating data using SQL statements.
- Have a solid understanding of joining tables and using subqueries to retrieve complex data.
- Be able to aggregate data and perform calculations using aggregate functions.
- Possess the skills to create and manage database objects, such as tables, views, and sequences.
- Have the ability to control transactions and ensure data consistency and integrity.
The course includes hands-on labs that provide participants with practical experience in applying SQL concepts and techniques. The labs cover various scenarios, allowing participants to practice querying and manipulating data, creating database objects, and managing transactions in Oracle Database 19c. The labs are designed to reinforce the concepts learned during the theoretical instruction and help participants build confidence in their SQL skills.