,

MS 20761 – Querying Data with Transact-SQL

This property is marketed by

InnoventSys

Member Since: 3 months
94777849438
WhatsApp
https://degree.lk/wp-content/themes/propertya-child/libs/images/type.png

Offer Type

best-certificate-courses

https://degree.lk/wp-content/themes/propertya-child/libs/images/medium.png

Medium

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/method.png

Method

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/duration.png

Duration

00 NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/location.png

Location

Colombo

https://degree.lk/wp-content/themes/propertya-child/libs/images/time.png

Commencement

Soon

Description

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, DatabaseDevelopment and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

 
Participant Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
 
Course Objectives

After completing this course, students will be able 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.
 
 

Details

Last Updated On: February 9th, 2024 at 2:24 pm
Method:NG
medium:NG
commencement:Soon
duration:00 NG
Location:Colombo

Features

  • Alumni Association
  • Book Shop
  • Cafeteria
  • Clubs and Societies
  • Labs
  • Library
  • LMS
  • Medical Facilities
  • Parking
  • Recreation Area
  • Relaxation Area
  • Student Center
  • Study Area
  • Wi-Fi

Statistics

Schedule a Call

Similar Programs

AWS Certified Solutions Architect – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

AWS Certified Developer – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

CSPO – Certified Scrum Product Owner

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

CSM – Certified Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

POPM – SAFe 5.0 Product Owner / Product Manager

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

SSM – SAFe 5.0 Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

Write a Review

You should logged in first to add a review.

Compare programs
Add programs to compare.