Microsoft-DAT201x-SQL-Server: Querying Data with Transact-SQL

Some basic SQL code I developed in 2018-2019 while pursuing the Microsoft's DAT207x: Analyzing and Visualizing Data with Power BI certificate.

Name		Name	Last commit message	Last commit date
Latest commit History 16 Commits
Final Assessment		Final Assessment
Module 1 Introduction to Transact-SQL		Module 1 Introduction to Transact-SQL
Module 10 Programming with Transact-SQL		Module 10 Programming with Transact-SQL
Module 11 Error Handling and Transactions		Module 11 Error Handling and Transactions
Module 2 Querying Tables with SELECT		Module 2 Querying Tables with SELECT
Module 3 Querying Multiple Tables with Joins		Module 3 Querying Multiple Tables with Joins
Module 4 Using Set Operators		Module 4 Using Set Operators
Module 5 Using Functions and Aggregating Data		Module 5 Using Functions and Aggregating Data
Module 6 Using Subqueries and APPLY		Module 6 Using Subqueries and APPLY
Module 7 Using Table Expressions		Module 7 Using Table Expressions
Module 8 Grouping Sets and Pivoting Data		Module 8 Grouping Sets and Pivoting Data
Module 9 Modifying Data		Module 9 Modifying Data
AdventureWorksLT_ER.pdf		AdventureWorksLT_ER.pdf
DataCamp-SQL.pdf		DataCamp-SQL.pdf
Getting Started with DAT201x.pdf		Getting Started with DAT201x.pdf
LICENSE		LICENSE
README.md		README.md
Syllabus.pdf		Syllabus.pdf

Provide feedback