How To Contact The Trainer About This Public / Open Course

Thank you for using our site to search for training courses. We list courses for over 1200 different training organisations and we hope that you will find a course that matches your individual training needs. Please get in contact with us if there is anything else that we can do for you. Also, where possible please mention us at Underoak as the source of your enquiry when speaking to any of the trainers listed on our site. It really helps us.

Course

Cost

Duration

Location

Nov

Dec

Jan

Feb

Mar

Apr

To send an email enquiry to the training provider: Request Information For Free

You will be sent an email with the full contact details for the trainer.

To ring us please call: +44 (0)20 7371 7103 - (Mon - Fri : 9am - 5pm)

When calling us please quote the 'Course ID' for this course:

Course ID: 134012
Trainer ID: 793

We will then ask the trainer to send you course information.

We are a small business and are keen to support the MacMillan Cancer Charity. We will donate 25 pence to them each time you submit an email enquiry through us (max £1.00 donated per person per day - excl Medical courses which we list for free). Your use of our site helps us to do this. Thank you for your help.

Please See Below For Course Information On 'Introduction to MySQL'

Overview

Objectives: By the end of the course, delegates will be able to: Outline the structure of a MySQL database Use the MySQL Client Program and other interfaces Create a MySQL database Write SQL statements to select data from a MySQL database Use joins, subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create and alter tables, indexes and views Use various data types and constraints Understand how privileges are controlled Understand the principles of transactions Export and Import data

Who is it for?

Delegates: New or existing users of MySQL, who have little or no previous experience with a relational database management system. This course is suitable for delegates intending to sit the Certified MySQL Associate (CMA) Examination. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

What will i learn?

P3 Delegates: New or existing users of MySQL, who have little or no previous experience with a relational database management system. This course is suitable for delegates intending to sit the Certified MySQL Associate (CMA) Examination. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Objectives: By the end of the course, delegates will be able to: Outline the structure of a MySQL database Use the MySQL Client Program and other interfaces Create a MySQL database Write SQL statements to select data from a MySQL database Use joins, subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create and alter tables, indexes and views Use various data types and constraints Understand how privileges are controlled Understand the principles of transactions Export and Import data Topics Covered: Client/Server Concepts Relational Database Principles The MySQL Client Program Other MySQL Interfaces Data Types Creating Databases The Basic SELECT Statement Selecting Data from Multiple Tables using JOIN Grouping and Sorting Output Sub-queries String, Temporal and Numeric Functions Creating, Altering and Dropping Tables Creating, Altering and Dropping Views Primary and Foreign Key Constraints Creating and Dropping Indexes Inserting, Updating and Deleting Data Transactions Controlling Access Exporting and Importing Data

You are here : Public Training Courses > Computing Courses > Data Storage Courses > MySQL Training > Course Details