MYSQL Intermediate Course, 3-Days, London, Live Virtual Classroom

MYSQL Intermediate Course, 3-Days, London, Live Virtual Classroom

Actions and Detail Panel

£750

Data analytics with queries using Oracle MySQL. From basics to intermediate MySQL course. Hands-on. Practical. Online. Instructor-led.

About this event

MySQL Intermediate Course, 3-day

Excellent course to get valuable information, trends, summaries, statistics and insights from your company data.

This MySQL Intermediate course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information. Create your own queries with ease.

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.

Course Duration: 3 consecutive days, the first of which displays as the booking date.

Beginners: Attend all 3 days: day 1,2,3

Intermediate: If you know all about where clauses, joins and aggregate, then day 2 and 3 are for you. Select the ticket at checkout.

MySQL Intermediate Course Contents:

Session 1,2 and 3: Brief revision of Basics

Session 4: LIMIT, UNION and AGGREGATE Functions

The LIMIT clause, Union, Union all, Aggregate, Group By , Roll-up with group by, Having.

Session 5 : Joins and Sub-queries.

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

Correlated and uncorrelated Sub-queries.

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

INCLUDED:

  • MySQL Intermediate Certificate on completion,
  • Course notes, Practical Class exercises.
  • To assist after the course: 1-Hour mentoring, online

System requirements: Your MYSQL Database, Workbench query interface and sample data must be ready before the course starts.

Read more: https://pcworkshopslondon.co.uk/mysql-intermediate-course.html

Share with friends