MySQL Administration and Development Course Outline

Overview
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.

Audience
Application and web developers, or system administrators.

Prerequisites
Prior experience installing software and programming in any language, such as HTML, is recommended but not required.

Number of Days
4 days

Course Outline

Section 1 An introduction to MySQL
Chapter 1     An introduction to relational databases and SQL
Chapter 2     How to use MySQL Workbench and other development tools

Section 2 The essential SQL skills
Chapter 3     How to retrieve data from a single table
Chapter 4     How to retrieve data from two or more tables
Chapter 5     How to code summary queries
Chapter 6     How to code subqueries
Chapter 7     How to insert, update, and delete data
Chapter 8     How to work with data types
Chapter 9     How to use functions

Section 3 Database design and implementation
Chapter 10     How to design a database
Chapter 11     How to create databases, tables, and indexes
Chapter 12     How to create views

Section 4 Stored program development
Chapter 13     Language skills for writing stored programs
Chapter 14     How to use transactions and locking
Chapter 15     How to create stored procedures and functions
Chapter 16     How to create triggers and events

Section 5 Database administration
Chapter 17     An introduction to database administration
Chapter 18     How to secure a database
Chapter 19     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

View outline in Word

XMYSQL

Attend hands-on, instructor-led MySQL Administration and Development training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Programming Courses and select the one that's right for you.