MySQL for Developers
Course
In Birmingham and London
Description
-
Type
Course
-
Location
-
Class hours
35h
-
Duration
5 Days
By the end of the course, delegates will be able to: Understand MySQL Client/Server concepts Use advanced features of the MySQL Client Understand various types of Connector Use advanced data types Manage databases, tables, indexes, views Write complex SQL query statements Use advanced SQL expressions and functions Modify, Import and export data Perform complex joins and. Suitable for: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. The content of the course covers the topics required for the Certified MySQL Developer I and MySQL Developer II examinations.
Facilities
Location
Start date
Start date
Start date
About this course
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.
Reviews
Subjects
- Performing advanced Insert
- Update
- Delete
- Replace and Truncate Operations
Course programme
MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. The content of the course covers the topics required for the Certified MySQL Developer I and MySQL Developer II examinations.
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:
- Understand MySQL Client/Server concepts
- Use advanced features of the MySQL Client
- Understand various types of Connector
- Use advanced data types
- Manage databases, tables, indexes, views
- Write complex SQL query statements
- Use advanced SQL expressions and functions
- Modify, Import and export data
- Perform complex joins and subqueries
- Use variables and prepared statements
- Create and use stored routines
- Create and use triggers
- Obtain database metadata
- Debug MySQL applications
- Understand Basic Optimisations
Topics Covered:
- Client/Server Concepts and Architecture
- The MySQL Client Program and Connectors
- Data Types including Bit and Binary
- Managing Databases, Tables, Indexes and Views
- Retrieving and Aggregating Data
- Advanced SQL Expressions and Functions
- Modifying, Importing and Exporting Data
- Complex Joins and Subqueries
- User Variable Syntax and Properties
- Prepared Statements
- Stored Routine Definition
- Procedures and Functions
- Creating, Dropping and Altering Stored Routines
- Invoking Stored Routines
- Trigger Concepts, Creation and Use
- Privileges for Stored Routines and Triggers
- Obtaining Database Metadata
- Debugging MySQL Applications
- Optimization Principles
- Storage Engines
Requirements:
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.
MySQL for Developers