Back to courses index

ISBP432: Advanced Database Systems Lab

Description:The objective of this course is to provide a practical introduction to the participants of the functions of database administrator. The participants are introduced to a professional environment where advanced database systems topics like scalability, optimization, and efficiency of information management and retrieval are tested.
Credit Hours.:1
Text Book: Ramakrishnan, R. &Gehrke, J., 2003, Database Management Systems, 3rd Edition, ISBN 0-07-115110-9.
Coordinator: Tony Ng
Topics Outline:
  1. Functions and Groups
  2. Using Multiple Tables and Sub Queries
  3. Optimizing Queries with Indexing
  4. Transaction Management
  5. SQL Tuning
  6. DB Backup
  7. Security and Permissions
  1. Develop skill to use Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL) and Transaction Control Language (TCL)
  2. Compare storage options
  3. Aptitude to optimize data retrieval using indexing
  4. Ability to tune SQL for better query performance
  5. Understand Data Backup and Security
Mapping of Topics Outline to Outcomes
 1 2 3 4 5 6 7
Co-requisite ISBP431: Advanced Database Systems
Volume of the Course that Contributes to CIT Students Outcomes(SOs)
Move the mouse over the Students Outcome number to view the Students Outcome text
a b c d e f g h i j k l m n
4% 6% 6% 0% 2% 0%2% 0% 27% 6% 27% 0% 13% 2%
Show Details