MySQL Development Training Video - Tutorial CD

This MySQL 5 Development Training Video - Part 2 is the comprehensive sequel to the introductory MySQL tutorial. Utilizing the same hands-on format of its predecessor, this MySQL training course provides viewers with a whole new understanding of complexity and control, showing you how to apply joins, perform queries and work with server-side programming constructs on multiple tables at once. With 184 separate MySQL tutorials, you'll build on previous concepts learned and develop an arsenal of knowledge and skills that can be readily applied to database challenges in the real world, including critical information on 'dangerous' commands that offer additional power but have the ability to affect the actual contents of your tables. In addition to teaching real MySQL development skills, the course also offers basic preparation for MySQL Certification, using the same example database featured on the exam. All lessons are self-paced, with playback controls that let you pause and repeat the training at any point. This is especially important when learning the complex skills that form the best practices of database development and design. The MySQL 5 Development Training Video - Part 2 is ready to order on CD / DVD or watchable online with all other training courses through the unlimited video plan. This tutorial is the ideal way to Learn MySQL Development at your own pace.

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

This MySQL 5 Development (Part 2) Training video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that bring a high degree of visual clarity to even the most complex applications. Being over 17.5 hours long this MySQL 5 Development (Part 2) Training on CD / DVD is extremely comprehensive and easy to follow. Video Tutorial taught by Experts - Low Cost

- Easy to Learn
Evaluate the high quality of this Tutorial
try a free demo Below.

Benefits

  • Works on PC or Mac
  • Professional Tutition by Experts
  • Self-Paced Learning Interface
  • Builds Practical Skills Quickly
  • Rapid Learning - High Retention
  • Free Certificate with each Tutorial

Client Testimonials

  • 'This training CD has been the most effective in helping me learn this complicated software...thank you very much! I look forward to new titles :-)'
    Pete Barker
    Little Rock, AR ;

Just Released Training

Select your PlayBack Preference
Quick Time Flash

Topics covered on this Tutorial Video
are Listed Below:-

Introduction Configuration Manipulating Data

The purchased version of this Training contains all the movies listed below as well as all the featured Movies above. add to cart US$ 99.95

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

When you order this MySQL Development Training CD you'll receive:-

An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

MySQL Development Training - VIDEO INFO

MySQL 5 Development (Part 2)

David Swain

17.5 hours - 184 Movies

US$ 99.95

Win 7 ,Vista, XP, 2000, 98. Mac OS X

Ground / 2 day / Next Day

34278

312 In Stock
Purchase Orders from Schools, Colleges and Government accepted

Multi User Version Available

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.
$500

Benefits of this Training Video

  • Learn MySQL Development in the shortest time possible
  • Self paced tutorial, training on video, learn at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you dont even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The tutorials can be rewound, fast forwarded or stopped at any time
  • Learn MySQL Development from the comfort of your own desk.

Prove your Skills. Free Certification

  • With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.

MySQL 5 Development (Part 2) Related Videos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: