New Free Course: Intro to SQL for Data ScienceJune 21st, 2017 in
Hello there! We have a big announcement today, DataCamp is supporting a new technology: SQL! We've made this first course 100% free for everyone - register with DataCamp today and learn everything you need to begin working with databases! This course is taught by Nick Carchedi.
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!
Intro to SQL for Data Science features interactive exercises that combine high-quality video, in-browser coding, and gamification for an engaging learning experience that will teach you how to work with databases!
What you'll learn:
Chapter 1: Selecting Columns
This chapter provides a brief introduction to working with relational databases.
Chapter 2: Filtering Rows
Learn how to use basic comparison operators, combine multiple criteria, match patterns in text, and much more.
Chapter 3: Aggregate Functions
Learn how to use aggregate functions to summarize your data and gain useful insights.
Chapter 4: Sorting, Grouping, and Joins
This chapter provides a brief introduction to sorting, grouping, and joining your results