1. Introduction to SQL
– Define and Understand the basics of the RDBMS and SQL.
– Understand the Unique role of SQL in Modern software systems (SQL is a 4GL)
– Summarize the SQL Language
– Use the Client Tools

2. Data Retrieval Using the SQL SELECT statements.
– List the Capabilities of SQL SELECT Statements
– Execute a Basic SELECT Statement
– Describe How schema objects Work

3. Restricting and Sorting Data
– Limit the rows that are retrieved by a Query
– Sort the rows that are retrieved by a Query
– Ampersand Substitution

4. Using Single-Row Functions to Customize Output
– Describe various types of functions that are available in SQL
– Use Character, number, and Date functions in select statements
– Using conversion functions (TO_CHAR, TO_NUMBER, TO_DATE etc.)
– Apply Conditional Expressions in a SELECT Statement

5. Reporting Aggregated Data Using the Group Functions
– Describe the Use of Group functions
– Group Data by Using the GroUP bY Clause
– Include or exclude grouped rows by using the Having Clause

6. Displaying Data from Multiple Tables
– Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-equijoins
– Join a Table to Itself Using a Self-Join
– View Data That Does Not Meet a Join Condition by Using Outer Joins
– Generate a Cartesian Product of Two or More Tables

7. Retrieving Data Using Subqueries
– Define Subqueries
– Describe thetypes of Problems that subqueries can solve
– List the Types of Subqueries
– Write Single-Row and Multiple-Row Subqueries

8. Creating Other Schema Objects.
– Create and use simple and ComplexViews
– Create, Maintain, and use sequences
– Create and Maintain Indexes
– Create Private and Public synonyms

9. Using the Set Operators
– Describe the Set Operators
– Use a Set Operator to Combine Multiple Queries into a Single Query
– Control the Order of Rows Returned

10. Manipulating Data
– Describe Each Data Manipulation Language (DML) Statement
– Insert Rows into a Table
– Update Rows in a Table
– Delete Rows from a Table
– Control Transactions

11. Using DDL Statements to create and manage tables
– Categorize the Main Database Objects
– Review the Table Structure
– List the Data Types That Are Available for Columns
– Create a Simple Table
– Explain How Constraints Are Created at the Time of Table Creation

12. Controlling User Access
– Differentiate system Privileges from object Privileges
– Grant Privileges on tables
– View Privileges in the Data Dictionary
– Grant roles
– Distinguish between Privileges and roles