Description

Duration

5 Days

30 CPD hours

This course is intended for

This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users.

Overview

Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables.
Before starting this course, make sure you meet at least one of the following prerequisites:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Basic working knowledge of Relational Databases.

In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL.

Course Outline

1.Introduction to Microsoft SQL Server

2.Introduction to T-SQL Querying

3.Writing SELECT Queries

4.Querying Multiple Tables

5.Sorting and Filtering Data

6.Working with SQL Server Data Types

7.Using DML to Modify Data

8.Using Built-In Functions

9.Grouping and Aggregating Data

10.Using Subqueries

11.Using Table Expressions

12.Using Set Operators

13.Using Windows Ranking, Offset, and Aggregate Functions

14.Pivoting and Grouping Sets

15.Executing Stored Procedures

16.Programming with T-SQL

Course Images

Querying Data with Microsoft SQL Server

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews