1

Introduction to Data Science and Databases

Description

Setting the Foundation - Description: This day introduces the core concepts of data science and the role of databases. You'll learn what data science is, its applications, and why SQL is crucial. You'll also learn the basics of databases: what they are, different types (relational vs. NoSQL – briefly), and why relational databases (and SQL) are common. - Resources/Activities: - Expected Outcomes: Understand the fundamentals of Data Science and the role of databases. Be able to define "database" and "SQL" in simple terms.

Available

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
2

SQL Fundamentals: SELECT and WHERE

  • Description: This day dives into the basics of SQL. You'll learn about SQL syntax, the SELECT statement (how to retrieve data), and the WHERE clause (how to filter data). Focus on understanding table structures and identifying columns. - Resources/Activities: - Expected Outcomes: Be able to write basic SELECT queries to retrieve data from a table and use the WHERE clause to filter the results. Understand table structure and identify data types.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
3

SQL Fundamentals: Operators and Ordering

  • Description: Building on Day 2, you'll learn about different SQL operators (=, <>, >, <, >=, <=, AND, OR, NOT) for more complex filtering, and the ORDER BY clause for sorting the results. - Resources/Activities: - Expected Outcomes: Be able to use various SQL operators for filtering, including logical operators. Be able to sort results using ORDER BY.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
4

Data Management Basics: Data Types, and Normalization (Overview)

  • Description: Introduce data types and how they are used for different kinds of data. Briefly introduce the concept of data normalization, emphasizing the importance of well-structured data. It is a very high level overview only. - Resources/Activities: - Expected Outcomes: Understand what data types are and the importance of choosing the correct ones. Have a high-level understanding of data normalization.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
5

SQL: Aggregate Functions and Grouping

  • Description: Learn about aggregate functions (e.g., COUNT, SUM, AVG, MIN, MAX) for summarizing data and the GROUP BY clause for grouping results. - Resources/Activities: - Expected Outcomes: Be able to use aggregate functions and GROUP BY to perform basic data analysis (e.g., calculating the average price, counting the number of items).
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
6

Joining Tables: `INNER JOIN`

  • Description: Learn about joins, specifically the INNER JOIN. Understand how to combine data from multiple tables based on a common column. This is fundamental for working with relational databases. - Resources/Activities: - Expected Outcomes: Understand how to use INNER JOIN to combine data from different tables. Be able to write join queries.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
7

SQL Practice and Review

  • Description: This day is for consolidating your learning through practice and review. You will perform more complex queries using the skills learned throughout the week. - Resources/Activities: - Expected Outcomes: Solidify your understanding of SQL fundamentals, including SELECT, WHERE, operators, aggregate functions, and joins. Gain confidence in writing SQL queries. Identify areas for future learning.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises

Share Your Learning Path

Help others discover this learning path