Description

🗄️ INTRODUCTION TO SQL DATABASE DEVELOPMENT

Ages: 13–55
Duration: 6 Weeks
Price: £249
Level: Beginner Friendly
Ideal For: Teens, Adults, Career Switchers, and Small Business Owners

---

⭐ Course Overview

Learn the essential skill that powers every modern application — SQL database development.

In this beginner-friendly course, students will learn how to design databases, write SQL queries, store and manage data, and build simple real-world projects using MySQL or SQL Server.

This course is perfect for anyone preparing for a tech career, upskilling for work, or learning how databases support websites, apps, and business systems.

---

🎯 Who is this Course For?

This course is suitable for:

✔ Teens interested in Computer Science
✔ Adults preparing for tech jobs
✔ Professionals wanting data skills
✔ Business owners who want to manage their own data
✔ Beginners with no prior experience
✔ Anyone preparing for future courses (C#, Python, Web Dev, AI, etc.)

---

📘 Week-by-Week Course Syllabus

Week 1 — Introduction to Databases & SQL

• What is a database?

• Understanding tables, rows, columns

• Installing MySQL / SQL Server

• Running your first SQL command

• Creating your first database

---

Week 2 — Creating & Managing Tables

• Data types: INT, VARCHAR, DATE, etc.

• Creating tables

• Inserting data (INSERT INTO)

• Understanding Primary Keys

• Designing simple database structures

---

Week 3 — Querying Data (SELECT)

• Retrieving data with SELECT

• Filtering using WHERE

• Sorting results (ORDER BY)

• Limiting results

• Practical exercises: student records, products, sales

---

Week 4 — Relationships & Joins

• What are relationships?

• One-to-many, many-to-many

• Foreign Keys explained

• INNER JOIN, LEFT JOIN, RIGHT JOIN

• Build a small relational database project

---

Week 5 — Updating, Deleting & Grouping Data

• UPDATE & DELETE commands

• GROUP BY & Aggregate functions: COUNT, SUM, AVG, MIN, MAX

• Real business examples:

  • sales reports

  • attendance tracking

  • inventory analysis

---

Week 6 — Final Project & Database Design

Students build a small database system:

• School system

• Store inventory

• Employee management

• Expenses tracker

• Small business database

Project includes:
✔ Table design
✔ Sample data
✔ Queries
✔ Reports
✔ Presentation

---

🎓 Course Outcomes

By the end of this course, students will:

✔ Understand how databases work
✔ Write SQL queries confidently
✔ Design and build a relational database
✔ Create meaningful reports from data
✔ Gain practical skills useful for jobs, GCSE/A-Level, and software development
✔ Be ready for advanced programming courses

---

🧰 Requirements

• Laptop or Chromebook

• No experience required

• All software provided

---

🕒 Class Format

• 6 weeks

• 1 class per week

• 2 hours per session

• Tutor-led, hands-on coding

• Real-world exercises every class

---

💳 Payment Options

• Pay in full: £249

• Weekly plan: £45/week

• Accept: PayPal, Stripe, Bank transfer, Cash