Training Course

Introduction to MySQL

PDF
3 Days
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.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
08 Jan - 10 Jan 2025
Virtual Course
£1195
12 Feb - 14 Feb 2025
Virtual Course
£1195
19 Mar - 21 Mar 2025
Virtual Course
£1195
23 Apr - 25 Apr 2025
Virtual Course
£1195
28 May - 30 May 2025
Virtual Course
£1195
30 Jun - 02 Jul 2025
Virtual Course
£1195
06 Aug - 08 Aug 2025
Virtual Course
£1195
10 Sep - 12 Sep 2025
Virtual Course
£1195

Private Training

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

Course Prerequisites

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

Course Objectives

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

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

Included with this course

    • Comprehensive course materials and exercises

Introduction to MySQL 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

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
08 Jan - 10 Jan 2025
Virtual Course
£1195
12 Feb - 14 Feb 2025
Virtual Course
£1195
19 Mar - 21 Mar 2025
Virtual Course
£1195
23 Apr - 25 Apr 2025
Virtual Course
£1195
28 May - 30 May 2025
Virtual Course
£1195
30 Jun - 02 Jul 2025
Virtual Course
£1195
06 Aug - 08 Aug 2025
Virtual Course
£1195
10 Sep - 12 Sep 2025
Virtual Course
£1195

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have 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.
  • Introduction to MySQL 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

Which part of the course did you find particularly valuable The practical approach of trying every aspect whether I had already done it before or I was trying it for the first time. It was a safe space to make mistakes and a very encouraging environment.

S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2

Any other comments or recommendations Very clear and informative

R.S. William Smith Group, Excel Level 2

Which part of the course did you find particularly valuable I felt there was good networking via the facilitator and group along with many hints and tips

S.M. Health Education England, Minute Taking

An excellent course and [the trainer] was very help and patient when addressing group questions.

G.T. Public course, Microsoft Power BI Desktop

Excellent course well presented.

N.C. Cembre Ltd, Excel Level 1 Essentials

Following this training what are you going to do differently Think about how I engage with my customers and build relationships

J.A. Cirrus Environmental Soultions Ltd, Customer Care

I feel more clear in mind of my objectives going forward and how to achieve them

S.R. J2 Research, Time Management

Any other comments or recommendations Adele was very informative and was great at acknowledging when we needed to focus on a topic or perhaps glance over as we had a good enough level of skill already

N.W. P695, Redefining PowerPoint Design Create Present with Impact

+ View More Training Reviews

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
08 Jan - 10 Jan 2025
Virtual Course
£1195
12 Feb - 14 Feb 2025
Virtual Course
£1195
19 Mar - 21 Mar 2025
Virtual Course
£1195
23 Apr - 25 Apr 2025
Virtual Course
£1195
28 May - 30 May 2025
Virtual Course
£1195
30 Jun - 02 Jul 2025
Virtual Course
£1195
06 Aug - 08 Aug 2025
Virtual Course
£1195
10 Sep - 12 Sep 2025
Virtual Course
£1195

Private Training

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

 

Please contact us to discuss your Introduction to MySQL 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 Introduction to MySQL 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 Introduction to MySQL course.

General Information

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:12/5/2024 3:48:02 AM