Easy to follow MySQL 5 Development Part 2 Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the MySQL 5 Development Part 2 tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

MySQL 5 Development Part 2 Tutorial Video - Try for FREE

Details

This MySQL 5 Development Tutorial Video Online Training - Part 2 builds upon the lessons included in the first instalment and instills in the viewer a working knowledge of best developer practices for MySQL. With extended lessons in working with database configuration and execution, this followup course bridges the gap between the basic introduction and a workable understanding of MySQL development and operation. Because the online MySQL training is authored and presented by expert and classroom instructor David Swaim, you're getting the same quality of instruction found in an expensive seminar-style course, but in a convenient self-paced format accessible from anywhere there's an internet connection. David's MySQL 5 tutorials cover data manipulation, complex querying and server-side programming constructs, teaching you how insert, update and delete data and derive new tables from existing ones. You'll learn how to solve query challenges and apply basic strategies to use MySQL syntax and solutions to work with data in actually useful ways. Once you have signed up, you can start learning with any of the tutorial videos listed here as well as the complete library of tutorial video online training on the site.

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!

Benefits of Online Learning

Unlimited viewing. No Hidden Costs
Downloadable working files.
Instant Access
Expert instructors.
Use at home / work or both.
Works on PC or Mac.
Telephone Tech support.
Cancel at any time.
600+ courses for 1 low fee.
New titles added monthly.
100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this MySQL 5 Development Part 2 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.

Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below

Topics covered on this tutorial video include:

Introduction

Configuration

Manipulating Data

Inserting Data

Inserting Data
Inserting Data Archaic Syntax
INSERT Demonstrations
Default Values on Insert
AUTO_INCREMENT on Insert
AUTO_INCREMENT Issues
LAST_INSERT_ID Function
Common INSERT Errors

Deleting Data

Deleting Data
DELETE with WHERE
DELETE with LIMIT
DELETE with ORDER BY
DELETE Result Messages

Updating Data

Updating Data
UPDATE with WHERE
UPDATE with LIMIT
UPDATE with ORDER BY
UPDATE Result Messages

Other MySQL DML Commands

REPLACE Command
REPLACE Demo
ON DUPLICATE KEY UPDATE Option
ON DUPLICATE KEY UPDATE Demo
TRUNCATE Command
TRUNCATE Demonstration
Safe Updates Mode

Importing Data

Importing Data
Basic Import Demonstrations
Importing Non-Tab Formats
Skipping Header Lines on Import
Changing Import Column Order
Converting Data on Import pt. 1
Converting Data on Import pt. 2
Importing on the Shell Command Line

Deriving New Tables

New Tables from Existing Tables
CREATE TABLE Using SELECT
Including Other Features
CREATE TABLE Using LIKE
Populating Derived Tables
Temporary Tables
Altering Derived Tables

Multi-Table Queries

Addressing Multiple Tables
Column Name Conflicts
Resolving Column Name Conflicts
Table Name Conflicts
Resolving Table Name Conflicts

Subqueries

Subquery Basics
Shape of the Result
Guaranteeing a Single Row
Scalar Subqueries
Table Subqueries
Columnar Subqueries
Row Subqueries
EXISTS Subqueries pt. 1
EXISTS Subqueries pt. 2
Correlated vs Non-Correlated
Nesting to Multiple Levels
Building Queries in Layers
Addressing the Same Table Twice
When to Use Subqueries

Joins

The FROM Clause
Join Basics pt. 1
Join Basics pt. 2
Inner Join Syntax
Basic Inner Join Demos
Inner Join Aggregation
The ON Clause
The USING Option
Natural Joins
Outer Joins
Join Criteria Options
Multiple Table Joins
Self Joins
Problems Joins Cannot Solve

Views

What a View Is
Uses of Views
Basic Syntax of a View
View Column Names
Updatable Views
Insertable Views
View Consistency
View Viability
Altering or Dropping a View
View Metadata

Multiple Table DML Operations

Multiple Table INSERT
Multiple Table UPDATE
Multiple Table DELETE
Advantages and Limitations

Transactions and Locking

Transaction Basics
Transactions in MySQL
AUTOCOMMIT Mode
Transaction Commands
Savepoints
Isolation
Isolation Levels
Transaction Demos
Locking Basics
Locking in MySQL
Explicit Row Locking with InnoDB
Row Locking Demos
Explicit Table Locking
Table Locking Demos
Deadlock Resolution
Implicit Commits

Stored Routine Basics

Procedures and Functions
Why Use Stored Routines
Basic Create Function Syntax
Invoking a Function
Basic Create Procedure Syntax
Invoking a Procedure
Database Association
Stored Routine Metadata
Where They Are Stored
Dropping Stored Routines

Stored Routine Programming

Compound Statements
Compound Statement Demos
Procedure Parameter Types
IN Parameters
INOUT Parameters
OUT Parameters
Declaring Local Variables
Assigning Values to Variables
Variable Scope
Conditional Blocks
IF Block Demos
CASE Block Demos
Iterative Blocks
LOOP Block Demos
REPEAT Block Demos
WHILE Block Demos
The LEAVE Statement
The ITERATE Statement
More We Can DECLARE
Declaring Conditions
Declaring Error Handlers
Declaring Cursors
Limitations on Cursors

Triggers

Trigger Basics
Uses for Triggers
Trigger Syntax
Trigger Examples
Exploring Triggers
Trigger Metadata
Dropping Triggers
User Accounts for Triggers
Trigger Limitations

Events

Event Basics
Event Execution
Event Syntax
Schedule Types
User Accounts for Events
Event Metadata
Event Limitations

Indexes

Index Basics
Defining Indexes for a Table
Adding Indexes to a Table
Dropping Indexes from a Table
Compound Indexes
Prefix Length Indexes
Covering Indexes
FULLTEXT Indexes pt. 1
FULLTEXT Indexes pt. 2

Efficiency Checks

Efficiency Checks
PROCEDURE ANALYSE function
EXPLAIN Command pt. 1
EXPLAIN Command pt. 2
EXPLAIN Command pt. 3

Conclusion

What We Covered
Where to Go from Here

Credits

About the Author

MySQL 5 Development Part 2 Video Tutorial

Title MySQL 5 Development Part 2 Training Tutorial

Author David Swain
Other Training Videos by this author

Duration 17.5 hours

Number of Videos 184

Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions

Own this Training Course on CD

Would you like to own this MySQL 5 Development (Pt 2) Training title on CD?

You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
MySQL 5 Development (Pt 2) tutorial on CD.

Multi User Accounts - Cost Effective Training

For Educational Establishments and Corporate Customers we have the idea way to train multi users simultaneously. Just like the single user account the Multi User option gives unlimited access to all listed courses. The cost of training multiple users is significantly reduced.

Free Certification - Prove Your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customer Comments