BCS Courses

 

Ready to Apply?
File your application
online through SUNY's
website.
Apply Now

 
Home :: Academics :: School of Business :: Computer Systems Homepage :: BCS Courses :: BCS 360: Programming in SQL

BCS 360: Programming in SQL



The second in a two course sequence applies the knowledge of BCS260 to administer and implement a relational database system. Topics covered may include: embedded SQL; PL/SQL; advanced/optimized SQL queries; transaction management including concurrency and recovery; schema refinement; higher-level normal forms; integrity; security; and database administration development. Credits: 3.00

Prerequisite: 

BCS 260 with a grade of C or better.

Course Objectives:

At the completion of this course, students will:

    1. Understand and use the database access language SQL in a command line interface on DEC VAX system.
    2. Understand data integrity concepts and write SQL declarative constraints to provide integrity within Oracle database.
    3. Know how to use a view as a security device to restrict user accessibility; and to allow DML operations to base tables through a view.
    4. Understand the notion of a transaction in Oracle using savepoint, commit, and rollback, explicit/ implicit commit.
    5. Describe concurrency, consistency and general licking concepts.
    6. Understand the benefits of PL/SQL blocks and code examples in the database using "JustLeeBook" in the text.
    7. Understand the use of cursor as used in: PL/SQL block and C++ application program.
    8. Know the logical & physical structures of the database: the Tablespaces and physical data files; schema objects in user's domain: tables, view, indexes, sequences, etc.; data storage: data blacks, extents, segments; segments: data, index, rollback, temporary, bootstrap, extents: initial, next and storage size.
    9. Describe the security features to proved access to database objects via privileges and roles. 

 Textbooks:

Morris-Murphy - Oracle 9I: SQL with an Introduction to PL/SQL.
Course Technology - ISBN - 0619212845