New

Querying with Transact-SQL

Explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database
    • Learning Style
      Self-Paced Learning
    • Difficulty
      Intermediate
    • Course Duration
      30 Hours
Explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database
Start FREE Subscription Trial
Get started with our Learn Subscription Plan that includes this course, PLUS:

  • 500+ high impact technical, end user and learning & business management courses
  • 100% online self-paced courses
  • Course completion certificates
  • Live tech support and you will be assigned your personal Learning Concierge
  • 7-Day FREE Trial
    Then Billed
    $14.99
    Every Month Until Canceled
  • Start FREE Trial
Purchase As Individual Course
  • Self-Paced Online Content
  • Attend Course Any Day or Any Time
  • Reports & Statistics
  • Certificate Upon Completion
  • $0.00
    Self-Paced Learning
  • Enroll Now
Purchase For Teams
Team Pricing Available - Request A Quote Today!

  • Group Discounts & Private Training Available
  • Free Learning Management Center
  • Group Reporting & Tracking
  • Author / Publish Your Own Courses
  • Request Team Enrollment

About This Course:

This course is part of the Microsoft Professional Program Certificate in Data Science and the Microsoft Professional Program Certificate in Big Data.

Transact-SQL is an essential skill for data professionals and developers working with SQL databases. With this combination of expert instruction, demonstrations, and practical labs, step from your first SELECT statement through to implementing transactional programmatic logic.

Work through multiple modules, each of which explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database. The labs in this course use a sample database that can be deployed easily in Azure SQL Database, so you get hands-on experience with Transact-SQL without installing or configuring a database server.

Course Objective:

  • Create Transact-SQL SELECT queries
  • Work with data types and NULL
  • Query multiple tables with JOIN
  • Explore set operators
  • Use functions and aggregate data
  • Work with subqueries and APPLY
  • Use table expressions
  • Group sets and pivot data
  • Modify data
  • Program with Transact-SQL
  • Implement error handling and transactions

Audience:

  • Programmer

Prerequisite:

  • Basic understanding of databases and IT systems.
More Information
Lab AccessNo
TechnologyMicrosoft
Learning StyleSelf-Paced Learning
DifficultyIntermediate
Course Duration30 Hours
LanguageEnglish
Write Your Own Review
You're reviewing:Querying with Transact-SQL
Your Rating