Class 7 Learning Objectives

Jump to bottom

Sarah Richardson edited this page May 10, 2017 · 2 revisions

By the end of this class students will be able to:

Explain what relational databases are used for and what SQL is
Perform CRUD (Create, Read, Update, Delete) operations using SQL queries
Explain what joins are used for
Describe the difference between the four types of joins: inner, left outer, right outer, and full outer
Write queries using joins
Utilize foreign keys
Explain the similarities between Python objects and database tables
Create tables with an understanding of one-to-many relationships