SQL pratice problems : 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach / Sylvia Moestl Vasilik
Book | Independently published ; | 2017.
Available at Gateway-Racine Campus General Collection (QA 76.7 V3.34 2017)

Additional actions:

see all


Location Call No. Status
Gateway-Racine Campus General Collection QA 76.7 V3.34 2017 Available
Show fewer items

More Details

142 pages : [n.I] ; 23 cm.
How to use this book -- Setup -- Introductory Problems
1. Which shippers do we have?
2. Certain fields from Categories
3. Sales Representatives
4. Sales Representatives in the United States
5. Orders placed by specific EmployeeID
6. Suppliers and ContactTitles
7. Products with "queso" in ProductName
8. Orders shipping to France and Belgium
9. Orders shipping to any country in Latin America
10. Employees, in order of age
11. Showing only the Date with DateTime field
12. Employees full name
13. OrderDetails amount per line item
14. How many customers?
15. When was the first order?
16. Countries where there are customers
17. Contact titles for customers
18. Products with associated supplier names
19. Orders and the Shipper that was used
Intermediate Problems
20. Categories, and the total products in each category
21. Total customers per country/city
22. Products that need reordering
23. Products that need reordering, continued
24. Customer list by region
25. High freight charges
26. High freight charges - 2015
27. High freight charges with between
28. High freight charges - last year
29. Employee/Order Detail report
30. Customers with no orders
31. Customers with no orders for EmployeeID 4
Advanced Problems
32. High-value customers
33. High-value customers - total orders
34. High-value customers - with discount
35. Month-end orders
36. Orders with many line items
37. Orders - random assortment
38. Orders - accidental double-entry
39. Orders - accidental double-entry details
40. Orders - accidental double-entry detail, derived tables
41. Late orders
42. Late orders - which employees?
43. Late orders vs. total orders
44. Late orders vs. total orders - missing employee
45. Late orders vs. total orders - fix null
46. Late orders vs. total orders - percentage
47. Late orders vs. total orders - fix decimal
48. Customer grouping
49. Customer grouping - fix null
50. Customer grouping with percentage
51. Customer grouping - flexible
52. Countries with suppliers or customers
53. Countries with suppliers or customers, version 2
54. Countries with suppliers or customers - version 3
55. First order in each country
56. Customers with multiple orders in 5 day period
57. Customers with multiple orders in 5 day period, version 2
It's easy to find basic SQL syntax and keyword information online. What's hard to find is challenging, well-designed, real-world problems--the type of problems that come up all the time when you're dealing with data. Learning how to solve these problems will give you the skill and confidence to step up in your career. With SQL Practice Problems, you can get that level of experience by solving sets of targeted problems. These aren't just problems designed to give an example of specific syntax. These are the most common problems you encounter when you deal with data.
17.00 DPWEB (31-152-4)
Browse Results
Other Sources:
View in classic catalog View MARC display
Recently Added:
Loading Suggestions...
Back to top