Buy and Download - Addison-Wesley Professional Learning SQL LiveLessons Video Training

2015
Addison-Wesley Professional
Ben Forta
1:27
English

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.

Lesson 1: Introducing SQL
Review database basics such as tables, rows, columns, and keys; understand what relational databases are; choose a DBMS; and learn what SQL is and what it does.
Lesson 2: Retrieving Data
Work with SELECT, the most used SQL statement. Retrieve individual, multiple, or all columns; retrieve specific rows; and limit the data you retrieve. Master and refine some important SQL skills and best practices.
Lesson 3: Sorting Retrieved Data
Use SELECT ORDER BY, sort by one or multiple columns, and specify the direction of your sort.
Lesson 4: Filtering Data
Use SELECT WHERE and its clause operators, use BETWEEN to filter for a range of values, and use NULL to filter for no value.
Lesson 5: Advanced Data Filtering
Combine WHERE filters using AND and OR; correctly manage “order of evaluation”; use IN to filter by a defined set of matches; and negate clauses with NOT.
Lesson 6: Using Wildcard Filtering
Create wildcard filters with the LIKE keyword, and learn three wildcards you can use to search for any character combinations.
Lesson 7: Creating Calculated Fields
Use concatenation and aliases, and perform on-the-fly mathematical calculations using calculate fields and mathematical operators.
Lesson 8: Using Data Manipulation Functions
Manipulate data with string and date functions.