ICC Teleservices Ltd
Your Trusted ICT Partner

Querying Data with Transact SQL Training from ICC Teleservices

Duration 32(Hrs)

Buy Now

COURSE OUTLINE

1 - INTRODUCTION TO MICROSOFT SQL SERVER 2016
  • Learn the Basics of SQL Server Architecture
  • Get Exposed to the Different SQL Server Editions and Versions
  • Become Familiar With SQL Server Management Studio
  • Lab: Working with SQL Server 2016 Tools
2 - INTRODUCTION TO T-SQL QUERYING
  • Learn the Components of T-SQL
  • Understand Sets and Predicate Logic
  • Master the Logical Order of Operations in SELECT statements
  • Lab: Introduction to Transact-SQL Querying
3 - WRITING SELECT QUERIES
  • Write Simple SELECT Statements and CASE Expressions
  • Eliminate Duplicates With DISTINCT
  • Practice Using Column and Table Aliases
  • Lab: Writing Basic SELECT Statements
4 - QUERYING MULTIPLE TABLES
  • Understand Joins
  • Query with Inner Joins, Outer Joins, Cross Joins and Self Joins
  • Lab: Querying Multiple Tables
5 - SORTING AND FILTERING DATA
  • Learn How to Sort Data
  • Filter Data with Predicates
  • Work With Unknown Values
  • Lab: Sorting and Filtering Data
6 - WORKING WITH SQL SERVER 2016 DATA TYPES
  • Learn About SQL Server 2016 Data Types
  • Work With Character Data and Date and Time Data
  • Lab: Working with SQL Server 2016 Data Types
7 - USING DML TO MODIFY DATA
  • Insert Data
  • Modify and Delete Data
  • Lab: Using DML to Modify Data
8 - USING BUILT-IN FUNCTIONS
  • Write Queries with Built-In Functions
  • Practice Conversion Functions and Logical Functions
  • Practice Using Functions to Work With NULL
  • Lab: Using Built-In Functions
9 - GROUPING AND AGGREGATING DATA
  • Use Aggregate Functions and the GROUP BY Clause
  • Filter Groups With HAVING
  • Lab: Grouping and Aggregating Data
10 - USING SUBQUERIES
  • Write Self-Contained and Correlated Subqueries
  • Execute the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries
11 - USING TABLE EXPRESSIONS
  • Navigate Views and Inline Table-Valued Functions
  • Manipulate Derived Tables and Common Table Expressions
  • Lab: Using Table Expressions
12 - USING SET OPERATORS
  • Complete Queries with the UNION Operator
  • Use EXCEPT, INTERSECT and APPLY
  • Lab: Using Set Operators
13 - USING WINDOWS RANKING, OFFSET, AND AGGREGATE FUNCTIONS
  • Create Windows with OVER
  • Explore Window Functions
  • Lab: Using Windows Ranking, Offset, and Aggregate Functions
14 - PIVOTING AND GROUPING SETS
  • Write Queries with PIVOT and UNPIVOT
  • Work with Grouping Sets
  • Lab: Pivoting and Grouping Sets
15 - EXECUTING STORED PROCEDURES
  • Query Data with Stored Procedures
  • Pass Parameters to Stored procedures
  • Create Simple Stored Procedures
  • Navigate Dynamic SQL
  • Lab: Executing Stored Procedures
16 - PROGRAMMING WITH T-SQL
  • Master T-SQL Programming Elements
  • Control Program Flow
  • Lab: Programming with T-SQL
17 - IMPLEMENTING ERROR HANDLING
  • Execute T-SQL Error Handling
  • Implement Structured Exception Handling
  • Lab: Implementing Error Handling
18 - IMPLEMENTING TRANSACTIONS
  • Learn About Transactions and Database Engines
  • Control Transactions
  • Lab: Implementing Transactions

OUR PARTNER