Course Description

Course Overview

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.

Prerequisites

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.

Methodology

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.

Course Outline

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

Column aliases

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

Performing self-joins

Utilizing subqueries

Aggregating 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

Modifying Data

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

Understanding transactions

Using the SAVEPOINT statement

Implementing data consistency and integrity

Course Outcome

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.

Course Labs

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.