Department Homepage  Course Listings Degree Options Department Information Home Department Listings eSchedule Catalog Home Home
 
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 2014
    0532
    Wallace Fisher
    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.