SQL Tutorial
Course Contents
SQL Tutorial
SQL Filtering & Sorting
SQL Aggregate Functions
SQL Joins
SQL Data Modification
SQL Data Definition
- SQL CREATE DATABASE
- SQL CREATE TABLE
- SQL Constraints
- SQL PRIMARY KEY Constraint
- SQL FOREIGN KEY Constraint
- SQL NOT NULL Constraint
- SQL UNIQUE Constraint
- SQL CHECK Constraint
- SQL DEFAULT Constraint
- SQL AUTO INCREMENT
- SQL ALTER TABLE
- SQL DROP TABLE / DROP DATABASE
SQL Views & Indexes
SQL Advanced Queries
SQL Functions
SQL Data Types
SQL Transactions & Concurrency
SQL Advanced
- SQL Window Functions
- SQL Common Table Expressions (WITH)
- SQL Recursive CTEs
- SQL Pivoting Data
- SQL Triggers
- SQL Stored Procedures
