20761C: Querying Data with Transact-SQL Training

Course 20761C: Querying Data with Transact-SQL Training

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.

✔ Course Duration : 40 hrs

✔ Training Options : Live Online / Self-Paced / Classroom

✔ Certification Pass : Guaranteed

Overview

What you will Learn

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.

PREREQUISITES

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of relational databases.

CURRICULUM

Learning Objectives:

The Basic Architecture of SQL Server

SQL Server Editions and Versions

Getting Started with SQL Server Management Studio

Learning Objectives:

Introducing T-SQL

Understanding Sets

Understanding Predicate Logic

Understanding the Logical Order of Operations in SELECT statements

Learning Objectives:

Writing Simple SELECT Statements

Eliminating Duplicates with DISTINCT

Using Column and Table Aliases

Writing Simple CASE Expressions

Learning Objectives:

Understanding Joins

Querying with Inner Joins

Querying with Outer Joins

Querying with Cross Joins and Self Joins

Learning Objectives:

Sorting Data

Filtering Data with Predicates

Filtering Data with TOP and OFFSET-FETCH

Working with Unknown Values

Learning Objectives:

Introducing SQL Server Data Types

Working with Character Data

Working with Date and Time Data

Learning Objectives:

Adding Data to Tables

Modifying and Removing Data

Generating automatic column values

Learning Objectives:

Writing Queries with Built-In Functions

Using Conversion Functions

Using Logical Functions

Using Functions to Work with NULL

Learning Objectives:

Using Aggregate Functions

Using the GROUP BY Clause

Filtering Groups with HAVING

Learning Objectives:

Writing Self-Contained Subqueries

Writing Correlated Subqueries

Using the EXISTS Predicate with Subqueries

Learning Objectives:

Using Views

Using Inline Table-Valued Functions

Using Derived Tables

Using Common Table Expressions

Learning Objectives:

Writing Queries with the UNION operator

Using EXCEPT and INTERSECT

Using APPLY

Learning Objectives:

Creating Windows with OVER

Exploring Window Functions

Learning Objectives:

Writing Queries with PIVOT and UNPIVOT

Working with Grouping Sets

Learning Objectives:

Querying Data with Stored Procedures

Passing Parameters to Stored procedures

Creating Simple Stored Procedures

Working with Dynamic SQL

Learning Objectives:

T-SQL Programming Elements

Controlling Program Flow

Learning Objectives:

Implementing T-SQL error handling

Implementing structured exception handling

Learning Objectives:

Transactions and the database engines

Controlling transactions

FAQs

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
1. Online ,By deposit the mildain bank account
2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.

Contact us using the form on the right of any page on the mildaintrainings website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

You will never miss a lecture at Mildaintrainigs! You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.

We have a limited number of participants in a live session to maintain the Quality Standards. So, unfortunately, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

Yes, you can cancel your enrollment if necessary prior to 3rd session i.e first two sessions will be for your evaluation. We will refund the full amount without deducting any fee for more details check our Refund Policy

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Just give us a CALL at +91 8447121833 OR email at info@mildaintrainings.com

Call us At