Duration
Annual
Prerequisites
Procedural Programming or previous Python coding experience is recommended. If taking the course as part of the Data Science and Machine Learning Program of Study, Procedural Programming should be taken first.
Requirements
Students will be required to download SQLite, a free database engine. Download instructions will be provided in the course.
Course Summary
In this course, you will explore data and databases through the fictional pet services company Critter Sitters. By examining real-world examples, you will learn how data can tell a story and gain the skills to analyze and make decisions from it. You will also expand and apply your Python skills to data science principles, from data dashboards to statistical analysis. Additionally, you will learn about data management, including using and storing quality data and how to spot biases within it. You will uncover how to create a database, write queries, and explore strategies for securing databases. By the end of this course, you will have a foundational understanding of data and databases and the exciting career opportunities available in the data science field.
Topics and Concepts
Segment One:
• Generating stories with data
• Considering data and bias
• Working with data in Python
• Using Pandas and Python
• Types of data visualization
• Selecting data charts
• Constructing interactive dashboards
• Calculating probabilities
• Creating probability trees
• Using basic statistical terminology
• Data sampling
• Hypothesis testing
• Cognitive bias
Segment Two:
• Database basics
• Sorting data
• Using SQL commands to query data
• Filtering data
• Grouping data
• Designing databases
• Joining and transforming data
• Foreign and primary database keys
• Best practices for SQL databases
• Data privacy
• Types of cyber attacks
• Risk assessment