Programming for Data Science with Python

Nanodegree key: nd104

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.
  - Concept 01: FAQ
  - Concept 02: Support
- 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.
- Lesson 02: SQL Joins
  In this lesson, you will learn how to combine data from multiple tables together.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
  
  Project Description - Investigate a Relational Database
  
  Project Rubric - Investigate a Relational Database

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.

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.
  - Concept 01: Welcome to the Course!
  - Concept 02: Programming in Python
- 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.
- 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.
- 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.
- 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.
- 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.
- Lesson 07: NumPy
  Learn the basics of NumPy and how to use it to create and manipulate arrays.
- Lesson 08: Pandas
  Learn the basics of Pandas Series and DataFrames and how to use them to load and process data.
- 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.
  
  Project Description - Explore US Bikeshare Data
  
  Project Rubric - Explore US Bikeshare Data

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.
  
  Project Description - Post your Work on GitHub
  
  Project Rubric - Post your Work on GitHub

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.
- 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.
  
  Project Description - Improve Your LinkedIn Profile
  
  Project Rubric - Improve Your LinkedIn Profile
- 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.
  
  Project Description - Optimize Your GitHub Profile
  
  Project Rubric - Optimize Your GitHub Profile

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.
- 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.
- 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.
- 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.
- 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.
- Lesson 06: Spreadsheets 4: Visualize Data
  In this lesson, you'll learn to present data professionally using spreadsheets: charts, histograms, box-plots, and formatting.

**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.
- Lesson 02: Design
  In this lesson, you will learn about visual encodings, and best practices for building data visualizations.
- 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!
- 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.

**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.
- Lesson 02: HTML Syntax Problem Set
  Get practice creating HTML documents and writing tags with this collection of fun challenges.
- Lesson 03: CSS Syntax
  Learn the basics of CSS syntax and get started adding style to your websites.
- Lesson 04: CSS Syntax Problem Set
  Practice writing CSS and styling websites while exploring new properties in this problem set.