Data Foundations
助教微信
udacity公众号
Nanodegree key: nd100
Version: 1.0.0
Locale: en-us
Master data fundamentals applicable to any industry, and learn to make data-driven decisions. Learn Excel and SQL, and gain data visualization skills with Tableau.
Content
Part 01 : Welcome to the Program
Welcome to the program! In this part, you’ll get an orientation into using our classroom and
services. You’ll also get advice for making the best use of your time while enrolled in this
program.
- Module 01: Welcome to the Nanodegree
- Lesson 01: Welcome to Data FoundationsIn the welcome, you will learn about the instructors, curriculum, and how this program is set up moving forward.
- Lesson 02: Nanodegree OrientationHere, you will learn more about the student services that are available for this Nanodegree program, as well as how to be successful in completing the program.
Module 02: Working with data
- Lesson 01: Working with dataTo get a glimpse at the tools you will be learning during this program and some areas where they are applied, this first project will tell you a few stories and give you a quick intro to each.Project Description - Interpret a Data VisualizationProject Rubric - Interpret a Data Visualization
Module 01: Descriptive Statistics
- Lesson 01: Descriptive Statistics IIn this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
- Concept 01: Video: Welcome!
- Concept 02: Video: What is Data? Why is it important?
- Concept 03: Video: Data Types (Quantitative vs. Categorical)
- Concept 04: Quiz: Data Types (Quantitative vs. Categorical)
- Concept 05: Video: Data Types (Ordinal vs. Nominal)
- Concept 06: Video: Data Types (Continuous vs. Discrete)
- Concept 07: Video: Data Types Summary
- Concept 08: Text + Quiz: Data Types (Ordinal vs. Nominal)
- Concept 09: Data Types (Continuous vs. Discrete)
- Concept 10: Video: Introduction to Summary Statistics
- Concept 11: Video: Measures of Center (Mean)
- Concept 12: Measures of Center (Mean)
- Concept 13: Video: Measures of Center (Median)
- Concept 14: Measures of Center (Median)
- Concept 15: Video: Measures of Center (Mode)
- Concept 16: Measures of Center (Mode)
- Concept 17: Video: What is Notation?
- Concept 18: Video: Random Variables
- Concept 19: Quiz: Variable Types
- Concept 20: Video: Capital vs. Lower
- Concept 21: Quiz: Introduction to Notation
- Concept 22: Video: Better Way?
- Concept 23: Video: Summation
- Concept 24: Video: Notation for the Mean
- Concept 25: Text: Summary on Notation
- Concept 26: Quiz: Summation
- Concept 27: Quiz: Notation for the Mean
- Lesson 02: Descriptive Statistics IIIn this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.
- Concept 01: Video: What are Measures of Spread?
- Concept 02: Video: Histograms
- Concept 03: Video: Weekdays vs. Weekends: What is the Difference
- Concept 04: Video: Introduction to Five Number Summary
- Concept 05: Quiz: 5 Number Summary Practice
- Concept 06: Video: What if We Only Want One Number?
- Concept 07: Video: Introduction to Standard Deviation and Variance
- Concept 08: Video: Standard Deviation Calculation
- Concept 09: Text: Introduction to the Standard Deviation and Variance
- Concept 10: Measures of Spread (Calculation and Units)
- Concept 11: Video: Why the Standard Deviation?
- Concept 12: Video: Important Final Points
- Concept 13: Advanced: Standard Deviation and Variance
- Concept 14: Quiz: Applied Standard Deviation and Variance
- Concept 15: Homework 1: Final Quiz on Measures Spread
- Concept 16: Text: Measures of Center and Spread Summary
- Concept 17: Video: Shape
- Concept 18: Video: The Shape For Data In The World
- Concept 19: Quiz: Shape and Outliers (What’s the Impact?).html)
- Concept 20: Video: Shape and Outliers
- Concept 21: Video: Working With Outliers
- Concept 22: Video: Working With Outliers My Advice
- Concept 23: Quiz: Shape and Outliers (Comparing Distributions)
- Concept 24: Quiz: Shape and Outliers (Visuals)
- Concept 25: Quiz: Shape and Outliers (Final Quiz)
- Concept 26: Text +Quiz: What Measures of Spread & Center Should We Use?
- Concept 27: Text: Descriptive Statistics Summary
- Concept 28: Video: Descriptive vs. Inferential Statistics
- Concept 29: Quiz: Descriptive vs. Inferential (Bagels)
- Concept 30: Quiz: Descriptive vs. Inferential (Udacity Students)
- Concept 31: Text: Descriptive vs. Inferential Summary
- Concept 32: Video: Summary
- Lesson 03: Spreadsheets 1: Getting StartedIn this lesson you’ll learn to get started with spreadsheets: creating and saving a spreadsheet, basic operations, fill, and addressing.
- Concept 01: Intro
- Concept 02: Commas vs. Decimals
- Concept 03: Why Spreadsheets?
- Concept 04: Spreadsheet Benefits
- Concept 05: Getting Started
- Concept 06: Navigation: Worksheet
- Concept 07: Column and Row Labels
- Concept 08: Navigation: Menu Bar
- Concept 09: Menu Bar
- Concept 10: Navigation: Shortcuts
- Concept 11: Fill
- Concept 12: Copy Data
- Concept 13: Exercise: Copy Data
- Concept 14: Range Addressing
- Concept 15: Range Addressing
- Concept 16: Relative vs Absolute Addressing
- Concept 17: Relative vs Absolute Addressing
- Concept 18: Insert and Delete
- Concept 19: Exercise: Insert and Delete
- Concept 20: Save Data
- Concept 21: File Types
- Concept 22: Recap
- Lesson 04: Spreadsheets 2: Manipulate DataIn this lesson, you’ll learn to manipulate data in a spreadsheet: formulas, functions, removing duplicate rows, splitting columns, filtering, and sorting.
- Concept 01: Intro
- Concept 02: Cell Formulas
- Concept 03: Quiz: Spreadsheet Functions
- Concept 04: SUBSTITUTE
- Concept 05: Quiz: SUBSTITUTE
- Concept 06: Extract Text
- Concept 07: Exercise: Extract Text
- Concept 08: Reformat Text
- Concept 09: Quiz: PROPER, UPPER, LOWER
- Concept 10: Math Functions
- Concept 11: Exercise: Math Functions
- Concept 12: Duplicate Rows
- Concept 13: Exercise: Duplicate Rows
- Concept 14: Split Columns
- Concept 15: Exercise: Split Columns
- Concept 16: Sort Data
- Concept 17: Exercise: Sort Data
- Concept 18: Filter Data
- Concept 19: Exercise: Filter Data
- Concept 20: Recap
- Lesson 05: Spreadsheets 3: Analyze DataIn this lesson, you’ll learn to analyze data in a spreadsheet: answer questions about the data using aggregation functions, logical functions, pivot tables, and lookup tables.
- Concept 01: Intro
- Concept 02: Aggregation Functions
- Concept 03: Aggregation Functions
- Concept 04: Logical Functions: IF
- Concept 05: Quiz: Comparison Operators
- Concept 06: Logical Functions: AND, OR, NOT
- Concept 07: Quiz: Logical Functions
- Concept 08: Conditional Aggregation Functions
- Concept 09: Exercise: COUNTIF, SUMIF
- Concept 10: Pivot Tables
- Concept 11: Exercise: Pivot Tables
- Concept 12: Named Ranges
- Concept 13: Named Ranges
- Concept 14: Lookup Functions
- Concept 15: Exercise: VLOOKUP
- Concept 16: Recap
- Lesson 06: Spreadsheets 4: Visualize DataIn this lesson, you’ll learn to present data professionally using spreadsheets: charts, histograms, box-plots, and formatting.
- Concept 01: Intro
- Concept 02: Pie Charts
- Concept 03: Exercise: Pie Charts
- Concept 04: Bar Charts
- Concept 05: Scatter and Line Plots
- Concept 06: Quiz: Chart Types
- Concept 07: Exercise: Scatter Plots
- Concept 08: Chart Layout Tools
- Concept 09: Quiz: Chart Layout
- Concept 10: Histograms
- Concept 11: Quiz: Histograms
- Concept 12: Box Plots
- Concept 13: Quiz: Box Plots
- Concept 14: Professional Presentations
- Concept 15: Exercise: Professional Presentations
- Concept 16: Recap
- Lesson 07: Analyze Survey DataWelcome to the second project! In this project you will use your knowledge of statistics and spreadsheets to analyze data about the students across Udacity programs.Project Description - Analyze Survey DataProject Rubric - Analyze Survey Data
- Concept 01: Project Overview
- Concept 02: Exploring the Data I
- Concept 03: Exploring the Data II
- Concept 04: Exploring the Data III
- Concept 05: Exploring the Data IV
- Concept 06: Project Details
- Concept 07: Finished Example Slide
- Concept 08: Helpful Ideas
- Concept 09: Common Mistakes
Part 03 : SQL for Data Analysis
- Lesson 01: Descriptive Statistics IIn this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
Module 01: SQL Things
- Lesson 01: Basic SQLIn this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
- Concept 01: Video: SQL Introduction
- Concept 02: Video: The Parch & Posey Database
- Concept 03: Video + Text: The Parch & Posey Database
- Concept 04: Quiz: ERD Fundamentals
- Concept 05: Text: Map of SQL Content
- Concept 06: Video: Why SQL
- Concept 07: Video: How Databases Store Data
- Concept 08: Text + Quiz: Types of Databases
- Concept 09: Video: Types of Statements
- Concept 10: Statements
- Concept 11: Video: SELECT & FROM
- Concept 12: Text + Quiz: Your First Query
- Concept 13: Solutions: Your First Query Solution
- Concept 14: Text: Formatting Best Practices
- Concept 15: Video: LIMIT
- Concept 16: Quiz: LIMIT
- Concept 17: Solutions: LIMIT
- Concept 18: Video: ORDER BY
- Concept 19: Quiz: ORDER BY
- Concept 20: Solutions: ORDER BY
- Concept 21: Video: ORDER BY Part II
- Concept 22: Quiz: ORDER BY Part II
- Concept 23: Solutions: ORDER BY Part II
- Concept 24: Video: WHERE
- Concept 25: Quiz: WHERE
- Concept 26: Solutions: WHERE
- Concept 27: Video: WHERE with Non-Numeric Data
- Concept 28: Quiz: WHERE with Non-Numeric
- Concept 29: Solutions: WHERE with Non-Numeric
- Concept 30: Video: Arithmetic Operators
- Concept 31: Quiz: Arithmetic Operators
- Concept 32: Solutions: Arithmetic Operators
- Concept 33: Text: Introduction to Logical Operators
- Concept 34: Video: LIKE
- Concept 35: Quiz: LIKE
- Concept 36: Solutions: LIKE
- Concept 37: Video: IN
- Concept 38: Quiz: IN
- Concept 39: Solutions: IN
- Concept 40: Video: NOT
- Concept 41: Quiz: NOT
- Concept 42: Solutions: NOT
- Concept 43: Video: AND and BETWEEN
- Concept 44: Quiz: AND and BETWEEN
- Concept 45: Solutions: AND and BETWEEN
- Concept 46: Video: OR
- Concept 47: Quiz: OR
- Concept 48: Solutions: OR
- Concept 49: Text: Recap & Looking Ahead
- Lesson 02: SQL JoinsIn this lesson, you will learn how to combine data from multiple tables together.
- Concept 01: Video: Motivation
- Concept 02: Video: Why Would We Want to Split Data Into Separate Tables?
- Concept 03: Video: Introduction to JOINs
- Concept 04: Text + Quiz: Your First JOIN
- Concept 05: Solution: Your First JOIN
- Concept 06: Text: ERD Reminder
- Concept 07: Text: Primary and Foreign Keys
- Concept 08: Quiz: Primary - Foreign Key Relationship
- Concept 09: Text + Quiz: JOIN Revisited
- Concept 10: Video: Alias
- Concept 11: Quiz: JOIN Questions Part I
- Concept 12: Solutions: JOIN Questions Part I
- Concept 13: Video: Motivation for Other JOINs
- Concept 14: Video: LEFT and RIGHT JOINs
- Concept 15: Text: Other JOIN Notes
- Concept 16: LEFT and RIGHT JOIN
- Concept 17: Solutions: LEFT and RIGHT JOIN
- Concept 18: Video: JOINs and Filtering
- Concept 19: Quiz: Last Check
- Concept 20: Solutions: Last Check
- Concept 21: Text: Recap & Looking Ahead
- Lesson 03: SQL AggregationsIn this lesson, you will learn how to aggregate data using SQL functions like SUM, AVG, and COUNT. Additionally, CASE, HAVING, and DATE functions provide you an incredible problem solving toolkit.
- Concept 01: Video: Introduction to Aggregation
- Concept 02: Video: Introduction to NULLs
- Concept 03: Video: NULLs and Aggregation
- Concept 04: Video + Text: First Aggregation - COUNT
- Concept 05: Video: COUNT & NULLs
- Concept 06: Video: SUM
- Concept 07: Quiz: SUM
- Concept 08: Solution: SUM
- Concept 09: Video: MIN & MAX
- Concept 10: Video: AVG
- Concept 11: Quiz: MIN, MAX, & AVG
- Concept 12: Solutions: MIN, MAX, & AVG
- Concept 13: Video: GROUP BY
- Concept 14: Quiz: GROUP BY
- Concept 15: Solutions: GROUP BY
- Concept 16: Video: GROUP BY Part II
- Concept 17: Quiz: GROUP BY Part II
- Concept 18: Solutions: GROUP BY Part II
- Concept 19: Video: DISTINCT
- Concept 20: Quiz: DISTINCT
- Concept 21: Solutions: DISTINCT
- Concept 22: Video: HAVING
- Concept 23: HAVING
- Concept 24: Solutions: HAVING
- Concept 25: Video: DATE Functions
- Concept 26: Video: DATE Functions II
- Concept 27: Quiz: DATE Functions
- Concept 28: Solutions: DATE Functions
- Concept 29: Video: CASE Statements
- Concept 30: Video: CASE & Aggregations
- Concept 31: Quiz: CASE
- Concept 32: Solutions: CASE
- Concept 33: Text: Recap
- Concept 34: Head to the Project
- Lesson 04: [Optional] SQL Subqueries & Temporary Tables (Advanced)In this lesson, you will learn how to use temporary tables and subqueries to take your querying to a whole new level!
- Concept 01: Video: Introduction
- Concept 02: Video: Introduction to Subqueries
- Concept 03: Video + Quiz: Write Your First Subquery
- Concept 04: Solutions: Write Your First Subquery
- Concept 05: Text: Subquery Formatting
- Concept 06: Video: More On Subqueries
- Concept 07: Quiz: More On Subqueries
- Concept 08: Solutions: More On Subqueries
- Concept 09: Quiz: Subquery Mania
- Concept 10: Solution: Subquery Mania
- Concept 11: Video: WITH
- Concept 12: Text + Quiz: WITH vs. Subquery
- Concept 13: Quiz: WITH
- Concept 14: Solutions: WITH
- Concept 15: Video: Subquery Conclusion
- Lesson 05: [Optional] SQL Data Cleaning (Advanced)Data cleaning is a necessary evil of working with data. In this lesson, you will learn how to clean data using SQL. These skills are so important with working with data that aren’t exactly perfect.
- Concept 01: Video: Introduction to SQL Data Cleaning
- Concept 02: Video: LEFT & RIGHT
- Concept 03: Quiz: LEFT & RIGHT
- Concept 04: Solutions: LEFT & RIGHT
- Concept 05: Video: POSITION, STRPOS, & SUBSTR
- Concept 06: Quiz: POSITION, STRPOS, & SUBSTR - AME DATA AS QUIZ 1
- Concept 07: Solutions: POSITION, STRPOS, & SUBSTR
- Concept 08: Video: CONCAT
- Concept 09: Quiz: CONCAT
- Concept 10: Solutions: CONCAT
- Concept 11: Video: CAST
- Concept 12: Quiz: CAST
- Concept 13: Solutions: CAST
- Concept 14: Video: COALESCE
- Concept 15: Quiz: COALESCE
- Concept 16: Solutions: COALESCE
- Concept 17: Video + Text: Recap
- Lesson 01: Basic SQLIn this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
Module 02: Query a Digital Music Store Database
- Lesson 01: Query a Digital Music Store DatabaseThe Chinook database is an iTunes library representing a digital music store. You will be querying this database as a part of this project to assist the store in learning about their customers. Project Description - SQL ProjectProject Rubric - SQL Project
- Concept 01: Project Introduction
- Concept 02: Set Up the Database
- Concept 03: Checking Setup
- Concept 04: Schema Match
- Concept 05: SQL: Question Set 1
- Concept 06: SQL: Question Set 2
- Concept 07: (Advanced) SQL: Question Set 3
- Concept 08: Different Date Functions for the Project
- Concept 09: Project Submission - IMPORTANT
- Concept 10: Common Mistakes
Part 04 : Data Visualization
Sharing your analysis results is integral to working with data. Here, you’ll learn how to properly design data visualizations and create interactive dashboards with Tableau.
- Lesson 01: Query a Digital Music Store DatabaseThe Chinook database is an iTunes library representing a digital music store. You will be querying this database as a part of this project to assist the store in learning about their customers. Project Description - SQL ProjectProject Rubric - SQL Project
Module 01: Data viz lessons
- Lesson 01: Introduction to Data VisualizationIn this lesson, you will learn the main data visualizations used for univariate and bivariate analyses. As well as the visualizations that are used for when you you want to compare more variables.
- Concept 01: Data Visualization Introduction
- Concept 02: Why Do We Use Data Visualizations?
- Concept 03: Motivation for Data Visualization
- Concept 04: Further Motivation
- Concept 05: Data Types Review
- Concept 06: Identifying Data Types
- Concept 07: Univariate Plots
- Concept 08: Univariate Plots
- Concept 09: Scatter Plots
- Concept 10: Quizzes On Scatter Plots
- Concept 11: Correlation Coefficients
- Concept 12: Correlation Coefficient Quizzes
- Concept 13: Line Plots
- Concept 14: What is the Question?
- Concept 15: What About with More Than Two Variables?
- Concept 16: Multiple Variables Quiz
- Concept 17: Why Data Dashboards
- Concept 18: Introduction to Data Dashboards
- Concept 19: Quiz On Visual Encodings
- Concept 20: Recap
- Concept 21: What’s Next?
- Lesson 02: DesignIn this lesson, you will learn about visual encodings, and best practices for building data visualizations.
- Concept 01: Introduction
- Concept 02: Lesson Overview
- Concept 03: Exploratory vs. Explanatory Analyses
- Concept 04: Quiz: Exploratory vs. Explanatory
- Concept 05: What Makes a Bad Visual?
- Concept 06: What Experts Say About Visual Encodings
- Concept 07: Chart Junk
- Concept 08: Data Ink Ratio
- Concept 09: Design Integrity
- Concept 10: Bad Visual Quizzes (Part I)
- Concept 11: Bad Visual Quizzes (Part II)
- Concept 12: Text: Effective Explanatory Visual Recap
- Concept 13: Using Color
- Concept 14: Designing for Color Blindness
- Concept 15: Shape, Size, & Other Tools
- Concept 16: General Design Tips
- Concept 17: Good Visual
- Concept 18: Tell A Story
- Concept 19: Same Data, Different Stories
- Concept 20: Quizzes on Data Story Telling
- Concept 21: Recap
- Concept 22: Onwards!
- Lesson 03: Data Visualizations in TableauIn this lesson, you will learn how to make visualizations in Tableau. Get excited - it is about to get awesome!
- Concept 01: Video: What is Tableau?
- Concept 02: Text: Installing Tableau
- Concept 03: Video: How This Lesson Is Structured?
- Concept 04: Text: Outline of Topics Covered
- Concept 05: Commas vs Periods
- Concept 06: Video: Connecting to Data
- Concept 07: Text: Connecting to Data Recap
- Concept 08: Quiz: Connecting to Data
- Concept 09: Video: Combining Data
- Concept 10: Text: Combining Data Recap
- Concept 11: Quiz: Combining Data
- Concept 12: Video: What Can You Create In Tableau?
- Concept 13: Video: Worksheets
- Concept 14: Text: Worksheets
- Concept 15: Quiz: Worksheets
- Concept 16: Text: Saving to Tableau Public
- Concept 17: Video: Aggregations
- Concept 18: Text: Aggregations
- Concept 19: Quiz: Aggregations
- Concept 20: Video: Hierarchies
- Concept 21: Text: Hierarchies
- Concept 22: Quiz: Hierarchies
- Concept 23: Video: Marks & Filters
- Concept 24: Text: Marks & Filters I
- Concept 25: Quiz: Marks & Filters I
- Concept 26: Text: Marks & Filters II
- Concept 27: Quiz: Marks & Filters II
- Concept 28: Video: Show Me
- Concept 29: Text: Show Me
- Concept 30: Quiz: Show Me
- Concept 31: Video: Small Multiples & Dual Axis
- Concept 32: Text: Small Multiples & Dual Axis
- Concept 33: Text: Map Configuration
- Concept 34: Quiz: Small Multiples
- Concept 35: Quiz: Dual Axis
- Concept 36: Video: Groups & Sets
- Concept 37: Text: Groups & Sets
- Concept 38: Quiz: Groups
- Concept 39: Quiz: Sets
- Concept 40: Video: Calculated Fields
- Concept 41: Text: Calculated Fields
- Concept 42: Quiz: Calculated Fields
- Concept 43: Video: Table Calculations
- Concept 44: Text: Table Calculations
- Concept 45: Quiz: Table Calculations
- Concept 46: Text: Recap
- Concept 47: Video: What’s Next?
- Lesson 04: Making Dashboards & Stories in TableauIn this lesson, you will learn from a Tableau expert, and start putting together your own dashboards and stories.
- Concept 01: Video: Communicating With Your Data
- Concept 02: Video + Text: What’s Ahead?
- Concept 03: Video: Hierarchies with Trina
- Concept 04: Quiz: Hierarchies with Trina
- Concept 05: Video: Building Dashboards & Stories with Trina
- Concept 06: Text: General Notes for Building Data Dashboards with Trina
- Concept 07: Text: General Notes for Building Stories
- Concept 08: Quiz: Building Dashboards & Stories with Trina
- Concept 09: Video: Extra Practice with Dashboards
- Concept 10: Quiz: Extra Practice with Dashboards
- Concept 11: Text: Lesson Recap
- Concept 12: Video: Congratulations!
- Lesson 05: Data Visualization ProjectProject Description - Build Data DashboardsProject Rubric - Build Data Dashboards
- Concept 01: Video: Project Introduction
- Concept 02: Text: Project Introduction Directions
- Concept 03: Text: Saving to Tableau Public
- Concept 04: Share Your Work
- Concept 05: Tableau Public / Tableau Desktop
- Concept 06: Text: Metadata
Part 05 : Congratulations and Next Steps
Once you have completed all four of the projects, you might be wondering ‘what next?’
- Lesson 01: Introduction to Data VisualizationIn this lesson, you will learn the main data visualizations used for univariate and bivariate analyses. As well as the visualizations that are used for when you you want to compare more variables.
Module 01: Now What
- Lesson 01: Congratulations and Next StepsIn this lesson, I want to take the time to congratulate you on your accomplishment, and talk about potential next steps in using data in your career and beyond.
- Concept 01: Congratulations
- Concept 02: Business Analyst Nanodegree
- Concept 03: Data Analyst Nanodegree
- Concept 04: Advice From Industry Leaders
- Concept 05: Sinthuja Nagalingam at Summit Schools
- Concept 06: Data Scientist at Hired
- Concept 07: Other Nanodegree Programs
- Concept 08: Receiving Your Certificate
Part 06 (Elective): Advanced SQL [Extra Materials]
- Lesson 01: Congratulations and Next StepsIn this lesson, I want to take the time to congratulate you on your accomplishment, and talk about potential next steps in using data in your career and beyond.
Module 01: Advanced SQL
- Lesson 01: [Optional] SQL Subqueries & Temporary Tables (Advanced)In this lesson, you will learn how to use temporary tables and subqueries to take your querying to a whole new level!
- Concept 01: Video: Introduction
- Concept 02: Video: Introduction to Subqueries
- Concept 03: Video + Quiz: Write Your First Subquery
- Concept 04: Solutions: Write Your First Subquery
- Concept 05: Text: Subquery Formatting
- Concept 06: Video: More On Subqueries
- Concept 07: Quiz: More On Subqueries
- Concept 08: Solutions: More On Subqueries
- Concept 09: Quiz: Subquery Mania
- Concept 10: Solution: Subquery Mania
- Concept 11: Video: WITH
- Concept 12: Text + Quiz: WITH vs. Subquery
- Concept 13: Quiz: WITH
- Concept 14: Solutions: WITH
- Concept 15: Video: Subquery Conclusion
- Lesson 02: [Optional] SQL Data Cleaning (Advanced)Data cleaning is a necessary evil of working with data. In this lesson, you will learn how to clean data using SQL. These skills are so important with working with data that aren’t exactly perfect.
- Concept 01: Video: Introduction to SQL Data Cleaning
- Concept 02: Video: LEFT & RIGHT
- Concept 03: Quiz: LEFT & RIGHT
- Concept 04: Solutions: LEFT & RIGHT
- Concept 05: Video: POSITION, STRPOS, & SUBSTR
- Concept 06: Quiz: POSITION, STRPOS, & SUBSTR - AME DATA AS QUIZ 1
- Concept 07: Solutions: POSITION, STRPOS, & SUBSTR
- Concept 08: Video: CONCAT
- Concept 09: Quiz: CONCAT
- Concept 10: Solutions: CONCAT
- Concept 11: Video: CAST
- Concept 12: Quiz: CAST
- Concept 13: Solutions: CAST
- Concept 14: Video: COALESCE
- Concept 15: Quiz: COALESCE
- Concept 16: Solutions: COALESCE
- Concept 17: Video + Text: Recap
- Lesson 01: [Optional] SQL Subqueries & Temporary Tables (Advanced)In this lesson, you will learn how to use temporary tables and subqueries to take your querying to a whole new level!
【点击购买】
若有收获，就点个赞吧
0 人点赞
