Intermediate SQL Queries
- Teach: https://www.datacamp.com/teach/repositories/641
- Campus: https://www.datacamp.com/courses/intermediate-sql-queries
- Docs: https://authoring.datacamp.com
Description
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 syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle. You will learn everything you need to know to begin working with databases today!
Learning objectives
- 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
Prerequisites
- None