Querying Data with Transact-SQL

Learning goals

On this seminar, participants acquire an understanding of the Transact-SQL language, which is used by all SQL Server-related disciplines: database administration, database development, and business intelligence.

Content

1. Introduction to Microsoft SQL Server 2016
   • Underlying Architecture of SQL Server
   • Editions and Versions
   • SQL Server Management Studio
2. Introduction to T-SQL Querying
   • Sets
   • Predicate Logic
   • Logical Sequence of Procedures in SQL Statements
3. Writing SELECT Queries
   • Writing Simple SELECT Statements
   • Removing Duplicates with DISTINCT
   • Using Column and Table Aliases
   • Writing Simple CASE Expressions
4. Querying Multiple Tables
   • Using JOINs
5. Sorting and Filtering Data
   • Sorting Data with ORDER BY
   • Filtering Data with Predicates in the WHERE Clause
   • Filtering with TOP, OFFSET and FETCH
   • Working with Unknown Values
6. Working with SQL Server 2016 Data Types
   • Character Data
   • Date and Time Data
7. Using Data Manipulation Language (DML)
   • Inserting Data
   • Modifying and Deleting Data
8. Using Built-In Functions
   • Write Queries with Built-In Functions
   • Data Type Conversion
   • Logical Functions
   • Working 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 EXIST Predicate
11. Using Set Operators
    • Writing Queries with the UNION Operator
    • Using EXCEPT and INTERSECT
    • Using APPLY

Requirements

Practical experience with relational databases, basic knowledge of the Windows operating system and its core functionality