Digital-CSP-Week-7-Tuesday-AWS- RDS.pptx

Breaking down AWS RDS concepts with Marvel characters

1. Tuesday - ❄️ Freeze the Rows, Chill the Columns: Intro to Amazon RDS Iceman Powers Up Relational Databases 🔔09/16 - Tuesday Bell Ringer - 🧩 Freeze-Frame Warm-Up: Everyday Data Detective (AWS Services (AS)) ‹#›

2. ‹#› 🧊 Iceman vs. the Data Avalanche: Why SQL Still Rules “Structure, relationships, and ACID keep mission-critical data rock-solid.”

3. ‹#› Standard Check “IT-CSP 3.4 : Identify AWS database services (RDS) and apply console/module steps appropriately.”

4. ‹#› Lesson Target “I can explain what Amazon RDS is and apply core relational concepts (tables, rows, columns, keys, relationships) to a real scenario.”

5. What is Relational Database Service (RDS)? AWS RDS automates provisioning, patching, backups, recovery Managed relational DB service on AWS. Uses SQL (Pronounced Sequel ) Choose engines: MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, Aurora. ‹#›

6. ‹#› Categories Rows Columns Data - Searched, Queried, Organized

7. SQL? What is that? Think of your school’s library or cafeteria menu. Books or meals = data Shelves or menus = tables Check-out desk or cashier = the database system When you want information (e.g., “all books by Jason Reynolds” or “every vegetarian lunch”), you ask a question. ‹#›

8. SQL? What is that? SQL is simply the language you use to ask and manage those questions inside a database. Instead of saying “Hey librarian, give me all Jason Reynolds books,” you write it in SQL. Example: ‹#›

9. ‹#›

10. SQL Terminology ‹#› SQL TERM Definition Table A spreadsheet or list (like a class roster) Row One entry (One student’s record) Column A single category of info (like name or class grades) Query A question or command (“Show me all seniors with GPA > 3.5”)

11. Core Things SQL Can Do ‹#› Read data: “Show all students in 11th grade” → SELECT Add data: “Enroll a new student” → INSERT Update data: “Change a student’s address” → UPDATE Remove data: “Delete graduates from last year” → DELETE

12. Why SQL Matters ‹#› These four commands— SELECT, INSERT, UPDATE, DELETE —are the building blocks of almost every database job. Websites like Instagram or YouTube use SQL behind the scenes to fetch posts or store comments. Businesses (from Netflix to banks) rely on it to keep data accurate and easy to find.

13. Everyday Uses 💡 ‹#› School Info System / Gradebooks – accurate attendance & GPAs Finance – bank balances and transactions Inventory – tracking parts or cafeteria supplies .

14. “Vocabulary” - Foundations 💡 ‹#› 🗄️ Relational Database (RDBMS) : Stores data in tables with rows/columns and defined relationships; Supports SQL and ACID transactions. 🛠️ Amazon RDS: Managed AWS service that sets up, operates, and scales relational databases (MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora). It automates provisioning, patching, backup, and recovery.

15. “Vocabulary” - Keys & Integrity 💡 ‹#› 🔑 Primary Key: Uniquely identifies each row. 🧩 Foreign Key: Links rows across tables; enforces relationships. ✅ ACID Transaction: All-or-nothing operations ensuring consistency (Atomicity, Consistency, Isolation, Durability). 🧭 Schema : Defined structure (tables, fields, types, relationships).

16. “Vocabulary” - Keys & Integrity 💡 ‹#› Online Transaction Processing (OLTP) : Processes data from transactions in real time. Online Analytical Processing (OLAP) : Processes complex queries to analyze historical data

17. 🍧 ACID: Keeping Data Solid Under Pressure ‹#› A C I D Atomicity - A ll or nothing Consistency - Rules or never broken Isolation - Each action stands alone Durability - Changes last

