.
SQL Course Structure Duration 45 hours
Introduction:
• What Is Database?
• What is Database Management System (DBMS)?
• What is Relational Model?
• Introduction to RDBMS
• Brief on E.F CODD
Data types and Constraints:
• What are Data types?
• Types and Examples
• How to use
• What are Constraints?
• Types and Examples.
• How to use.
Statements in SQL:
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Transaction Control Language (TCL)
• Data Control Language (DCL)
• Data Query Language (DQL)
Software installation:
• Installing and set up of software
• Working on Oracle 10g. ( Basic commands )
Data Query Language (DQL):
• Select
• From
• Where
• Group By
• Having
• Order By
Operators:
Types and Examples
Functions in SQL:
• Single Row Functions
• Multi Row Functions
Max ()
Min ()
Sum ()
Avg ()
Count ()
Sub Query:
• Introduction to Sub Query
• Working of Sub Query
• Query Writing and Execution
• Types of Sub Query
- Single Row Sub Query
- Multi Row Sub Query
• Nested Sub Query
Pseudo Columns:
• Introduction on Pseudo Columns
• ROWID
• ROWNUM
• Working and Usage.
JOINS:
• What Is Join?
• Types of Joins.
• Cartesian Join
• Inner Join
• Outer Join
• Self-Join
• Queries and Examples.
Co- Related Sub Query:
• Working and Examples
Data Definition Language (DDL):
• Create
• Rename
• Alter
• Truncate
• Drop
Data Manipulation Language (DML):
• Insert
• Update
• Delete
Transaction Control Language (TCL):
• Commit
• Save point
• Rollback
Data Control Language (DCL):
• Grant
• Revoke
Cursors:
Implicit cursor
Explicit cursor
Sub programs:
Stored procedures
Functions
Triggers:
Introduction
Types of triggers
Normalization:
• Introduction to Normalization
• Types of Normal Forms
• Examples.
E R Diagrams:
• Introduction to ERD
• Examples.