🗄️ SQL Database Project

During my Data Technician Bootcamp, SQL has helped me develop a stronger understanding of how data is stored, organised and analysed within relational databases. 💻

🔗 I practised creating tables, using primary and foreign keys, inserting data and writing SQL queries to retrieve and work with information.

📊 This project strengthened my understanding of database relationships, data organisation and data analysis, giving me practical experience in working with structured data and supporting data-driven decision-making. 🚀

🔗 SQL Cross Join Project

This project helped me understand how SQL can combine data from multiple tables. 💻 I used a CROSS JOIN to combine the Customer and Orders tables, creating a result that pairs each customer with every available order.

📊 This strengthened my understanding of SQL queries, relational data and table relationships, while showing how SQL can be used to bring information together for further analysis. 🚀

🗄️ SQL Sales Database Project

This project helped me develop practical SQL database skills by creating a sales table and inserting structured sales data. 💻 The dataset included product names, prices, quantities, invoice months and cities, allowing me to practise working with business data

🔨 I used SQL to create tables, define data types and insert multiple records into a database.

📊 Core skills learnt:

Creating SQL tables
Inserting records
Working with data types
Handling product and sales data
Organising structured data
Preparing data for analysis
Understanding how databases store business information

💡 Key focus: Building a strong foundation in SQL and learning how sales data can be stored, queried and analysed to produce useful business insights. 🚀

Page updated

Google Sites

Report abuse