COURSE AUTHOR –
Temotec Learning Academy
1. Using Real World PostgreSQL Database Airlines Database.
2. Use Python Pandas to Analyze and visualize Postgres Data Output.
3. SQL Test Your Self, SQL Challenges, SQL Final Exam and more
4. Use Python to visualize Postgres Data Output and get your Conclusion about Data.
5. Use SQL to create databases.
6. Use Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.
7. Use SQL to insert data into a table.
8. Use SQL to Query & retrieve data from databases.
9. Use SQL to Sort records after retrieving from databases.
10. Use SQL to Group data by specific conditions.
11. Use SQL to Filter data by using where clause.
12. How & when to use Joins types in SQL.
13. How to create and deal with Sub-queries in SQL.
14. How to create and deal with common table expression in SQL.
15. Use SQL to perform data analysis of real world databases
16. Use SQL to perform advanced techniques to retrieve data from databases.
17. Use Python with SQL Postgres database.
18. Use Python to load Postgres Data Output file.
19. Apply what you will learn in Python & SQL through exercises.