[Home]  -->[You are here: Managing Data(bases) using SQL]

This course provides students with an in-depth training of the core Structured Query Language (SQL). Emphasis is given to Data Query Language (DQL) and Data Manipulation Language (DML), however, Data Definition (DDL) and Data Control Language (DCL) are briefly covered. The information is presented using lectures with hands-on exercises to reinforce the concepts of SQL. Additional class exercises, tests, and projects are assigned to enhance the student's learning experience. Upon successful completion, students will be able to write and understand complex SQL statements and have a basic understanding of database operations. Basic course outline:

If you have any questions, please send an e-mail to the instructor

• Introduction and overview of SQL, Normalization rules
• The SELECT statement with all its clauses
• SQL datatypes, expressions, Nulls, and wildcard characters
• Complex filtering of data, Intersect, Difference, and Union
• Using multiple tables, Inner join, Left, Right, Full Outer join, self join
• SQL subqueries
• Group By Queries
• Data Manipulation statements(Insert, Delete, Update)
• Data Definition statements(Create, Drop, Alter)
• System privileges, object privileges, Grant and Revoke statements

Class Syllabus

Homework Assignments

Fall 2008 Agenda, Quizzes, Homework due dates

Resources

SQL references (books, web sites)

Install Oracle Express Edition 10g

Installation script to create student schema

HR Sample data in MS Acces (zip file)

HR Sample data ERD

SQL Server Migration Assistant for Access