Course Details

MYSQL Training

Course description

MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs. This course covers MySQL 5.6.

Course outline

Section 1 An introduction to MySQL      An introduction to relational databases and SQL      How to use MySQL Workbench and other development tools Section 2 The essential SQL skills      How to retrieve data from a single table     How to retrieve data from two or more tables      How to code summary queries      How to code subqueries     How to insert, update, and delete data      How to work with data types    How to use functions Section 3 Database design and implementation      How to design a database     How to create databases, tables, and indexes      How to create views Section 4 Stored program development      Language skills for writing stored programs      How to use transactions and locking      How to create stored procedures and functions      How to create triggers and events Section 5 Database administration      An introduction to database administration      How to secure a database      How to back up and restore a database Appendixes Appendix A     How to install the software for this book on Windows Appendix B     How to install the software for this book on Mac OS X