CSE 340: Web Backend Development

Learning Activity (1 of 2): SQL Basics

Overview

The foundation of all dynamic Web applications is some kind of data storage. In this course, you will use a relational database and making use of SQL.

This week will focus on foundational SQL concepts and it will help you set up the database you'll need for your semester project. It is not a substitute for a complete course on Databases, but it will give you enough information to be successful in this course, even if you haven't take a database course yet.

Prepare

Read/watch the following preparation material:

  1. Watch: Relational Database Terms
  2. Read: Introduction to SQL, Chapter 1 (Available free through the Library subscription).
  3. Watch: PostgreSQL Crash Course

Submission

When you have completed all of the learning activities for this week, you will return to Canvas and submit the associated quiz there.

Up Next

Other Links: