MySQL Course

Become Proficient With MySQL!

This Is An In-depth Series Of Videos, Online Lessons, and Quizzes Covering the basics of writing and testing SQL commands.

As With All Of Our Products, Each Screen Video Demonstration Will Give You Easy To Follow Examples

You Will Learn How To Use phpMyAdmin
to browse and execute MySQL commands
against your MySQL database.

From: Neal Walters
Date: January 22, 2008

Dear Friends,

I recently began selling Joomla courses, and it occurred to me that a lot of Joomla users started with Joomla because it is easy to use.  But at some point, the users of Joomla often need to turn to the database to perform more advanced functions, or eventually want to write their own PHP programs to extend or enhance their system.

Regardless of whether you are a Joomla user or not, if you want to learn MySQL from the very beginning, then this course is for you.

We teach how to build SELECT statements, including keywords such as ORDER BY, GROUP BY, DISTINCT, COUNT, SUM, AVG and so on.  We have an entire lesson dedicated to teaching how to join multiple tables together in one query.  Another chapter covers the update commands:  INSERT, UPDATE, and DELETE.  We cover important concepts such as backups, and even explain devious techniques such as "SQL Injection".

All demos are perfomed using phpMyAdmin, which is the tool that all hosting services provide for you to access and maniuplate your database.

Before you go, Let me introduce you to "Office 2007 - Video Training Course." We have put together a series of up-to-date videos that demonstrate how to use the ENTIRE suite of Office Products for Office 2007.

What You Don't Know Could Be Keeping You From A Promotion Or Even Handicapping Your Business Efforts!

If you work on any web-based system today, knowing SQL is a must!  Since MySQL is free with most all hosting packages, it is the perfect system to learn-on. 

Here's just a little of what's included with this Fantastic Video Series:

Select
   Where Clause
      Conditional Expressions 
      = <> > < 
      BETWEEN 
      IN 
      LIKE
   Order By
   Sum,Min,Max,Avg,Count with GROUP BY and HAVING
   DISTINCT 
   Joining Multiple Tables
     Inner Joins
     Outer Joins
     Joining a table with itself (nested, recursive, reflexive JOIN)
Update Commands
    Two types of INSERT Commands
    UPDATE
    DELETE
Database Structure
    How to read a database diagram
    How to understand one-to-many relationships
    How to JOIN multiple tables together
Creating new tables
Using Create, Alter, Drop
Backup and Restore with Export and Import
Making a copy of your database
MySQL built-in functions
   Date/Time Functions
   String Functions (such as CONCAT)
   Numeric Functions (such as ROUND) 
Using MySQL in PHP
   Connecting to your database from PHP
   Executing Update Commands from PHP 
   Retrieving a single row
   Retrieving multiple rows
   Creating an HTML table from your data
   How to avoid "SQL Injection"
 

Take A Look At Two FREE Sample Videos (These will open in new browser tab or screen.)

Course Outline

Here is the link to our course outline: 
This detailed outline will show you exactly what vidoes are included and the run-time of each video. JOOM301 - MySQL Course Outline

This course includes 33 videos and over 5 hours of total playing time.
 

Order Today
MySQL - Online Video-Based Training Course

Credit card orders receive INSTANT ACCESS. PayPal orders require a manual intervention by our staff, which usually only takes an hour or so, but might take up to one business day.

NOTE: These are videos that you play on your computer in your web browser.

Meet You At The Top !

Neal Walters and Jim Messler