• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Querying Data with Microsoft SQL Server

Querying Data with Microsoft SQL Server

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online

  • 5 days

  • All levels

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

About The Provider

Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK....

Read more about Nexus Human

Tags

Reviews