Skip to content

HackYourFutureBelgium/sql-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

92 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published