SQL Programming
A Complete SQL Programming tutorial for beginners.
Topics List
Basics
- SQL Introduction
- Databases and Tables
- SQL Syntax
- SELECT Statement in SQL
- WHERE Clause in SQL
- ORDER BY in SQL
- LIMIT in SQL
- DISTINCT in SQL
- NULL in SQL
Data Manipulation
- INSERT in SQL
- UPDATE in SQL
- DELETE in SQL
- Aliases in SQL
- LIKE in SQL
- IN Operator in SQL
- BETWEEN in SQL
Aggregation
- COUNT in SQL
- SUM in SQL
- AVG in SQL
- MIN and MAX in SQL
- GROUP BY in SQL
- HAVING in SQL
Joins
- INNER JOIN in SQL
- LEFT JOIN in SQL
- RIGHT JOIN in SQL
- FULL JOIN in SQL
- SELF JOIN in SQL
- CROSS JOIN in SQL
Advanced Queries
- Subqueries in SQL
- Correlated Subqueries in SQL
- EXISTS in SQL
- CASE Statement in SQL
- UNION vs UNION ALL
- CTE in SQL
- Window Functions in SQL
Schema and Constraints
- CREATE TABLE in SQL
- ALTER TABLE in SQL
- DROP TABLE in SQL
- Primary Key in SQL
- Foreign Key in SQL
- UNIQUE Constraint in SQL
- NOT NULL in SQL
- CHECK Constraint in SQL
- DEFAULT Constraint in SQL
Transactions and Performance
- Transactions in SQL
- COMMIT and ROLLBACK in SQL
- ACID Properties
- Isolation Levels in SQL
- Index in SQL
- View in SQL
- Stored Procedure in SQL
- Trigger in SQL
Utility Topics
- String Functions in SQL
- Date Functions in SQL
- Numeric Functions in SQL
- Pagination in SQL
- Normalization in SQL
