/Transact-SQL-Queries

In This repository you can learn basic Transact-SQL

Primary LanguageSQLPL

Transact-SQL-Queries

In This repository you can learn basic Transact-SQL

NOTE : You can find video tutorial and other related document in this GitHub Repository

Module 1: Introduction to Transact-SQL

  • Retrieving Customer Data
  • Create List of Customer Contacts
  • Create List of Customer Contacts (2)
  • Retrieving Customer and Sales Data
  • Retrieving Customer and Sales Data (2)
  • Retrieving Customer Contact Names
  • Retrieving Primary Contact Details
  • Retrieving Shipping Status

Module 2: Querying Tables with SELECT

  • Retrieving Transportation Report Data
  • Retrieving Transportation Report Data (2)
  • Retrieving Transportation Report Data (3)
  • Retrieving Product Data
  • Retrieving Product Data (2)
  • Retrieving Product Data (3)
  • Retrieving Product Data (4)

Module 3: Querying Multiple Tables with Joins

  • Generating Invoice Reports
  • Generating Invoice Reports (2)
  • Retrieving Sales Data
  • Retrieving Sales Data (2)
  • Retrieving Sales Data (3)

Module 4: Using Set Operators

  • Retrieving Customer Addresses
  • Retrieving Customer Addresses (2)
  • Retrieving Customer Addresses (3)
  • Filtering Customer Addresses (1)
  • Filtering Customer Addresses (2)

Module 5: Using Functions and Aggregating Data

  • Retrieving Product Information
  • Retrieving Product Information (2)
  • Retrieving Product Information (3)
  • Retrieving Product Information (4)
  • Ranking Customers By Revenue
  • Aggregating Product Sales
  • Aggregating Product Sales (2)
  • Aggregating Product Sales (3)

Module 6: Using Subqueries and APPLY

Retrieving Product Price Information

  • Retrieving Product Price Information (2)
  • Retrieving Product Price Information (3)
  • Retrieving Product Price Information (4)
  • Retrieving Customer Information
  • Retrieving Customer Information (2)

Module 7: Using Table Expressions

  • Retrieving Product Information
  • Retrieving Product Information (2)
  • Retrieving Product Information (3)
  • Retrieving Customer Sales Revenue

Module 8: Grouping Sets and Pivoting Data

  • Retrieving Regional Sales Totals
  • Retrieving Regional Sales Totals (2)
  • Retrieving Regional Sales Totals (3)
  • Retrieving Customer Sales By Category

Module 9: Modifying Data

  • Inserting Products (1)
  • Inserting Products (2)
  • Inserting Products (3)
  • Updating Products
  • Updating Products (2)
  • Deleting Products

Module 10: Programming with Transact-SQL

  • Writing a Script to Insert an Order Header
  • Extend Script to Insert an Order Detail
  • Updating Bike Prices

Module 11: Error Handling and Transactions

  • Logging Errors
  • Logging Errors (2)
  • Ensuring Data Consistency

Sample Database ERD

Database ERD