Databases: Relational

4 hours of instruction

An introduction to relational databases and how relational databases can help shape your production-ready application.

OBJECTIVES

1. Learn the fundamentals of databases and the relational model for database management
2. Connect and interact with a database with SQL queries
3. Learn to build your own databases and keep them updated

PREREQUISITES

Backend: Python

SYLLABUS & TOPICS COVERED

1. Intro To Databases And The Relational Model
   • Introduction to the relational model
   • Connecting to your database and autoloading tables
   • Understanding and querying your tables
   • Handling a ResultSet
2. Creating And Manipulating Databases
   • Creating databases and tables
   • Constraints and data defaults
   • Updating data in your tables
   • Deleting data and tables from your database

SOFTWARE REQUIREMENTS

Database software/Snowflake, Terminal, Text editor