Data Query with Transact-SQL with Python

Course Cover
compare button icon

Course Features

icon

Duration

4 weeks

icon

Delivery Method

Online

icon

Available on

Lifetime Access

icon

Accessibility

Mobile, Desktop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Effort

5 hours per week

icon

Teaching Type

Self Paced

Course Description

This self-paced course is designed to help developers and data professionals improve their Transact-SQL skills, which are essential for SQL databases. The course covers various modules that focus on querying and modifying data in Microsoft SQL Server and Azure SQL Database. Participants will gain hands-on experience using Transact-SQL without the need to install or configure a database server. The course also covers key aspects of SQL, such as data types, NULL values, querying multiple tables with JOIN, using set operators, functions, and aggregate data. Participants will learn Transact-SQL programming. This course is a continuation of the ExpertTrack courses and will enhance participants' knowledge of Microsoft Azure.

Course Overview

projects-img

Alumni Network

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Developed Transact-SQL SELECT queries

Engaged with data types and NULL

Query multiple tables with JOIN

Explored set operators

Engaged in functions and aggregate data

Engaged with subqueries and APPLY

Applied table expressions

Collaborated with group sets and pivot data

Target Students

This ExpertTrack is designed for aspiring database professionals, application developers and anyone preparing for SQL Server certification exams

Course Cover