Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This MySQL 5 Development Tutorial Video - Part 2 offers the hands-on follow-up to the initial training series on MySQL database creation and control. In this innovative video course, IT expert David Swaim briefly reviews some of the concepts covered in the first tutorial and then begins to tackle topics of more difficulty and sophistication, step by step. This is where you'll begin to learn the real database skills that define professional level use, from multi-table queries and subqueries to joins, transactions, and a full range of stored routine programming techniques. Not only do you get a hands-on primer in practical theory and skills, but the 'world' database utilized in the training examples is the same one used in the official MySQL certification exam, giving you a solid basis for further study and professional development. The combination of the two MySQL 5 training videos will provide you with a foundation for best developer practices and a working knowledge of database creation, modification, querying and execution. With this understanding, you can then move on to more in-depth strategies used in IT departments worldwide. The MySQL 5 Development Tutorial Video - Part 2 can be ordered on CD / DVD or viewed streaming online through the unlimited video service.

Associated Tutorials: MySQL 5 Development Part 1 | Beginners MySQL | Beginners PHP 5 | Database Optimization | PostgreSQL

MySQL 5 Development (Pt 2) Tutorial CD / DVD

When you order this MySQL 5 Development (Pt 2) Video Tutorial CD You'll Receive...
Over 17.5 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn MySQL 5 Development (Pt 2) from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I ordered your videos online and the package got here FAST. I've only had it for a couple days but I've already learned some great tips. "Paul Richardson, Massachusetts

MySQL 5 Development (Pt 2) Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 17.5 Hours in Duration and Covers 184 Lessons.
Intro to the MySQL Course - Part Two Setting Up Intro to Data Manipulation in MySQL
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
How to Insert Your Data
  • How to Insert Your Data
  • How to Insert Data Archaic Syntax
  • Hands-on with INSERT
  • INSERT Defaults
  • Working with AUTO_INCREMENT
  • Complications with AUTO_INCREMENT
  • Working with LAST_INSERT_ID
  • INSERT Issues to Be Aware Of
How to Delete Data
  • Removing Data
  • DELETE Using the WHERE Command
  • DELETE Using the LIMIT Command
  • DELETE Using the ORDER BY Command
  • Understanding DELETE Results
How to Update Your Data
  • How to Update Your Data
  • UPDATE Using the WHERE Command
  • UPDATE Using the LIMIT Command
  • UPDATE Using the ORDER BY Command
  • Understanding UPDATE Results
Extended MySQL DML Commands to Know
  • Using REPLACE
  • Hands-on with REPLACE
  • Using ON DUPLICATE KEY UPDATE
  • Hands-on with ON DUPLICATE KEY UPDATE
  • Using TRUNCATE
  • Hands-on Example of TRUNCATE
  • How to Achieve Safe Updates
How to Import Your Data
  • How to Import Your Data
  • Hands-on with Simple Importing
  • How to Import Non-Tab Format Types
  • Importing Tip: How to Skip Header Lines
  • Importing TIp: How to Change Column Orders
  • How to Convert Data When Importing Lesson One
  • How to Convert Data When Importing Lesson Two
  • How to Import Via Shell Command Line
How to Derive Additional Tables
  • Create Tables from Tables
  • CREATE TABLE via the SELECT Command
  • How to Include More Features
  • CREATE TABLE via the LIKE Command
  • How to Populate Derived Tables
  • Working with Temp. Tables
  • How to Modify Derived Tables
Understanding Multi-Table Queries
  • Addressing Multiple Tables
  • Encountering Column Naming Conflicts
  • Working with Column Naming Conflicts
  • Encountering Table Naming Conflicts
  • Working with Table Name Conflicts
Fundamentals of Subqueries
  • Subquery Essentials
  • Understanding the Shape of the Result
  • How to Guarantee Single Rows
  • Working with Scalar Subqueries
  • Working with Table Subqueries
  • Working with Column Subqueries
  • Subqueries for Rows
  • Subqueries Tip: EXISTS Lesson One
  • Subqueries Tip: EXISTS Lesson Two
  • Comparing Correlated Versus NonCorrelated
  • How to Nest to Multiple Levels
  • How to Build Queries in Layers
  • Address the Same Table More Than Once
  • Tips for Using Subqueries Correctly
Fundamentals of Joins
  • Working with the FROM Clause
  • Join Essentials: Lesson One
  • Join Essentials: Lesson Two
  • The Correct Syntax for Inner Join
  • Hands-on with Simple Inner Joins
  • Aggregating Inner Joins
  • Understanding the ON Clause
  • Understanding the USING Option
  • Intro to Natural Join Fundamentals
  • Intro to Outer Join Fundamentals
  • Tips for Join Criteria
  • How to Perform Multiple Table Joins
  • How to Perform Self Joins
  • What Joins Cannot Fix
Introduction to Viewing
  • Views Defined
  • How to Use Views
  • Fundamental View Syntax and Structure
  • Viewing Column Names
  • Working with Updatable Views
  • Working with Insertable Views
  • Understanding View Consistency
  • Understanding View Viability
  • How to Alter and Drop Views
  • How to View Metadata
DML Operations with More Than One Table
  • Using INSERT with More Than One Table
  • Performing UPDATE with More Than One Table
  • DELETE with More Than One Table
  • Further Considerations
Understanding Locking and Transaction Fundamentals
  • Intro to Transaction Fundamentals
  • Transactions As they Apply to MySQL
  • Using AUTOCOMMIT
  • Essential Commands for Transactions
  • Using Save points
  • Understanding Isolation
  • Working with Isolation Levels
  • Hands-on Examples of Transactions
  • Intro to Locking Essentials
  • Locking as it Applies to MySQL
  • About Explicit Row Locking
  • Hands-on with Row Locking
  • Understanding Explicit Table Locking
  • Hands-on with Table Locking
  • Using Deadlock Resolution
  • Tips for Implicit Commits in MySQL
Intro to Stored Routine Fundamentals
  • Understanding Procedures and Functions
  • Reasons for Stored Routines
  • Simple Syntax and Structure for Creating Functions
  • How to Invoke Functions
  • Creating Proper Procedure Syntax
  • How to Invoke Procedures
  • Understanding Database Associations
  • Working with Metadata for Stored Routines
  • Storage Locations
  • About Dropping Stored Routines
Programming Fundamentals for Stored Routines
  • Intro to Compound Statements
  • Hands-on Examples of Compound Statements
  • Intro to Procedure Parameter Types
  • Intro to IN Parameter Types
  • About INOUT Parameter Types
  • Working with OUT Parameter Types
  • How to Declare Local Variables
  • How to Assign Values to Variables
  • Understanding Variable Scope
  • Intro to Conditional Blocks in MySQL
  • Hands-on with IF Blocks
  • Hands-on with CASE Blocks
  • Hands-on with Iterative Blocks
  • Hands-on with LOOP Block
  • Hands-on with REPEAT Block
  • Hands-on with WHILE Block
  • Understanding the LEAVE Statement
  • Working with the ITERATE Statement
  • Extended DECLARE Examples
  • How to Declare Conditions
  • How to Declare Error Handlers
  • How to Declare Cursors
  • About Limits on Cursors
Intro to Triggers
  • Trigger Essentials
  • Trigger Purposes
  • About Trigger Syntax and Structure
  • Hands-on with Triggers
  • More About Triggers
  • Tips on Metadata
  • About Dropping Triggers
  • Understanding User Accounts and Triggers
  • About Limits on Triggers
Event Fundamentals
  • Event Essentials
  • Executing Events
  • About Event Syntax and Structure
  • Considering Schedule Types
  • Understanding User Accounts and Events
  • Tips on Metadata
  • About Limits on Events
Working with Indexes
  • Index Essentials
  • How to Define Indexes for Individual Tables
  • How to Add Indexes to Tables
  • How to Drop Indexes from Tables
  • Working with Compound Indexes
  • Working with Prefix Length Indexes
  • Tips for Using Covering Indexes
  • FULLTEXT Indexing: Lesson One
  • FULLTEXT Indexing: Lesson Two
Using Efficiency Checks in MySQL
  • Intro to Efficiency Checks
  • About Using PROCEDURE ANALYSE
  • Using EXPLAIN: Lesson One
  • Using EXPLAIN: Lesson Two
  • Using EXPLAIN: Lesson Three
In Closing
  • Course Summary
  • Going Beyond the Lessons
End Notes
  • Tutor Bio

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this MySQL 5 Development (Pt 2) Training CD

Title MySQL 5 Development (Pt 2)
Tutor David Swain
Other tutorials by David Swain
Videos 184 Lessons- Video run time: 17.5 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2011
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
468 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn MySQL 5 Development (Pt 2) from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

FileMaker Tutorials | MySQL and PHP Tutorial Videos | Crystal Reports Training| Online MySQL 5 Development (Pt 2) Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.