Solution: Query information from a database - SQL Server Tutorial

Contents

• Introduction Introduction

  • Turn data into information with queries

    49s
  • What you should know

    53s
  • Download the sample database

    2m 51s
  • (Locked)
    Exploring the code challenge environment

    1m 54s
• 1. Introduction to T-SQL Queries 1. Introduction to T-SQL Queries

  • What is Transact SQL?

    3m 22s
  • (Locked)
    The SQL querying environment

    8m 6s
  • (Locked)
    Return records with SELECT and FROM

    8m 45s
  • (Locked)
    Filter records with WHERE

    4m 42s
  • (Locked)
    Sort records with ORDER BY

    2m 57s
  • (Locked)
    Column aliases

    2m 24s
  • (Locked)
    Create values with constants and math

    4m 22s
  • (Locked)
    Challenge: Write a SELECT query

    1m 15s
  • (Locked)
    Solution: Write a SELECT query

    4m 14s
  • (Locked)
    Solution: Query information from a database

    5m 32s
• 2. Additional Filter Techniques 2. Additional Filter Techniques

  • Limit results with TOP

    4m 39s
  • (Locked)
    Remove duplicates with DISTINCT

    2m 53s
  • (Locked)
    Comparison operators

    3m 43s
  • (Locked)
    Understand NULL values

    4m 42s
  • (Locked)
    Match text with LIKE and wildcards

    4m 36s
  • (Locked)
    Challenge: Retrieve matching text strings

    49s
  • (Locked)
    Solution: Retrieve matching text strings

    4m 52s
  • (Locked)
    Solution: Filter results from a query result

    4m 28s
• 3. Retrieve Records from Multiple Tables 3. Retrieve Records from Multiple Tables

  • Table joins and relationships

    3m 42s
  • (Locked)
    Inner joins

    8m 8s
  • (Locked)
    Left, right, and full outer joins

    4m 37s
  • (Locked)
    Cross joins

    4m 39s
  • (Locked)
    Challenge: Return data from multiple tables

    1m 6s
  • (Locked)
    Solution: Return data from multiple tables

    6m 12s
  • (Locked)
    Solution: Join data in multiple tables

    4m 4s
• 4. Group Records 4. Group Records

  • Understand record grouping

    2m 44s
  • (Locked)
    Use GROUP BY and COUNT

    5m 6s
  • (Locked)
    Aggregate functions

    3m 27s
  • (Locked)
    Explore data with SUM

    7m 13s
  • (Locked)
    Filter groups with HAVING

    3m 41s
  • (Locked)
    Challenge: Obtain order summaries

    1m 21s
  • (Locked)
    Solution: Obtain order summaries

    10m 34s
  • (Locked)
    Solution: Group rows and aggregate data

    3m 45s
• 5. Manipulate Data with Functions 5. Manipulate Data with Functions

  • Use functions in T-SQL

    3m 10s
  • (Locked)
    String functions

    3m 44s
  • (Locked)
    Text concatenation

    3m 40s
  • (Locked)
    Round with mathematical functions

    3m 13s
  • (Locked)
    Find the GREATEST or LEAST value

    5m 5s
  • (Locked)
    Work with date functions

    5m 56s
  • (Locked)
    FORMAT date and times

    3m 36s
  • (Locked)
    Group dates into buckets

    6m 10s
  • (Locked)
    Return random records with NEWID

    2m 22s
  • (Locked)
    Create a series of values

    5m 13s
  • (Locked)
    The IIF logical function

    3m 39s
  • (Locked)
    Write a CASE statement

    4m 34s
  • (Locked)
    Challenge: Use functions in a SQL query

    49s
  • (Locked)
    Solution: Use functions in a SQL query

    13m 55s
  • (Locked)
    Solution: Use functions in a query

    4m 22s
• 6. Writing SQL Scripts 6. Writing SQL Scripts

  • Change database context with USE

    3m 26s
  • (Locked)
    Add comments to a script

    3m 43s
  • (Locked)
    When to use square brackets

    1m 43s
• 7. SQL Subqueries 7. SQL Subqueries

  • (Locked)
    What is a subquery?

    5m 14s
  • (Locked)
    Use a subquery in a HAVING clause

    6m 26s
  • (Locked)
    Correlated subqueries

    6m 29s
  • (Locked)
    PIVOT the result set

    4m 20s
  • (Locked)
    Challenge: Write a query with a subquery

    1m 2s
  • (Locked)
    Solution: Write a query with a subquery

    8m 49s
  • (Locked)
    Solution: Obtain information with a subquery

    5m 44s
• 8. Work with Variables 8. Work with Variables

  • (Locked)
    Create and use variables in a query

    4m 46s
  • (Locked)
    Create a counter for a looping statement

    5m 37s
  • (Locked)
    Challenge: Use variables in a query

    43s
  • (Locked)
    Solution: Use variables in a query

    5m 1s
• 9. Result Set Operators 9. Result Set Operators

  • (Locked)
    Combine results with UNION

    3m 7s
  • (Locked)
    Return distinct rows with EXCEPT

    4m 15s
  • (Locked)
    Return common rows with INTERSECT

    3m 38s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 28s