SQL

SQL course is offered by SGIT. Faculty is friendly and knowledgable. They help learning the topic with deep understanding.

Syllabus:

• SQL Join
• SQL JOIN
• SQL Outer Join
• SQL Left Join
• SQL Right Join
• SQL Full Join
• SQL Cross Join
• SQL Keys
• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key
• SQL Table
• What is Table
• SQL CREATE TABLE if not exists
• SQL DROP TABLE
• SQL DELETE TABLE
• SQL RENAME TABLE
• SQL TRUNCATE TABLE
• SQL COPY TABLE
• SQL TEMP TABLE
• SQL ALTER TABLE
• SQL Basics
• SQL Syntax
• SQL Data Types
• SQL Operators
• SQL Clause
• SQL WHERE
• SQL AND
• SQL OR
• SQL WITH
• SQL AS
• SQL HAVING Clause
• SQL Delete
• DELETE Statement
• SQL DELETE TABLE
• SQL DELETE ROW
• SQL DELETE All RowsDELETE Duplicate Rows
• SQL DELETE DATABASE
• SQL DELETE VIEW
• SQL DELETE JOIN
• SQL Insert
• INSERT Statement
• INSERT INTO Values
• INSERT INTO SELECT
• INSERT Multiple Rows
• SQL Select
• 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 IN
• SQL SELECT Multiple
• SQL SELECT DATE
• SQL SELECT SUM
• SQL SELECT NULL
• SQL Update
• UPDATE Statement
• SQL UPDATE JOIN
• SQL UPDATE DATE
• SQL OrderBy
• ORDER BY Clause
• ORDER BY ASC
• ORDER BY DESC
• ORDER BY RANDOM
• ORDER BY LIMIT
• ORDER BY Multiple Cols
• SQL Database