SQL Fundamentals LiveLessons (Video Training) DVD

Description

Start building powerful SQL queries right now!

8 Hours of Expert Video Instruction

This one-of-a-kind video package gives you instant skills, answers, and solutions from eight hours of quick, easy DVD video LiveLessons.

Database expert Arie Jones teaches you SQL the right way...hands-on, and step-by-step! These video lessons focus on exactly what you need to know to master new skills fast and put them to work immediately. Simply place the DVD video in your computer's DVD drive, and begin mastering SQL the easy way!

Watch and learn how to write queries using the world's #1 open source database, MySQL--and build skills you can use with any database, from Oracle to SQL Server! Learn to navigate MySQL's command line and Query Browserget data out of databases with SELECTsequence results with ORDERfilter data with WHEREmanage, aggregate, and group datawork with tablesmanage security and accesseven use advanced functions, views, and stored procedures!

For even more practical guidance, turn to Sams Teach Yourself SQL in 24 Hours, Fourth Edition, by Ryan Stephens, Ron Plew, and Arie Jones. With 24 easy, practical, hands-on lessons, it's the only SQL book you'll ever need!

CONTENTS:

DVD Contents

1: Introduction to the MySQL Interfaces [00:14:10]

2: Getting Data out of the Database [01:04:42]

3: Managing Data in the Database [00:52:48]

4: Aggregation and Grouping [00:42:10]

5: Working with Multiple Tables [01:01:52]

6: Working with Tables in the Database [01:26:43]

7: Working with Security [00:42:42]

8: Advanced SQL Programming [01:57:18]