UC Davis
В любой момент
4 месяца
Стоимость курса
39 USD/мес.
Подробности и регистрация

Specialization Learn SQL basics for Data science

Навыки, которые вы получите:
SQL Apache Spark A/B testing Query string Presentation skills Exploratory data analysis

This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency. Through four progressively more difficult SQL projects with data science applications, you will cover topics such as SQL basics, data wrangling, SQL analysis, AB testing, distributed computing using Apache Spark, and more. These topics will prepare you to apply SQL creatively to analyze and explore data; demonstrate efficiency in writing queries; create data analysis datasets; conduct feature engineering, use SQL with other data analysis and machine learning toolsets; and use SQL with unstructured data sets. 

The Program

  1. SQL for Data Science.
  2. Data Wrangling, Analysis and AB Testing with SQL.
  3. Distributed Computing with Spark SQL.
  4. SQL for Data Science Capstone Project.

What will you learn

  • U​se SQL commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis.

  • A​ssess and create datasets to solve your business questions and problems using SQL.

  • U​se the collaborative Databricks workspace and create an end-to-end pipeline that reads data, transforms it, and saves the result.

  • ​Develop a project proposal & select your data, perform statistical analysis & develop metrics, and p​resent your findings & make recommendations.

Нам нужен ваш фидбек!
Честный и беспристрастный