Skip to content

fissehab/T_SQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
0 - Setup.sql
0 - Setup.sql
 
 
01 - Insert Products.sql
01 - Insert Products.sql
 
 
01 - Insert Sales Order Script.sql
01 - Insert Sales Order Script.sql
 
 
01- Regional Sales Totals.sql
01- Regional Sales Totals.sql
 
 
01-Functions.sql
01-Functions.sql
 
 
01-Grouping Sets.sql
01-Grouping Sets.sql
 
 
01-Inner Joins.sql
01-Inner Joins.sql
 
 
01-Inserting Data.sql
01-Inserting Data.sql
 
 
01-Invoice Reports.sql
01-Invoice Reports.sql
 
 
01-Logging Errors.sql
01-Logging Errors.sql
 
 
01-Raising Errors.sql
01-Raising Errors.sql
 
 
01-Views.sql
01-Views.sql
 
 
02 - Update Bike Prices.sql
02 - Update Bike Prices.sql
 
 
02 - Update Products.sql
02 - Update Products.sql
 
 
02- Customer Sales by Category.sql
02- Customer Sales by Category.sql
 
 
02-Ensuring Data Consistency.sql
02-Ensuring Data Consistency.sql
 
 
02-Group By.sql
02-Group By.sql
 
 
02-Handling Errors.sql
02-Handling Errors.sql
 
 
02-Outer Joins.sql
02-Outer Joins.sql
 
 
02-Pivot.sql
02-Pivot.sql
 
 
02-Sales Reports.sql
02-Sales Reports.sql
 
 
02-Temp Tables and Variables.sql
02-Temp Tables and Variables.sql
 
 
02-Updating and Deleting.sql
02-Updating and Deleting.sql
 
 
03 - Delete Products.sql
03 - Delete Products.sql
 
 
03-Cross Join.sql
03-Cross Join.sql
 
 
03-Having.sql
03-Having.sql
 
 
03-TVFs.sql
03-TVFs.sql
 
 
03-Transactions.sql
03-Transactions.sql
 
 
04-Derived Tables.sql
04-Derived Tables.sql
 
 
04-Self Join.sql
04-Self Join.sql
 
 
05- CTEs.sql
05- CTEs.sql
 
 
1 - Customer Addresses.sql
1 - Customer Addresses.sql
 
 
1 - Eliminating Duplicates and Sorting Results.sql
1 - Eliminating Duplicates and Sorting Results.sql
 
 
1 - Product Data.sql
1 - Product Data.sql
 
 
1 - Product Price Data.sql
1 - Product Price Data.sql
 
 
1 - Scalar Subquery.sql
1 - Scalar Subquery.sql
 
 
1 - Union.sql
1 - Union.sql
 
 
1 - Variables.sql
1 - Variables.sql
 
 
1-Select.sql
1-Select.sql
 
 
2 - Customer Information.sql
2 - Customer Information.sql
 
 
2 - Customer Sales.sql
2 - Customer Sales.sql
 
 
2 - Filtering Customer Addresses.sql
2 - Filtering Customer Addresses.sql
 
 
2 - Filtering with Predicates.sql
2 - Filtering with Predicates.sql
 
 
2 - If Else.sql
2 - If Else.sql
 
 
2 - Intersect.sql
2 - Intersect.sql
 
 
2 - Multi-Valued Subquery.sql
2 - Multi-Valued Subquery.sql
 
 
2 - Ranked Customers.sql
2 - Ranked Customers.sql
 
 
2-Converting Data Types.sql
2-Converting Data Types.sql
 
 
3 - Correlated Subquery.sql
3 - Correlated Subquery.sql
 
 
3 - Except.sql
3 - Except.sql
 
 
3 - Product Sales.sql
3 - Product Sales.sql
 
 
3 - While.sql
3 - While.sql
 
 
3-NULLs and Expressions.sql
3-NULLs and Expressions.sql
 
 
4 - CROSS APPLY.sql
4 - CROSS APPLY.sql
 
 
4-Stored Procedure.sql
4-Stored Procedure.sql
 
 
Customer Contact Details.sql
Customer Contact Details.sql
 
 
Customer Data.sql
Customer Data.sql
 
 
Customer and Sales Data.sql
Customer and Sales Data.sql
 
 
DAT201x Querying with Transact-SQL-final exam and quizes.txt
DAT201x Querying with Transact-SQL-final exam and quizes.txt
 
 
Lab01.docx
Lab01.docx
 
 
Lab02.docx
Lab02.docx
 
 
Lab03.docx
Lab03.docx
 
 
Lab04.docx
Lab04.docx
 
 
Lab05.docx
Lab05.docx
 
 
Lab06.docx
Lab06.docx
 
 
Lab07.docx
Lab07.docx
 
 
Lab08.docx
Lab08.docx
 
 
Lab09.docx
Lab09.docx
 
 
Lab10.docx
Lab10.docx
 
 
Lab11.docx
Lab11.docx
 
 
Product Data.sql
Product Data.sql
 
 
README.md
README.md
 
 
Transportation Reports.sql
Transportation Reports.sql
 
 

Repository files navigation

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

About

Microsoft: DAT201x Querying with Transact-SQL from edx

Resources

Readme
Activity

Stars

31 stars

Watchers

5 watching

Forks

30 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages