Working with Databases
Understanding why databases are important and how they’re used in various industries is key for any future developer. As we become more reliant on data, knowing how to design and use databases will be a valuable skill. Let’s talk about how we can use databases to solve real-world problems and help businesses thrive.
Updated
Introduction to Databases
- What is a Database? (Novice): A database is an organized place where an application stores its information so it can manage it and find it again quickly.
- Why Do We Need Data Storage? (Novice): Applications keep their data in a database to have it in one place, keep it accurate and secure, manage it quickly, and grow as the data grows.
What is an RDBMS
- What is an RDBMS (Novice): A relational database (RDBMS) stores data in tables of rows and columns, links tables with primary and foreign keys, and is queried with SQL.
Using MySQL
- MySQL Workbench (Novice): Connect to your local MySQL server with MySQL Workbench, load the northwind, sakila and world sample databases, and browse their tables.