Training Course:MySQL for Developers (Certificate)School/Trainer:Montreal College of Management and Technology
Montreal, Quebec, Canada
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Do you want to learn how to develop database applications on MySQL?
Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
Do you want to transfer your data from one server to another?
Then MySQL for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0
This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.
At the completion of this course, you should be able to:
Describe the MySQL client/server architecture
Understand the steps necessary to invoke MySQL client programs
Utilize the general-purpose mysql client program to run queries and retrieve results
Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
Explain the MySQL connectors that provide connectivity for client programs
Select the best data type for representing information in MySQL
Manage the structural characteristics of your databases
Manage the structural characteristics of the tables within your databases
Utilize the SELECT statement to retrieve information from database tables
Utilize expressions in SQL statements to retrieve more detailed information
Utilize SQL statements to modify the contents of database tables
Write join expressions in your SQL statements to obtain information from multiple tables
Utilize subqueries in your SQL statements
Create views utilizing SELECT statements to produce "virtual tables" of specific data
Perform bulk data import and export operations
Create user defined variables, prepared statements and stored routines
Create and manage triggers
Use the INFORMATION_SCHEMA database to access metadata
Debug MySQL applications
Configure and Optimize MySQL
Certification:
Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
Who should Attend
Developers who want to learn MySQL 5.0
Prerequisites
Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.
Format
Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
...''
Please go to the school's official website for training price and schedule:
http://www.montrealcollege.ca/
Phone:1 514 312 2383
School Address:
1255 University Street, Suite 510
Montreal, Quebec, Canada
H3B 3V8
Jobs & Resumes: Montreal
Houses & Roommates: Montreal
Travel Agencies: Montreal
Search other schools for MySQL for Developers training resources.
Other training courses offered by Montreal College of Management and Technology:
Informatica
Informatica PowerCenter 8.0 Development
Business Intelligence
SAS Programming I: Essentials
SAS Programming II: Data Manipulation Using the Data Step
SAS Programming III: Advanced Techniques
SQL Processing with SAS Software
Crystal Reports
Linux
MySQL for Beginners
MySQL and PHP - Developing Dynamic Web Applications
MySQL 5.0: Upgrading and New Features
MySQL for DBAs
MySQL
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.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
