Book now

MySQL Intermediate 3-day Course

Course summary

Learn how to get valuable information, trends, summaries, statistics and insights from your company data.

This course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information.

This course uses MySQL Workbench. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

Prerequisites: Understanding of data
Duration: 3 days.
Max group size : 4 delegates.
Included in the price: Certificate on completion (assessment based), Course notes, Practical Class exercises, Teas/Coffees but no lunch
To assist after the course: 1-Hour mentoring, online via Skype

Course Contents:

Session 1,2and 3: Brief revision of Basics

Session 4: LIMIT, UNION and AGGERGATE Functions

The LIMIT clause, Union, Union all, Aggregate, GroupBy , Rollup with group By, Having.

Session 5: Joins and Subqueries.

Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products.

Correlated and uncorrelated Subqueries.

Session 6: Numeric and Character Functions. DATE, TIME and Other functions.

Session 7: Create, alter and drop Views. Stored procedures, without and with parameters. Custom Functions.

Session 8: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints.

Session 9: Create, alter and drop Indexes.

Session 10: Managing Data

Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits

Session 11: Access Control

Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges

Session 12: Import and Export

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Starting How long Where Price

Mon 25th Jun
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 4PD
Map

£650
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

3 days
Full time
London,
WC2N 4HS
Map

£750
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

3 days
Full time
London,
WC2N 5BY
Map

£750
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

3 days
Full time
Milton Keynes,
MK9 2UB
Map

£875
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

3 days
Full time
Southend-On-Sea,
SS1 1NE
Map

£875
per course

> Book now

Mon 02nd Jul
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 4PD
Map

£650
per course

> Book now

Mon 09th Jul
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 4PD
Map

£650
per course

> Book now

Mon 16th Jul
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 4PD
Map

£650
per course

> Book now

Mon 23rd Jul
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 4PD
Map

£650
per course

> Book now