Report Formatting - Understanding Format Exercise & Solution 6
Course Content
0 / 151 completedSelect - All columns
Select - Few Columns
Demo Lecture - 2
Course Content Walkthrough
Demo Lecture - 1
Resource - Creating Databases and Inserting Data
Select - Old Price and New Price
Select - Distinct
Select - Report with Comment
Alias - SQL Alias
Reporting with Concatenation - Title and First Name
Reporting with Concatenation - Customer and Location
Reporting with Concatenation - Customer and Location II
Reporting with Concatenation - Total Value of Products In Stock
Report Formatting - Introduction
Report Formatting - Understanding Format Exercise & Solution 1
Report Formatting - Understanding Format Exercise & Solution 2
Report Formatting - Understanding Format Exercise & Solution 3
Report Formatting - Understanding Format Exercise & Solution 4
Report Formatting - Understanding Format Exercise & Solution 5
Report Formatting - Understanding Format Exercise & Solution 6
Round - Amount Formatting Exercise & Solution 1
Round - Amount Formatting Exercise & Solution 2
Round - Amount Formatting Exercise & Solution 3
Order By - Ascending Exercise & Solution 1
Round - Amount Formatting Exercise & Solution 4
Order By - Ascending and Ascending Exercise & Solution 3
Order By - Ascending and Descending Exercise & Solution 2
Where - Sales Managers' Details
Where - Owners' Details
Where - Searching for a Product with Price
Where - Specific Order ID
Where - Searching for a Product with Price II
Where - Searching for a Customer with ID
Where - Products less than 10
Where - Products above 32.8
Where - Products whose price are 40 and above
Where - Products within a range
Where - Order amount of 10540 or above
Where - Products - Restocking
Where - None Sales Representative
Where - None Mr
Where - Price Between two figures
Where - Not Between
Where - Customers from certain cities
Where - Two Between
Where - Names of certain products with given prices
Where - Every other customers except
Where - Sales Manager & Vice President Details
Where - Customers From France
Where - Searching for a product given certain details
Where - Searching for employee given certain details
Where - Not Null Region
Where - Null Region
Wildcard - Contains Sales
Wildcard - Phone number starts with 171
Wildcard - Contact ends with...
Wildcard - Searching with letter
Wildcard - Searching for a company
Wildcard - Searching for a city with starting and end letters
Wildcard - Searching for a city
Wildcard - NOT
Aggregate - Introduction
Aggregate - Min()
Aggregate - Min() - First Shipment
Aggregate - Count()
Aggregate - Max()
Aggregate - Count() - Number of Orders
Aggregate - Avg()
Aggregate - Avg() - Purchase
Aggregate - SUM() - Total Sales
Aggregate - Sum()
Aggregate - Sum() - Total number of stock
Aggregate - ARRAY AGG() - Customer Names
Aggregate - STRING AGG() - List of Customers
Aggregate - ARRAY AGG()
Understanding Limit, Fetch and Offset
Limit - First Row
Limit - First Three Rows
Offset & Limit - Third to Fifth Rows
Offset & Limit - The Most Expensive Product
Offset & Limit - Productivity
Basics - Type of Join
Basics - Introduction to Join - Purpose of Join
Basics - Cross Join
Basics - Inner Join
Basics - Left Join
Basics - Right Join
Basics - Full Outer Join
Basics - Self Join
Basics - Natural Join
Intermediate - How to choose the right column for the JOIN - Exercise
Intermediate - Understanding USING
Intermediate - Understanding Alias in JOIN
Intermediate - ON and WHERE
Intermediate - Joining Many Tables
Intermediate - How to choose the right column for the JOIN
Group By With Single Table - A requirement for further lesson
Group By With Two Tables - A requirement for further lesson
Pro - Two Tables - The Second to The Cheapest Product
Pro - Two Tables - Better Report
Intermediate - Hits on Joining Many Tables
Pro - Two Tables - Number of Orders Per Employee
Pro - Two Tables - Number of Shipment 1998
Pro - Two Tables - Number of Shipment Per Each Shipping Company
Pro - Two Tables - Shipment to Countries
Pro - Two Tables - Territories to Employees
Pro - Categories per Products per Supplier
Pro - Two Tables - Territories Per Region
Pro - Territory per Employee
Pro - Most Purchased Product
Pro - Revenue from each Customer
Pro - Revenue from each Customer in 1996
Pro - Revenue from each Customer June 199
Pro - List of Products Purchased by a Specific Customer in a year- Four Tables
Pro - List of Products Purchased by a Specific Customer - Four Tables
Pro - List of Products Purchased by Each Customer - Four Tables
Pro - Searching for a customer with given details - Four tables
Pro - Reports on Delayed orders
Pro - Report Involving Five Tables
Understanding the Movie Rental Schema
Pro - Reports on Delayed orders with CASE
Pro - Actors and Movies
Pro - 15 Tables Joins
Pro - Actors and Movies listed
Pro - List of Actors in Each Movie
Pro - Number of Actors Per Movie
Pro - Actor with the highest number of appearance in movies - Code
Pro - List of Actors in Each Movie & Category
Pro - First 10 lowest appearance
Pro - History of Rental
Pro - Number of Movies Each Actor Acted In
Pro - Revenues
Exercise 1 - employee performance report
Exercise 2 - employee performance report II
Exercise 3 - Customers per employee report
Exercise 4 - Suppliers and shipper per employee report
Exercise 5 - Employees' regions report
Exercise 6 - Employees' regions report II
Exercise 7 - Employee - Region - Customers report
Exercise 8 - Orders report
Exercise 10 - Orders with the products suppliers II
Exercise 9 - Orders with the products suppliers
Understanding Intersect
What is Union
Union - Exercise 2
Union - Exercise 4
Union - Exercise 3
Understanding Except
Union - Exercise 1
Except - Exercise