Module 1: Introduction to SQL

• Introduction to SQL
• SQL Developer
• Logging in SQL*Plus
• Connecting to Database on windows and Linux

Module 2: SQL Languages -DDL,DML,TCL,DCL

• Database Objects
• CREATE TABLE statement
• Data types
• Overview of constraint
• Creating a table using subquery
• Use the ALTER TABLE statement to add, modify, and drop a column
• DROP TABLE statement

Module 3: Accessing Data Using Queries

• Select Statements
• Arithmetic expressions and NULL values in the SELECT statement
• Column aliases
• Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• DESCRIBE command

Module 4: Restricting and Sorting Data

• Sorting rows using ORDER BY clause
• SQL row limiting clause in a query

Module 5: Using Single-Row Fuunction to Customize Output

• Describe the differences between single row and multiple row functions
• Manipulate strings with character function in the SELECT and WHERE clauses
• Manipulate numbers with the ROUND, TRUNC and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the date functions

Module 6: Working On constraints

• Managing constraints
• TYPES of Constraints
• ON DELETE Cascade option

Module 7: USing the SET operator

• Set Operators
• INTERSECT operator
• MINUS operator
• Matching the SELECT statements
• Using ORDER BY clause in set operations

Module 8: USing Conversion Function and Conditional Expressions

• Describe implicit and explicit data type conversion
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Conditional Expressions

Module 9: Reporting Aggregated Data USing the Group Functions

• Group Functions
• Grouping Rows (GROUP BY and HAVING clause)
• Nesting Group Functions

Module 10: Displaying Data Form Multiple Tables USing Joins

• Introduction to JOINS
• Types of Joins
• Natural join
• Self-join
• OUTER join
• Cartesian Joins / Cross Joins

Module 11: Using Subqueries to Solve Queries

• Introduction to Subqueries
• Single Row Subqueries
• Multiple Row Subqueries

Module 12: Dictionary Views

• Introduction to Data Dictionary
• Describe the Data Dictionary Structure
• Using the Data Dictionary views
• DBMS_metadata
• User_source
• User_views
• Querying the Data Dictionary Views

Module 13:Views, Sequences and Synonyms

• Why Views
• View TYPES
• Sequences and its use
• Using Synonyms

Module 14: External tables & DBMS_Error

• SQL*Loader
• Loading data from excel / text files to tables
• DBMS_ErrorLog
• External tables

Module 15: Indexes

• Types of Indexes
• Binary Tree
• Bit Map

Module 16: USer access control

• Grant/Revoke privileges to other users
• With GRANT Option
• Objects Vs System Privileges

Module 17: Timezone

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types
• Using Datetime functions in queries