PIIT's MySQL Training program: |
| Why MySQL Training? |
When our consultants are asked to recommend an RDBMS, their stock response is to ask: “What do you want the database to do?”, “What skills have you already got?” “What database systems have you already committed resources and data to?”
We are most likely to recommend an investment in MySQL training, if you are resourcing a new project, especially one with a web focus, because supporting database-driven websites is one of the things that MySQL does best. MySQL is probably the world’s most popular website backend (on all major operating systems, Windows, Linux, Unix, Mac, etc), because it is stunningly fast at reading data, i.e. the thing that data-driven websites do most of the time. The price isn’t bad either!
MySQL is also a pretty good choice for generic database applications in small and medium sized business (SME/SMB) environments, providing power and reliability beyond the likes of MS Access, and price/performance advantages over unnecessarily heavy duty RDBMSes like Oracle, DB2 and SQL Server.
MySQL is not currently the best choice for massively complex data centre operations in very large enterprises (e.g. processing hundreds of millions of records in highly interdependent systems), but it is rapidly acquiring many of the features which have previously excluded it from this domain (e.g. transactions, sub-selects, triggers, etc). Although most of these features appear in the latest MySQL development releases, we are not yet confident enough of their maturity to recommend them for the largest business-critical applications. |
| Synopsis |
The MySQL database has become the world's leading open source database. With consistent fast performance, high reliability and ease of use it is the open source database of choice for many organizations. This introductory course covers all the basics of MySQL. |
| Objectives |
| By the end of the program, 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 sub queries |
:: |
Use variables and prepared statements |
:: |
Create and use stored routines |
:: |
Create and use triggers |
:: |
Obtain database metadata |
:: |
Debug MySQL applications |
:: |
Understand Basic Optimizations |
| Suitable For |
| MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course |
| Course Prerequisites |
:: |
A working knowledge of any RDBMS is required. |
| Contents |
1. |
Client/Server Concepts and Architecture |
2. |
The MySQL Client Program and Connectors |
3. |
Data Types including Bit and Binary |
4. |
Managing Databases, Tables, Indexes and Views |
5. |
Retrieving and Aggregating Data |
6. |
Advanced SQL Expressions and Functions |
7. |
Modifying, Importing and Exporting Data |
8. |
Complex Joins and Sub queries |
9. |
User Variable Syntax and Properties |
10. |
Prepared Statements |
11. |
Stored Routine Definition |
12. |
Creating, Dropping and Altering Stored Routines |
13. |
Invoking Stored Routines |
14. |
Trigger Concepts, Creation and Use |
15. |
Privileges for Stored Routines and Triggers |
16. |
Obtaining Database Metadata |
17. |
Debugging MySQL Applications |
18. |
Optimization Principles |
19. |
Storage Engines |
20. |
Procedures and Functions |