Course description
Learn SQL Basics for Data Science Specialization
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, Delta Lake 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.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
No prior experience required.
Outcome / Qualification etc.
What You Will Learn
- Use SQL commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis
- Assess and create datasets to solve your business questions and problems using SQL
- Use 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 present your findings & make recommendations
Skills You Will Gain
- Data Analysis
- Apache Spark
- Delta Lake
- SQL
- Data Science
- Sqlite
- A/B Testing
- Query String
- Predictive Analytics
- Presentation Skills
- creating metrics
- Exploratory Data Analysis
Training Course Content
- SQL for Data Science
- Data Wrangling, Analysis and AB Testing with SQL
- Distributed Computing with Spark SQL
- SQL for Data Science Capstone Project
Course delivery details
This course is offered through University of California, Davis, a partner institute of Coursera.
Suggested pace of 5 hours/week
Expenses
Please visit the Institute website for more information about tuition fees