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.

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: Subqueries and Joins

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

Session 6: Numeric and Character Functions

Session 7: DATE, TIME and Other functions

Session 8: Databases and Tables

Session 9: Indexes and Views

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.

Buy a voucher
Starting How long Where Price

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

3 days
Full time
London,
WC2N 4AP
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

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

3 days
Full time
Manchester,
M2 2AN
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

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

3 days
Full time
Milton Keynes,
MK9 2UB
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

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

3 days
Full time
London,
WC2N 5BY
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

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

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

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 04th Oct
11:00am - 6:00pm

3 days
Full time
London,
WC2N 4AP
Map

£750.00 17% off
£622.5
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 04th Oct
11:00am - 6:00pm

3 days
Full time
London,
WC2N 5BY
Map

£875.00 17% off
£726.25
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 04th Oct
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 2AN
Map

£875.00 17% off
£726.25
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 04th Oct
11:00am - 6:00pm

3 days
Full time
Milton Keynes,
MK9 2UB
Map

£875.00 17% off
£726.25
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 04th Oct
11:00am - 6:00pm

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

£875.00 17% off
£726.25
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher