Nanodegree key: nd104 需要项目参考答案跟一对一VIP服务请扫描上方二维码
Version: 3.0.0
Locale: en-us
Learn programming skills needed to uncover patterns and insights in large data sets, running queries with relational databases and working with Unix shell and Git.
Content
Part 01 : Welcome to the Program
Welcome to the program! In this part, you will 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 Program
-
Lesson 01: Welcome to the Nanodegree
Welcome to the Programming for Data Science Nanodegree program! In this lesson, you will learn more about the structure of the program and meet the team.
-
Lesson 02: Mentor Help, Peer Chat, and Careers
You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.
-
Lesson 03: Get Help with Your Account
What to do if you have questions about your account or general questions about the program.
-
Lesson 04: The Life of a Data Scientist
In this lesson, you'll hear from a few data analysts and data scientists about what it's like to work in data analytics.
-
Part 02 : Introduction to SQL
Learn SQL language fundamentals such as building basic queries and advanced functions like Window Functions, Subqueries and Common Table Expressions.
-
Module 01: Introduction to SQL
-
Lesson 01: Basic SQL
In 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: Video: Why SQL
- Concept 06: Video: How Databases Store Data
- Concept 07: Types of Databases
- Concept 08: Video: Types of Statements
- Concept 09: Statements
- Concept 10: Video: SELECT & FROM
- Concept 11: Your First Queries in SQL Workspace
- Concept 12: Solution: Your First Queries
- Concept 13: Formatting Best Practices
- Concept 14: Video: LIMIT
- Concept 15: Quiz: LIMIT
- Concept 16: Solution: LIMIT
- Concept 17: Video: ORDER BY
- Concept 18: Quiz: ORDER BY
- Concept 19: Solutions: ORDER BY
- Concept 20: Video: ORDER BY Part II
- Concept 21: Quiz: ORDER BY Part II
- Concept 22: Solutions: ORDER BY Part II
- Concept 23: Video: WHERE
- Concept 24: Quiz: WHERE
- Concept 25: Solutions: WHERE
- Concept 26: Video: WHERE with Non-Numeric Data
- Concept 27: Quiz: WHERE with Non-Numeric
- Concept 28: Solutions: WHERE with Non-Numeric
- Concept 29: Video: Arithmetic Operators
- Concept 30: Quiz: Arithmetic Operators
- Concept 31: Solutions: Arithmetic Operators
- Concept 32: Text: Introduction to Logical Operators
- Concept 33: Video: LIKE
- Concept 34: Quiz: LIKE
- Concept 35: Solutions: LIKE
- Concept 36: Video: IN
- Concept 37: Quiz: IN
- Concept 38: Solutions: IN
- Concept 39: Video: NOT
- Concept 40: Quiz: NOT
- Concept 41: Solutions: NOT
- Concept 42: Video: AND and BETWEEN
- Concept 43: Quiz: AND and BETWEEN
- Concept 44: Solutions: AND and BETWEEN
- Concept 45: Video: OR
- Concept 46: Quiz: OR
- Concept 47: Solutions: OR
- Concept 48: Text: Recap & Looking Ahead
-
Lesson 02: SQL Joins
In 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 Aggregations
In 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
-
Lesson 04: SQL Subqueries & Temporary Tables
In this lesson, you will be learning to answer much more complex business questions using nested querying methods - also known as subqueries.
- 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: SQL Data Cleaning
Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.
- 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 06: SQL Window Functions
Compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis: window functions.
- Concept 01: Video: Introduction to Window Functions
- Concept 02: Video: Window Functions 1
- Concept 03: Quiz: Window Functions 1
- Concept 04: Solutions: Window Functions 1
- Concept 05: Quiz: Window Functions 2
- Concept 06: Solutions: Window Functions 2
- Concept 07: Video: ROW_NUMBER & RANK
- Concept 08: Quiz: ROW_NUMBER & RANK
- Concept 09: Solutions: ROW_NUMBER & RANK
- Concept 10: Video: Aggregates in Window Functions
- Concept 11: Quiz: Aggregates in Window Functions
- Concept 12: Solutions: Aggregates in Window Functions
- Concept 13: Video: Aliases for Multiple Window Functions
- Concept 14: Quiz: Aliases for Multiple Window Functions
- Concept 15: Solutions: Aliases for Multiple Window Functions
- Concept 16: Video: Comparing a Row to Previous Row
- Concept 17: Quiz: Comparing a Row to Previous Row
- Concept 18: Solutions: Comparing a Row to Previous Row
- Concept 19: Video: Introduction to Percentiles
- Concept 20: Video: Percentiles
- Concept 21: Quiz: Percentiles
- Concept 22: Solutions: Percentiles
- Concept 23: Video: Recap
-
Lesson 07: SQL Advanced JOINS & Performance Tuning
Learn advanced joins and how to make queries that run quickly across giant datasets. Most of the examples in the lesson involve edge cases, some of which come up in interviews.
- Concept 01: Video: Introduction to Advanced SQL
- Concept 02: Text + Images: FULL OUTER JOIN
- Concept 03: Quiz: FULL OUTER JOIN
- Concept 04: Solutions: FULL OUTER JOIN
- Concept 05: Video: JOINs with Comparison Operators
- Concept 06: Quiz: JOINs with Comparison Operators
- Concept 07: Solutions: JOINs with Comparison Operators
- Concept 08: Video: Self JOINs
- Concept 09: Quiz: Self JOINs
- Concept 10: Solutions: Self JOINs
- Concept 11: Video: UNION
- Concept 12: Quiz: UNION
- Concept 13: Solutions: UNION
- Concept 14: Video: Performance Tuning Motivation
- Concept 15: Video + Quiz: Performance Tuning 1
- Concept 16: Video: Performance Tuning 2
- Concept 17: Video: Performance Tuning 3
- Concept 18: Video: JOINing Subqueries
- Concept 19: More Practice!
- Concept 20: Video: SQL Completion Congratulations
-
Lesson 08: Investigate a Relational Database
The Sakila Movie database is a SQL database of online DVD rentals . You will query the database to answer questions about business decisions.
- Concept 01: Project Overview
- Concept 02: Project Details
- Concept 03: Workspace vs. Local environment
- Concept 04: Set Up Your Local Environment
- Concept 05: Composite Key
- Concept 06: Workspace: DVD Rental Database
- Concept 07: Understanding the database
- Concept 08: Practice Quiz #1
- Concept 09: Practice Solution #1
- Concept 10: Practice Quiz #2
- Concept 11: Practice Solution #2
- Concept 12: Workspace + Question Set #1
- Concept 13: Workspace + Question Set #2
- Concept 14: Project Submission
- Concept 15: Common Mistakes
- Concept 16: Helpful strategies
- Concept 17: BONUS: Project FAQs
-
Part 03 : Command Line Essentials
The Unix shell is a powerful tool for developers of all sorts. In this lesson, you'll get a quick introduction to the very basics of using it on your own computer.
-
Module 01: Command Line Essentials
-
Lesson 01: Shell Workshop
The Unix shell is a powerful tool for developers of all sorts. In this lesson, you'll get a quick introduction to the very basics of using it on your own computer.
- Concept 01: Introduction to Unix Shell
- Concept 02: Intro to the Shell
- Concept 03: Windows: Installing Git Bash
- Concept 04: Opening a terminal
- Concept 05: Your first command (echo)
- Concept 06: Navigating directories (ls, cd, ..)
- Concept 07: Current working directory (pwd)
- Concept 08: Parameters and options (ls -l)
- Concept 09: Organizing your files (mkdir, mv)
- Concept 10: Downloading (curl)
- Concept 11: Viewing files (cat, less)
- Concept 12: Removing things (rm, rmdir)
- Concept 13: Searching and pipes (grep, wc)
- Concept 14: Shell and environment variables
- Concept 15: Startup files (.bash_profile)
- Concept 16: Controlling the shell prompt ($PS1)
- Concept 17: Aliases
- Concept 18: Keep learning!
-
Part 04 : Introduction to Python
Learn Python programming fundamentals such as data types and structures, variables, loops, and functions.
-
Module 01: Introduction to Python
-
Lesson 01: Why Python Programming
Welcome to Introduction to Python! Here's an overview of the course.
-
Lesson 02: Data Types and Operators
Familiarize yourself with the building blocks of Python! Learn about data types and operators, built-in functions, type conversion, whitespace, and style guidelines.
- Concept 01: Introduction
- Concept 02: Arithmetic Operators
- Concept 03: Quiz: Arithmetic Operators
- Concept 04: Solution: Arithmetic Operators
- Concept 05: Variables and Assignment Operators
- Concept 06: Quiz: Variables and Assignment Operators
- Concept 07: Solution: Variables and Assignment Operators
- Concept 08: Integers and Floats
- Concept 09: Quiz: Integers and Floats
- Concept 10: Booleans, Comparison Operators, and Logical Operators
- Concept 11: Quiz: Booleans, Comparison Operators, and Logical Operators
- Concept 12: Solution: Booleans, Comparison and Logical Operators
- Concept 13: Strings
- Concept 14: Quiz: Strings
- Concept 15: Solution: Strings
- Concept 16: Type and Type Conversion
- Concept 17: Quiz: Type and Type Conversion
- Concept 18: Solution: Type and Type Conversion
- Concept 19: String Methods
- Concept 20: String Methods
- Concept 21: Another String Method - Split
- Concept 22: Quiz: String Methods Practice
- Concept 23: Solution: String Methods Practice
- Concept 24: "There's a Bug in my Code"
- Concept 25: Conclusion
- Concept 26: Summary
-
Lesson 03: Data Structures
Use data structures to order and group different data types together! Learn about the types of data structures in Python, along with more useful built-in functions and operators.
- Concept 01: Introduction
- Concept 02: Lists and Membership Operators
- Concept 03: Quiz: Lists and Membership Operators
- Concept 04: Solution: List and Membership Operators
- Concept 05: Why Do We Need Lists?
- Concept 06: List Methods
- Concept 07: Quiz: List Methods
- Concept 08: Check for Understanding: Lists
- Concept 09: Tuples
- Concept 10: Quiz: Tuples
- Concept 11: Sets
- Concept 12: Quiz: Sets
- Concept 13: Dictionaries and Identity Operators
- Concept 14: Quiz: Dictionaries and Identity Operators
- Concept 15: Solution: Dictionaries and Identity Operators
- Concept 16: Quiz: More With Dictionaries
- Concept 17: When to Use Dictionaries?
- Concept 18: Check for Understanding: Data Structures
- Concept 19: Compound Data Structures
- Concept 20: Quiz: Compound Data Structures
- Concept 21: Solution: Compound Data Structions
- Concept 22: Practice Questions
- Concept 23: Solution: Practice Questions
- Concept 24: Conclusion
-
Lesson 04: Control Flow
Build logic into your code with control flow tools! Learn about conditional statements, repeating code with loops and useful built-in functions, and list comprehensions.
- Concept 01: Introduction
- Concept 02: Conditional Statements
- Concept 03: Practice: Conditional Statements
- Concept 04: Solution: Conditional Statements
- Concept 05: Quiz: Conditional Statements
- Concept 06: Solution: Conditional Statements
- Concept 07: Boolean Expressions for Conditions
- Concept 08: Quiz: Boolean Expressions for Conditions
- Concept 09: Solution: Boolean Expressions for Conditions
- Concept 10: For Loops
- Concept 11: Practice: For Loops
- Concept 12: Solution: For Loops Practice
- Concept 13: Quiz: For Loops
- Concept 14: Solution: For Loops Quiz
- Concept 15: Quiz: Match Inputs To Outputs
- Concept 16: Building Dictionaries
- Concept 17: Iterating Through Dictionaries with For Loops
- Concept 18: Quiz: Iterating Through Dictionaries
- Concept 19: Solution: Iterating Through Dictionaries
- Concept 20: While Loops
- Concept 21: Practice: While Loops
- Concept 22: Solution: While Loops Practice
- Concept 23: Quiz: While Loops
- Concept 24: Solution: While Loops Quiz
- Concept 25: For Loops vs. While Loops
- Concept 26: Check for Understanding: For and While Loops
- Concept 27: Solution: Check for Understanding: For and While Loops
- Concept 28: Break, Continue
- Concept 29: Quiz: Break, Continue
- Concept 30: Solution: Break, Continue
- Concept 31: Practice: Loops
- Concept 32: Solution: Loops
- Concept 33: Zip and Enumerate
- Concept 34: Quiz: Zip and Enumerate
- Concept 35: Solution: Zip and Enumerate
- Concept 36: List Comprehensions
- Concept 37: Quiz: List Comprehensions
- Concept 38: Solution: List Comprehensions
- Concept 39: Practice Questions
- Concept 40: Solutions to Practice Questions
- Concept 41: Conclusion
-
Lesson 05: Functions
Learn how to use functions to improve and reuse your code! Learn about functions, variable scope, documentation, lambda expressions, iterators, and generators.
- Concept 01: Introduction
- Concept 02: Defining Functions
- Concept 03: Quiz: Defining Functions
- Concept 04: Solution: Defining Functions
- Concept 05: Check For Understanding: Functions
- Concept 06: Variable Scope
- Concept 07: Variable Scope
- Concept 08: Solution: Variable Scope
- Concept 09: Check For Understanding: Variable Scope
- Concept 10: Documentation
- Concept 11: Quiz: Documentation
- Concept 12: Solution: Documentation
- Concept 13: Lambda Expressions
- Concept 14: Quiz: Lambda Expressions
- Concept 15: Solution: Lambda Expressions
- Concept 16: Conclusion
-
Lesson 06: Scripting
Setup your own programming environment to write and run Python scripts locally! Learn good scripting practices, interact with different inputs, and discover awesome tools.
- Concept 01: Introduction
- Concept 02: Python Installation
- Concept 03: Install Python Using Anaconda
- Concept 04: [For Windows] Configuring Git Bash to Run Python
- Concept 05: Running a Python Script
- Concept 06: Programming Environment Setup
- Concept 07: Editing a Python Script
- Concept 08: Scripting with Raw Input
- Concept 09: Quiz: Scripting with Raw Input
- Concept 10: Solution: Scripting with Raw Input
- Concept 11: Errors and Exceptions
- Concept 12: Errors and Exceptions
- Concept 13: Handling Errors
- Concept 14: Practice: Handling Input Errors
- Concept 15: Solution: Handling Input Errors
- Concept 16: Accessing Error Messages
- Concept 17: Reading and Writing Files
- Concept 18: Quiz: Reading and Writing Files
- Concept 19: Solution: Reading and Writing Files
- Concept 20: Quiz: Practice Debugging
- Concept 21: Solutions for Quiz: Practice Debugging
- Concept 22: Importing Local Scripts
- Concept 23: The Standard Library
- Concept 24: Quiz: The Standard Library
- Concept 25: Solution: The Standard Library
- Concept 26: Techniques for Importing Modules
- Concept 27: Quiz: Techniques for Importing Modules
- Concept 28: Third-Party Libraries
- Concept 29: Experimenting with an Interpreter
- Concept 30: Online Resources
- Concept 31: Practice Question
- Concept 32: Solution for Practice Question
- Concept 33: Conclusion
-
Lesson 07: NumPy
Learn the basics of NumPy and how to use it to create and manipulate arrays.
- Concept 01: Instructors
- Concept 02: Introduction to NumPy
- Concept 03: Why Use NumPy?
- Concept 04: Creating and Saving NumPy ndarrays
- Concept 05: Quiz: Creating and Saving NumPy ndarrays
- Concept 06: Solution: Creating and Saving NumPy ndarrays
- Concept 07: Using Built-in Functions to Create ndarrays
- Concept 08: Create an ndarray
- Concept 09: Accessing, Deleting, and Inserting Elements Into ndarrays
- Concept 10: Slicing ndarrays
- Concept 11: Boolean Indexing, Set Operations, and Sorting
- Concept 12: Manipulating ndarrays
- Concept 13: Arithmetic operations and Broadcasting
- Concept 14: Creating ndarrays with Broadcasting
-
Lesson 08: Pandas
Learn the basics of Pandas Series and DataFrames and how to use them to load and process data.
- Concept 01: Instructors
- Concept 02: Introduction to pandas
- Concept 03: Why Use pandas?
- Concept 04: Creating pandas Series
- Concept 05: Accessing and Deleting Elements in pandas Series
- Concept 06: Arithmetic Operations on pandas Series
- Concept 07: Manipulate a Series
- Concept 08: Creating pandas DataFrames
- Concept 09: Accessing Elements in pandas DataFrames
- Concept 10: Dealing with NaN
- Concept 11: Manipulate a DataFrame
- Concept 12: Loading Data into a pandas DataFrame
-
Lesson 09: Advanced Topics
In this lesson we cover some advanced topics of iterators and generators. You are not required to complete this but we have provided these to give you a taste of these.
-
Lesson 10: Explore US Bikeshare Data
Use Python to understand U.S. bikeshare data. Calculate statistics and build an interactive environment where a user chooses the data and filter for a dataset to analyze.
- Concept 01: Project Overview
- Concept 02: Project Details
- Concept 03: Code Walkthrough
- Concept 04: Understanding the Data
- Concept 05: Practice Problem #1
- Concept 06: Practice Solution #1
- Concept 07: Practice Problem #2
- Concept 08: Practice Solution #2
- Concept 09: Practice Problem #3
- Concept 10: Practice Solution #3
- Concept 11: Completing and Submitting this Project - Two Options
- Concept 12: BONUS: Project FAQs
- Concept 13: Project Workspace: Complete and Submit Project
-
Part 05 : Introduction to Version Control
Learn how to use version control to save and share your projects with others.
-
Module 01: Introduction to Version Control
-
Lesson 01: What is Version Control?
Version control is an incredibly important part of a professional programmer's life. In this lesson, you'll learn about the benefits of version control and install the version control tool Git!
-
Lesson 02: Create a Git Repo
Now that you've learned the benefits of Version Control and gotten Git installed, it's time you learn how to create a repository.
-
Lesson 03: Review A Repo's History
Knowing how to review an existing Git repository's history of commits is extremely important. You'll learn how to do just that in this lesson.
-
Lesson 04: Add Commits to A Repo
A repository is nothing without commits. In this lesson, you'll learn how to make commits, write descriptive commit messages, and verify the changes you're about to save to the repository.
-
Lesson 05: Tagging, Branching, and Merging
Being able to work on your project in isolation from other changes will multiply your productivity. You'll learn how to do this isolated development with Git's branches.
-
Lesson 06: Undoing Changes
Help! Disaster has struck! You don't have to worry, though, because your project is tracked in version control! You'll learn how to undo and modify changes that have been saved to the repository.
-
Lesson 07: Working With Remotes
You'll learn how to create remote repositories on GitHub and how to get and send changes to the remote repository.
-
Lesson 08: Working On Another Developer's Repository
In this lesson, you'll learn how to fork another developer's project. Collaborating with other developers can be a tricky process, so you'll learn how to contribute to a public project.
-
Lesson 09: Staying In Sync With A Remote Repository
You'll learn how to send suggested changes to another developer by using pull requests. You'll also learn how to use the powerful
git rebase
command to squash commits together. -
Lesson 10: Post your Work on GitHub
Use your local git repository and your GitHub repository. Fork a repository, work on files, stage files and commit them to GitHub. You will also demonstrate how to hide files using .gitignore files.
-
Part 06 : Career Services
These Career Services will ensure you make meaningful connections with industry professionals to accelerate your career growth - whether looking for a job or opportunities to collaborate with your peers. Unlike your Nanodegree projects, you do not need to meet specifications on these Services to progress in your program. Submit these Career Services once, and get honest, personalized feedback and next steps from Udacity Career Coaches!
-
Module 01: Career Services
-
Lesson 01: Industry Research
You're building your online presence. Now learn how to share your story, understand the tech landscape better, and meet industry professionals.
- Concept 01: Self-Reflection: Design Your Blueprint for Success
- Concept 02: Debrief: Self-Reflection Exercise Part 1
- Concept 03: Debrief: Self-Reflection Exercise Part 2
- Concept 04: Map Your Career Journey
- Concept 05: Debrief: Map Your Career Journey
- Concept 06: Conduct an Informational Interview
- Concept 07: How to Request an Informational Interview
- Concept 08: Ways to Connect
- Concept 09: Ask Good Questions
- Concept 10: Debrief: Sample Questions Quiz
- Concept 11: Keep the Conversation Going
-
Lesson 02: Take 30 Min to Improve your LinkedIn
Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.
- Concept 01: Get Opportunities with LinkedIn
- Concept 02: Use Your Story to Stand Out
- Concept 03: Why Use an Elevator Pitch
- Concept 04: Create Your Elevator Pitch
- Concept 05: Use Your Elevator Pitch on LinkedIn
- Concept 06: Create Your Profile With SEO In Mind
- Concept 07: Profile Essentials
- Concept 08: Work Experiences & Accomplishments
- Concept 09: Build and Strengthen Your Network
- Concept 10: Reaching Out on LinkedIn
- Concept 11: Boost Your Visibility
- Concept 12: Up Next
-
Lesson 03: Optimize Your GitHub Profile
Other professionals are collaborating on GitHub and growing their network. Submit your profile to ensure your profile is on par with leaders in your field.
- Concept 01: Prove Your Skills With GitHub
- Concept 02: Introduction
- Concept 03: GitHub profile important items
- Concept 04: Good GitHub repository
- Concept 05: Interview with Art - Part 1
- Concept 06: Identify fixes for example “bad” profile
- Concept 07: Quick Fixes #1
- Concept 08: Quick Fixes #2
- Concept 09: Writing READMEs with Walter
- Concept 10: Interview with Art - Part 2
- Concept 11: Commit messages best practices
- Concept 12: Reflect on your commit messages
- Concept 13: Participating in open source projects
- Concept 14: Interview with Art - Part 3
- Concept 15: Participating in open source projects 2
- Concept 16: Starring interesting repositories
- Concept 17: Next Steps
-
Part 07 : Congratulations and Next Steps
Congratulations on completing all projects for this Nanodegree!
-
Module 01: Congratulations and Next Steps
-
Lesson 01: Congratulations!
Congratulations on completing all your projects!
-
Part 08 (Elective): SQL Project Additional Resources
-
Module 01: SQL Project Additional Resources
-
Lesson 01: Descriptive Statistics I
In 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 II
In 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?)
- 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 Started
In 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 Data
In 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 Data
In 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 Data
In 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
-
Part 09 (Elective): Data Visualization with Tableau
Learn to apply sound design and data visualization principles to the data analysis process. Learn how to use analysis and visualizations in Tableau to tell a story with data.
-
Module 01: Data Visualization with Tableau
-
Lesson 01: Introduction to Data Visualization
In 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: Design
In 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 Tableau
In 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 Tableau
In 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!
-
Part 10 (Elective): Introduction to HTML and CSS
Introduction to HTML and CSS syntax with problem sets.
-
Module 01: Introduction to HTML and CSS
-
Lesson 01: HTML Syntax
Set up your development environment for writing HTML and learn basic tags and syntax.
- Concept 01: Lesson Introduction
- Concept 02: HTML Structure Part 1
- Concept 03: Make Your First Element
- Concept 04: Environments
- Concept 05: Text Editors
- Concept 06: Browsers
- Concept 07: Workflow
- Concept 08: Trees
- Concept 09: HTML and Trees
- Concept 10: Spot the Bug
- Concept 11: HTML Research
- Concept 12: HTML Structure Part 2
- Concept 13: HTML Documents in Depth
- Concept 14: Lesson Wrap Up
-
Lesson 02: HTML Syntax Problem Set
Get practice creating HTML documents and writing tags with this collection of fun challenges.
- Concept 01: Welcome to the Problem Set!
- Concept 02: Make a Button
- Concept 03: Make a Button Solution
- Concept 04: Make All the Headers
- Concept 05: Make a List
- Concept 06: Tree to HTML
- Concept 07: Constructing Links
- Concept 08: Add an Image
- Concept 09: A Guide to Paths
- Concept 10: Figures
- Concept 11: Mockup to Website
-
Lesson 03: CSS Syntax
Learn the basics of CSS syntax and get started adding style to your websites.
- Concept 01: Getting Started with CSS
- Concept 02: What is CSS?
- Concept 03: CSS or HTML?
- Concept 04: CSS Rulesets
- Concept 05: CSS Syntax
- Concept 06: Comments
- Concept 07: Tag Selectors
- Concept 08: Attributes and Selectors
- Concept 09: Using Selectors
- Concept 10: Using CSS References
- Concept 11: Developer Tools
- Concept 12: Developer Tools on Different Browsers
- Concept 13: Quiz: Using Developer Tools
- Concept 14: CSS Units
- Concept 15: Units in CSS
- Concept 16: CSS Colors
- Concept 17: Identifying Colors
- Concept 18: Outro
-
Lesson 04: CSS Syntax Problem Set
Practice writing CSS and styling websites while exploring new properties in this problem set.
- Concept 01: Welcome to the Problem Set!
- Concept 02: Style an Image
- Concept 03: Style the Font
- Concept 04: Writing Selectors
- Concept 05: Using Attributes
- Concept 06: Attributes Workspace
- Concept 07: Slack Card
- Concept 08: Slack Card Workspace
- Concept 09: Udacity Site Header
- Concept 10: Udacity Site Header Workspace
- Concept 11: What is a Stylesheet?
- Concept 12: Link to a Stylesheet
-