Welcome to the first week of Back End 1. In this unit, we will learn:
- What are relational databases
- What are CRUD operations
- The basics of the SELECT statement for querying a database
- Filtering result sets with a WHERE clause
- Modifying data using INSERT INTO, UPDATE, and DELETE statements
- Some of the basics of SQL reporting, including ordering, paging, and limiting results
Back End Week 1 Goals
- Understand how applications use databases
- Prepare for next week when more complicated querying is discussed
Curriculum
This is your curriculum for Back End 1 Week 1.
1.1 SQL Basics
1.2 Modifying Data with SQL
1.3 Reporting with SQL
The reporting section is very long, and it is not critical that you complete it. Please complete the first section on ordering, limiting, and paging, and review the other sections as time permits.
Assignment
Your assignment for week 1 can be found Here
In addition to this assignment, please set up your machine for Ruby and Rails development. It is quite easy to set up Linux and Mac machines for Ruby and Rails development, but it is harder on Windows. Instructions for all three platforms are given Here. Please follow these instructions.