Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL for Beginners
Course type Essentials (What does this mean?)
| Course title | MySQL for Beginners |
|---|---|
| Delivery method |  Classroom |
| RRP | £1320 exc. VAT |
| Days/Duration | 4 |
| Code | SQL4401 |
Secure online payment
- view dates / book course
- course description
- skills paths
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |11 |- |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |- |- |- |- Tabernacle Street, EC2 location information and directions
11 Jun fewer than 5 places available £1,452 exc VAT MySQL for Beginners training in Tabernacle Street, EC2
North
Manchester |- |18 |- |- Location Sep Oct Nov Dec view earlier dates Manchester |- |- |- |- Manchesterlocation information and directions
18 Jun 5 or more places available £1,320 exc VAT MySQL for Beginners training in Manchester
Special Notices
Please note that Oracle courses running at London training centres are subject to a 10% surcharge.
Overview
Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.
Students who can benefit from this course: New or existing users of MySQL, who have little or no previous experience with a relational database management system.
Prerequisites
- Knowledge of database concepts
- Previous experience with any command-line program
- Basic computer literacy is required
Delegates will learn how to
- Understand the features and benefits of MySQL
- Be able to find information about products, support and training
- Be able to install and start the MySQL server
- Understand the basics of Relational Databases
- Understand the SQL and MySQL languages
- Understand Data/Column types with regard to efficient database design
- Be able to view a database design structure/content
- Create a database design using an efficient structure
- Be able to extract basic database information using the SELECT command
- Be able to troubleshoot syntax and understand typical warnings and errors
- Be able to delete or modify a database
- Be able to delete or modify table row data
- Grouping query data with Aggregation
- Connect data from multiple table rows using JOIN
- Perform nested sub-queries
- Use of Simple Functions (String, Date, Numerical)
- Understand the primary methods for exporting and importing data
- Describe MySQL connectors, their major features and differences
- Understand MySQL storage engines, transactions and features of the common engines
Related certification and/or skills paths
This course forms part of the following certification track(s) or skills path(s):
- Oracle Certified Associate, MySQL 5.0/5.1/5.5
- Oracle Certified Professional, MySQL 5.0 Developer
- Oracle Certified Professional, MySQL 5.0 Database Administrator
Need help planning your training?
The easiest way to get help planning your training is to call one of our specialists on 0845 757 3888 or to email us info@qa.com. We'll be happy to help.
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
