Ilya Rogov

To access password protected posts, please check the blackboard for the password.

Using the moviedb database, answer the following questions:

1. List the actors who starred in the oldest movie?

2. Which movie has been rented the maximum number of times?

2a Also, list all customers who […]

Assignment: SQL #2 Putting Data Into a Database

Click here for a copy of the assignment. This is due on Wednesday – October 3, 2012. Please submit a printout of your answers at the beginning of class.

Click here for instructions on the inclass exercise. Please make sure to note your MySQL login and password from the gradebook before coming to the lab.

Pls note the following office hours for the SQL 1 assignment.

1. I have my office hours after class today from 3-4pm in Speakman 201 E

2. The TA will have office hours in Alter Hall 603 (Laptop Lab) tomorrow […]

Think for about 100 seconds what you learnt in class during week 5 and summarize your thought here.

Click here for class captures by date:

September 17, 2011

September 19, 2011

September 21, 2011

Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.

Click here for a copy of the presentation slides.  We’ll cover this in week 5.

In this lecture, we’ll discuss the use of Structured Query Language (SQL) to performs operations related to creating and deleting […]

Assignment: SQL (Getting Data out of the Database) – Due Date 9/26/2012

For this assignment, you will be working with the same movie rental database as your in-class exercise. The schema is also the same, so […]

Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.

Click here for instructions on the inclass exercise. Also, you can view the complete schema of the database here.