Back
|
|
|
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: |
|
Before taking any examination, ensure you 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
|
Requirements:
|
|
A basic understanding of IT is required. |
|
|
|
