SQL SELECT STATEMENT

SQL DATABASE

SQL TABLE

• SQL OVERVIEW
• SQL SELECT STATEMENT
• SQL ORDER BY
• SQL TOP NTH VALUE
• SQL DISTINCT VALUE
• SQL ALIAS
• SQL UNION

• SQL DATABASE
• CREATE DATABASE
• DROP DATABASE
• SELECT DATABASE
• SELECT DATA TYPES

• SQL CREATE TABLE
• SQL DROP TABLE
• SQL SELECT INTO STATEMENT
• SQL INSERT INTO
• SQL TRUNCATE TABLE
• SQL DELETE TABLE

SQL CLAUSE

SQL ALTER STATEMENT

SQL CONSTRAINT

• SQL WHERE
• SQL AND
• SQL OR
• SQL IN
• SQL NOT IN
• SQL BETWEEN
• SQL LIKE OPERATOR

• SQL ALTER STATEMENT
• SQL ADD COLUMN
• SQL DROP COLUMN
• SQL RENAME COLUMN
• SQL MODIFY COLUMN DATA TYPE
• SQL UPDATE STATEMENT

• PRIMARY KEY
• FOREIGN KEY
• UNIQUE
• DEFAULT
• NOT NULL
• CHECK
• IDENTITY

ALTER CONSTRAINT

SQL JOINS

SQL VIEWS

• Alter PRIMARY KEY
• Alter FOREIGN KEY
• Alter UNIQUE
• Alter DEFAULT
• Alter CHECK
• Alter NOT NULL

• SQL JOINS
• SQL INNER JOIN
• SQL LEFT JOIN
• SQL RIGHT JOIN
• SQL FULL JOIN

• SQL CREATE VIEW
• SQL DROP VIEW
• SQL ALTER VIEW

SQL STORE PROCEDURE

SQL GROUP BY

• SQL CREATE STORE PROCEDURE
• SQL STORE PROCEDURE OUTPUT
• SQL DROP STORE PROCEDURE
• SQL ALTER STORE PROCEDURE

• SQL GROUP BY
• GROUP BY WITH JOINS
• GROUP BY WITH WHERE
• HAVING CLAUSE