Training Course

MySQL Introduction

PDF
Course Duration: 3 Days

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.

Course Objectives

    • Create and alter a MySQL database and query and modify data held within such a database

Prerequisites

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

Course Certification

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.

Target Audience for this Course

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

Skills Gained from this Training

    • 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

Course Content

  • 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

  • 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

  • BASIC SELECT

    The SQL SELECT statement
    Case sensitivity
    Quotes
    Statement terminator
    Syntax conventions
    The select clause
    The FROM clause
    Conditions and the WHERE clause
    Logical operators
    The ORDER BY clause
    Column aliases
    Arithmetic expressions
    Precedence of operators

  • 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

  • SUBQUERIES AND JOINS

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

  • NUMERIC AND CHARACTER FUNCTIONS

    Function types
    Testing functions
    Numeric functions
    Character functions

  • 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

  • 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

  • INDEXES AND VIEWS

    What is an index?
    Creating an index
    Reviewing indexes
    Dropping indexes
    What is a view?
    Creating views
    View restrictions
    Dropping views

  • MANAGING DATA

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

  • ACCESS CONTROL

    Creating users
    Renaming users
    Dropping users
    Granting privileges
    Revoking privileges

  • IMPORT AND EXPORT

    Exporting using SQL
    Importing using SQL
    Exporting from the command line
    Importing from the command line

Included with this course

    • Comprehensive course materials and exercises

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
06 Aug - 08 Aug 2025
Virtual
£1195
10 Sep - 12 Sep 2025
Virtual
£1195

Private Training

Private course
Flexible date and location
Please quote for prices

  • Public Dates

    Prices per delegate. All prices exclude VAT.
    06 Aug - 08 Aug 2025
    Virtual
    £1195
    10 Sep - 12 Sep 2025
    Virtual
    £1195

    Private Courses

    Private course
    Flexible date and location
    Please quote for prices
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask a Question
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • MySQL Introduction Course Options
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
  • Virtual Training

 

Course Reviews
Really enjoyed the course and meeting [the trainer], who was very patient and knowledgeable :

M.R. Teesworks, Visio Essentials

Content exceeded my expectations and handouts were informative

V.E. Her Majestys Prison and Probation Service, Minute Taking

Excellent session

M.C. South Tyneside Council, Excel Level 2

Which part of the course did you find particularly valuable A chance to reflect on how we might use sharepoint with our team

E.B. URC, SharePoint Overview

Excellent clear training

G.T. Public course, Microsoft Power BI Desktop

Following this training what are you going to do differently Enhance current Visio charts and use multiple pages

S.P. Direct Rail Services, Visio Essentials

Very good

M.B. MGL Group, Telephone Skills

Enjoyable course

D.S. CMR UK Ltd, Excel Level 2

 

Public Scheduled Courses

Prices per delegate. All prices exclude VAT.
06 Aug - 08 Aug 2025
Virtual
£1195
10 Sep - 12 Sep 2025
Virtual
£1195

Private Courses

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your MySQL Introduction course, we have many solutions available to ensure you receive the best training possible.
 You can choose your learning path and delivery style.  Courses can be delivered at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible MySQL Introduction course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL, please contact us to book a place or request a quote for your MySQL Introduction course.
MySQL Introduction Course in Newcastle, Durham, Washington, Gateshead, Darlington, Leeds, Middlesbrough and throughout the North East of England. Introduction to MySQL - MySQL Training Course Available Throughout The North East.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:8/2/2025 8:44:37 PM