A290: SQL Programming
Fall 2009



Time & Location:

 Monday & Wednesday (MW) 6:30-7:45pm
Location: Lindley Hall (LH) 115

Instructor:

Jeremy Engle

jtengle
Office: Lindley Hall (LH) 401A
Office Hours: TR noon-1pm


Course Description

 The Structured Query Language (SQL) is a programming language used to create, maintain, and access relational databases, e.g. Microsoft Access, SQL Server, or Oracle. An increasing amount of daily activities from registering for classes to buying something on Amazon involves interaction, whether we know it or not, with a database. All of these interactions depend on programmers writing SQL to use the information in a database. This course will provide an introduction to designing a database, advantages of SQL, and how SQL is used in real information systems. The course will cover in more depth the different features of SQL and how to use them to write queries which get the desired information from a database.


Course Text Book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 2/E
Authors: John L. Viescas, Michael Hernandez
ISBN-10: 0321444434
ISBN-13: 9780321444431



Policies

 All students and work in A290 SQL Programming must adhere to the Computer Science Department's Academic Integrity policy. It is students' responsibilities to be familiar with all elements of the policy.

The "W" drop deadline for all second eight weeks course is November 24th.

If a student is going to miss an exam the instructor must be notified PRIOR to the day of the exam and arrangements will be made for making up the exam. Verification of the reason for missing the exam may be required.


Assignments

 All assignments will be posted and turned in through Oncourse.

Late Assignments

Late assignments may be turned in 24 hours after the deadline for a 5% penality or 48 hours after the deadline for a 10% penalty. After 48 hours, late assignments will not be accepted.


Grades

 Classroom Participation: 5%
Assignments and Projects: 75%
Final Exam: 20%


Resources