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
SQL Fundamentals Overview
- SQL Fundamentals Overview 00:03:01
- Lesson 1: Introduction to the MySQL Interfaces
- Lesson 2: Getting Data Out of the Database
- Lesson 3: Managing Data in the Database
- Lesson 4: Aggregation and Grouping
- Lesson 5: Working with Multiple Tables
Lesson 6: Working with Tables in the Database
- Learning Objectives 00:00:59
- CREATE and DROP 00:17:22
- ALTER objects in the table objects 00:13:38
- Placing indexes on tables for improved performance 00:29:45
- Using keys and constraints to control data entered into tables 00:17:56
- Working with temporary table objects 00:07:03
Lesson 7: Working with Security
- Learning Objectives 00:00:43
- Introduction of how security in the database is handled 00:09:28
- Working with Users 00:15:39
- Assigning rights 00:16:53
- Lesson 8: Advanced SQL programming
- Title: SQL Fundamentals LiveLessons
- Release date: September 2009
- Publisher(s): Sams
- ISBN: 9780768694765