Learn MYSQL with Examples (Jul 2024)

Explore MySQL workbench, create and drop schemas and tables, and master SQL commands across DDL, DML, DCL, and DQL, plus constraints, clauses, and indexes for efficient querying.

Create and drop databases, schemas, and tables in MySQL Workbench, use the test db, and apply SQL scripts to build and remove structures.

Learn to perform sql commands across ddl, dml, dcl, dql, and tcl with hands-on practice creating databases and tables, and performing insert, query, update, delete, and transaction operations.

Explore not null constraint, unique key constraint, primary key constraint, autoincrement, foreign key constraint, check constraint, default constraint, and composite key handling in MySQL through practical table exercises.

Practice MySQL clauses and indexes with examples, including from, where, and, or, order by, group by, having, limit, distinct; create and drop indexes on employee table and apply aggregate functions.

Explore MySQL joins, views, and triggers, including inner, self, left, right, full, and cross joins, and learn creating, updating, and dropping views with joins and triggers.

Learn to perform inner, left outer, right, full outer, and cross joins in MySQL using the customer and orders tables, including join conditions on customer ID and the union approach.

Learn to create and display MySQL views, including views with join, alter and drop statements, using tutor and contact_tutor tables to produce tutor_details and tutor_age results.

Explore creating, showing, and dropping various MySQL trigger statements, including before and after insert, update, and delete triggers, with practical examples on professor and student tables.

Master MySQL operators and built-in functions, including arithmetic, comparison, logical, set, unary, and bitwise types. Understand user defined functions and stored procedures, with syntax to create, call, and drop.

Explore MySQL operations on an employee table, including arithmetic, comparison, logical, unary and bitwise operators, and set operations like union, union all, and intersect (not supported in MySQL).

Explore how to perform different types of MySQL built-in functions and userdefined functions, including string, numeric, date, and control flow operations, with practical examples and table queries.

Create and call parameterized stored procedures and user defined functions in MySQL. Work with one and multiple parameters and manage procedures using designation and employee tables.

Learn how to import and export data in MySQL, load CSV data, export tables to CSV, and manage concurrency with shared and exclusive locks, plus troubleshooting performance.

Learn to import a csv into a MySQL database via MySQL Workbench using the table data import wizard, then export a MySQL table to a csv file.

learn how to perform read and write table locking in MySQL, observe lock behavior across sessions, unlock tables, and use show processlist to monitor operations.

Explore Google Cloud SQL for MySQL as a fully managed relational database on GCP. Create a Cloud SQL instance, host a MySQL database, and perform actions on the database.

Learn to host a MySQL database on Google Cloud, create an SQL instance, connect via Cloud Shell and MySQL Workbench, manage databases and users, and verify connections.