The course examines the tools used by MySQL development professionals, and uses real-world examples in explaining how to generate complex queries, and consume them in your application.
Students perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines. In addition, it will prepare students for the Oracle Certified Professional, MySQL 5 Developer certification.
Learn to:
Use MySQL tools to connect to databases
Examine database structure and contents
Generate database structure diagrams
Execute complex queries
Manipulate numeric, text, spatial, and temporal data
Execute complex subqueries and joins