Course summary

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?

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!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.