Course

Structured Query Language (SQL): Level 0

The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Therefore, to be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL (pronounced ess-que-ell, or sequel). This course teaches you everything you need to know to begin working with databases today!

7 Lessons
Outcomes

By the end of the course, learners will be able to:

  • Appreciate SQL as a query language
  • Appreciate what data is, and how it is stored and retrieved in most databases
  • What is DBMS and how the data is stored in databases
  • Various components of ER diagram
  • Create a SQL query keeping in mind the order of execution and perform aggregations at any level
  • Create SQL query using case-when statements
  • Appreciate the functioning and need for joins
  • Employ window functions
 Level: 00
Duration: 05 Hours
Pre-requisites: Beginner’s Guide of Data Engineering Level 01
What’s next: SQL: Level 01