CSCI 2105 Advanced Database with SQL

Description

Advanced Database Concepts with SQL introduces a comprehensive look at SQL (Structured Query Language) which is a programming language that is used by diverse groups of programmers today. Learning of SQL commands and database design and the many uses of SQL.

Credits

3

Prerequisite

CSCI 1102 and ACCT 1122

Topics to be Covered

1. Advanced database designing

2. Creating multiple table queries

3. Updating and creating new tables from existing tables

4. Database administration

5. SQL functions and procedures

6. Oracle databases

7. Functions and procedures

Learning Outcomes

1. Advanced database designing

2. Creating multiple table queries

3. Updating and creating new tables from existing tables

4. Database administration

5. SQL functions and procedures

6. Oracle databases

7. Functions and procedures

Credit Details

Lecture: 3

Lab: 0

OJT: 0