Introduction to MySQL
Course
In London, Leeds, Manchester and another venue.
Description
-
Type
Course
-
Location
-
Class hours
21h
-
Duration
3 Days
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. Suitable for: 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.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
About this course
A basic understanding of IT is required.
Reviews
Subjects
- Using client programs to access a MySQL database
Course programme
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
Requirements:
A basic understanding of IT is required.
Introduction to MySQL