SQL Masterclass: Basics to Expert with AI & Tutor Support

Identify tables, keys, columns, and constraints by analyzing daily operations to design a library database with entities like members, staff, books, and transactions for efficient storage, retrieval, and SQL-based creation.

Learn how primary keys and foreign keys connect tables, define 1-to-1, 1-to-many, and many-to-many relationships, and use the transactions table as a junction to link members, books, and staff.

Learn to build a hospital ERD by identifying patients, doctors, appointments, admissions, and treatments, and mapping one-to-many and many-to-many relationships.

Apply entity relationship diagrams to define entities, attributes (columns), data types, and constraints. Learn to assign primary keys, foreign keys, not null, unique, and default values for a database schema.

Explore building a hospital database with patients, appointments, doctors, admissions and treatments; learn keys, relationships, data types, constraints, and a doctor–treatment junction table—prepping for sql implementation.

Explore SQL basics to create, store, and retrieve data using keywords and syntax. Practice with library and patient admission databases via MySQL workbench, working with commands and comments.

Create and modify a library database in SQL, including creating databases and tables with appropriate columns, data types, and constraints, and altering tables with foreign keys and primary keys.

Learn hands-on how to design and implement a library database by creating tables from an entity relationship diagram, defining primary and foreign keys, constraints, and linking tables with SQL workbench.

Learn how to store data in tables with sql insert into values, update set where, and delete where, ensuring data integrity and correct constraints in real-world library systems.

Learn hands-on how to store, update, and delete data in a library database using SQL workbench. Create tables, enforce constraints, and manage transactions with inserts, updates, and deletes.

Learn to retrieve data using select from, filter with where, and sort with order by; aggregate data to answer business questions and combine data from multiple tables.

Learn basic data retrieval with SQL: select, where, like, between, and in; concatenate first and last names; and sort and filter on a hospital database.

Apply SQL aggregate functions to summarize data using sum, average, count, max, and min; group by categories, use where and having to filter after aggregation for quick insights.

Learn to summarize data in sql by calculating averages, bmi, and counts, and group by gender or city to gain high-level insights.

Learn to summarize data in SQL using functions and grouping to gain key insights without retrieving all records. Explore records with order by, limit, and subqueries on a hospital database.

Join a hands-on demonstration of summarizing data in sql. Learn to use aggregate functions—count, sum, average, max, and min—along with case when, group by, and having to generate concise insights.

Explore how to combine data from multiple tables using inner, left, right, and full outer joins in SQL, with library database examples linking members, transactions, and books.

Learn how inner joins connect admissions and patients to analyze age and duration of stay, using normalization, primary and foreign keys, and the on clause.

Explore hands-on sql joins to answer business questions by linking patients, provinces, admissions, and doctors; use inner and left joins, filter diagnoses, and count admissions per doctor.

Explore SQL techniques for doctors and admissions data, including inner joins, first and last admission aggregation, concatenating names, and union of patients and doctors.

Apply multi-table inner joins across patients, admissions, and doctors to list epilepsy patients with patient names, diagnoses, attending doctor Lisa, and doctor specialty.

Learn to use subqueries and nested queries to simplify data retrieval, break complex problems into steps, and reuse intermediate results. Practice applying subqueries in real-world databases for clearer sql.

Learn hands-on subqueries in SQL, using the hospital database to compare with joins, filter admissions by allergies, and order by most recent dates in Alberta.

This hands-on SQL lecture demonstrates subqueries, linking doctors and patients via admissions, filtering Ontario females weighing 60–100 kg born in Feb, May, or Dec, and extracting birth month for insights.

Master SQL basics and database concepts, including data types, tables, keys, joins, and subqueries. Elevate skills with window functions, indexing, stored procedures, and BI integrations with Power BI or Tableau.