Online Course – Certified Professional Internship in Data Science from the University of California, Davis

Discover our world of expertise with tips and advice on various products and services. Find the best solutions for you and the next steps to take for a great shopping experience.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת במדעי הנתונים של אוניברסיטת קליפורניה

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Data analysis
  • SQL
  • Apache Spark
  • Delta Lake

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • SQL Developer
  • Business Intelligence Analyst
  • Data Scientist
  • Data Engineer
  • Machine Learning Engineer
  • Database Administrator
  • Research Analyst
  • Data Consultant

Internship – 3-part course series

General description

This specialization is intended for those who have no prior programming experience and are interested in developing skills in writing SQL queries.

projects

Through four progressively more difficult SQL projects with data science uses, you will learn topics such as:

  • SQL Basics
  • Data processing
  • SQL analysis
  • AB experiments
  • Distributed computing using Apache Spark
  • Delta Lake

Learning objectives

These topics will prepare you to:

  • Apply SQL creatively to analyze and explore data
  • Demonstrate ability in writing queries
  • Create datasets for analysis
  • Perform feature engineering
  • Use SQL with other data analysis and machine learning tools
  • Implement SQL with unstructured datasets

Details of the courses that make up the specialization

SQL in Data Science

  • Course 1 • 15 hours • 4.6 (16,454 ratings)

Course Details

What you’ll learn
  • Identify a required set of data from a column or set of columns and write an SQL query to limit the results to those.
  • Use SQL commands to filter, sort, and summarize data.
  • Create an analysis table from multiple queries using the UNION operator.
  • Animate strings, dates, and numeric data using functions to combine data from different sources into properly formatted fields for analysis.
Skills you will develop
  • Category: Data Science
  • Category: Data Analysis
  • Category: Sqlite
  • Category: SQL

Data processing, analysis, and A/B testing using SQL

  • Course 2 • 15 hours • 3.3 (960 ratings)

Course Details

What you’ll learn
  • Validate and clean a dataset.
  • Evaluate and create datasets to answer your questions.
  • Solve problems using SQL.
  • Build a simple testing framework to touch A/B testing.
Skills you will develop
  • Category: Query string
  • Category: Predictive Analytics
  • Category: Data Analysis
  • Category: SQL
  • Category: A/B Testing

SQL Final Project in Data Science

  • Course 3 • 35 hours • 4.2 (228 ratings)

Course Details

What you’ll learn
  • Develop a project proposal and select your data.
  • Perform descriptive statistics as part of the exploratory analysis.
  • Develop metrics and perform advanced techniques in SQL.
  • Present your findings and make recommendations.
Skills you will develop
  • Category: Data Analysis
  • Category: Creating metrics
  • Category: Presentation Skills
  • Category: SQL
  • Category: Exploratory Data Analysis

Related products