sql-database

[!WARNING] This module is under development

sql-database

Databases module of HackYourFuture Belgium’s Sunday classes, 2024 edition

In the world of data management and database systems, SQL (Structured Query Language) is fundamental technology that plays a crucial role. SQL is a standardized programming language used for managing and querying relational databases, while MySQL is one of the most popular open-source relational database management systems that can be used with various programming languages.

In this module, we will delve into the world of SQL and MySQL, exploring their importance, usage, and key concepts.

Repository content

This modules is planned for 3 weeks. For each week, you will see:

1. README.md: the theory to cover this week. This is where you should start. Some of the content may link to external resources
2. EXERCISES.md: the instructions for each week’s assignment
3. LESSONPLAN.md: this document is meant for mentors as a reference

Learning goals

In this module, you will learn the fundamentals of Databases, with a focus relational databases (SQL). By the end of it, you’ll be comfortable with:

• What a database is and its role is an application
• How to work with Structured Query Language (SQL)
• How to design a simple relational model and create its SQL representation
• Hands on experience with MySQL, as an example of a relational database system

Agenda

Week	Topics	Readings	Exercises	Lesson Plan
1	- Introduction to Databases - Introduction to the relational model - Introduction to SQL: retrieving data	Week 1 Readings	Week 1 Exercises	Week 1 Lessonplan
2	- Keys and constraints - Creating your first database	Week 2 Readings	Week 2 Exercises	Week 2 Lessonplan
3	- Manipulating data - Others: views, triggers, transactions	Week 3 Readings	Week 3 Exercises	Week 3 Lessonplan

License

HackYourFuture - SQL Databases Module © 2024 by HackYourFutureBelgium is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International.