SQL Bootcamp

📝 Overview

This is a hands-on bootcamp to master Structured Query Language (SQL) through a set of mini-lectures and interactive practice sessions.

📅 Logistics

  • Date: Oct 26, 2024 (Saturday)
  • Time: 10 AM - 4 PM EST
  • Location: College of Computing Room 102
  • Organizers: Joy Arulraj and Shamkant B. Navathe (School of Computer Science)

📘 Course Materials

⏰ Schedule

⏰ Time Slot 🎯 Topic
10 - 11 AM 📘 Session 1: Basic SQL
  • 💡 Introduction to SQL
  • 🗂️ FROM
  • 🔍 WHERE
  • 📊 SELECT
  • 📑 ORDER BY
  • 🔢 LIMIT and OFFSET
  • ⚙️ Operators
  • 📐 Database Schema
11 AM - 12 PM 🛠️ Practice Session
12 - 1 PM 📘 Session 2: Mid-Level SQL (Part 1)
  • 🔗 JOIN
  • 📊 GROUP BY and HAVING
  • 📈 Aggregate Functions
  • 📅 DATE and TIME Functions
  • 📝 Data Modification Statements
1 - 2 PM 🍽️ Working Lunch + Practice Session
2 - 2:30 PM 📘 Session 3: Mid-Level SQL (Part 2)
  • 🧩 Nested Queries
  • ❓ Handling NULL
  • ✔️ EXISTS and UNIQUE functions
  • 🔐 Constraints
  • 🪟 Views
  • 🔄 Schema Modification Statements
2:30 - 3 PM 🛠️ Practice Session
3 - 3:30 PM 📘 Session 4: Advanced SQL
  • 🔄 Recursive Queries
  • 📜 Common Table Expressions
  • 🪟 Window Functions
3:30 - 4 PM 🛠️ Practice Session