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.
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.
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.
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.
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.