SQL - Introduction to SQL with MySQL

Sql, the structured query language, enables you to create databases and tables, insert data, and query for specific records to generate reports and export results.

Learn to distinguish flat and relational databases, understand how to break a flat list into related tables, and relate data with common keys like customer id and employee id.

Explore why MySQL, a free open source relational database management system, is cross-platform and easy to use for creating and relating multiple tables and running SQL queries.

Download the MySQL workbench and server for Windows from mysql.com, select the MySQL installer for Windows in the community downloads, download the larger file, then run the installer to install.

Install MySQL on Windows by selecting developer defaults, configuring the server and MySQL Workbench, and creating a secure password; then launch MySQL Workbench to manage your database.

Explore the MySQL Workbench interface, learn to connect to a local MySQL server, store passwords securely, and navigate schemas, object info, and the SQL editor to write and run statements.

Set up the MySQL server and workbench, run the SQL file to create the Intro_SQL database with tables for employees, customers, orders, and products, then tour and refresh the schema.

Learn how to select the working database in MySQL using the use statement, switch to the intro_SQL database, and ensure all queries run against the active database.

Learn the sql select statement syntax, specifying columns and the table to pull data from, with examples showing single and multiple columns from the customers table.

Use the select statement to pull specific columns from the customers table in your database, validating column names with object info and executing the query to view results.

Learn how to fetch all columns from a table by using the select statement with an asterisk in SQL, demonstrated on the customers table.

Create readable report outputs by renaming columns with the alias keyword in a select statement, using as and single quotes for multiword aliases.

Use the select distinct country from customers statement to pull unique country values, removing duplicates from the results.

Explore the where clause syntax to filter results via a select statement from a table, using equals, greater than, and less than with quoted literals, as shown for country Germany.

Use the where clause to filter the customers table by country, returning only records where country equals France with id, company name, and phone number.

Filter text vs numeric data using SQL where clauses: apply equals for strings with quotes, and use greater than or less than on freight values in the orders table.

Learn to apply the SQL and operator to filter records by multiple criteria using the where clause, with examples from the customers table to retrieve USA and Oregon results.

Learn to add single-line and multi-line comments in MySQL files using -- with a space and /* ... */ to document statements for coworkers, without affecting execution.

Explore filtering date values in MySQL by using the between operator or a range with and on the order date, including quoting dates.

Learn to use the or operator in SQL to filter by multiple countries, compare and vs or logic, and write effective where clauses.

Explore the lab environment for the MySQL course, practice with phpMyAdmin or terminal, and complete tasks on identifying the database, selecting data, aliasing columns, and filtering with where and between.

Explore the order by syntax in SQL select statements to sort results, with ascending as the default and descending when specified, demonstrated in MySQL Workbench.

Apply the order by keyword to sort data in MySQL by selecting id, company name, and country from the customers table, then sort ascending or descending.

Sort SQL data by multiple columns using order by, first by country then by company name, with ascending as default and optional descending for deeper result ordering.

Group by clause groups records with the same values, enabling per-group summaries such as counting customers by country using an aggregate like count.

Group by the country column to group the customers table by a single value, producing one record per country and revealing how group by differs from distinct.

Explore the key differences between distinct and group by in SQL, showing how distinct returns unique rows while group by enables aggregation like summing units in stock by category.

Group by category, remove distinct, and calculate sums of units in stock with an alias total stock to perform calculations within grouped data and explore other aggregate functions.

Explore MySQL aggregate functions for grouping, such as min, max, and average, to analyze category stock and identify reorder needs; consult the attached resource for more examples.

Filter grouped data by applying the having clause to aggregate calculations, such as total stock per category, using group by and having to enforce criteria.

Create a new database in MySQL using the create command, name the database, and refresh the schema to view it. Then create tables and insert records inside that database.

Explore how to delete a database in MySQL using the drop command, and heed the caution that this action removes the database and its content.

Create a table in a MySQL database with the create table statement, define id, first name, last name, and department as varchar, and ensure the correct database is in use.

Learn how to enforce data integrity with the SQL not null constraint, ensuring the id and first name values are always present while the last name remains optional.

Explore the SQL auto increment column, which lets the ID field automatically populate with a numeric value and increment for each new record as users enter data.

Learn how the id field serves as the primary key, ensuring uniqueness, not null, auto increments, and creates an index to enable relationships between tables and faster lookups.

Explore table relationships in MySQL by linking an employees table to a customers table using a primary key and a foreign key, creating a one-to-many relationship and enabling efficient queries.

Master the sql insert into statement to add records to an existing table, exploring two methods: insert all columns or explicitly list targeted columns and values.

Learn how to insert data into specific columns with insert into, omitting the auto-incremented id, and verify results using select statements and the output panel.

Learn to insert data with explicit column lists or with all columns supplied. Use defaults for autoincrement ids and avoid column count mismatches.