Learn MySQL from scratch for Data Science and Analytics

Install MySQL community server 8.0 on Windows, configure an instance name and users, set the TCP/IP port to 3306, and optionally install Workbench and sample databases to connect later.

Learn to connect a MySQL server instance using MySQL Workbench, configure local and remote connections, test the connection, and explore databases, tables, views, procedures, and schemas.

Explore MySQL Workbench overview: connect to a database, create new connections, view schemas, run queries, and monitor server status with administration tools.

Download a sample MySQL database from GitHub using MySQL Workbench to practice schemas, tables, and data for data science and analytics.

Learn MySQL server basics, including creating databases and tables, choosing data types with MySQL Workbench, and implementing primary and foreign keys, plus creating temporary tables for real-world scenarios.

Learn the fundamentals of MySQL databases and SQL, compare spreadsheets to relational databases, and explore data integrity, multiuser access, and basic queries like select from where.

Create databases and schemas in MySQL using Workbench, name them in lowercase with underscores, apply to the connected server, and explore default objects like tables, views, stored procedures, and functions.

Learn to set a primary key in MySQL Workbench for the id column, using create or alter table, ensuring not null and unique values to improve performance.

Learn to implement foreign key constraints by linking a student registration table to a course table, using course_id as a foreign key referencing the primary key.

Create and explore an enhanced entity relationship diagram using MySQL workbench, performing reverse engineering to reveal primary and foreign keys, and establish one-to-one and one-to-many relations.

Learn the sql data manipulation language basics in mysql, including insert, update, and delete statements to manage data records in a table.

Learn how to update records in MySQL using the update statement, set, and where clause to modify a course's name and description for a specific id, with MongoDB example.

Learn to write a create table statement in MySQL, define a person table with id as primary key, name, email, and registration_date defaulting to current timestamp, then insert and query.

Modify an existing table with the alter statement using the MySQL Workbench wizard to add an address column, set its data type and length, and apply changes on staging first.

Explore how comments in a MySQL query document purpose, authorship, and creation date to aid maintenance and quick problem identification.

Learn how to rename a table in MySQL using the rename keyword and alter table, without changing its structure, using MySQL Workbench, applying changes, and refreshing the database to verify.

Create a new database user in MySQL Workbench by adding an account, configuring login details, and applying the settings, with permissions granted via data control language in the next lecture.

Grant permissions to a MySQL user by selecting a schema or all schemas, assign select, update, insert, delete, create, and alter rights, and apply to secure access.

Learn how to revoke permissions in MySQL using data control language and a guided wizard, including revoking all privileges and managing global privileges across instances.

Learn how to use the column alias in MySQL to rename fields such as customer name and postal code, enabling customized columns and easier joins for reports.

Learn to build dashboard analytics reports using simple aggregation functions, counting registered customers and orders to present live totals and drill-down insights on a configurable dashboard.

Master the select and where clause to filter records from the customers table using customer number and operators like and, or, in, and between.

Learn to apply the sum aggregation function in MySQL to compute total amounts from payments, and use group by to generate category-, product-, or customer-wise totals for decision making.

Apply min and max aggregate functions in MySQL to extract the smallest and largest transaction amounts, understand their use with customer IDs, and practice real-world queries.