3-Day MySQL Intermediate Course – Hands-On Training in London & Online

Course Schedule and Hands-On Training Format


Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements.
Hands-on, Practical MySQL Course Intermediate.
PCWorkshops MySQL Course Intermediate Certificate.
Max 4 people per course, we keep it personalised.

Where is the MySQL Course Intermediate?

  • Online: Instructor-led.
  • Classroom: Request per email.

MySQL Course Intermediate Materials

  • mySQL Coding Examples
  • Manuals and Notes: In-depth reference materials
  • Exercises: Practical exercises

Who Should Attend This 3-Day MySQL Workshop

  • You already have an idea of mysql and most like can read queries

Included with MySQL Course Intermediate:

  • Certificate of Completion for the MySQL Intermediate Course
  • Comprehensive MySQL Intermediate Course Manual
  • Practical MySQL Exercises, Intermediate-Level Code Samples, and Revision Work
  • One Free Post-Course Q&A Session for MySQL Intermediate Students
  • Small Group Size – Maximum 4 Participants per Online and Classroom MySQL Intermediate Course

What You Will Learn in the MySQL Intermediate Course

<

MySQL Intermediate Course summary



  • DAY 1:
  • The MySQL Intermediate Course focuses on the powerful open-source relational database management system (RDBMS), MySQL. Licensed under the GNU General Public License, MySQL is free to use and widely trusted across industries. Owned by Oracle Corporation, MySQL’s legacy includes a popular fork called MariaDB, created in 2010.
    Did you know? The name “MySQL” combines “SQL” (Structured Query Language) with “My,” named after co-founder Michael Widenius’s daughter.
    In this MySQL Intermediate Course, you will learn how to extract valuable business intelligence from your company data using advanced SQL techniques. The course is designed for managers, data analysts, and professionals who want to uncover insights, trends, summaries, and statistics to drive smarter decision-making.
  • Session 1: Database Concepts To assist with the MySQL aspects of the MySQL Course Intermediate, we also cover database basics. What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
  • Session 2: Using the MySQL client MySQL Course Intermediate Getting started and Logging in, Selecting a database, Client commands, Entering and executing MySQL statements, Retrieving previous commands, Creating, editing and executing MySQL files, Redirecting output into a file, Command line execution of MySQL Scripts
  • Session 3: Basic MySQL SELECT statement The MySQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and MySQL conditional operators. The ORDER BY clause, Column aliases, Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Precedence of operators
  • Session 4: LIMIT / TOP, UNION Queries and MySQL AGGREGATE Functions The LIMIT and TOP clauses, Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Rollup with Group By, Having.
  • Session 5: Joins MySQL Cartesian products, MySQL Joins (Inner join, Left join, Right join, Full join) Table aliases, Natural joins, Multi-table joins. Union, Union All, Except/Minus, Simulating join with Intersect.


  • DAY 2:
  • Session 6: MySQL Subqueries, Nested Subqueries, Correlated and uncorrelated subqueries. Global and Local Temp Tables.
  • Session 7: MySQL Built-in Functions: Numeric Functions (ABS, SIGN, MOD, etc.) and String Functions (Locate, Left, Right, Concat, etc), DATE and TIME functions.
  • Session 8: MySQL Views (Create, alter and drop), Stored Procedures (Create, alter and drop, Input and Output parameters); Custom Functions (Create, alter and drop).


  • DAY 3:
  • Session 9: Managing Data Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
  • Session 10: MySQL Indexes (Create, alter and drop).
  • Session 11: Creating Databases and Tables (Create, alter and drop); Constraints (Add, alter and drop).
  • Session 12: Import data into MySQL and Export from MySQL. Exporting using MySQL, Importing using MySQL.

Book the MySQL Course Intermediate

MySQL Course Intermediate

DOWNLOAD A MySQL Course Intermediate CATALOGUE

MySQL Course Intermediate

Learn SQL

Is MySQL in demand? Over 467,319 companies are using Relational Databases tools. MySQL with 40.76% market share (190,460 customers), PostgreSQL with 17.53% market share (81,902 customers), Oracle Database with 9.83% market share (45,927 customers).
MySQL more popular than MS SQL? As of 2025, Oracle’s Database Management System (DBMS) remains the most popular application in the market, surpassing Microsoft’s and MySQL’s versions. Additionally, Oracle is one of the 20 largest companies in the world, with a market capitalization of $635.16 billion.
Knowledge of SQL good Given the business world’s growing focus on big data and data analytics, knowledge of SQL programming languages has become an important asset for software developers around the world, and database management skills are seen as highly desirable.
What is MySQL? The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
MySQL Course Intermediate
MySQL Course Intermediate

Request a Free mySQL Course Intermediate Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.

Copyright © PCWorkshops 2024. All Rights Reserved.