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!
- Learn the basic language and structure of relational databases
- Select columns of interest from database tables
- Filter for records matching specific criteria
- Compute helpful quantities like counts and averages, both overall and within groups
- Arrange data based on the values of certain columns
- None