18. 🍧 ACID in RDS ‹#› A C I D “ACID is a way databases keep data reliable—like making perfect ice cubes every time.” “Atomicity = the database saves all parts of a change or none at all, so we never get half-updated information.” “ Consistency means every update follows the rules—think ‘no water leaks in the ice mold.’” “ Isolation means two people can update different parts of the data at once without getting mixed results.” “ Durability means data stays correct even if the power goes out.”

19. ‹#›

20. 🍧 ACID: Ice man Examples ‹#› A C I D Like turning water to ice: the whole cube freezes or it doesn’t—no half-frozen cubes Your freezer always makes solid ice; no slushy surprises. Each ice cube tray freezes separately so they don’t mix flavors. Once frozen, the cube stays solid even if the freezer door opens.

21. 🗄️ Core Relational Concepts — The Organized Ice Cube Tray ‹#› Tables = Ice Cube Trays Hold data neatly (like each cube = a student record). Rows = individual cubes (records) Columns = ingredients (name, grade, GPA) Primary Key 🔑 A unique label for each cube so nothing melts together. Foreign Key 🌐 A cross-link to another tray (connects Students table to Classes table).

22. 🗄️ Core Relational Concepts — The Organized Ice Cube Tray ‹#› Joins ➕ Snap two trays together to see how they match (which student is in which class). ACID ❄️ Reliability recipe so data stays solid: All or nothing Correct every time Independent changes Data stays safe

23. High Availability & Regions ‹#› Multi-AZ deployments for resilience; automated backups; Snapshots or Point-In-Time restore functionality Multiple AZs

24. When Your Data Is/Has When to choose RDS vs. NoSQL ‹#›

25. RDS Overview: Understanding Amazon Relational Database Service (RDS) ‹#›

26. Story Time: ❄️ “Blizzard of Business Rules” ‹#›

27. ‹#› Background: Bobby Drake (Iceman), tasked with securing the X-Academy Student Information System. Goal: Accurate grades, schedules, and transcripts with auditable changes. Story Time: ❄️ “Blizzard of Business Rules”

28. ‹#› Challenge: Prior ad-hoc spreadsheets caused data loss and inconsistent results when multiple staff edited at once. Impact : Report cards delayed and scholarship risk for seniors. Story Time: ❄️ “Blizzard of Business Rules”

29. ‹#› Need: A managed relational database with transactions, backups, and point-in-time recovery. “Amazon RDS manages backups, patching, and failover so staff focus on data integrity, not server upkeep. Schools, hospitals, and banks rely on relational databases for rules-heavy workflows.” Story Time: ❄️ “Blizzard of Business Rules”

30. 🕒🔧 Why Managed RDS Matters: Saving Time & Boosting Reliability ‹#› Time Savings ⏳ No need to babysit servers – AWS handles setup, updates, and patches. ⚡ Automatic backups & snapshots – no manual scheduling. 🧩 Quick scaling – add capacity with a few clicks instead of buying hardware.

31. 🕒🔧 Why Managed RDS Matters: Saving Time & Boosting Reliability ‹#› Reliability 🛡️ High availability built-in – Multi-AZ deployment keeps data safe if one site fails. 🔁 Automatic failover – service switches to a backup server without downtime. 🧊 Consistent performance – AWS monitors and optimizes the system 24/7.

32. 🕒🔧 Why Managed RDS Matters: Saving Time & Boosting Reliability ‹#› “A small school IT team may only have two or three people. If they spend all day patching servers and running backups, they can’t focus on things like cybersecurity or student apps.” “RDS removes repetitive chores, and Multi-AZ design means data is safe even during hardware failures.”

33. Brief Summary RDS = managed relational database; AWS handles heavy lifting (provisioning, patching, backup). Use when you need joins, relationships, and ACID. Multi-AZ and backups support availability and recovery. ‹#›

34. Check-In: 🦸‍♂️ Can Iceman Close the Gradebook Gap? “With RDS (PostgreSQL), Iceman gets transactions for grade changes, foreign keys for course ↔ student integrity, and automated backups for audit requests. Problem: solved.” ‹#›

35. Exit Ticket ‹#› 🔚 09/16 - Tuesday - “Exit Ticket: 🚪❄️ Final Freeze Check