Study repository focused on SQL, relational databases, queries, joins and database design fundamentals.
This repository is part of my backend learning path. The goal is to practice how data is structured, queried and related in relational databases, using small examples and practical exercises.
The exercises cover important database concepts for backend development, including table creation, relationships, filtering, joins, aggregate functions and simple database design.
| Section | Topic | Description |
|---|---|---|
01-basic-queries |
Basic SQL | Create tables, insert data and select records |
02-table-relationships |
Relationships | Primary keys, foreign keys and related tables |
03-joins |
Joins | Combining data from multiple tables |
04-aggregate-functions |
Aggregations | COUNT, SUM, AVG, GROUP BY |
05-database-design |
Modeling | Small finance database model |
You can run these scripts using MySQL, MariaDB, DBeaver, MySQL Workbench or another SQL client.
Suggested order:
01-basic-queries/
02-table-relationships/
03-joins/
04-aggregate-functions/
05-database-design/
- Writing SQL queries
- Understanding relational database structure
- Designing simple tables and relationships
- Using joins to combine data
- Reading and organizing query results
- Building a stronger database foundation for backend projects
Developed by Luan Cabral.
- GitHub: @luancabral1
- LinkedIn: Luan Cabral
Repositório de estudos focado em SQL, bases de dados relacionais, queries, joins e fundamentos de modelagem de dados.
Este repositório faz parte do meu percurso de aprendizagem em backend. O objetivo é praticar como os dados são estruturados, consultados e relacionados em bases de dados relacionais, usando exemplos simples e exercícios práticos.
Os exercícios abordam conceitos importantes para desenvolvimento backend, incluindo criação de tabelas, relacionamentos, filtros, joins, funções agregadas e modelagem básica de base de dados.
Pode executar estes scripts usando MySQL, MariaDB, DBeaver, MySQL Workbench ou outro cliente SQL.