Engineering and Technology
Become an SQL power user with the ability complete complex tasks in SQL, including cleaning data and tuning the performance of your queries so they run quickly—even over giant data sets.
The Introduction to SQL course on Udacity covers the fundamentals of SQL, including writing common SQL commands such as SELECT, FROM, and WHERE, and using logical operators like LIKE, AND, and OR. Students will also learn about SQL JOINs and how to combine data from multiple sources to answer complex business questions. The course covers SQL aggregations, including common aggregations like COUNT, SUM, MIN, and MAX, as well as working with NULLs and using CASE and DATE functions. Students will also learn about SQL subqueries and temporary tables, and how to run multiple queries together and access tables with more than one query. The course also covers SQL data cleaning strategies, including normalizing data and creating columns from existing data. Students will learn about SQL window functions and how to use them for analysis tasks that require further targeting or segmentation. The course also covers advanced JOINs and performance tuning, teaching students how to write queries that run quickly across large datasets and optimize query performance. The course concludes with a project where students act as data analysts for an organization focused on reducing deforestation. Students will clean data, join tables, and perform calculations to analyze forest size and deforestation trends in different countries and regions, and will compile their findings into a report for stakeholders.
by Udacity
Become an SQL power user with the ability complete complex tasks in SQL, including cleaning data and...
by Udacity
Master SQL, the core language for big data analysis, to enable insight-driven decision-making and st...
by Udacity
Learn the fundamental programming tools for data professionals: Python, SQL, terminal, and Git.
by Udacity
Prepare for a data science career by learning the fundamental data programming tools: R, SQL, comman...
by Udacity
Build confidence translating business requirements into project scope statements, creating project p...
by Udacity
Learn the foundational concepts of developing stack applications using modern cloud architecture.
by Udacity
Get your start in the high growth field of cybersecurity by building foundational skills including e...
by Udacity
Learn the 5 key stages of the data analysis process in this hands-on introduction to data analysis.
by Udacity
This class will teach you the end-to-end process of investigating data through a machine learning le...
by Udacity
A first step for beginners towards careers in web and app development, machine learning, data scienc...