SQL for Data Science

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time.

• Identify and query subsets of data using SQL
• Use SQL commands to filter, sort, and summarize data
• Create analysis tables by combining queries with UNION
• Manipulate strings, dates, and numeric data for integrated analysis

• Basic knowledge of data science
• Understanding of relational databases