Tutorial · 35 chapters
SQL
Learn SQL hands-on with MySQL: queries, joins, subqueries, window functions, transactions and the most asked SQL interview questions.
Mission log
01Introduction to SQL02Setting Up MySQL03SQL Data Types04CREATE DATABASE & CREATE TABLE05INSERT INTO06SELECT Statement07WHERE Clause08SQL Operators (AND, OR, IN, BETWEEN, LIKE)09NULL Values10ORDER BY & LIMIT11DISTINCT12UPDATE & DELETE13ALTER, DROP & TRUNCATE14SQL Constraints15Aggregate Functions16GROUP BY & HAVING17SQL Joins18INNER JOIN19LEFT, RIGHT & FULL OUTER JOIN20SELF JOIN & CROSS JOIN21UNION & Set Operations22Subqueries23Correlated Subqueries & EXISTS24CASE Expression25String Functions26Date & Time Functions27Views28Indexes29Common Table Expressions (WITH)30Window Functions31Ranking Functions (ROW_NUMBER, RANK, DENSE_RANK)32Transactions in SQL33Stored Procedures & Functions34Triggers35Top SQL Interview Queries
