Learn SQL Basics for Data Science

Online Course. This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency.

What You Will 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.

Skills You Will Gain

About this 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, 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.

There are 4 Courses in this Specialization

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

How the Specialization Works

Take Courses

A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you’d like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.

Hands-on Project

Every Specialization includes a hands-on project. You’ll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you’ll need to finish each of the other courses before you can start it.

Earn a Certificate

When you finish every course and complete the hands-on project, you’ll earn a Certificate that you can share with prospective employers and your professional network.

Offered by

University of California, Davis
 

See more Data Analysis Courses here

See also...

Excel VBA: Hyper-disambiguated Excel VBA Programming Part 2 Online Course for Health Economists

Hyper-Disambiguated Excel VBA Programming Part 2

Online Course. Master Excel VBA event programming; move beyond simple Excel VBA macros. What you’ll ... Read more

Beginners to Expert Excel and Excel VBA 38 Hours Mega Online Course for health economists

Beginners to Expert Excel and Excel VBA – 38 Hours Mega Course

Online Course. Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with ... Read more

Python for Data Science and Machine Learning Bootcamp for health economics

Python for Data Science and Machine Learning Bootcamp

Learn how to use NumPy, Pandas, Seaborn, Matplotlib, Plotly, Scikit-Learn, Machine Learning, Tensorflow, and more! ... Read more

Excel Dashboards and Data Analysis Masterclass Online course for health economists

Excel Dashboard and Data Analysis Masterclass

Online Course. Create 6 Interactive Microsoft Excel Dashboards from Scratch (Excel Dashboard Templates Included). What ... Read more

Complete Presentation Skills Masterclass for Every Occasion for health economists

Complete Presentation Skills Masterclass

Online Course. Presentation Skills – Public Speaking – Communication Skills – Storytelling Skills for Every ... Read more

LinkedIn Blueprint: Become An Influencer an Online Course for Health Economists

LinkedIn Blueprint: Become An Influencer

Online Course. LinkedIn Hacks: My LinkedIn Path To 1000+ Connections, Top 1% Profile Views In ... Read more

Categories

Tags