Real SQL queries, 50 challenges : practice for reporting and analysis / Brian Cohen, Neil Pepi, Neerja Mishra
Book | [CreateSpace Independent Publishing Platform] | 2015
Available at Gateway-Racine Campus General Collection (QA 76.77 C6.78 2015)

Additional actions:

close
see all

Items

Location Call No. Status
Gateway-Racine Campus General Collection QA 76.77 C6.78 2015 Available
Show fewer items

More Details

Description
x, 99 pages ; 26 cm
Note
"USE [ADVENTUREWORKS2012]"--Cover.
Contents
Introduction
The Challenges
The Solutions
What's Needed
Organization
Pt.1: Exploring a New Database
Pt.2: Challenge Questions
Challenge Question 1: Year over Year Comparisons
Challenge Question 2: The 2/22 Promotion
Challenge Question 3: Ten Million Dollar Benchmark
Challenge Question 4: Upsell Tuesdays
Challenge Question 5: Expired Credit Cards
Challenge Question 6: Print Catalog
Challenge Question 7: Special Offers
Challenge Question 8: Similar Products
Challenge Question 9: Product Combinations
Challenge Question 10: Median Revenue
Challenge Question 11: Needy Accountant
Challenge Question 12: Product Inventory Updates
Challenge Question 13: Vacation Hours
Challenge Question 14: Purchasing
Challenge Question 15: Interpretation Needed
Challenge Question 16: Online/Offline
Challenge Question 17: Long Time No Sale
Challenge Question 18: Costs Vary
Challenge Question 19: Thermoform Temperature
Challenge Question 20: Toronto
Challenge Question 21: Marketing Employees
Challenge Question 22: Who Left That Review?
Challenge Question 23: Label Mix-Up
Challenge Question 24: Clearance Sale
Challenge Question 25: Top Territories
Challenge Question 26: Commission Percentages
Challenge Question 27: Work Orders
Challenge Question 28: Revenue Trended
Challenge Question 29: Separation
Challenge Question 30: Shift Coverage
Challenge Question 31: Labels
Challenge Question 32: Employment Survey
Challenge Question 33: Age Groups
Challenge Question 34: Revenue by State
Challenge Question 35: Two Free Bikes
Challenge Question 36: Volume Discounts
Challenge Question 37: Overpaying
Challenge Question 38: Margins
Challenge Question 39: Percent to Quota
Challenge Question 40: Revenue Ranges
Challenge Question 41: E-mail Mystery
Challenge Question 42: The Mentors
Challenge Question 43: Calendar of Work Days
Challenge Question 44: Annual Salary by Employee
Challenge Question 45: Annual Salaries by Department
Challenge Question 46: Holiday Bonus
Challenge Question 47: Company Picnic
Challenge Question 48: Sales Quota Changes
Challenge Question 49: Scrap Rate
Challenge Question 50: Reasons
Challenge Question 51: Excess Inventory
Challenge Question 52: Pay Rate Changes
Challenge Question 53: Sales Order Counts
Challenge Question 54: Loyal Customers
Challenge Question 55: Date Range Gaps
Pt.3: Hints for Challenge Questions
Hints for Challenge Question 1: Year over Year Comparisons
Hints for Challenge Question 2: The 2/22 Promotion
Hints for Challenge Question 3: Ten Million Dollar Benchmark
Hints for Challenge Question 4: Upsell Tuesday
Hints for Challenge Question 5: Expired Credit Cards
Hints for Challenge Question 6: Print Catalog
Hints for Challenge Question 7: Special Offers
Hints for Challenge Question 8: Similar Products
Hints for Challenge Question 9: Product Combinations
Hints for Challenge Question 10: Median Revenue
Hints for Challenge Question 11: Needy Accountant
Hints for Challenge Question 12: Product Inventory Updates
Hints for Challenge Question 13: Vacation Hours
Hints for Challenge Question 14: Purchasing
Hints for Challenge Question 15: Interpretation Needed
Hints for Challenge Question 16: Online/Offline
Hints for Challenge Question 17: Long Time No Sale
Hints for Challenge Question 18: Costs Vary
Hints for Challenge Question 19: Thermoform Temperature
Hints for Challenge Question 20: Toronto
Hints for Challenge Question 21: Marketing Employees
Hints for Challenge Question 22: Who Left That Review?
Hints for Challenge Question 23: Label Mix-Up
Hints for Challenge Question 24: Clearance Sale
Hints for Challenge Question 25: Top Territories
Hints for Challenge Question 26: Commission Percentages
Hints for Challenge Question 27: Work Orders
Hints for Challenge Question 28: Revenue Trended
Hints for Challenge Question 29: Separation
Hints for Challenge Question 30: Shift Coverage
Hints for Challenge Question 31: Labels
Hints for Challenge Question 32: Employment Survey
Hints for Challenge Question 33: Age Groups
Hints for Challenge Question 34: Revenue by State
Hints for Challenge Question 35: Two Free Bikes
Hints for Challenge Question 36: Volume Discounts
Hints for Challenge Question 37: Overpaying
Hints for Challenge Question 38: Margins
Hints for Challenge Question 39: Percent to Quota
Hints for Challenge Question 40: Revenue Ranges
Hints for Challenge Question 41: E-mail Mystery
Hints for Challenge Question 42: The Mentors
Hints for Challenge Question 43: Calendar of Work Days
Hints for Challenge Question 44: Annual Salary by Employee
Hints for Challenge Question 45: Annual Salaries by Department
Hints for Challenge Question 46: Holiday Bonus
Hints for Challenge Question 47: Company Picnic
Hints for Challenge Question 48: Sales Quota Changes
Hints for Challenge Question 49: Scrap Rate
Hints for Challenge Question 50: Reasons
Hints for Challenge Question 51: Excess Inventory
Hints for Challenge Question 52: Pay Rate Changes
Hints for Challenge Question 53: Sales Order Counts
Hints for Challenge Question 54: Loyal Customers
Hints for Challenge Question 55: Date Range Gaps
Pt.4: Solutions to Challenge Questions
Solution 1 to Challenge Question 1: Year over Year Comparisons
Solution 2 to Challenge Question 1: Year over Year Comparisons
Solution to Challenge Question 2: The 2/22 Promotion
Solution 1 to Challenge Question 3: Ten Million Dollar Benchmark
Solution 2 to Challenge Question 3: Ten Million Dollar Benchmark
Solution to Challenge Question 4: Upsell Tuesdays
Solution to Challenge Question 5: Expired Credit Cards
Solution to Challenge Question 6: Print Catalog
Solution 1 to Challenge Question 7: Special Offers
Solution 2 to Challenge Question 7: Special Offers
Solution 3 to Challenge Question 7: Special Offers
Solution to Challenge Question 8: Similar Products
Solution to Challenge Question 9: Product Combinations
Solution 1 to Challenge Question 10: Median Revenue
Solution 2 to Challenge Question 10: Median Revenue
Solution to Challenge Question 11: Needy Accountant
Solution to Challenge Question 12: Product Inventory Updates
Solution to Challenge Question 13: Vacation Hours
Solution to Challenge Question 14: Purchasing
Solution to Challenge Question 15: Interpretation Needed
Solution to Challenge Question 16: Online/Offline
Solution to Challenge Question 17: Long Time No Sale
Solution to Challenge Question 18: Costs Vary
Solution to Challenge Question 19: Thermoform Temperature
Solution to Challenge Question 20: Toronto
Solution to Challenge Question 21: Marketing Employees
Solution to Challenge Question 22: Who Left That Review?
Solution to Challenge Question 23: Label Mix-Up
Solution to Challenge Question 24: Clearance Sale
Solution to Challenge Question 25: Top Territories
Solution to Challenge Question 26: Commission Percentages
Solution to Challenge Question 27: Work Orders
Solution to Challenge Question 28: Revenue Trended
Solution to Challenge Question 29: Separation
Solution to Challenge Question 30: Shift Coverage
Solution to Challenge Question 31: Labels
Solution to Challenge Question 32: Employment Survey
Solution to Challenge Question 33: Age Groups
Solution to Challenge Question 34: Revenue by State
Solution to Challenge Question 35: Two Free Bikes
Solution to Challenge Question 36: Volume Discounts
Solution to Challenge Question 37: Overpaying
Solution to Challenge Question 38: Margins
Solution to Challenge Question 39: Percent to Quota
Solution to Challenge Question 40: Revenue Ranges
Solution to Challenge Question 41: E-mail Mystery
Solution to Challenge Question 42: The Mentors
Solution to Challenge Question 43: Calendar of Work Days
Solution to Challenge Question 44: Annual Salaries by Employee
Solution to Challenge Question 45: Annual Salaries by Department
Solution 1 to Challenge Question 46: Holiday Bonus
Solution 2 to Challenge Question 46: Holiday Bonus
Solution 3 to Challenge Question 46: Holiday Bonus
Solution to Challenge Question 47: Company Picnic
Solution to Challenge Question 48: Sales Quota Changes
Solution to Challenge Question 49: Scrap Rate
Solution to Challenge Question 50: Reasons
Solution to Challenge Question 51: Excess Inventory
Solution 1 to Challenge Question 52: Pay Rate Changes
Solution 2 to Challenge Question 52: Pay Rate Changes
Solution 1 to Challenge Question 53: Sales Order Counts
Solution 2 to Challenge Question 53: Sales Order Counts
Solution to Challenge Question 54: Loyal Customers
Solution to Challenge Question 55: Date Range Gaps
Summary
Queries improve when challenges are authentic. This book sets your learning on the fast track with realistic problems to solve. Topics span sales, marketing, human resources, purchasing, and production. Real SQL Queries: 50 Challenges is perfect for analysts, report writers, or anyone searching for a hands-on approach to learning SQL Server.
15.00 DPWEB (31-152-4)
Subject
Added Author
Pepi, Neil, author.
Mishra, Neerja, author.
Microsoft Corporation.
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top