Oracle SQL Training Program

Module-1: Introduction to SQL

Introduction to Oracle Database

This section introduces Oracle Database 12c, highlighting its features, the basic design of a database, and the classification of different types of SQL statements. Learners will also understand the dataset used in the course, practice logging in with the SQL Developer environment, and learn how to save queries to files and use script files within SQL Developer.

Retrieve Data using the SQL SELECT Statement

Students will explore the capabilities of SQL SELECT statements, including retrieving all columns or specific columns from a table. They will learn how to use arithmetic and concatenation operators, and how to apply the DESCRIBE command to view table structures.

Learn to Restrict and Sort Data

This section covers filtering data using the WHERE clause, applying comparison and logical operators, and understanding rules of precedence. Students will practice using character string literals in conditions and writing queries with the ORDER BY clause to sort results. It also introduces SQL row-limiting clauses such as FETCH FIRST, OFFSET, and WITH TIES.

Usage of Single-Row Functions to Customize Output

Learners will study the differences between single-row and multiple-row functions. They will manipulate strings with character functions, apply numeric functions such as ROUND, TRUNC, and MOD, perform arithmetic with dates, and use DATE functions for effective data handling.

Invoke Conversion Functions and Conditional Expressions

This part focuses on implicit and explicit data type conversion. Students will practice using conversion functions like TO_CHAR, TO_NUMBER, and TO_DATE. They will also learn to nest multiple functions, apply NVL, NULLIF, and COALESCE to manage null values, and incorporate conditional IF-THEN-ELSE logic into SELECT statements.

Aggregate Data Using the Group Functions

Students will learn how to apply aggregation functions to generate reports, divide data into groups using GROUP BY, and refine grouped results with the HAVING clause.

Display Data From Multiple Tables Using Joins

This section teaches how to write SELECT statements that combine data from multiple tables. Students will understand outer joins to include unmatched rows and learn to use self-joins when referencing the same table.

Use Sub-queries to Solve Queries

Learners will understand the types of problems sub-queries can address, define sub-queries, study their different types, and practice writing both single-row and multiple-row sub-queries.

The SET Operators

This section introduces SET operators, explaining their use in combining query results. Students will practice UNION, UNION ALL, INTERSECT, and MINUS, along with controlling the order of the rows returned.

Data Manipulation Statements (DML)

Here, students will study the key DML statements—INSERT, UPDATE, and DELETE. They will also explore transaction management through COMMIT and ROLLBACK, while understanding the concept of read consistency in Oracle SQL.

Use of DDL Statements to Create and Manage Tables

This section introduces data definition language (DDL). Students will create simple tables, alter and truncate them, and drop tables while understanding the Recycle Bin concept. They will also learn to enforce data integrity using constraints such as Primary Key, Foreign Key, NOT NULL, UNIQUE, and CHECK.

Other Schema Objects

Finally, learners will explore additional schema objects. They will create and use simple and complex views, retrieve data from views, manage sequences, create and maintain indexes, and work with private as well as public synonyms.