
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 27-lesson course built from Data with Baraa's 4h 04m of YouTube video. 3 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 Data with Baraa on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand the course structure, why SQL is a high-demand skill, and the core concepts of data, information, databases, DBMS, and SQL.
Explain how relational databases organize data into servers, schemas, tables, columns, rows, cells, and primary keys, and contrast MySQL's schema/database model with other systems.
Classify SQL commands into Data Definition, Data Query, Data Manipulation, Data Control, and Transaction Control languages, and identify which groups the course covers.
Break down a SQL statement into comments, clauses, keywords, identifiers, and operators to read and write queries more effectively.
Navigate the Navigator (schemas/tables), Main Toolbar (DDL), Query Toolbar (execution), Query Editor, Result Grid, and Output/Log panels in MySQL Workbench.
Download the tutorial SQL script, execute it in MySQL Workbench to create the 'customers', 'employees', and 'orders' tables with sample data, and verify the installation.
Apply three formatting rules—new lines for clauses, uppercase keywords, and explicit column names—to write readable, maintainable SQL queries.
Write SELECT * and SELECT column_list FROM table queries, understand clause order (SELECT before FROM), and retrieve all or specific columns from a table.
Sort query results ascending (ASC) or descending (DESC) by one or multiple columns, and avoid using column positions in ORDER BY for maintainability.
Add WHERE conditions after FROM to filter rows by exact matches (e.g., country = 'Germany') and understand how the database evaluates each row against the condition.
Use =, <>, >, <, >=, <= to filter numeric and text columns, and rewrite BETWEEN as two explicit comparisons for clarity and boundary control.
Combine multiple conditions with AND/OR, negate conditions with NOT, and handle NULL values correctly when using NOT.
Filter rows within inclusive boundaries using BETWEEN min AND max, and prefer explicit >=/<= conditions for readability and flexible boundary handling.
Match a column against a list of values using IN (val1, val2, ...) as a compact, readable alternative to chaining multiple OR conditions.
Build patterns with % (any characters) and _ (single character) to filter strings by prefix, suffix, containment, or exact position, and understand case sensitivity.
Explain how joins combine columns from two tables, define the join key, and use aliases (AS) to shorten table references and avoid ambiguous column names.
Write INNER JOIN queries to return only rows with matching keys in both tables, and trace how the database matches and filters non-matching rows.
Combine rows from two tables with identical column counts and orders using UNION (removes duplicates) or UNION ALL (keeps duplicates), and control output column names in the first SELECT.
Calculate totals, sums, averages, minimums, and maximums over columns, handle NULLs correctly, and alias aggregate columns for readable output.
Manipulate text by concatenating columns, changing case, trimming whitespace, measuring cleaned string length, and extracting substrings by position and length.
Group rows by a column (e.g., country) and apply aggregate functions per group, then sort grouped results with ORDER BY after GROUP BY.
Filter grouped results using HAVING with aggregate conditions (e.g., COUNT(*) > 1) placed after GROUP BY, distinct from WHERE which filters raw rows.
Write dynamic filters using subqueries in WHERE with IN (list match) or EXISTS (correlated existence check) to avoid hard-coded value lists.
Insert new rows with INSERT INTO table (columns) VALUES (values), use DEFAULT for auto-increment keys, NULL for optional columns, and verify with SELECT.
Change specific column values for a single row using UPDATE table SET column = value WHERE primary_key = id to avoid accidental mass updates.
Define new tables with CREATE TABLE specifying column names, data types (INT, VARCHAR, DATE), sizes, and constraints (PRIMARY KEY, AUTO_INCREMENT, NOT NULL, UNIQUE).
Add columns to existing tables with ALTER TABLE ADD COLUMN, and permanently remove tables with DROP TABLE.