SQL Basics for Data Science Specialization

Colleagues, in the “SQL Basics for Data Science Specialization” training you will 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, and develop a project proposal & select your data, perform statistical analysis & develop metrics, and present your findings and make recommendations. Build high-demand skills involving Data Analysis, SQL, Apache Spark and Delta Lake. 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. Skill-based training lessons include: 1) SQL for Data Science - Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results, Use SQL commands to filter, sort, and summarize data, Create an analysis table from multiple queries using the UNION operator, and Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis; 2) Data Wrangling, Analysis and AB Testing with SQL - Validate and clean a dataset, Assess and create datasets to answer your questions, Solve problems using SQL, and Build a simple testing framework to touch on AB Testing; and 3) SQL for Data Science Capstone Project - Develop a project proposal and select your data, Perform descriptive statistics as part of your exploratory analysis, Develop metrics and perform advanced techniques in SQL, and Present your findings and make recommendations.

Enroll today (teams & executives are welcome): https://imp.i384100.net/raaJJ3 

Download your free Software Development - Career Transformation Guide. 

For your reading pleasure consider: 

1 - JavaScript Full Stack Developer: Capture the Job Offer and Advance Your Career (Audible) (Kindle)

2 - AI Software Engineer: ChatGPT, Bard & Beyond (Audible) (Kindle) 

 

3 - The Upskill Gambit - Discover the 5 Keys to Your Career and Income Security in the Digital Age (Audible) (Kindle) 

Much career success, Lawrence E. Wilson - Online Learning Central (share with your team)