1. Course summary
Great work! You have officially reached the end of this reporting in SQL class. We went over quite a bit, so lets summarize what you learned.
2. Course summary
In chapter 1,
3. Course summary
you learned how to gain a solid understanding of our dataset
4. Course summary
by using E:R diagrams
5. Course summary
and efficient data exploration techniques.
6. Course summary
In chapter 2, you learned how to take a logical, step-by-step approach to building large queries
7. Course summary
by planning the query,
8. Course summary
identifying and combining tables,
9. Course summary
and creating custom fields.
10. Course summary
In chapter 3, you learned how to clean messy data by
11. Course summary
fixing inconsistent data types with the CAST function,
12. Course summary
parsing strings with string functions,
13. Course summary
handling nulls with COALESCE,
14. Course summary
and dealing with duplication.
15. Course summary
In chapter 4, you learned how to build more complex calculations through the use of
16. Course summary
window functions
17. Course summary
and layered calculations.
18. Now what?
Now that you have this foundation for building SQL reports, you can use this in conjunction with your tool of choice. SQL works very well as a compliment to
19. Now what?
R,
20. Now what?
Python,
21. Now what?
Tableau,
22. Now what?
and Excel, to name a few.
23. Thank you!
I truly appreciate you taking this class, and I hope you enjoyed this class as much as I enjoyed teaching it. Now go out there and create some fancy reports. Happy querying!