Learn SQL Basics for Data Science
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.
Created by: University of California, Davis
Created by: University of California, Davis
Find Out More
Share
e.g. This is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with high school students and professionals with an interest in programmingGain the skills for building efficient and scalable data pipelines. Explore essential data engineering...
In today\'s rapidly evolving digital landscape, the importance of cybersecurity cannot be overstated. Threats to organizations, both large and small, are on the rise, and the consequences of security breaches can be devastating. It\'s no longer enough to rely solely on technical solutions; a...
Want to learn the basics of computer programming in a fun and innovative way? This course introduces computer programming using an educational block-based visual programming environment called NetsBlox (), emphasizing modern computer science concepts like networking, the internet, and distributed...
This course introduces learners to the analysis of binary/dichotomous outcomes. Learners will become familiar with fundamental tests for two-group comparisons and statistical inference plus prediction more broadly using logistic regression. They will understand the connection between prevalence,...
This course will begin by discussing superconductivity - a central example of a macroscopic phenomenon. It will then proceed to discuss various modern topics in quantum condensed matter physics, including fractionalization, anyon statistics, topology, and non-equilibrium phases. The course aims...
