Course curriculum

  • 1

    Read Me

    • Syllabus
  • 2

    Week 1

    • What is Database, data types, SELECT, FROM, WHERE, GROUP BY, HAVING ORDER BY, LIMIT, Aggregate functions

    • Top 10 Most Used Databases By Developers In 2020 [Optional reading]

    • Database as a service (DBaaS) [Optional reading]

    • Week 1 Feedback

    • What did you learn this week?
  • 3

    Week 2

    • NULL, CTE, Subquery, Primary keys, Foreign keys, JOIN, Order of execution

    • SQL vs noSQL [Optional reading]

    • Week 2 Feedback

    • What did you learn this week?
  • 4

    Week 3

    • Problem solving framework, Different types of JOIN

    • Load data from Excel to SQL Database

    • Relationship types

    • Week 3 Feedback

    • What did you learn this week?
  • 5

    Week 4

    • Midterm exam

    • A Short Story About SQL’s Biggest Rival [Optional reading]

    • Week 4 Feedback

    • What did you learn this week?
  • 6

    Week 5

    • Window functions

    • Top 10 Databases Used In Machine Learning Projects [Optional reading]

    • Week 5 Feedback

    • What did you learn this week?
  • 7

    Week 6

    • String and Date manipulation

    • PIVOT table in SQL

    • Week 6 Feedback

    • What did you learn this week?
  • 8

    Week 7

    • Phone interview simulation

    • Solution

    • Week 7 Feedback

    • What did you learn this week?

    • Data warehouse vs Data lake vs Data mart
  • 9

    Week 8

    • Final exam

    • Week 8 Feedback

    • What did you learn this week?

Reviews