Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


MySQL Administration and Development Course Outline

 (4 days)

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 Open Source Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $2100

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

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

Email Alert

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

Attend from your office or home

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

Need a class for a group?

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

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com