clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master MySQL 5 Development (Part 1) - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and " why " those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!
MySQL 5 Development (Part 1) Training
Access the complete MySQL 5 Development (Part 1) Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for MySQL 5 Development (Part 1) plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn MySQL 5 Development (Part 1) from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

MySQL 5 Development (Part 1)
- Information About This Title -
Click Here To Purchase
Proper Title: MySQL 5 Development (Part 1)
Description: Click here to open / close full description
As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and " why " those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!

-Close-
Instructor: David Swain (more by this author)
Instruction: 129 Tutorials - Duration: 11 hrs
First Release: 2011-07-01
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you MySQL 5 Development (Part 1)
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for MySQL 5 Development (Part 1)
 
Below is content list for all of the lessons included with the MySQL 5 Development (Part 1) Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction
movie image Welcome
movie image What This Course Will Cover
movie image System Requirements
movie image A Brief History of MySQL
movie image Help on the MySQL Web Site
movie image Online Manual Demonstration pt. 1
movie image Online Manual Demonstration pt. 2

Database Basics
movie image Definitions
movie image Client/Server Systems
movie image Tables/Columns/Rows
movie image Database Design in a Nutshell
movie image Indexes
movie image Databases in MySQL

Installation
movie image Installation Basics
movie image Windows
movie image Mac OS X
movie image Linux
movie image What We Installed
movie image Starting and Stopping MySQL


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2012 VTC Canada All Rights Reserved.