• Write SQL queries using the SELECT statement.
• Restrict and sort query results.
• Use single-row, conversion, and conditional functions.
• Generate aggregated reports using group functions.
• Retrieve data from multiple tables using joins.
• Work with subqueries and set operators.
• Manipulate data using DML statements.
• Create views, indexes, sequences, synonyms, and schema objects.
• Use advanced SQL queries and data manipulation techniques.
• Control user access and work with different time zones.

Module 1: Introduction

• Introduction to Oracle Database 19c
• Relational database concepts
• SQL programming language
• SQL development environment

Module 2: Retrieving Data Using the SQL SELECT Statement

• SELECT statement fundamentals
• Selecting columns
• Using expressions
• Column aliases
• DISTINCT
• Basic query construction

Module 3: Restricting and Sorting Data

• Restricting rows
• WHERE clause
• Comparison operators
• Logical operators
• Sorting query results
• ORDER BY clause

Module 4: Using Single-Row Functions to Customize Output

• Single-row functions
• Character functions
• Number functions
• Date functions
• Function usage in SQL statements
• Customizing query output

Module 5: Using Conversion Functions and Conditional Expressions

• Conversion functions
• Implicit and explicit data conversion
• Conditional expressions
• CASE expressions
• General functions
• COALESCE function

Module 6: Reporting Aggregated Data Using the Group Functions

• Group functions
• Aggregate calculations
• GROUP BY clause
• HAVING clause
• Creating summary reports

Module 7: Displaying Data from Multiple Tables Using Joins

• Join concepts
• Joining multiple tables
• Equijoin
• Nonequijoin
• Outer joins
• Self joins
• Cross joins
• Join conditions

Module 8: Using Subqueries to Solve Queries

• Subquery concepts
• Single-row subqueries
• Multiple-row subqueries
• Subqueries in SELECT statements
• Subqueries in WHERE clauses

Module 9: Using Set Operators

• Set operator concepts
• UNION
• UNION ALL
• INTERSECT
• MINUS
• Combining query results

Module 10: Managing Tables Using DML Statements

• Data Manipulation Language
• INSERT
• UPDATE
• DELETE
• MERGE
• Transaction concepts
• Managing table data

Module 11: Introduction to Data Definition Language

• Data Definition Language
• Creating database objects
• ALTER statements
• DROP statements
• DDL considerations

Module 12: Introduction to Data Dictionary Views

• Data dictionary concepts
• Data dictionary views
• Viewing database metadata
• Querying dictionary information

Module 13: Creating Sequences, Synonyms, and Indexes

• Creating sequences
• Sequence options
• Creating synonyms
• Public and private synonyms
• Creating indexes
• Index considerations

Module 14: Creating Views

• View concepts
• Creating views
• Querying views
• Modifying views
• Managing views

Module 15: Managing Schema Objects

• Schema objects
• Object dependencies
• Managing database objects
• Object metadata
• Managing schema-level resources

Module 16: Retrieving Data by Using Subqueries

• Advanced subqueries
• Multiple-column subqueries
• Correlated subqueries
• Subqueries in complex queries

Module 17: Manipulating Data by Using Subqueries

• Using subqueries with DML
• INSERT with subqueries
• UPDATE with subqueries
• DELETE with subqueries
• Data manipulation using nested queries

Module 18: Controlling User Access

• Database user access
• Privileges
• Roles
• Granting privileges
• Revoking privileges
• Controlling access to database objects

Module 19: Manipulating Data Using Advanced Queries

• Advanced SQL query techniques
• Complex data manipulation
• Advanced query construction
• Advanced SQL reporting
• Advanced query practice

Module 20: Managing Data in Different Time Zones

• Time zone concepts
• Oracle date and time data
• Time zone data types
• Working with data across time zones

Module 21: Conclusion

• Course review
• SQL skills recap
• Applying SQL skills in Oracle Database 19c

5 days

• Practice writing basic SQL SELECT statements.
• Retrieve data from Oracle database tables.
• Restrict and sort query results.
• Use single-row functions to customize output.
• Apply conversion functions and conditional expressions.
• Use the COALESCE function.
• Generate aggregated reports using group functions.
• Retrieve data from multiple tables using joins.
• Use subqueries to solve business queries.
• Combine query results using set operators.
• Insert, update, delete, and merge table data.
• Create and modify database objects using DDL.
• Query data dictionary views.
• Create sequences, synonyms, and indexes.
• Create and manage views.
• Manage schema objects.
• Retrieve data using advanced subqueries.
• Manipulate data using subqueries.
• Control user access through privileges and roles.
• Perform advanced SQL queries and data manipulation.
• Work with data stored across different time zones.

Course Completion Certificate by Network Binary

• SQL Developers
• Database Developers
• Application Developers
• Data Analysts
• Business Analysts
• Database Administrators
• Professionals who need to query Oracle databases
• IT professionals seeking foundational Oracle SQL skills

• Basic computer skills.
• Basic database knowledge is helpful but not required.
• Familiarity with relational database concepts is beneficial.