MySQL: The Ultimate MySQL Course

Learn sql fundamentals through interactive statements, grasp sql syntax and clauses, and see results from a simple relational database like a publisher table.

Explore relational databases and tables with a book pub database, focusing on primary keys and joins. Learn SQL in MySQL to select, insert, update, delete, and create data.

Explore core MySQL statements in a whirlwind tour: create and drop tables, insert and update data, select with order by, and join employees with departments to show related data.

Install a local or hosted MySQL environment by choosing a hosting service or using wamp/mamp, start the server, access my admin, create databases, and load test data with SQL.

Learn how to create a table with columns, data types, and constraints like primary key and not null, and remove tables with drop table, using a test database and employee schema.

Explore the three core data type categories in MySQL—text/character, numeric, and date/time—covering var char versus char, numeric with decimals, and date time storage, defaults, and formatting.

Learn how a primary key guarantees unique values and identifies a single row, with examples using author_id and isbn and a multi-column key.

Create indexes on database tables to speed up queries, including unique and multi-column indexes, while the database engine decides when to use them; manage and drop indexes as needed.

Learn how to modify an existing table after creation with alter table, changing columns, adding and dropping columns, with examples like widening last name and adding a phone column.

Learn how to add rows to a table using the insert into syntax, specify columns and values, handle nulls, and review a publisher table example.

Learn how to change existing data with the update statement, using the set clause and optional where clause to update specific rows, with examples adjusting book prices and advances.

Learn how to remove rows from a table using the delete statement, with where clauses to target records (such as price or city) and avoid deleting all data.

Learn to retrieve data from a table with select *, limit to specific columns like title and price, and understand nulls in a relational database.

Master restricting rows with the where clause in a select statement, using price thresholds, null exclusions, and Cupertino publisher filters, then tailor results by selecting title and price.

Learn to use mathematical and text expressions in a MySQL select statement to compute revenue, format results, and alias expressions for clearer output.

Learn to sort query results using order by, including sorting by title and price, with ascending and descending options, multiple columns, and secondary sorts within groupings.

Learn how to use comparison operators in the where clause, including not equal, exclude California records, and order results by last name and first name, with date and price examples.

Learn how to use and, or, and not in SQL where clauses to filter rows and understand how true conditions determine results.

Learn how to handle null values in MySQL using is null and is not null, differentiate null from blank or zero, and practice with the book table examples.

Identify how foreign keys link a table to a primary key in another table, enabling one-to-many relationships and joined queries across publishers and books.

Learn how to join tables in MySQL using the on clause and the using clause. Use table aliases to simplify queries and qualify column names.

Explore aggregate functions in SQL, including sum, average, min, max, and count, with examples using the book and author tables, handling nulls and group by clause.

Explore single row functions in MySQL, operating on a row at a time, with text, numeric, and date operations and examples like lower, upper, substring, concat, round, and date format.

Learn to use group by to summarize year-to-date sales by book type, handle null groups with where, and join book and publisher tables to show sales by publisher.

Learn how to filter groups with the having clause in MySQL, using aggregate criteria like average price to refine results, and understand why the where clause cannot filter summaries.

Learn to model many-to-many relationships in MySQL with a bridge table between authors and books, using foreign keys and a composite primary key, plus three-table joins.

Master multi-table joins in MySQL using the using clause, performing three- and four-table joins across publisher, book, book_author, and author to show books with authors and royalty shares.

Learn to join multiple tables using the on clause with table aliases, linking book, book author, and author. Explore multi-column joins on city and state to connect authors with publishers.

Learn to remove duplicate rows in MySQL queries by using distinct before the select list, then count distinct states and group by state for summaries.

Master the like operator for pattern matching in SQL, using percent wildcards and underscores to express begins with, ends with, and contains patterns. See case-insensitive results with names and numbers.

Learn to use the in operator in the where clause to replace long or conditions with a state list, as shown with Illinois, Utah, Michigan, and California.

Master subqueries in depth with MySQL, filtering authors who wrote more than one book and comparing prices using inner select results in outer queries.

Create or replace a view to store a select statement as a virtual table you can query like a regular table, and use it to simplify joins and control security.

Combine the results of multiple select statements using union or union all, apply a final order by to the combined set, highlight duplicates, and label origins with text expressions.

Explore legacy sql techniques, from pre-join era methods to placing join criteria in the where clause, using table aliases, and understanding correlated subqueries.

Master creating and managing tables, indexes, and views in MySQL, then query data with joins, aggregates, and sorting. Understand foreign keys and third normal form.