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. Watch: PostgreSQL Crash Course

If you would like additional study material, you can also refer to the learning activities from the course materials of ITM 111, Introduction to Databases.

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: