MySQL Administration and Development Course

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.

MySQL Administration and Development Course

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

GENERAL INFO

Class Format
Class Policies
Student Reviews

MySQL Administration and Development Course

MySQL Administration and Development Course

Overview

Audience

Prerequisites

Number of Days

Section 1 An introduction to MySQL

Section 2 The essential SQL skills

Section 3 Database design and implementation

Section 4 Stored program development

Section 5 Database administration

Appendixes

Business to Business Only

New Hampshire Residents