📊 SQL Database Management

This repository contains practical SQL exercises developed as part of my studies in Analysis and Systems Development (ADS).

The project focuses on fundamental database operations and data management techniques commonly used in software development and database administration.

---

🚀 Skills Practiced

• INSERT
• UPDATE
• DELETE
• ALTER TABLE
• CREATE TABLE
• Data Migration
• Data Cleaning
• Schema Evolution
• Database Maintenance

---

📂 Project Structure

sql-data-manipulation-project
│
├── datasets
│   ├── Tabela_fornecedores.csv
│   ├── Tabela_medicamentos.csv
│   ├── Tabela_lotes_estoque.csv
│   ├── Tabela_promocoes_temporarias.csv
│   ├── Tabela_podcasts.csv
│   ├── Tabela_episodios.csv
│   ├── Tabela_inscricoes.csv
│   └── Tabela_recomendacoes_temporarias.csv
│
├── sql_data_manipulation_project.ipynb
│
└── README.md

---

🛠 Technologies

• SQL
• Deepnote
• Relational Databases
• CSV Datasets

---

📚 Concepts Covered

Data Manipulation Language (DML)

• Insert records
• Update records
• Delete records
• Conditional filtering

Data Definition Language (DDL)

• Create tables
• Alter tables
• Drop tables
• Schema modifications

Database Maintenance

• Historical data cleanup
• Data migration
• Record archiving
• Table restructuring

---

🎯 Learning Goals

This project was developed to strengthen practical SQL skills and improve understanding of relational database management.

The exercises simulate real-world database administration and maintenance scenarios frequently encountered in software development projects.

---

👨‍💻 Author

Giovanna de Oliveira

Analysis and Systems Development

---

📌 Status

Completed