In This repository you can learn basic Transact-SQL
NOTE : You can find video tutorial and other related document in this GitHub Repository
- 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
- 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)
- Generating Invoice Reports
- Generating Invoice Reports (2)
- Retrieving Sales Data
- Retrieving Sales Data (2)
- Retrieving Sales Data (3)
- Retrieving Customer Addresses
- Retrieving Customer Addresses (2)
- Retrieving Customer Addresses (3)
- Filtering Customer Addresses (1)
- Filtering Customer Addresses (2)
- 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)
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)
- Retrieving Product Information
- Retrieving Product Information (2)
- Retrieving Product Information (3)
- Retrieving Customer Sales Revenue
- Retrieving Regional Sales Totals
- Retrieving Regional Sales Totals (2)
- Retrieving Regional Sales Totals (3)
- Retrieving Customer Sales By Category
- Inserting Products (1)
- Inserting Products (2)
- Inserting Products (3)
- Updating Products
- Updating Products (2)
- Deleting Products
- Writing a Script to Insert an Order Header
- Extend Script to Insert an Order Detail
- Updating Bike Prices
- Logging Errors
- Logging Errors (2)
- Ensuring Data Consistency