Querying Data with Transact-SQL

Descrizione del corso

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Programma

1. Introduction to Microsoft SQL Server 2016
   • The Basic Architecture of SQL Server
   • SQL Server Editions and Versions
   • Setting Started with SQL Server Management Studio
2. Introduction to T-SQL Querying
   • Introducing T-SQL
   • Understanding Sets
   • Understanding Predicate Logic
   • Understanding the Logical Order of Operations in SELECT statements
3. Writing SELECT Queries
   • Writing Simple SELECT Statements
   • Eliminating Duplicates with DISTINCT
   • Using Column and Table Aliases
   • Writing Simple CASE Expressions
4. Querying Multiple Tables
   • Understanding Joins
   • Querying with Inner Joins
   • Querying with Outer Joins
   • Querying with Cross Joins and Self Joins
5. Sorting and Filtering Data
   • Sorting Data
   • Filtering Data with Predicates
   • Filtering with the TOP and OFFSET-FETCH Options
   • Working with Unknown Values
6. Working with SQL Server 2016 Data Types
   • Introducing SQL Server 2016 Data Types
   • Working with Character Data
   • Working with Date and Time Data
7. Using DML to Modify Data
   • Inserting Data
   • Modifying and Deleting Data
8. Using Built-In Functions
   • Writing Queries with Built-In Functions
   • Using Conversion Functions
   • Using Logical Functions
   • Using Functions to Work with NULL
9. Grouping and Aggregating Data
   • Using Aggregate Functions
   • Using the GROUP BY Clause
   • Filtering Groups with HAVING
10. Using Subqueries
    • Writing Self-Contained Subqueries
    • Writing Correlated Subqueries
    • Using the EXISTS Predicate with Subqueries