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