Querying Data with Transact-SQL, Certificate

  • Application Deadline
  • 42 days
    Duration
  • English
    Language
EdX is an online learning platform trusted by over 12 million users offering Querying Data with Transact-SQL course in collaboration with MicrosoftX. From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.

About

The Querying Data with Transact-SQL course is part of the Microsoft Professional Program Certificate in Data Science and the Microsoft Professional Program Certificate in Big Data from MicrosoftX.

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

Detailed Programme Facts

  • Deadline and start date Application deadline and start date were not specified by the programme.
  • Programme intensity Part-time
    • Average part-time duration 42 days
    • Intensity 4 hrs/week
    • Duration description

      6 weeks 4 to 5 hours per week

  • Languages
    • English
  • Delivery mode
    Online
    • Time flexibility
      Self-paced
  • More information Go to the programme website

Programme Structure

What you'll learn:
  • 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

Lecturers

  • Geoff Allix - Microsoft Certified IT Professional for SQL Server

  • Graeme Malcolm - Senior Content Developer

English Language Requirements

This programme requires students to demonstrate proficiency in English.

Schedule IELTS

Academic Requirements

Prerequisites:

Basic understanding of databases and IT systems.

Tuition Fee

  • International Applies to you

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 42 days.
  • National Applies to you

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 42 days.
We've labeled the tuition fee that applies to you because we think you are from and prefer over other currencies.
  • 5% discount coupon: Z7LZNQ4TN3B2JTWU valid for any free course + certificate upgrade

Funding

Check the programme website for information about funding options.

StudyPortals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

The Global Study Awards: get funded with up to £10,000 to study abroad

Together with the ISIC Association and British Council IELTS, StudyPortals offers you the chance to receive up to £10000 to expand your horizon and study abroad. We want to ultimately encourage you to study abroad in order to experience and explore new countries, cultures and languages.