MySQL for Developers

Parity Training Ltd.
Edinburgh, Leeds, London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course is designed for MySQL Developers who have a basic understanding of a MySQL database and SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements, including Stored Routines and Triggers. Together with the Introduction to MySQL course, the content of this course covers the topics required for the Certified MySQL Developer I and Certified MySQL Developer II examinations
Course Objectives
To provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.
Skills Gained
Use advanced features of the Mysql Client.
Use advanced data types.
Manage the structure of databases and tables.
Manage and using indexes.
Write complex SQL query statements.
Use advanced SQL expressions.
Use advanced SQL functions.
Perform advanced Insert, Update, Delete, Replace and Truncate Operations.
Use user variable syntax and properties.
Import and export data from within mysql.
Import and export data from the command line.
Perform complex joins to access multiple tables.
Perform complex subqueries.
Create, manage and use views.
Use prepared statements.
Create and use stored routines.
Create and use triggers.
Obtain database metadata.
Optimise queries.
Work with the main storage engines.
Debug MySQL applications. ...''

Elements of this syllabus are subject to change.

Phone:0800 656 100

School Address/Venue(s):

Parity Training Ltd
3rd Floor
120 Moorgate
London
United Kingdom
EC2M 6SS

Jobs & Resumes: Edinburgh, Leeds, London
Houses & Roommates: Edinburgh, Leeds, London
Travel Agencies: Edinburgh, Leeds, London

Search other schools for MySQL for Developers training resources.

Wide Area Networks
Local Area Networks
Wireless Broadband Networking
Wireless Convergence
Wireless Networking Security and Troubleshooting
Storage Networking Concepts
Storage Networking Standards - Fibre Channel
MySQL
SQL
Relational Database & Data Modelling
Oracle 10g Application Server
Oracle 10g Discoverer for Administrators
Oracle 10g Discoverer Plus
Oracle Database 10g Data Guard
Oracle Database 10g DBA
Oracle SQL Performance Tuning
Oracle SQL
Oracle Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.