|
Master
Course Outline
CS 246
SQL and Relational Database Programming
|
| Credits: 5 |
Clock Hours per Quarter: 50
AA Discipline:
Lecture Hours:50
|
Description
Database design concepts are applied in programming environment. Focuses on learning and applying the SQL programming language to efficiently define, access, update and retrieve information from a database in a server based environment. |
Intended Learning Outcomes
Understand and develop a practical working knowledge of SQL's Data Definition, Manipulation and Control Languages.
Understand optimization techniques to speed up and simplify transactions.
Understand and enforce data integrity rules.
Understand and implement functions, subqueries and views.
Develop and test simple SQL based applications.
Understand how SQL relates to Database Adminstration.
Develop an understanding of advanced data access including embedded code.
Gain experience using SQL in an application programming environment.
|
Course Topics
Gain experience using SQL in an application programming environment
How to optimization techniques to speed up and simplify transactions
Enforcing data integrity rules
Advanced data access including embedded code
|
|
|
Syllabi
Listing
See ALL Quarters
| Course |
Year
Quarter
|
Item
|
Instructor |
|
| CS 246 |
Spring 2013 |
0519 |
Wallace Fisher |
|
| CS 246 |
Spring 2012 |
0583 |
Wallace Fisher |
|
| CS 246 |
Spring 2010 |
0583 |
James Adamski |
|
|
Two Year Projected Schedule
| Year
One* |
Year
Two** |
Fall |
Winter |
Spring |
Summer |
Mini |
Fall |
Winter |
Spring |
Summer |
Mini |
|
|
X
|
|
|
|
|
X
|
|
|
|
*If fall quarter starts on an odd year (2003, 2005, etc.), it's Year One.
**If fall quarter starts on an even year (2002, 2004, etc.), it's Year Two.
printable version
|
|
