The Ultimate MySQL Crash Course

Learn to install xampp on a virtual machine, choose a compatible version, and start the apache server and mysql services via the control panel, using phpmyadmin for database management.

Learn to create and drop databases in MySQL using the command line, including selecting database names, using database commands, and understanding syntax and reserved words.

Explore how tables form the building blocks of a database, create a database and a users table, and define columns with names, data types, and constraints like not null.

Describe a table to view its columns, then drop a table to remove it, and learn to handle syntax errors and unknown table messages in MySQL.

Master how to insert data into a MySQL table by crafting insert statements for a users table, including single and multiple row inserts with proper quotes and numeric values.

Update and delete data in a table using SQL statements with where conditions to target specific rows, updating columns like username or email and deleting by id.

Explore the four main data types in MySQL: integers, decimals, dates and times, and strings or text, and understand null values for effective table design.

Explore SQL operators: arithmetic, comparison, and logical operators, and learn how they power select statements and where clauses in MySQL.

Explore constraints and primary keys in MySQL, showing how a primary key identifies a column as unique, not null, usually using an ID column to reliably locate records.

Discover how foreign keys link a table's column to another table's primary key, forming connections such as users to their blogs, and use joins to retrieve related data.

Explore essential MySQL functions that perform operations on data, using select statements to compute averages, counts, minimums, and maximums on numeric and string columns from tables like blogs and users.

Explore the select query in MySQL to retrieve data, select all or specific columns, and filter with where using equals, not equals, and/or logical operators.

Learn how order by sorts query results by a chosen column in ascending or descending order, with practical examples on blogs and users tables.

Learn how group by aggregates data by a column, differs from order by, and uses count to tally records in a Katz category table with auto increment and primary key.

Learn how to use alter table to modify your blogs table by adding a created_at timestamp, updating with data, and dropping the column to see how alterations affect the dataset.

Learn how to use sql aliases to give columns temporary, shorter names with as, see examples selecting titles from a blog table, and understand that aliases don't change stored data.

Explore how inner joins merge data from linked tables to produce matched rows, using keys like id and customer_id. Learn to join multiple tables, apply aliases, and select relevant columns.

Understand how left joins and right joins differ from inner joins in MySQL. See how each join preserves all rows from the left or right table, including unmatched ones.

Master wild cards in sql by using the like keyword in a where clause to pattern match data. Explore starts with, ends with, and contains patterns with percent wildcards.

Learn how underscore and percent wildcards work in SQL like queries to match single or multiple characters, with examples showing how to filter data from tasks.

Set up a simple todos app by establishing a PHP MySQL connection, configuring host, database, and user, handling errors, and creating a tasks table with id, name, and time stamp.

Create a PHP form on index.php, post data to the server, and insert a task into the todos table using a prepared statement, displaying results in a table.

Learn how to insert data via a form, redirect after insert, and loop through all records from the tasks table, displaying id and name.

Create a delete page that removes a database record by passing an id, preparing and executing a delete query, and confirming the record vanishes from the database.

Learn how to implement an update flow: fetch a record by id, display it in a form, and execute an update query to modify the tasks table.