Oracle SQL Database Certification Training

Module 1: Introduction & Software Installation

• Overview of Oracle Database

• Overview of RDBMS Concepts And Terminologies

• Introduction to SQL and its Development Environments

• Installing Oracle

• Installing Java SDK

• Installing SQL Developer Client

Module 2: Retrieve Data Using The Sql Select Statement

• List the Capabilities Of Sql Select Statements

• Generate a Report Of Data From The Output Of a Basic Select Statement

• Use Arithmetic Expressions and Null Values In the Select Statement

• Invoke Column Aliases

• Concatenation Operator, Literal Character Strings, Alternative Quote Operator, and the Distinct Keyword

• Display the Table Structure Using the Describe Command

Module 3: Restricted And Sorted Data

• Write Queries With a Where Clause to Limit the Output Retrieved

• Describe the Comparison Operators and Logical Operators

• Describe the Rules Of Precedence For Comparison and Logical Operators

• Usage Of Character String Literals In the Where Clause

• Write Queries With an Order By Clause

• Sort the Output In Descending and Ascending Order

• Substitution Variable

Module 4: Usage Of Single-Row Functions To Customize Output

• List the Differences Between Single Row and Multiple Row Functions

• Manipulate Strings Using Character Functions

• Manipulate Numbers With the ROUND, TRUNC, and MOD Functions

• Perform Arithmetic With Date Data

• Manipulate Dates With the DATE Functions

Module 5: Conversion Functions And Conditional Expressions

• Describe Implicit and Explicit Data Type Conversion

• Describe The TO_CHAR, TO_NUMBER, And TO_DATE Conversion Functions

• Nesting Multiple Functions

• Apply the NVL, NULLIF, and COALESCE Functions to Data

• Usage Of Conditional IF THEN ELSE Logic In a SELECT Statement

Module 6: Aggregated Data Using The Group Functions

• Usage Of The Aggregation Functions In SELECT Statements To Produce Meaningful Reports

• Describe the AVG, SUM, MIN, and MAX Function

• How to Handle Null Values In a Group Function

• Divide The Data In Groups By Using The GROUP BY Clause

• Exclude Groups Of Date By Using The HAVING Clause

Module 7: Display Data From Multiple Tables

• Write SELECT Statements To Access Data From More Than One Table

• Join Tables Using SQL:1999 Syntax

• View Data That Does Not Meet a Join Condition By Using Outer Joins

• Join A Table To Itself By Using a Self-Join

• Create Cross Joins

Module 8: Usage Of Subqueries To Solve Queries

• Use a Subquery To Solve a Problem

• Single-Row Subqueries

• Group Functions In A Subquery

• Multiple-Row Subqueries

• Use The ANY and ALL Operator In Multiple-Row Subqueries

• Use The EXISTS Operator

Module 9: SET Operators

• Describe The SET Operators

• Use A SET Operator To Combine Multiple Queries Into a Single Query

• Describe The UNION, UNION ALL, INTERSECT, and MINUS Operators

• Use The ORDER BY Clause In Set Operations

Module 10: Data Manipulation

• Add New Rows To a Table

• Change The Data In a Table

• Use The DELETE and TRUNCATE Statements

• How To Save and Discard Changes With The COMMIT and ROLLBACK Statements

• Implement Read Consistency

• Describe The FOR UPDATE Clause

Module 11: DDL Statements To Create And Manage Tables

• Categorize Database Objects

• Create Tables

• Describe The Data Types

• Understand Constraints

• Create a Table Using A Subquery

• How To Alter a Table

• How To Drop a Table

Module 12: Other Schema Objects

• Create, Modify, And Retrieve Data From a View

• Perform Data Manipulation Language (DML) Operations On a View

• How to Drop a View

• Create, Use, and Modify a Sequence

• Create and Drop Indexes

• Create and Drop Synonyms