• Course level: Beginner
  • Total Duration: 1 Month
  • What is SQL?
  • Why SQL?
  • SQL Commands
  • SQL RDBMS Concepts
  • What is NULL value?
  • SQL Constraints
  • NOT NULL Constraint
  • PRIMARY Key
  • FOREIGN Key
  • INDEX
  • SQL SELECT Statement
  • SQL DISTINCT Clause
  • SQL WHERE Clause
  • SQL AND/OR Clause
  • SQL IN Clause
  • SQL BETWEEN Clause
  • SQL Like Clause
  • SQL ORDER BY Clause
  • SQL GROUP BY Clause
  • SQL COUNT Clause
  • SQL HAVING Clause
  • SQL CREATE TABLE Statement
  • SQL DROP TABLE Statement
  • SQL CREATE INDEX Statement
  • SQL DROP INDEX Statement
  • SQL DESC Statement
  • SQL TRUNCATE TABLE Statement
  • SQL ALTER TABLE Statement
  • SQL ALTER TABLE Statement
  • SQL INSERT INTO Statement
  • SQL UPDATE Statement
  • SQL DELETE Statement
  • SQL CREATE DATABASE Statement
  • SQL DROP DATABASE Statement
  • SQL USE Statement
  • SQL COMMIT Statement
  • SQL ROLLBACK Statement
  • SQL Data Types
  • Exact Numeric Data Types
  • Approximate Numeric Data Types
  • Date and Time Data Types
  • Character Strings Data Types
  • Unicode Character Strings Data Types
  • Binary Data Types
  • SQL Operators
  • CREATE Database DELETE Database SELECT Database
  • CREATE Table DROP or DELETE Table
  • SQL INSERT Query
  • SQL SELECT Query
  • SQL Operators
  • SQL UPDATE Query
  • SQL DELETE Query
  • SQL LIKE Clause
  • SQL TOP Clause
  • SQL ORDER BY Clause
  • SQL Group By
  • SQL Distinct Keyword
  • SQL SORTING Results
  • SQL Joins
  • INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN SELF JOIN CARTESIAN JOIN
  • SQL Unions Clause
  • The UNION ALL Clause
  • SQL NULL Values
  • SQL Alias Syntax
  • SQL Indexes
  • The CREATE INDEX Command
  • Single-Column Indexes
  • Unique Indexes
  • Composite Indexes
  • Implicit Indexes
  • The DROP INDEX Command
  • SQL ALTER TABLE Command
  • SQL TRUNCATE TABLE
  • SQL - Using Views
  • Creating Views
  • SQL HAVING CLAUSE
  • SQL Transactions
  • The COMMIT Command
  • The ROLLBACK Command
  • SQL Wildcard Operators
  • SQL Date Functions
  • SQL Temporary Tables
  • SQL Sub Queries
  • Subqueries with the SELECT Statement
  • Subqueries with the INSERT Statement
  • Subqueries with the UPDATE Statement
  • Subqueries with the DELETE Statement
  • SQL Indexes
  • The CREATE INDEX Command
  • Using AUTO_INCREMENT column
  • SQL – Handling Duplicates
  • SQL Injection