Learning SQL

Video description

Almost 3 Hours of Video Instruction

Your complete SQL video course: Master hands-on, real-world skills for working with data, tables, queries, and much more!

Description

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.

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

Course Requirements

  • Basic experience using databases; no SQL experience necessary

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.

Lesson 9: Summarizing Data
Use the aggregate functions AVG, COUNT, MAX, MIN, and SUM to summarize data, totals, averages, and more.

Lesson 10: Grouping Data
Group data with the GROUP BY clause, and use the HAVING clause to filter by group rather than row.

Lesson 11: Working with Subqueries
Create powerful subqueries (queries passed to other queries) to filter rows in conjunction with WHERE and to return values to calculated fields.

Lesson 12: Joining Tables
Master and compare two ways to create simple joins with keys. Then, learn how to join multiple tables.

Lesson 13: Creating Advanced Joins
Use table aliases, self-joins, and outer joins, and combine joins with aggregate functions.

Lesson 14: Combining Queries
Use UNION to combine query result sets from multiple SELECT statements, include or exclude duplicate rows, and use ORDER BY to sort the queries you’ve combined.

Lesson 15: Inserting Data
Insert rows or retrieved data, avoid unsafe ways to use the INSERT statement, master best practices to prevent accidental data changes or deletion, and copy data to another table.

Lesson 16: Updating and Deleting Data
Update and delete table rows. Master UPDATE and DELETE best practices to make sure you don’t inadvertently change or delete data that should remain intact.

Lesson 17: Where to Go from Here
Discover what can be done with advanced features such as views, stored procedures, triggers, constraints, and transactions.

About LiveLessons Video Training

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at http://www.informit.com/livelessons.

Table of contents

  1. Introduction
    1. Learning SQL LiveLessons: Introduction
  2. Lesson 1: Introducing SQL
    1. Learning Objectives
    2. 1.1 Review database basics
    3. 1.2 Choose a DBMS
    4. 1.3 Get ready to learn SQL
  3. Lesson 2: Retrieving Data
    1. Learning Objectives
    2. 2.1 Use the SELECT statement
    3. 2.2 Retrieve individual columns
    4. 2.3 Retrieve multiple columns
    5. 2.4 Retrieve all columns
    6. 2.5 Retrieve distinct rows
    7. 2.6 Limit retrieved data
    8. 2.7 Refine your SQL skills
    9. Summary
  4. Lesson 3: Sorting Retrieved Data
    1. Learning Objectives
    2. 3.1 Use ORDER BY
    3. 3.2 Sort by one column
    4. 3.3 Sort by multiple columns
    5. 3.4 Specify sort direction
    6. Summary
  5. Lesson 4: Filtering Data
    1. Learning Objectives
    2. 4.1 Use WHERE
    3. 4.2 Use WHERE clause operators
    4. 4.3 Filter using a range
    5. 4.4 Filter for no value
    6. Summary
  6. Lesson 5: Advanced Data Filtering
    1. Learning Objectives
    2. 5.1 Combine WHERE clauses
    3. 5.2 Understand order of evaluation
    4. 5.3 Filter using IN
    5. 5.4 Negate using NOT
    6. Summary
  7. Lesson 6: Using Wildcard Filtering
    1. Learning Objectives
    2. 6.1 Filter using LIKE
    3. Summary
  8. Lesson 7: Creating Calculated Fields
    1. Learning Objectives
    2. 7.1 Use concatenation
    3. 7.2 Use aliases
    4. 7.3 Perform mathematical calculations
    5. Summary
  9. Lesson 8: Using Data Manipulation Functions
    1. Learning Objectives
    2. 8.1 Use string functions
    3. 8.2 Use date functions
    4. Summary
  10. Lesson 9: Summarizing Data
    1. Learning Objectives
    2. 9.1 Use aggregate functions
    3. Summary
  11. Lesson 10: Grouping Data
    1. Learning Objectives
    2. 10.1 Use GROUP BY
    3. 10.2 Use HAVING
    4. Summary
  12. Lesson 11: Working with Subqueries
    1. Learning Objectives
    2. 11.1 Use subqueries with WHERE
    3. 11.2 Use subqueries as calculated fields
    4. Summary
  13. Lesson 12: Joining Tables
    1. Learning Objectives
    2. 12.1 Create a basic join
    3. 12.2 Join multiple tables
    4. Summary
  14. Lesson 13: Creating Advanced Joins
    1. Learning Objectives
    2. 13.1 Use table aliases
    3. 13.2 Create a self-join
    4. 13.3 Create an outer join
    5. 13.4 Use joins with aggregate functions
    6. Summary
  15. Lesson 14: Combining Queries
    1. Learning Objectives
    2. 14.1 Use a UNION
    3. 14.2 Include/exclude duplicates
    4. 14.3 Sort combined queries
    5. Summary
  16. Lesson 15: Inserting Data
    1. Learning Objectives
    2. 15.1 Insert a row
    3. 15.2 Insert retrieved data
    4. 15.3 Copy to another table
    5. Summary
  17. Lesson 16: Updating and Deleting Data
    1. Learning Objectives
    2. 16.1 Update a row
    3. 16.2 Delete a row
    4. Summary
  18. Lesson 17: Where to Go from Here
    1. Learning Objectives
    2. 17.1 Understand table manipulation
    3. 17.2 Understand views
    4. 17.3 Understand stored procedures
    5. 17.4 Be familiar with a few more
    6. Summary
  19. Summary
    1. Learning SQL LiveLessons: Summary

Product information

  • Title: Learning SQL
  • Author(s):
  • Release date: July 2015
  • Publisher(s): Pearson
  • ISBN: 0134193709