SQL Fundamentals

Course Description:

This SQL Fundamentals course, taught at Bridgerland Technical College, familiarizes students with concepts of relational databases and how to access data using SQL queries. During the course, a series of database application projects teach students to pull, filter, aggregate, and join data. Students will also learn how to restore a database, save queried data to a database, and learn basic navigation within the database. Students will build working knowledge and hands-on familiarity with SQL using industry software.

Course Contents: 

Course materials include a syllabus and an .imscc file. The syllabus includes an introduction, course description, course objectives, course activities, employment skills, and more. The .imscc file includes numerous folders and files from the Canvas course. Below is a list of modules and a sample of topics:

• Module 1 - Data Ethics
  • Introduction to Data Ethics
  • Fundamental Concepts of Data Interpretation
  • Interpreting Percentages
  • Grouping Data: Simpson's Paradox
  • Bias in Data and AI
  • Privacy Standards
  • Transparency & Accountability
• Module 2 - Introduction to Databases
  • Introduction to Databases Overview
    • Relational Databases
    • Relational Vs. Non-Relational
    • Module 2 Demo
  • Module 2 Assignment - ERD
• Module 3 - Setting up Your SQL Environment
  • Setting up Your SQL Environment Overview
    • Introduction to IDEs
    • Installing & Using DBeaver
• Module 4 - Introduction SQL Basics & Query Construction
  • Introduction SQL Basics & Query Construction Overview
    • Introduction to SQL & Relational Databases
      • SQLite & SQL Data Types
      • Basic SQL Query Structure
      • Formatting & Best Practices-2
• Module 5 - Introduction to Filtering & Sorting
  • Introduction to Filtering & Sorting Overview
    • Filtering Basics
    • Advanced Filtering
    • Module 5 Demo
• Module 6 - Introduction to Aggregates & Groups
  • Introduction to Aggregates & Groups Overview
    • Row Level Aggregations
    • Column Level Aggregations
    • Formatting Query Results
    • Aggregating Within Groups
    • Filtering Groups
    • Module 6 Demo
• Module 7 - Introduction to Joins
  • Introduction to Joins Overview
    • SQL Joins
    • Types of Joins
    • Multiple Joins
    • SQL Joins Demo
    • Types of Joins
    • Multiple Joins
    • SQL Joins Demo
• Module 8 - Final
  • Final Project Overview
• Bonus Material
  • CRUD Overview
  • SQL Subqueries