MySQL for Developers
Our 'MySQL for Developers' course is aimed at web developers that wish to get a better understanding of the popular MySQL database system and how it can be integrated with scripting languages such as PHP, ASP and Perl to create dynamic content in web pages.
The objectives are not only to give developers a better understanding of how MySQL works, and a deeper knowledge of the SQL lanuage itself, but also to discuss and explore how best to use MySQL as part of a dynamic website or web based application.
Students can register either for the core MySQL course, or the core course plus one or more optional modules - 'MySQL Administration' & 'MySQL & PHP integration & performance workshop'.
| Month | Dates (slight variances may apply) |
|---|
Format
This course is offered online - with a live instructor - for 18 hours (6 x 3-hour sessions) for the core course, plus 2 optional 3-hour modules.The course can also be adapted for the classroom setting.
Audience
This course is designed for those who want to become proficient in the use of the MySQL database system and its use in the development of dynamic websites and web-based applications.
Prerequisite(s)
There are no prerequisite for students attending the MySQL component of the course. Students attending the MySQL & PHP performance module should have a good understanding of (X)HTML and be reasonably proficient in PHP.
Objective
To gain a better understanding of MySQL and its use in developing dynamic websites.
Topics Include
Core course
- Introduction to relational database concepts
- Introduction to MySQL
- The SQL language
- Using SQL to create and manage MySQL databases
- Normalisation
- MySQL table and data types
- Using the appropriate data type
- Use of keys and indexes
- Inserting and updating records - including data import techniques. (INSERT, UPDATE, LOAD)
- Handling updates to duplicate records
- Retrieving data from a MySQL database using SQL queries (SELECT statements)
- Query optimisation techniques
- Data filtering (WHERE clause)
- Grouping results (GROUP BY, HAVING, etc)
- Using Aggregate functions
- Working with multiple tables (JOINS)
- Using nested sub-queries
- Advanced query techniques
- Concurency and Transactions
- Stored Procedures and Triggers
- Review of MySQL functions
Optional MySQL Admin module
- MySQL Administration
- User Management and Access Privileges
- Backup and Restore
Optional MySQL & Web application integration & performance module
- Integrating MySQL into a web development environment
- Review of dynamic data handling in an integrated web application (use of scripting vs MySQL)
- Optimisation & performance considerations.
Length: Core course: 18 hours (6 x 3-hour sessions) :: Additional modules: 3 hours each
Starts: view schedule
Price
The MySQL course is priced at £795.00 for the core MySQL section, & £95.00 for each additional module. The course can also be combined with PHP courses as part of a PHP 'Web Developer' package of 3 courses at a discounted price.
Questions? email us