Booking options
Price on Enquiry
Price on Enquiry
Delivered Online
5 days
All levels
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
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....