Call us: 02045797300
Email us: info@trainingdeals.co.uk
For all your training needs.
Lines are open 24 Hours, Monday to Sunday
Introduction to MySQL Training
- MySQL is the most commonly used Open-Source database
- Develop your database management skills using MySQL
- Learn how to create a relational database structure on a web server
- Courses delivered by world class MySQL training instructors in luxury venues
- The MySQL training course includes material, manuals and exam preparation
- Book Online or Call 02045797300 to speak to a MySQL training expert today
Sorry, we do not have any courses matching your criteria
FAQs
What time shall I arrive at the venue?
Please arrive at the venue for 08:45am
What are the pre-requisites?
There are no pre-requisites for this course.
What exam do I need to take?
MySQL 5 Certified Associate Exam (1Z0-870).
What follow on course would you recommend?
MySQL for Developers
Who is this course for?
Anyone who needs to access and work with a MySQL Database.
What you provide me with on the course
The courseware Book, MySQL 5 Certified Associate Exam (1Z0-870) preparation, Manual, Certificate, Experienced Instructor, Refreshments
Overview
Introduction
Our introduction to MySQL course covers the basics of the SQL language
Who should attend this course?
Anyone who needs to access and work with a MySQL Database.
What will I learn?
- 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
Pre-requisites
There are no pre-requisites for this course.
Course Outline
- Database concepts
- Using the MySQL client
- Basic Select
- Limit, union and aggregate functions
- Subqueries and joins
- Date, time and other functions
- Databases and tables
- Indexes and views
- Managing data
- Access control
Exam required for Introduction to MySQL course:
1Z0-870 MySQL 5 Certified Associate Exam (1Z0-870).
What's Included
<ul> <li> The courseware Book</li> <li> MySQL 5 Certified Associate Exam (1Z0-870) preparation</li> <li> Manual</li> <li> Certificate</li> <li> Experienced Instructor</li> <li> Refreshments</li> </ul>Testimonials
There hasn't been any testimonials submitted to this course
Video
We do not currently have a video for this course