Skip to content
Microsoft: DAT201x Querying with Transact-SQL from edx
Branch: master
Clone or download
Fisseha Berhane
Fisseha Berhane Update README.md
Latest commit 7990827 May 19, 2015
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
0 - Setup.sql
01 - Insert Products.sql
01 - Insert Sales Order Script.sql labs quizes final exam May 6, 2015
01- Regional Sales Totals.sql
01-Functions.sql labs 4 annd examples Apr 26, 2015
01-Grouping Sets.sql labs quizes final exam May 6, 2015
01-Inner Joins.sql exercises and examples Apr 26, 2015
01-Inserting Data.sql
01-Invoice Reports.sql
01-Logging Errors.sql
01-Raising Errors.sql
01-Views.sql
02 - Update Bike Prices.sql labs quizes final exam May 6, 2015
02 - Update Products.sql
02- Customer Sales by Category.sql labs Apr 28, 2015
02-Ensuring Data Consistency.sql
02-Group By.sql exercises and examples Apr 26, 2015
02-Handling Errors.sql
02-Outer Joins.sql
02-Pivot.sql labs Apr 28, 2015
02-Sales Reports.sql
02-Temp Tables and Variables.sql
02-Updating and Deleting.sql
03 - Delete Products.sql labs quizes final exam May 6, 2015
03-Cross Join.sql exercises and examples Apr 26, 2015
03-Having.sql
03-TVFs.sql
03-Transactions.sql
04-Derived Tables.sql labs Apr 28, 2015
04-Self Join.sql exercises and examples Apr 26, 2015
05- CTEs.sql labs Apr 28, 2015
1 - Customer Addresses.sql excercises and labs Apr 26, 2015
1 - Eliminating Duplicates and Sorting Results.sql exercises and examples Apr 26, 2015
1 - Product Data.sql
1 - Product Price Data.sql labs Apr 28, 2015
1 - Scalar Subquery.sql
1 - Union.sql exercises and examples Apr 26, 2015
1 - Variables.sql
1-Select.sql
2 - Customer Information.sql labs Apr 28, 2015
2 - Customer Sales.sql labs Apr 28, 2015
2 - Filtering Customer Addresses.sql
2 - Filtering with Predicates.sql exercises and examples Apr 26, 2015
2 - If Else.sql labs quizes final exam May 6, 2015
2 - Intersect.sql exercises and examples Apr 26, 2015
2 - Multi-Valued Subquery.sql
2 - Ranked Customers.sql labs 4 annd examples Apr 26, 2015
2-Converting Data Types.sql exercises and examples Apr 26, 2015
3 - Correlated Subquery.sql labs Apr 28, 2015
3 - Except.sql exercises and examples Apr 26, 2015
3 - Product Sales.sql
3 - While.sql labs quizes final exam May 6, 2015
3-NULLs and Expressions.sql exercises and examples Apr 26, 2015
4 - CROSS APPLY.sql
4-Stored Procedure.sql
Customer Contact Details.sql labs one and two Apr 26, 2015
Customer Data.sql labs one and two Apr 26, 2015
Customer and Sales Data.sql
DAT201x Querying with Transact-SQL-final exam and quizes.txt labs quizes final exam May 6, 2015
Lab01.docx labs quizes final exam May 6, 2015
Lab02.docx
Lab03.docx
Lab04.docx
Lab05.docx
Lab06.docx
Lab07.docx labs quizes final exam May 6, 2015
Lab08.docx labs quizes final exam May 6, 2015
Lab09.docx
Lab10.docx
Lab11.docx
Product Data.sql
README.md
Transportation Reports.sql labs one and two Apr 26, 2015

README.md

T_SQL

Microsoft: DAT201x Querying with Transact-SQL from edx

ID Verified certificate available at: https://s3.amazonaws.com/verify.edx.org/downloads/cb977a59e4b544bd954bf7313c76e934/Certificate.pdf

Course Outline

Introduction to Transact-SQL

Querying Tables with SELECT

Querying Multiple Tables with Joins

Using Set Operators

Using Functions and Aggregating Data

Using Subqueries and APPLY

Using Table Expressions

Grouping Sets and Pivoting Data

Modifying Data

Programming with Transact-SQL

Error Handling and Transactions

You can’t perform that action at this time.