Training Home | Web Design | MySQL Beginners Training

Beginners MySQL Training DVD

Learn how to take your skills to the next level. This Beginners MySQL training DVD is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface, This Beginners MySQL tutorial video makes learning simple, quick and enjoyable. All training courses are authored by professional instructors who have a passion for teaching.

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Reduce learning time by 80%. Learn from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer an insight into the quality of these Beginners MySQL tutorials. In order for the free demo videos to play QuickTime needs to be installed.

This Weeks Limited Offer

25% off AutoCAD 2010 Videos

OVER 9 hours of Video Training - ONLY $74.95

We are pleased to announce that we have just released our Amazing AutoCAD training videos. This highly intuitive and engaging training course is only $74.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »

Customer Testimonials

I was a contract/freelance web designer struggling with the transition from table-based to CSS-only layouts. I was falling behind the curve, losing work and quickly becoming obsolete. After watching all of your CSS training videos, I was able to land my dream job at an award-winning web design agency here in Phoenix, AZ. THANK YOU!!
bobby d.

1. Introducing MySQL

Welcome Demo
What is MySQL? Demo
Important terminology Demo
Using the exercise files

2. Installing the Test Environment

Installation overview
Installing XAMPP on Windows
Installing XAMPP on a Mac

3. Configuring MySQL

Using the MySQL Command Line Interface on Windows Demo
Using the MySQL Command Line Interface on a Mac Demo
Setting up the root user Demo
Setting up a regular user
Importing databases on Windows
Importing databases on a Mac

4. Using the SQL Interactive Demonstrator (SID)

Using SID
Installing SID on Windows
Installing SID on a Mac

5. Creating a Database

Creating a database
Creating a table Demo

6. MySQL Data Types

What are data types?
Numeric types
String types
Large storage types
Date and time types
Bit type
Boolean values
Enumeration types

7. MySQL Functions

MySQL functions
String functions
Numeric functions
Date and time functions
Time zones in MySQL
Installing time zone support in MySQL in Windows
Installing time zone support in MySQL on a Mac
Aggregate functions
Full-text search

8. PHP's MySQLi Interface

PHP programming interfaces
Introducing CRUD
Connecting to the database
Prepared statements
Fetching results
Auto-increment IDs

9. PHP's PDO Interface with MySQL

PDO is multi-platform
Connecting to the database
Prepared statements
Fetching results
Auto-increment IDs

Conclusion

Goodbye

Beginners MySQL Training DVD Info

Title Information.

MySQL is by far the most popular database management system for small- to medium-sized web projects. In this beginners MySQL Training video, expert tutor Bill Weinman provides clear, concise instruction in the tools needed to create and maintain a database. Bill explores the different data types MySQL supports, and the functions it provides, enabling the user to get the most out of them. He even shows the MySQL PHP interfaces that can be used to create web applications. Exercise files accompany the tutorial.. Close »

Instructor : Bill Weinman

All Training Courses by this author

Publisher:

lynda.com, Inc.

Duration:

2.75 hours - 47 lessons

Platform:

PC or Mac

Fomat :

DVD Video

Price:

$49.95

£34.57

€40.41

Select your delivery option

Beginners MySQL Related Training Videos :

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Adobe Photoshop CS5 Training
Microsoft Office 2010
Learning Microsoft Project 2010
Learning Microsoft Excel 2010
Carrara 8 Training

Learn Online - Instant Access - Low Price

Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.

You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.

Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.

Customer Comments

I just want to thank you for helping me in my studies of all the new CS4 products by Adobe. The programs are fantastic-but, the reason I think they are fantastic is BECAUSE of the way you have helped me to learn them. Your training is really the best! I look forward to more learning with you.
john w.