Welcome to Sql Coding exercises
Select a chapter to start practicing exercise questions.
SQL Fundamentals
Introduction to SQL
What is Database
MySQL Installation
Types of Database
What is a Table in SQL
Creating First Database
Creating First Table
SQL Data Type
SQL Commands Overview
What Are SQL Commands
Types of SQL Commands
Database Queries - CREATE, DROP, USE
Table Queries
CRUD Operations
SQL SELECT
SQL INSERT
SQL UPDATE
SQL DELETE
Schema Modification
Keys & Constraints
Keys in SQL
SQL Constraints
Foreign Keys
Constraints
Data Filtering
SELECT
WHERE
SQL Operators
SQL LIMIT
SQL ORDER BY
SQL Aggregate
SQL GROUP BY
SQL HAVING
SQL Execution Order
Joins & Sets
SQL JOINS
Advanced SQL Joins
SQL Self Join
SQL CROSS JOIN
SQL UNION
SQL INTERSECT & EXCEPT
Subqueries & Views
SQL Subqueries
Single Row Subqueries
Multi Row Subqueries
Correlated Subqueries
Derived Tables
Views
Updating Views
Indexes & Programs
SQL Indexes
Query Optimization
Index Optimization
Procedures
Functions
Triggers
Transactions & Security
SQL Transactions
ACID Properties
SQL Normalization
SQL Denormalization
SQL Security
SQL Injection
Advanced SQL
Window Functions
Interview Queries
Capstone Project