Learn MySQL

Unlimited Online Training and Tutorials

MySQL Online Video Training and Tutorials by Joshua Mostafa consists of approximately 8 hours of training over 56 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

MySQL

Start learning MySQL right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Getting Started

Database

SQL Basics

Finding Your Way About

Creating a Database

Creating a Table

Column Types-String Pt 1

Column Types-String Pt 2

Column Types-Numeric Pt 1

Column Types-Numeric Pt 2

Retrieving Data With Search Criteria

Changing Existing Data

Altering A Table

Keys And Indexes

Basics Syntax Recap

More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00

Subscribe Now!

Operators in MySQL

Arithmetic Operators

Numeric Comparison Operators

String Comparison Operators

Logical Operators

Bitwise Operators

Regular Expressions 1

Regular Expressions 2 Pt 1

Regular Expressions 2 Pt 2

Operators Syntax Recap

Querying Your Data

Sorting Retrieved Data

Specifying Numbers of Results

Joining Tables Pt 1

Joining Tables Pt 2

More On Joining Tables

Data Aggregation

Queries Syntax Recap

More Complex SQL

Using Default Data

Date And Time 1 Pt 1

Date And Time 1 Pt 2

Date And Time 2

ENUM column type

SET column type Pt 1

SET column type Pt 2

Using Variables

Conditional: IF()

Complex Syntax Recap

Good Practises

Using SQL batch files Pt 1

Using SQL batch files Pt 2

Data Modeling Pt 1

Data Modeling Pt 2

Normalization Pt 1

Normalization Pt 2

Optimizations

Security

Users And Privileges

More About Users And Privileges

The mysql Database Pt 1

The mysql Database Pt 2

Encryption

Security Syntax Recap

Building A Database Application

Planning The Structure

Designing The Database Pt 1

Designing The Database Pt 2

Creating The Database Pt 1

Creating The Database Pt 2

Logging In And Out

Checking Videos In And Out Pt 1

Checking Videos In And Out Pt 2

Searching For A Video

Adding A New Title

Signing Up A New Customer

Hiring And Firing Employees Pt 1

Hiring And Firing Employees Pt 2

Listing Debtors

MySQL Video Training Detail:

Instructor:	Joshua Mostafa
Course Lessons:	56 Total Lessons
Course Duration:	8hrs total
First Release Date:	2002-07-25
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

Course Description:

Virtual Training Company's MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner's understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn MySQL from VTC Instructor Joshua Mostafa?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom