Data Science

SQL for Data Analytics

GROUP TRAINING

Overview

This course provides you with an overview of Structured Query Language (SQL) so that you can quickly begin working with and analyzing data with other data science tools. Before you can analyze data, you need to have the correct data. Many organizations store their data in structured databases and SQL is the language of choice to extract, manipulate, filter, and generally wrangle that data.

Topics covered include:

SQL syntax
Selecting data
Filtering and sorting data
Importing and exporting data from CSV and Excel
Data normalization
Differences between SQL and NoSQL databases

Who Should Take This Course

Audience

Anyone that wishes to work in data analytics.

Prerequisites

This course assumes no previous knowledge of SQL. Students should be comfortable working at the command line in Windows, Linux, or Mac.

Why You Should Take This Course

Upon completing this course, students will be able to:

Select data based on values within fields
Work with patterns to match multiple values
Join tables and queries together to answer questions
Analyze data and find basic statistics with SQL aggregate functions
Import and export data for use with analysis tools such as the Python pandas library
Create data models