Improve job skills - Become more efficient - Produce better results !

Learn MySQL 5 Development (Part 2) (in only 17 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: This MySQL 5 Development Part 2 course continues the introduction to MySQL we began with Part 1. But in Part 2, we now begin working with commands that are used to change the contents of the tables in our database. We also explore various ways of building more complex queries, including command options that allow us to address more than one table in a single command. While this is still an introductory course, we are now exploring tools that let us handle more complex operations and build more sophistication into our MySQL database systems. The topics we cover in Part 2 include inserting/updating/deleting data, subqueries, joins, transactions, table and row locking, stored procedures and functions, triggers and events, indexes, and more. We have tried to keep the examples in the lessons as simple as possible to illustrate them most effectively, but the further study exercises are more realistic as to how these tools are used in practice. Online training videos are great for individuals and companies.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 181 Free Video Video Time
(minutes)

Introduction

Inserting Data

Deleting Data

Updating Data

Other MySQL DML Commands

Importing Data

Deriving New Tables

Multi-Table Queries

Subqueries

Joins

Views

Multiple Table DML Operations

Transactions and Locking

Stored Routine Basics

Stored Routine Programming

Triggers

Events

Indexes

Efficiency Checks

Conclusion