SQL

 ORACLE SQL

Demo Links : 

Demo Session 1:

Demo Session 2 :

Demo Session 3 :

Course Content :

Module-1: USERS AND SCHEMAS

• Introduction to Users and Schemas
• Definitions and Client Tools
• SQL Developer Login
• Creating An Application Schema

Module-2: PSEUDO COLUMNS & FUNCTIONS

• Using The Dual Table
• Functions
• Pseudo-Columns
• Using Rowid
• Using Rownum

Module-3: USING SUBQUERIES

• Simple Subqueries
• Inline Views
• Correlated Subqueries
• Scalar Subquery

Module-4: JOINING TABLES

• Review of Joins
• Equijoins
• Inner Joins
• Outer Joins
• Cross Joins
• Natural Joins
• Using Named Subqueries

Module-5: GROUP OPERATIONS

• About Group Processing
• Simple GROUP BY
• ROLLUP Function

Module-6: USING SET OPERATORS

• Set Operators Defined
• Relationship to Mathematical Set Theory
• Restrictions on Set Operators

Module-7: CONDITIONAL PROCESSING

• The DECODE Function
• The Case Expression
• Exercise: Conditional Processing

Module-8: SQL FUNCTIONS (CHARACTER)

• What Are SQL Functions?
• Character Functions
• CONCAT
• LENGTH
• INSTR
• REPLACE
• UPPER
• LOWER
• INITICAP
• LPAD
• RPAD
• TRIM
• TO_CHAR
• SOUNDEX

Module-9: SQL FUNCTIONS (NON-CHARACTER)

• Numeric Functions
• The TO_CHAR Function with numbers
• Date/Time Functions
• Date Format Functions
• Date Arithmetic Functions
• Null Value Functions

Module-10: SQL DATA MANIPULATION LANGUAGE

• The INSERT Statement
• INSERT Statement Categories
• The UPDATE Statement
• The DELETE Statement
• Transactions
• Complex Table References
• The MERGE statement

Module-11: Analytical Functions

Module-12: Queries for Queries

Module-13: Techniques to compare data

Module-14: Efficiently writing SQL queries

SQL Interview Questions

Click Here to download SQL 240 Queries for Practice

Oracle SQL Training Sessions

SNO	Topic	To View
1.1	DB Software Link	Click Here
1.2	SQL Developer Tool Link	Click Here
2	DDL Commands	Click Here
3	DML and DRL Commands	Click Here
4	Constraints_01	Click Here
5	Constraints_02	Click Here
6	Datatypes_01	Click Here
7	Operators_01	Click Here
8	Operators_02	Click Here
9	SetOperators	Click Here
10	Clauses	Click Here
11	Number_Aggregate	Click Here
12	Charactor_Functions	Click Here
13	Null_Functions	Click Here
14	Date_Functions	Click Here
15	Analytical_Functions	Click Here
16	PSuedo_Columns	Click Here
17	Joins	Click Here
18	Subqueries_Sequences	Click Here
19	DCL_TCL_Commands	Click Here
20	Charactor_Functions02	Click Here