SQL TRAINING COURSE CONTENT

100% Job Oriented Programme

  • Introduction to SQL
  • What is Database
  • What is RDBMS
  • DBMS vs RDBMS
  • SQL Syntax
  • SQL Data Types
  • SQL Operators

  • What is Table
  • SQL TABLE Variable
  • SQL CREATE TABLE
  • SQL DROP TABLE
  • SQL DELETE TABLE
  • SQL RENAME TABLE
  • SQL TRUNCATE TABLE
  • SQL COPY TABLE
  • SQL TEMP TABLE
  • SQL ALTER TABLE

  • SELECT Statement
  • SQL SELECT UNIQUE
  • SQL SELECT DISTINCT
  • SQL SELECT COUNT
  • SQL SELECT TOP
  • SQL SELECT FIRST
  • SQL SELECT LAST
  • SQL SELECT RANDOM
  • SQL SELECT AS
  • SQL SELECT IN
  • SQL SELECT Multiple
  • SQL SELECT DATE
  • SQL SELECT SUM
  • SQL SELECT NULL

  • ORDER BY Clause
  • ORDER BY ASC
  • ORDER BY DESC
  • ORDER BY RANDOM
  • ORDER BY LIMIT
  • ORDER BY Multiple Cols

  • DELETE Statement
  • SQL DELETE TABLE
  • SQL DELETE ROW
  • SQL DELETE All Rows
  • DELETE Duplicate Rows
  • SQL DELETE DATABASE
  • SQL DELETE VIEW
  • SQL DELETE JOIN

  • Primary Key
  • Foreign Key
  • Composite Key
  • Unique Key
  • Alternate Key

  • SQL CREATE Database
  • SQL DROP Database
  • SQL RENAME Database
  • SQL SELECT Database

  • INSERT Statement
  • INSERT INTO Values
  • INSERT INTO SELECT
  • INSERT Multiple Rows

  • SQL WHERE
  • SQL AND
  • SQL OR
  • SQL WITH
  • SQL AS

  • UPDATE Statement
  • SQL UPDATE JOIN
  • SQL UPDATE DATE

  • SQL JOIN
  • SQL Outer Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Cross Join

  • SQL vs NoSQL