O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Fundamentals LiveLessons

SQL Fundamentals LiveLessons

by Arie D. Jones
Publisher: Sams
Release Date: September 2009
ISBN: 9780768694765
View table of contents
Start watching

Video 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 Browser…get data out of databases with SELECT…sequence results with ORDER…filter data with WHERE…manage, aggregate, and group data…work with tables…manage security and access…even 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!

Table of Contents

  1. SQL Fundamentals Overview
    1. SQL Fundamentals Overview 00:03:01
  2. Lesson 1: Introduction to the MySQL Interfaces
    1. Learning Objectives 00:00:41
    2. Introduction to the MySQL Interfaces 00:13:30
  3. Lesson 2: Getting Data Out of the Database
    1. Learning Objectives 00:00:36
    2. The SELECT statement 00:12:04
    3. DISTINCT 00:08:17
    4. Ordering the results with ORDER clause 00:10:09
    5. Using the WHERE clause to filter data 00:22:23
    6. Using Subqueries to filter data 00:11:14
  4. Lesson 3: Managing Data in the Database
    1. Learning Objectives 00:00:38
    2. UPDATE 00:12:56
    3. INSERT 00:14:16
    4. DELETE 00:07:04
    5. Managing Transactions 00:17:55
  5. Lesson 4: Aggregation and Grouping
    1. Learning Objectives 00:00:49
    2. COUNT/SUM/MIN/MAX 00:14:26
    3. GROUP BY 00:14:50
    4. Filtering results using the HAVING clause 00:12:05
  6. Lesson 5: Working with Multiple Tables
    1. Learning Objectives 00:00:44
    2. Introduction to the concept of joins 00:13:10
    3. INNER 00:08:51
    4. OUTER 00:10:31
    5. UNION 00:08:42
    6. INTERSECT 00:10:25
    7. MINUS 00:09:29
  7. Lesson 6: Working with Tables in the Database
    1. Learning Objectives 00:00:59
    2. CREATE and DROP 00:17:22
    3. ALTER objects in the table objects 00:13:38
    4. Placing indexes on tables for improved performance 00:29:45
    5. Using keys and constraints to control data entered into tables 00:17:56
    6. Working with temporary table objects 00:07:03
  8. Lesson 7: Working with Security
    1. Learning Objectives 00:00:43
    2. Introduction of how security in the database is handled 00:09:28
    3. Working with Users 00:15:39
    4. Assigning rights 00:16:53
  9. Lesson 8: Advanced SQL programming
    1. Learning Objectives 00:00:42
    2. SQL Functions: String and Numbers 00:17:21
    3. SQL Functions: Date and Time 00:14:20
    4. SQL Functions: Conversions 00:10:27
    5. VIEWS 00:09:45
    6. STORED PROCEDURES 00:21:29
    7. TRIGGERS 00:23:02
    8. CURSORS 00:16:09