Transact SQL (T-SQL) (DP-080) Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

Transact SQL (T-SQL) (DP-080) training course provides an understanding of the Transact-SQL language which is used by all SQL Server-related disciplines such as Database Administration, Database Development and Business Intelligence.

By attending Transact SQL (T-SQL) (DP-080) workshop, delegates will learn to:

Describe key capabilities and components of SQL Server
Describe T-SQL, sets, and predicate logic
Write a single table SELECT statement
Write a multi-table SELECT statement
Write SELECT statements with filtering and sorting
Describe how SQL Server uses data types
Write DML statements
Write queries that use built-in functions
Write queries that aggregate data
Write subqueries
Create and implement views and table-valued functions
Use set operators to combine query results
Write queries that use window ranking, offset, and aggregate functions
Transform data by implementing pivot, unpivot, rollup and cube
Create and implement stored procedures
Add programming constructs such as variables, conditions,and loops to T-SQL code

A working knowledge of relational databases but not necessarily Microsoft SQL

This Transact SQL (T-SQL) (DP-080) class is intended for Database Administrators, Database Developers and BI professionals.

Introduction to Microsoft SQL

The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio

Introduction to T-SQL Querying

Introducing T-SQL
Sets
Predicate Logic
Logical Order of Operations in SELECT statements

Writing SELECT Queries

Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions

Querying Multiple Tables

Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins

Sorting and Filtering Data

Sorting Data
Filtering Data with Predicates
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown Values

Working with SQL Server Data Types

Introducing SQL Server Data Types
Working with Character Data
Working with Date and Time Data

Using DML to Modify Data

Inserting Data
Modifying and Deleting Data

Using Built-In Functions

Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL

Grouping and Aggregating Data

Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING

Using Subqueries

Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries

Using Set Operators

Using Set

Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY

Using Windows Ranking, Offset, and Aggregate

Creating Windows with OVER
Exploring Window Functions

Pivoting and Grouping Sets

Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets

Stored Procedures

Querying Data with Stored Procedures
Passing Parameters to Stored Procedures
Creating Simple Stored Procedures
Working with Dynamic SQL

Programming with T-SQL

T-SQL Programming Elements
Controlling Program Flow

Implementing Error Handling

Implementing T-SQL Error Handling
Implementing Structured Exception Handling

Implementing Transactions

Transactions and the Database Engines
Controlling Transactions

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Transact SQL (T-SQL) (DP-080)

COURSE AGENDA