SQL Server 2014, Part 8 of 9: T-SQL Select, Where, and Clauses
Interactive

SQL Server 2014, Part 8 of 9: T-SQL Select, Where, and Clauses

Biz Library
Updated Feb 04, 2020

In this course you’ll learn about the SELECT statement and its incredible flexibility when retrieving data from one or more database tables. You can shape the data you retrieve, and filter it using the WHERE clause. SQL Server rarely returns data in the order you want, so you can use the ORDER BY clause to sort it. Next you’ll learn some advanced ways to select data. With the GROUP BY clause, you can summarize the information in one or more tables, aggregating it various ways, if you wish. You’ll also learn how you can join the data together from multiple tables, efficiently including related data in the result sets.


Lesson 1:

  • Transact-SQL Data Selection
  • Schemas and Naming in SQL
  • The SELECT Statement
  • Demo: The SELECT Statement
  • Semicolon vs. GO
  • Demo: The Asterisk Symbol
  • Demo: Concatenation
  • Demo: Aliases
  • Demo: Distinct.

Lesson 2:

  • Demo: The WHERE Clause
  • Comparison Operators
  • Demo: LIKE and Wildcards
  • Demo: BETWEEN Operator
  • Demo: Test for Null
  • Three-Valued Logic: Nulls
  • Demo: AND, OR, NOT Operators
  • Demo: Operator Precedence
  • Demo: Overriding Precedence
  • Demo: IN Operator.

Lesson 3:

  • Demo: ORDERBY
  • Demo: GROUPBY and Aggregates
  • Demo: Count
  • Demo: GROUPBY
  • Demo: ORDERBY with GROUPBY
  • Demo: HAVING Clause
  • Demo: Top Clause
  • Demo: Top, Ties and PERCENT.

Lesson 4:

  • Demo: Cross Join
  • Demo: How Joins Work
  • Demo: Joins with WHERE Clause
  • Join Notation
  • Demo: JOIN Clause
  • Demo: Alias Tip
  • Inner Joins
  • Demo: INNER JOIN
  • Demo: Multiple Table Joins
  • Demo: Joins and Aggregates.

Lesson 5:

  • Demo: Outer Joins
  • Demo: Left Outer Join
  • Demo: Right Outer Join
  • Demo: Full Outer Join
  • Demo: Combining Joins
  • Demo: Two Left Joins
  • Self Joins
  • Demo: Self Joins.