Learning SQL: Use the SELECT Statement

http://www.informit.com/store/learning-sql-livelessons-video-training-9780134193571?WT.mc_id=Social_YT

Learning SQL: Use the SELECT Statement is an excerpt from Learning SQL LiveLessons Video Training -- Learn the fundamentals of SQL quickly and easily from the world's favorite SQL teacher. In Learning SQL LiveLessons bestselling author Ben Forta teaches you the basic 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, one-on-one, from the absolute basics all the way to 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.

Based on Forta's bestselling book, Sams Teach Yourself SQL in 10 Minutes, everything's organized into bite-sized, self-contained lessons, so you can learn key SQL skills quickly and easily.

Skill Level
Beginner & Intermediate

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

Who Should Take This Course:
Everyone who wants to master SQL to manage data, write queries, and/or build database applications with any modern relational database
Professional and casual developers at all levels

http://www.informit.com/store/learning-sql-livelessons-video-training-9780134193571?WT.mc_id=Social_YT