Training Course
MySQL Introduction
3 Days
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.
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.
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
MySQL Introduction 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.
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.
-
MySQL Introduction Course Options
Please contact us to discuss options for this coursePrivatePrivateFlexible 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 ScheduledPublic ScheduledFixed 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
"Many thanks. .. good initial overview."
A.S.L. United Reformed Church Northern Synod, SharePoint and Teams Overview
"Very good course"
B.S. Adler and Allan ltd, Microsoft Project Essentials
What were the most useful aspects of the course
"Learning how to deal with stress and recognise it "
J.F. Welwyn Components Ltd, Stress Management and Powering up Your Mental Resilience
"[The trainer] was very personable and interesting to listen too"
J.M. Watmos, Microsoft Office 365 Overview
"I'm very pleased I went on this course I have learnt a lot and I'm sure I will be more efficient in my role as a result. The tips I learnt will save me a lot of time at work."
D.S. Joseph Rowntree Foundation, Outlook Essentials
Any other comments or recommendations
"The course has been very valuable and informative the trainer was great and went above course information to help me understand information about the software ie helped with links to my sage accounts"
B.E. Nordem Ltd, Sage Payroll
"Clear and understandable"
S.W. Ballast Phoenix, Conflict Management
Please select the words that best describe your learning experience
"For someone who hasn't used computers much this was a great help"
G.H. universal wolf, Excel Level 1
Public Scheduled Course Dates
Prices per delegate. All prices exclude VAT.
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.
Courses Related to MySQL Introduction Training
PHP Developer Course Course overview: PHP is a popular general purpose scripting language commonly used for building web applications.The PHP Developer course is designed to provide delegates with all the core skills necessary to build and maintain web applications that provide access to persistent data. Note that while the course is ge MySQL Database Administration Course Course overview: This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.The course provides an understanding of MySQL Architecture and provides practical experience in the routine maintena
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.
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:2/11/2025 6:29:17 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:2/11/2025 6:29:17 AM