🗄️ Database Design & SQL

This project contains my work from Week 3 of my Data Technician Skills Bootcamp, focused on database design, relational databases and SQL.

📌 Project Overview

Week 3 introduced the principles of working with structured data and relational databases, with a focus on understanding how databases are designed, organised and managed.

The week provided practical experience with SQL and the core operations used to work with database records.

🧠 Skills Developed

🗃️ Database Design

• Understanding database structures
• Working with relational databases
• Understanding tables and relationships
• Structuring data effectively
• Introduction to database normalisation
• Understanding how data is organised within relational systems

💻 SQL

Developed practical knowledge of SQL and the core operations used to work with database records, including:

• CREATE – creating database structures
• SELECT – retrieving data
• INSERT – adding records
• UPDATE – modifying existing records
• DELETE – removing records

These operations provided a foundation for querying and managing structured datasets.

🔍 Data Skills

Through the exercises and practical work, I developed a better understanding of how data moves from a structured database into useful information.

Key areas included:

• Retrieving information from databases
• Managing database records
• Working with structured data
• Understanding relationships between data
• Writing SQL statements
• Applying database design principles
• Understanding the importance of organised and consistent data

🎯 What I Learned

Week 3 helped me understand the role that databases play in data analysis and how SQL can be used to interact with structured data.

It also helped build the foundation for later stages of the course, where SQL knowledge can be combined with tools such as Excel, Tableau, Power BI and Python to analyse and communicate data.

🛠️ Tools & Technologies

• 💻 SQL
• 🗄️ Relational Databases
• 📊 Structured Data
• 🐙 GitHub

📚 Course

Data Technician Skills Bootcamp

Week 3 – Database Design & SQL

This repository forms part of my ongoing Data Analysis portfolio and documents my progression throughout the bootcamp.

---

⭐ Next step: Continue developing my SQL skills and applying database knowledge to real-world data analysis projects.