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:
README.md: the theory to cover this week. This is where you should start. Some of the content may link to external resources
EXERCISES.md: the instructions for each week's assignment
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
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:
README.md: the theory to cover this week. This is where you should start. Some of the content may link to external resourcesEXERCISES.md: the instructions for each week's assignmentLESSONPLAN.md: this document is meant for mentors as a referenceLearning 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:
Structured Query Language(SQL)MySQL, as an example of a relational database systemAgenda
- Introduction to the relational model
- Introduction to SQL: retrieving data
- Implementation of a domain: identifiers, constraints, relationships
Week 1
I Need Help With:
What went well?
What went less well?
Lessons Learned
Sunday Prep Work
---- END CHECK-IN TEMPLATE ---->