LiveLessons – Learning SQL

Your complete SQL video course: Master hands-on, real-world skills for working with data, tables, queries, and much more!
In Learning SQL LiveLessons Ben Forta, the world’s favorite SQL teacher, helps you master the core real-world skills you need to succeed with SQL. Drawing on his experience helping thousands of developers and other IT pros at all levels, Forta guides you from the absolute basics all the way to advanced queries, joins, and beyond. One step at a time, you’ll learn how to retrieve data with SELECT; sort, filter, group, and summarize data; create calculated fields; manipulate data with string and date functions; build queries and subqueries; create basic and advanced table joins; combine queries with UNION; sort your queries; insert, update, and delete data; and even discover what you can do with triggers and stored procedures. Everything’s organized into bite-sized, self-contained lessons, so you can learn key SQL skills quickly and easily.About the Instructor
Ben Forta, Senior Technical Evangelist at Adobe, has more than two decades of experience in software product development, support, training, and marketing. He is author of the best-selling Teach Yourself SQL in 10 Minutes, ColdFusion Web Application Construction Kit, and Advanced ColdFusion Application Development; as well as several books on mobile and Windows development. Over half a million Ben Forta books have been printed in a dozen languages. Forta writes regularly on Internet development, and lectures and speaks on related topics worldwide.

What You Will Learn

Retrieve data using the SQL SELECT statement
Sort, filter, and manipulate data
Create calculated fields
Group and summarize data
Work with subqueries and WHERE statements
Use basic and advanced table joins
Combine queries with UNION statements
Insert, update, and delete data
Get started with advanced SQL features