Introduction to MySQL

3 days @ £995.00 exc. VAT

Course Code: MYSI

Upcoming Scheduled Events - next 6 months

Location	Start Date	Spaces	Book
London	09 Jul 2018	Spaces	Book
Sunderland	01 Aug 2018	Spaces	Book
London	12 Sep 2018	Spaces	Book
Manchester	17 Sep 2018	Spaces	Book

View Further Dates

Location	Start Date	Spaces	Book
Sunderland	08 Oct 2018	Spaces	Book
London	05 Nov 2018	Spaces	Book
Manchester	28 Nov 2018	Spaces	Book
Sunderland	05 Dec 2018	Spaces	Book

Virtual Events You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

S10

Introduction to MySQL Course Overview

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

The delegate will learn and acquire skills as follows:

Using client programs to access a MySQL database
Creating, altering and dropping a MySQL database
Writing SQL statements to select data from a MySQL database
Writing joins and subqueries
Using SQL expressions
Using SQL aggregate functions and scalar functions
Inserting, updating, deleting and replacing rows
Creating and altering tables, indexes and views
Using transactions
Granting and revoking access privileges on tables and views
Exporting and importing data

Who will the Course Benefit?

Anyone who needs to access and work with a MySQL Database.

Course Objectives

To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.

Examinations

Together with the MySQL for Developers course, this course covers the major topics required for the MySQL 5.6 Developer Certified Professional Exam(1Z0-882).

Together with theMySQL Database Administration course, this Introduction to MySQL course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Database Administrator Certified Professional Exam(1Z0-883).

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements

There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.

Follow-On Courses

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

View Course Contents - DAY 1

Introduction to MySQL Training Course

Course Introduction

Administration and course materials
Course structure and agenda
Delegate and trainer introductions

Session 1: DATABASE CONCEPTS

What is a database?
Database management systems
Tables, rows and columns
Indexes, primary keys, unique constraints and foreign keys
Client-Server architecture
Supported data types
Storage engines and table types
The Information_Schema and MySQL Databases
Exercise: Using a MySQL Database

Session 2: USING THE MySQL CLIENT

What is the MySQL client?
Getting started and Logging in
Selecting a database
Client commands
Entering and executing SQL statements
Retrieving previous commands
Creating, editing and executing SQL files
Redirecting output into a file
Command line execution of MySQL Scripts
Exercise: Using the MySQL Client

Session 3: BASIC SELECT

Session 4: LIMIT, UNION AND AGGREGATE FUNCTIONS

The LIMIT clause
UNION
UNION ALL
Aggregate functions
The GROUP BY clause
Using Rollup with GROUP BY
The HAVING clause
Exercises: Using Limit, Union and Aggregate Functions

View Course Contents - DAY 2

Introduction to MySQL Training Course

Session 5: SUBQUERIES AND JOINS

Session 6: NUMERIC AND CHARACTER FUNCTIONS

Function types
Testing functions
Numeric functions
Character functions
Exercise: Using Numeric and Character Functions

Session 7: DATE, TIME AND OTHER FUNCTIONS

Date and time column types
Date and time formats
The date format function
Functions to return date time
Functions to extract components from date time
Date time arithmetic
Miscellaneous functions
Exercise: Using Date, Time and other functions

View Course Contents - DAY 3

Introduction to MySQL Training Course

Session 8: DATABASES AND TABLES

Creating a database
Selecting a database
Creating tables
Auto_increment
Show create table
Column operations
Constraint operations
Copying tables
Renaming tables
Changing engine for tables
Dropping tables
Temporary tables
Exercises: Maintaining databases and tables

Session 9: INDEXES AND VIEWS

Session 10: MANAGING DATA

Session 11: ACCESS CONTROL

Creating users
Renaming users
Dropping users
Granting privileges
Revoking privileges
Exercise: Creating users, granting and revoking

Session 12: IMPORT AND EXPORT

Exporting using SQL
Importing using SQL
Exporting from the command line
Importing from the command line
Exercise: Export and import data

Home Let Us Call You Enquiry

Place A booking

97.35%
Instructor
Quality
Rating

92.55%
Course
Practical
Rating

94.36%
Overall
Courseware
Rating

96.3%
Overall
Course
Rating

Print Friendly

97.35%
Instructor
Quality
Rating

96.3%
Overall
Course
Rating

Course Reviews

The course is perfect for anyone who is just starting to use MySQL. Well paced and with enough time for questions and to go over the exercises if any of the candidates were unclear. I feel that I would be able to go back to work and start using these techniques immediately.

Simone - Programme Support Officer - NHS - March 2018

Really good course for beginners, I had zero coding or database experience before starting the course but had no problem with the practice exercises due to the clear explanation of everything taught. Would recommend to friends or colleagues. Thanks!

George - Marketing Data Analyst - Marketing - August 2017

Fantastic trainer... really enthusiastic, helpful and made the course very understandable. Would definitely come back for future training. Thanks, Paul

Paul - CRM Email Marketing Manager - Retail / Hire

More Course Reviews....

Excellent course, would recommend to colleagues or friends.

Paul - Tech Support Engineer - IT

Very well structured thank you! Enjoyed the pace and the challenging exercises.

Katerina - Analyst Statistician - Automotive

I have achieved what I need from attending that course, thanks to the trainer for his help on that.

Ahmed - Senior IT Support Specialist - Oil

All Course Reviews....

Book further course dates

London dates View London dates

London Venue

View London location details

Manchester dates View Manchester dates

Manchester Venue

View Manchester location details

Sunderland dates View Sunderland dates

Sunderland Venue

View Sunderland location details

StayAhead Locations

Request a Centre .......

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.