/sqlintro

SQL Exercises for CTD Students

Primary LanguageRuby

Ruby on Rails Introduction to SQL

This repository is to be used for lessons 1 and 2 of the Code the Dream Ruby on Rails class. The lesson material and assignments are linked below. These lessons introduce SQL.

Lesson 1
Assignment 1
Lesson 2
Assignment 2

Lesson 1 Learning Objectives

  • Understand what relational databases are
  • Learn what SQL is
  • Understand why this is important to the back-end developer
  • Know the CRUD operations
  • Learn the SQL used in query operations: SELECT, constraints, ordering
  • Understand primary and foreign keys
  • Learn the SQL needed for joins

Lesson 2 Learning Objectives

  • Learn to do SELECT queries that aggregate data: sums, averages, etc.
  • Learn how the SELECT query is processed: order of operations
  • SQL for adding, modifying, and deleting entries
  • SQL for managing database schema: creating and modifying tables