Menu
  1. Home
  2. Programming
  3. SQL
  4. Short
  5. MySql Intermediate 3-Days
Enquire Now

MySql Intermediate 3-Days

Study Method
In-class
Locations
London, Milton Keynes, Portsmouth, Southend-on-Sea
Institution
PCWorkshops
Start Date
Multiple start dates available

Course overview

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 modelling, 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.

Expand all and read more

Campus locations

Study method

  • In-class
  • Blended
  • Online

Locations

  • England
    • London
    • Milton Keynes
    • Portsmouth
    • Southend-on-Sea
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 3 Days

Entry requirements

Prerequisites: Understanding of data

Find out more about the entry requirements for this course
Get the course guide

Course features

  • SQL course certificate on completion (assessment based)
  • SQL course notes
  • Practical SQL course exercises, SQL course homework/SQL course revision work
  • To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer
  • Max group size on this SQL course is 4

Subjects

Core Sessions
Sessions 1-3: Brief revision of basics
Session 4: LIMIT, UNION and AGGREGATE Functions

The LIMIT clause, UNION, UNION ALL, AGGREGATE, GROUP BY, ROLLUP with GROUP BY and HAVING

Session 5: Joins and Subqueries

Joins with original syntax, Table aliases, Natural Joins, Join using, Join on, Multi-table joins. Cartesian products and 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, Data Types, Constraints
And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £800 

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.