MySQL 5 Development Training Video - Tutorial CD

The MySQL 5 Development Training Video - Part 1 allows you to learn the basics of this powerful database standard without prior experience in a short amount of time. Narrated by professional MySQL classroom trainer David Swaim, these video tutorials will provide you with a solid understanding of database construction and some of the powerful options and commands that make MySQL the top database standard used today. If you've ever tried to learn a system like MySQL from a book, you'll know how quickly you can get bogged down with technical terms and confusing descriptions. That is simply not the case with this MySQL training. Because of its video teaching style, you get to actually see concepts and techniques put into practice. And of course, the training videos can be paused, reversed or repeated throughout, giving you complete control over how fast you move through each lesson. You'll learn how to install and configure a MySQL server on your operating system of choice, how to set up usable database tables suitable for a diverse range of projects, and then apply non-destructive querying commands to access, manipulate, and export your data. MySQL 5 Development Training Video - Part 1 can be ordered now on CD / DVD or watched online through the video streaming plan. This tutorial is the ideal way to Learn MySQL 5 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 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 11 hours long this MySQL 5 Development 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

  • Our company designs websites, and graphics. We have tried many different methods of training for over staff and most have failed to meet our expectations. We have been with your company for less than a month and have had our expectations exceeded ten fold. Your products are an extreme boost to our company and we look forward to purchasing more of your titles in the near future. When we have had questions your customer support staff was very thorough and professional. In my experience not many companies go beyond the call of duty. I would recommend your company to any and all that would ask. Tell your customer service team to keep up the good work.
    Sincerely, Janice McKeown
    Honey Brook, PA

Just Released Training

Select your PlayBack Preference
Quick Time Flash

Topics covered on this Tutorial Video
are Listed Below:-

Introduction Database Basics Installation

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

Configuration
  • MySQL Server Configuration
  • Server Startup Options
  • MySQL Configuration File
  • Important Configuration Options
Client Programs
  • Command Line Operations
  • Using a Command Line Client
  • Command Line Client Help File
  • MySQL Client Batch Mode
  • MySQL Client Interactive Mode pt. 1
  • MySQL Client Interactive Mode pt. 2
  • MySQL Client Interactive Mode pt. 3
  • Executing Scripts
  • Exploring Databases and Tables
SELECT Statement Basics
  • SELECT Arithmetic
  • Selecting More Than One Column
  • Operators and Functions
  • Column Aliases
  • NULL
  • Data Type Basics
Variables
  • What is a Variable?
  • User Variables
  • Assignment Operator
  • SET Statement
  • System Variables
  • Variable Scope
Calculations and Expressions
  • New Values From Old
  • Operators and Operands
  • Arithmetic Operators
  • String Operators
  • Comparison Operators
  • Logical Operators
  • Order of Precedence
  • Functions and Parameters
  • Useful Numeric Functions
  • Useful Character String Functions
  • Temporal Operations
  • Useful Temporal Functions
  • Decision-Making Functions
  • NULL-Related Functions
  • Useful System Functions
Querying SQL Data
  • Using a Database
  • Selecting FROM a Table
  • Targeting Rows Using WHERE
  • Complex WHERE Criteria
  • Sorting Results Using ORDER BY
  • Going to Extremes Using LIMIT
  • Avoiding Duplicates Using DISTINCT
  • Aggregation Queries
  • Subtotals Using GROUP BY
  • Filter Derived Columns with HAVING
  • Multilevel Sums Using WITH ROLLUP
  • Summarizing SELECT Clauses
  • Some Clauses Cannot Coexist
Databases and Tables
  • Databases in MySQL
  • Creating a Database
  • Aspects of a Table
  • Creating a Table
  • Table Options
  • Column Options
  • Auto-Incrementation
  • Altering a Table
  • Adding and Dropping Columns
  • Altering a Column
  • Dropping a Table
  • Dropping a Database
Data Type Details
  • Data Type Categories
  • Integer Numbers
  • Floating Point Numbers
  • Fixed Decimal Numbers
  • BIT Data Type
  • Strings
  • Basic Character Strings
  • ENUM Character Strings
  • SET Character Strings
  • Character Sets
  • Collations
  • Fonts and Keystroke Mapping
  • Binary Strings
  • Temporal Data
  • Timestamp and Time Types
Storage Engines
  • Storage Engine Basics
  • Discovering Storage Engines
  • MyISAM
  • InnoDB
  • Memory
  • Example
  • CSV
  • Archive
  • Federated
  • Blackhole
  • Third Party Engines
Exporting Data
  • Basic Export Concepts
  • Exporting Using SQL Commands pt. 1
  • Exporting Using SQL Commands pt. 2
  • Exporting on the Shell Command Line
  • Using MySQLDUMP for Scripts
  • Using MySQLDUMP for Exporting
Prepared Statements
  • Prepared Statement Basics
  • Prepared Statement Demonstration
  • Commands That Can Be Prepared
  • When to Use Them
Server Information
  • Metadata
  • SHOW Commands
  • DESCRIBE Command
  • MySQLSHOW Command Line Client
  • Information_Schema Database pt. 1
  • Information_Schema Database pt. 2
Conclusion
  • What We Covered
  • Where to Go from Here
Credits
  • About the Author

When you order this MySQL 5 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 5 Development Training - VIDEO INFO

MySQL 5 Development

David Swain

11 hours - 129 Movies

US$ 99.95

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

Ground / 2 day / Next Day

34225
125 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 5 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 5 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.

Related Tutorial Videos

MySQL 5 Development 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: