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
SQL Fundamentals Overview
SQL Fundamentals Overview
Lesson 1: Introduction to the MySQL Interfaces
Learning Objectives
Introduction to the MySQL Interfaces
Lesson 2: Getting Data Out of the Database
Learning Objectives
The SELECT statement
DISTINCT
Ordering the results with ORDER clause
Using the WHERE clause to filter data
Using Subqueries to filter data
Lesson 3: Managing Data in the Database
Learning Objectives
UPDATE
INSERT
DELETE
Managing Transactions
Lesson 4: Aggregation and Grouping
Learning Objectives
COUNT/SUM/MIN/MAX
GROUP BY
Filtering results using the HAVING clause
Lesson 5: Working with Multiple Tables
Learning Objectives
Introduction to the concept of joins
INNER
OUTER
UNION
INTERSECT
MINUS
Lesson 6: Working with Tables in the Database
Learning Objectives
CREATE and DROP
ALTER objects in the table objects
Placing indexes on tables for improved performance
Using keys and constraints to control data entered into tables
Working with temporary table objects
Lesson 7: Working with Security
Learning Objectives
Introduction of how security in the database is handled
Working with Users
Assigning rights
Lesson 8: Advanced SQL programming
Learning Objectives
SQL Functions: String and Numbers
SQL Functions: Date and Time
SQL Functions: Conversions
VIEWS
STORED PROCEDURES
TRIGGERS
CURSORS