SQL Course Content

SQL Course Training Schedule- 60 Hrs

Prerequisite:

S.No Topics
1.
  • SQL- Introduction
    • DBMS
    • RDBMS
2.
  • SQL- Data Types
  • SQL- Operators
3.
  • SQL– Database Operation
    • CREATE Database
    • DROP Database
    • RENAME Database
    • SELECT Database
4.
  • SQL- Tables
    • What is Table
    • Variable
    • CREATE TABLE
    • DROP TABLE
    • DELETE TABLE
    • RENAME TABLE
    • TRUNCATE TABLE
    • COPY TABLE
    • TEMP TABLE
    • ALTER TABLE
5.
  • SQL- Select Statement
    • Select Statement
    • Select UNIQUE
    • Select DISTINCT
    • Select COUNT
    • Select TOP
    • Select FIRST
    • Select LAST
    • Select RANDOM
    • Select AS
    • Select IN
    • Select Multiple
    • Select DATE
    • Select SUM
    • Select NULL
6.
  • SQL- Clause
    • SQL WHERE
    • SQL AND
    • SQL OR
    • SQL WITH
    • SQL AS
7.
  • SQL- Order By Clause
    • Ascending
    • Descending
    • Limit
    • Random
8.
  • SQL- Insert statement
    • Single Insert
    • Multiple Insert
    • Insert Into Select
9.
  • SQL- Update
    • Update Values
    • Update with JOIN
10.
  • SQL- Delete Operations
    • Delete TABLE
    • Delete ROW
    • Delete All Rows
    • Delete Duplicate Rows
    • Delete DATABASE
    • Delete VIEW
    • Delete JOIN
11.
  • SQL-  Joins
    • Inner Join
    • Outer Join
    • Left Join
    • Right Join
    • Full Join
    • Cross Join
12.
  • SQL- Keys
    • Primary Key
    • Foreign Key
    • Composite Key
    • Unique Key
    • Alternate Key
13.
  • SQL- PL/SQL
    • PL/SQL Variables
    • PL/SQL Constant
    • PL/SQL Control Statements
    • PL/SQL IF
    • PL/SQL Case
    • PL/SQL Loop
    • PL/SQL Exit Loop
    • PL/SQL While Loop
    • PL/SQL For Loop
    • PL/SQL Continue
    • PL/SQL GOTO
    • PL/SQL Procedure
    • PL/SQL Function
    • PL/SQL Cursor
    • PL/SQL Exception
    • PL/SQL Trigger
Total Hours