SQL COURSE CONTENT
Introduction to SQL
- What is SQL?
- SQL vs DBMS
- Basic structure of a SQL query
- SQL Table & Relational Concepts
SQL Statements (DDL & DML)
- CREATE, ALTER, RENAME, DROP
- SELECT, INSERT, UPDATE, DELETE
- TRUNCATE, DESC, SHOW
SQL Clauses
- WHERE, GROUP BY, HAVING, ORDER BY
- DISTINCT keyword
- LIMIT
SQL Operators
- Comparison Operators (=, !=, >, <)
- LIKE, IN, NOT IN, IS NULL
- BETWEEN, AND, OR
SQL Constraints
- PRIMARY KEY
- FOREIGN KEY
- UNIQUE
- NOT NULL
- CHECK
Advanced SQL
- JOINS: Inner, Outer, Cross, Self
- ALIASES
- GROUP FUNCTIONS: SUM, AVG, COUNT
- VIEWS, INDEX, SUBQUERIES, GRANT/REVOKE
