Learn SQL databases in a weekend

Install MySQL by following official instructions; set up the database server and client, install language drivers, and optionally add a database administration tool, with Windows steps and Linux/macOS links.

Install the MySQL community server on Windows and choose server only with port 3306. Start the Windows service, set a root password, and test the connection.

Open and configure the MySchool database by creating a new MySQL connection, verifying host, port, and credentials, installing the driver, and debugging the public key retrieval issue.

Define table columns by name and type, noting types vary by database system. Explore common types like integers, decimals, date/time, strings, and binaries, and use them for arithmetic.

Learn how to escape reserved keywords with backticks to safely name tables or columns like order, avoiding syntax errors and enabling flexible database design.

Learn to create a database and a store table in sql, define id as auto increment primary key with name and address, and use database.table syntax.

Alter table lets you modify a table after creation by listing actions (add, drop, rename, change) including primary keys, separated by commas and ending with a semicolon.

Drop the employee table, then restore the database by importing the provided Eskil dump from lecture resources to recover the original structure.

Insert data into tables using the insert into statement to add rows to the employee table, with case-insensitive keywords, specifying columns and values in quotes, ending with a semicolon.

Insert two employees into the employees table, including Charlie Young at 1.85 meters and Other Lovelace at 1.77 meters, to practice SQL insert operations.

Insert two people into the employee table using first_name, last_name, and height, then verify that two new rows appear.

Create a product table with id as an auto incrementing primary key, and name as a string and quantity as an integer defaulting to zero.

Extend the product table by adding a new column named added with a default today's date, then insert a couple of products and verify the added column shows the date.

Learn to query data from a single table using the select statement, understand its parts and the importance of order, and know that queries return a table.

Learn how to select specific columns in SQL by using projections instead of select asterisk, returning only name and quantity from the product table.

Practice using expressions in select statements to convert heights from meters to feet and apply arithmetic on single or multiple columns, including plus, minus, multiplication, and division.

Learn how the where clause filters rows by evaluating a condition for each row and returns only those that satisfy it, illustrated with employee and product table examples.

Learn how to combine conditions with logical operators using and, or, and not in SQL. Explore practical examples—range filters, or-conditions, and complex first-name and height queries—highlighting potential surprises.

Explore how operator precedence shapes SQL queries, with arithmetic, comparison, and logical operators, and learn to enforce the intended order using parentheses.

Learn substring search in sql using the like operator with the % wildcard to pattern-match names. Discover case-insensitive matching that finds starts-with and contains patterns, returning Chuck, Charlie, and Jack.

Group data by chosen columns and apply aggregates to each group to produce counts and sums. Group by single or multiple fields, and order results by category or first name.

Learn to insert null values in sql by using insert into statements for two products with unknown quantity and category, where weight is 0.01.

Learn how null values influence expressions and comparisons in SQL, where unknowns yield null in arithmetic and cannot be compared, leaving only null or not null checks.

Explore how null values affect aggregation in sql, learning how averages and sums treat unknowns, the difference between count(*) and count(column), and grouping by nulls.

Practice delete statements by removing all products with no weight, using a proper delete statement. Consider exporting data, backing up the database, and restoring from backup in the next video.