SQL Sandbox

CS 411 is a databse systems class. Therefore, we feel as though it's important for you to be able to experiment with different queries and SQL practices whenever you'd like. Additionally, the output you receieve should be easy to read, fast, and user friendly.

The SQL sandbox is geared towards doing just this- allowing you to play around with our own example tables.

SQL Tables For Querying

We have three tables that you can query from in the sandbox: Courses, Enrollments, and Students.

Courses

CRN - INT

Title - VARCHAR(255)

Department - VARCHAR(100)

Instructor - VARCHAR(255)

Enrollments

NetId - VARCHAR(10)

CRN - INT

Credits - INT

Score - REAL

Students

NetId - VARCHAR(10)

FirstName - VARCHAR(255)

LastName - VARCHAR(255)

Department - VARCHAR(100)

The Sandbox