Week 7: C.R.U.D

🗓 Week of October 15

Concepts

PART 1

SQL Basics

C.R.U.D stands for Create, Read, Update, Delete, which are the four basic functions of an SQL Database. We will learn how to make queries for all four functions.

View

Lynda

Programming Foundations: Databases

Discover how a database can benefit both you and your architecture, whatever the programming language, operating system, or application type you use.

View

Practice

In-Class Exercise

Querying Seussology DB

You do not like them, so you say, try them, try them, and you may. Try them and you may, I say.

It is time to test our your SQL querying skills by retrieve records from the Seussology Database.

View

Individual Assignment

Blacksmith DB

Seussology DB

For this assignment you will be demonstrating your skills and understanding of SQL Queries by creating queries that create, read, update, and delete data from the Blacksmith Seussology Database.

View on GitHub Classroom

Independent Study

PluralSight

The Sequel to SQL

Watch the first three parts of this five-part course and learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.

Watch