With this module, you'll learn about persisting data beyond a process in memory, including binary files and structured data stored in databases.
With this topic, you'll learn about the spectrum of unstructured to structured data types and how to classify data correctly.
- Describe binary data
- Compare structured and unstructured data types
- Theorize what data types you might use in an application
With this topic, you'll learn techniques to store data of all types for usage in an application.
- 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
With this topic, you'll learn how to interact with and manipulate data from storage providers using techniques such as SQL or SSH.
- 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
- 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 ($)
With this topic, you'll learn to convert data from one type to another using data wrangling techniques.
- 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
With this topic, you'll learn about effectively using different patterns to manage the state in an application.
- 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