.

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

  1. Single Row Sub Query
  2. 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.

Scroll to Top