MySQL Intermediate Course

Short course

Online

Save 10%
£ 675 VAT exempt

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    3 Days

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

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

Ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information.

Previous experience with data

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MySQL
  • Database
  • Database training
  • Web
  • Intermediate
  • Data Types
  • Functions
  • Queries
  • Access Control
  • Joins

Teachers and trainers (1)

Sarah Barnard

Sarah Barnard

Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

Course programme

SQL Course Contents:

Session 1, 2 Brief revision of Basics

Session 3: Union, Union All, Intersect, Minus

Session 4: AGGERGATE Functions

Aggregate, GroupBy , Rollup with group By, Having.

Session 5: Joins

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

Session 5: Subqueries.

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.

Session 7: Custom Functions.

Session 8: Managing Data

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

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

Session 10: Create, alter and drop Indexes.

Session 11: Access Control

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

Session 12: Import and Export

MySQL Intermediate Course

£ 675 VAT exempt