Mastering MySQL from Beginner to Expert

Master how to create a database from scratch using MySQL syntax, including the semicolon and naming, and execute with Ctrl+Shift+Enter. Refresh schemas and use drop database to delete.

Learn how to access and switch between MySQL databases using the use command, create new databases, and ensure subsequent queries target the selected database.

Learn how to create a MySQL table by selecting a database, defining columns with int and varchar data types, using underscores for multiword names, and executing to view the table.

Learn how to insert data into a MySQL table using insert into, specify column names, and supply values for multiple rows with proper quotes and syntax.

Delete data with two forms in MySQL: delete from customers to remove all rows, or delete from customers where condition to target specific rows.

Learn how to drop the customers table from a database using the drop table syntax, then execute to delete it.

Explore how to alter table by adding a new column to the customers table, changing a column's datatype from int to varchar, and dropping a column to manage schema changes.

Learn how to access a sql script to create databases (if not exists customers db), use a database, create tables, and insert data into customers and orders.

Learn to use the select statement to retrieve data from a table, view all columns with an asterisk, and select specific columns like total amount from the orders table.

Use the where clause to filter data in MySQL queries, selecting specific customer records by id, name, or email from the customers table.

Master the between operator to filter records by a numeric range in MySQL using the orders table, with examples of values between 50 and 170.

Explore how the like operator filters results with a where clause using wildcards % and _ to match patterns, such as names starting with j or ending with h.

Explore how to use and, or, and not operators in a where clause to filter data based on multiple conditions, with practical examples from an orders table.

Learn to use the in operator to specify multiple values in a where clause. Retrieve orders by customer_id in (1, 2) and exclude others with not in.

Apply the limit clause to control the number of records returned in a query, such as retrieving only one, two, or more rows from the orders table.

Use the distinct function to retrieve unique values from a specified column in MySQL, such as unique customer IDs from the orders table.

Learn to filter records with comparison operators using the where clause, including greater than, less than, greater than or equal to, and less than or equal to.

Explore how inner joins use a related column to return matching records from two or more tables, including joins across databases with aliases and database prefixes.

Learn how to use right joins to combine orders and customers on the customer id, returning all records from the right table with matching data from the left table.

Master left joins in MySQL by returning all rows from the left table and matching right-table rows, shown by joining the customers and orders tables on customer_id.

Demonstrates how a cross join returns records from both the customers and orders tables by matching the customer ID, even when the tables come from different databases.

Master the MySQL union operator by combining two select statements, such as customer IDs and emails, into a single result set; observe how the order of results may vary.

Learn to compute the sum of a numerical column with the sum function, alias the result as total, and pull data from the orders table in the orders database.

Learn to compute the average of a numeric column using the average function in MySQL, applying it to the orders table and aliasing the result for clarity.

Use the count function to return the number of rows meeting a criteria, such as orders with total amount greater than 50, in the orders table, with an alias.

Learn to use the max and min functions in MySQL to find the largest and smallest values in the amount column, with example results.

Learn how group by clause groups rows with same values and uses aggregate functions like max, sum, average, and count to tally customer IDs by total amount in orders.

discover how the having clause filters grouped results after a group by, using aggregate functions such as count. compare it to the where clause, but it is applied after grouping.

Learn how the order by statement sorts data in ascending or descending order, using desc for descending, with examples sorting the orders table by total amount.

Discover how views act as a virtual table derived from an SQL query, storing no data yet simplifying complex queries and controlling access to specific columns or rows.

Learn to create, manage, and call MySQL stored procedures, including changing the delimiter, writing a begin and end block with a select statement, and executing the procedure to retrieve data.