data.md

Data

With this module, you'll learn about persisting data beyond a process in memory, including binary files and structured data stored in databases.

Topics

Types of Data

With this topic, you'll learn about the spectrum of unstructured to structured data types and how to classify data correctly.

Learning Outcomes

• Describe binary data
• Compare structured and unstructured data types
• Theorize what data types you might use in an application

Resources

• Structured vs. Unstructured Data Article

Exercises

• File to Hex

---

Data Storage

With this topic, you'll learn techniques to store data of all types for usage in an application.

Learning Outcomes

• Compare storing data in a relational and non-relational database
• Explain storing data using object storage providers such as AWS S3
• Describe three different approaches to persist data for an application

Resources

• 7 Database Paradigms Video
• AWS Databases Resource
• AWS Storage Resource
• Cloud Firestore Tool

Exercises

• Database Provisioning

---

Data Manipulation

With this topic, you'll learn how to interact with and manipulate data from storage providers using techniques such as SQL or SSH.

Learning Outcomes

• Explain what CRUD operations are
• Explain what relational database schema is
• Retrieve data from a database using a SELECT query
• Use an ORM to retrieve data from a database in an application
• Download a file from a server using SSH
• Create a new item in a database table using an INSERT INTO query
• Update an existing item in a database table using an UPDATE query
• Delete an existing item in a database table using a DELETE query
• Use migrations to update the schema of a database

Resources

• Database normalization Resource
• Normal Data Forms Video
• SQL Explained in 100 Seconds Video
• SQL playground Tool
• SQLZOO Tutorial
• Modifying Data with SQL Course ($)
• Querying Relational Databases Course ($)
• SQL Basics Course ($)

Exercises

• ORM Utilization

---

Data Wrangling

With this topic, you'll learn to convert data from one type to another using data wrangling techniques.

Learning Outcomes

• Describe the ETL (extract, transform, load) process
• Use a regular expression (Regex) to grep for IP addresses in log files
• Convert a WAV audio file to an MP3 audio file using FFmpeg

Resources

• Missing Semester: Data Wrangling Video
• Regex in 100 Seconds Video
• What is ETL? Article

Exercises

• FFmpeg Conversion

---

Managing State

With this topic, you'll learn about effectively using different patterns to manage the state in an application.

Learning Outcomes

• Describe application "state"
• Explain the factors to consider when caching data
• Describe the purpose of offline data storage
• Compare using global and local state in an application
• Compare eventual and strong consistency and explain their differences

Resources

• 3 Tips That Will Simplify Your Application State Management Article
• Caching in a PWA Tutorial
• Event-driven architecture Article
• Implementing a simple state machine library in JavaScript Article
• What do you mean by "Event-Driven"? Article
• What is caching? Article

Exercises

• Cache Buster