Querying Microsoft® SQL Server® 2014

Current Status

Not Enrolled

Price

$1500

Get Started

Take this Course

Course Content

Expand All

Module 1

The Basic Architecture of SQL Server 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Relational Databases

About the Course Sample Database

Client Server Databases

Queries

SQL Server Editions and Versions 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

SQL Server Versions

SQL Server Editions

Getting Started with SQL Server Management Studio 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Starting SSMS

Connecting to SQL Server

Working with Object Explorer

Working with Script Files and Projects

Executing Queries

Using Books Online

Demonstration: Introducing Microsoft SQL Server 2014

Module 2

Introducing T-SQL 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

About T-SQL

Categories of T-SQL Statements

T-SQL Language Elements

T-SQL Language Elements: Predicates and Operators

T-SQL Language Elements: Functions

T-SQL Language Elements: Variables

T-SQL Language Elements: Expressions

T-SQL Language Elements: Control of Flow, Errors, and Transactions

T-SQL Language Elements: Comments

T-SQL Language Elements: Batch Separators

Demonstration: T-SQL Language Elements

Understanding Sets 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Set Theory and SQL Server

Set Theory Applied to SQL Server Queries

Understanding Predicate Logic 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Predicate Logic and SQL Server

Predicate Logic Applied to SQL Server Queries

Understanding the Logical Order of Operations in SELECT Statements 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Elements of a SELECT Statement

Logical Query Processing

Applying the Logical Order of Operations to Writing SELECT Statements

Demonstration: Logical Query Processing

Module 3

Writing Simple SELECT Statements 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Elements of the SELECT Statement

Retrieving Columns from a Table or View

Displaying Columns

Using Calculations in the SELECT Clause

Demonstration: Writing Simple SELECT Statements

Eliminating Duplicates with DISTINCT 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

SQL Sets and Duplicate Rows

Understanding DISTINCT

SELECT DISTINCT Syntax

Demonstration: Eliminating Duplicates with DISTINCT

Using Column and Table Aliases 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Using Aliases to Refer to Columns

Using Aliases to Refer to Tables

The Impact of Logical Processing Order on Aliases

Demonstration: Using Column and Table Aliases

Writing Simple CASE Expressions 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Using CASE Expressions in SELECT Clauses

Forms of CASE Expressions

Demonstration: Using a Simple CASE Expression

Module 4

Understanding Joins 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

The FROM Clause and Virtual Tables

Join Terminology: Cartesian Product

Overview of Join Types

T-SQL Syntax Choices

Demonstration: Understanding Joins

Querying with Inner Joins 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Understanding Inner Joins

Inner Join Syntax

Inner Join Examples

Demonstration: Querying with Inner Joins

Querying with Outer Joins 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Understanding Outer Joins

Outer Join Syntax

Outer Join Examples

Demonstration: Querying with Outer Joins

Querying with Cross Joins and Self Joins 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Understanding Cross Joins

Cross Join Syntax

Cross Join Examples

Understanding Self Joins

Self Join Examples

Demonstration: Querying with Cross Joins and Self Joins

Module 5

Sorting Data 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Using the ORDER BY Clause

ORDER BY Clause Syntax

ORDER BY Clause Examples

Demonstration: Sorting Data

Filtering Data with Predicates 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Filtering Data in the WHERE Clause with Predicates

WHERE Clause Syntax

Demonstration: Filtering Data with Predicates

Filtering Data with TOP and OFFSET-FETCH 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Filtering in the SELECT Clause Using the TOP Option

Filtering in the ORDER BY Clause Using OFFSET-FETCH

OFFSET-FETCH Syntax

Demonstration: Filtering Data with TOP and OFFSET-FETCH

Working with Unknown Values 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Three-Valued Logic

Handling NULL in Queries

Demonstration: Working with NULL

Module 6

Introducing SQL Server 2014 Data Types 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

SQL Server Data Types

Numeric Data Types

Binary String Data Types

Other Data Types

Data Type Precedence

When Are Data Types Converted?

Demonstration: SQL Server Data Types

1 of 4