SQL Fundamentals
Day 1: Introduction to Databases
- Setting up SQLite/MySQL.
- Basic SQL queries:
SELECT, INSERT, UPDATE, DELETE.
Day 2: Creating and Managing Tables
- Defining schemas with constraints.
- Relationships between tables (foreign keys).
Day 3: Joins and Aggregations
- Combining tables with joins.
- Aggregation functions:
COUNT, SUM, AVG.
Day 4: Subqueries and Views
- Writing subqueries and creating views.
Day 5: Project: “Student Enrollment Database”
- Design and query a database for managing students and courses.
- Features: Add students, enroll in courses, generate reports.