
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 36-lesson course built from Apna College's 3h 16m of YouTube video. 2 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by Apna College on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand the course structure, what SQL is, and the difference between SQL and Sequel pronunciations.
Define databases, DBMS, RDBMS vs NoSQL, and identify popular relational database systems like MySQL.
Explain the four CRUD operations and classify SQL commands into DDL, DQL, DML, DCL, and TCL categories.
Install MySQL Community Server and MySQL Workbench on macOS, create a connection, and verify it.
Install MySQL Installer (Full) and MySQL Workbench on Windows, configure root password, and set up a local connection.
Visualize database hierarchy, differentiate columns (schema) from rows (data), and define primary keys.
Execute CREATE DATABASE, USE, CREATE TABLE with columns (roll_number PK, name, age), and verify in Workbench.
Insert rows with INSERT INTO ... VALUES, handle duplicate primary key errors, and view data with SELECT *.
Compare fixed-length CHAR and variable-length VARCHAR, and explain memory efficiency of VARCHAR.
Describe BLOB for large strings, INT/TINYINT/SMALLINT/MEDIUMINT/BIGINT ranges, BIT, FLOAT, DOUBLE, and BOOLEAN (via TINYINT).
List DATE, TIME, DATETIME, YEAR types and introduce constraints: PRIMARY KEY, NOT NULL, DEFAULT, CHECK, FOREIGN KEY.
Solve a practice problem: create database, employee table (id PK, name, salary), insert data, and select all.
Use SELECT column_list FROM table and SELECT * to retrieve specific or all columns from a table.
Insert single/multiple rows with explicit column lists or implicit order, and verify with SELECT.
Detail INT ranges, TINYINT/SMALLINT/MEDIUMINT/BIGINT, BIT storage, FLOAT precision, DOUBLE for large decimals.
Apply DEFAULT to set fallback values (e.g., salary 25000) and CHECK to enforce conditions (e.g., age >= 18).
Filter rows using WHERE with operators: =, !=, >, >=, <, <=, and string matching.
Combine multiple conditions in WHERE using AND, OR, and negate with NOT.
Match values against a list (IN), range (BETWEEN), and patterns with wildcards (LIKE % _).
Sort results ascending/descending with ORDER BY and restrict row count with LIMIT (e.g., top 3 students).
Compute single-value summaries over columns: maximum, minimum, average, sum, and row count.
Group rows by a column (e.g., city) and apply aggregates per group (e.g., count students per city).
Filter groups after aggregation using HAVING (e.g., cities with max marks > 90), contrasting with row-level WHERE.
Recite the standard SQL clause order: SELECT -> FROM -> WHERE -> GROUP BY -> HAVING -> ORDER BY -> LIMIT.
Modify existing rows with UPDATE table SET column=value WHERE condition; handle safe update mode errors.
Remove specific rows with DELETE FROM table WHERE condition; warn against omitting WHERE.
Change table schema: ADD COLUMN, DROP COLUMN, MODIFY COLUMN (type/constraint), RENAME TABLE.
Distinguish TRUNCATE (delete data, keep structure) from DROP (delete table entirely).
Define FOREIGN KEY REFERENCES parent_table(column), identify parent/child tables, and visualize ER diagram.
Apply ON UPDATE CASCADE and ON DELETE CASCADE to propagate parent changes to child tables automatically.
Combine rows from two tables where join columns match (e.g., student.id = course.student_id).
Retrieve all rows from left/right table plus matches; emulate FULL JOIN via UNION of LEFT and RIGHT JOINs.
Isolate non-matching rows: LEFT EXCLUSIVE (LEFT JOIN WHERE right.key IS NULL), RIGHT EXCLUSIVE, FULL EXCLUSIVE.
Join a table to itself using aliases (e.g., employee.manager_id = manager.id) to find manager names.
Combine result sets vertically: UNION removes duplicates, UNION ALL keeps all rows; column count/types must match.
Nest SELECT inside WHERE for dynamic filtering (e.g., students with marks > class average, even roll numbers).