Easy to follow MySQL 5 Development Part 1 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 1 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 1 Tutorial Video - Try for FREE

Details

This MySQL 5 Development Tutorial Video Online Training delivers a classroom-quality introduction to this popular database system in an incredibly convenient and affordable format that will make learning easy. Veteran trainer David Swaim draws from his experience as a MySQL trainer for the IT industry to deliver a course that is highly informative and relevant to real world solutions. In addition to covering key concepts and the basic building blocks of database design, the tutorials will help you develop a core understanding of client/server interaction so you can accomplish more complex solutions as your level of experience grows. That being said, this is a beginner-friendly online training course. While it will help you take a professional approach to MySQL database design, it assumes no prior knowledge, and will help you gradually increase your knowledge and confidence step by step, example by example. As part one of a two-part MySQL 5 tutorial video series, this course will help you install and configure your own MySQL server, learn how to design and build basic database solutions and how to perform non-destructive queries and calculations and get the most from your data. Once you've registered, you will have access to all the tutorials featured here as well as the entire 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 1 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

Database Basics

Installation

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

MySQL 5 Development Part 1 Video Tutorial

Title MySQL 5 Development Part 1 Training Tutorial

Author David Swain
Other Training Videos by this author

Duration 11 hours

Number of Videos 129

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 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 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