Skip to content

Repo containing files from MOOC, Query with Transact-SQL, offered by Microsoft via edX

License

Notifications You must be signed in to change notification settings

Rajata25072/MOOC_Query-with-Transact-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

[Querying with Transact-SQL]


This repository contains the lab, handouts and exercise files from Microsoft MOOC course, Querying with Transact-SQL, which I have workerd through in edX.

The course comprises of 11 labs which are

  • Lab01_Introduction to Transact-SQL
  • Lab02_Querying Tables with SELECT
  • Lab03_Querying Multiple Tables with JOIN
  • Lab04_Using Set Operators
  • Lab05_Using Functions and Aggregating Data
  • Lab06_Using Subqueries and APPLY
  • Lab07_Using Table Expressions
  • Lab08_Grouping Sets and Pivoting Data
  • Lab09_Modifying Data
  • Lab10_Programming with Transact-SQL
  • Lab11_Error Handling and Transactions

In each lab directory, there are 4 types of file:

  • HO: HO = Handout files (both .pptx and .pdf)
  • Demo: Demo = Demonstration files, demonstrating the code examples
  • Lab: Lab = Lab exercise files (instruction and exercise)
  • Sol: Solution = Solution for lab exercise files

About

Repo containing files from MOOC, Query with Transact-SQL, offered by Microsoft via edX

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published