|
|
| Course Category: |
Computer Science/Information Technology |
| Course Level: |
Undergraduate |
| Credit Hours: |
3 |
| Pre-requisites: |
N/A |
|
| Introduction to Data and Information, Data Storage Mechanisms, 3-Tier Architecture and Process to Database Design, Fact Finding Techniques, Implementing Fact Finding Techniques, Process of Database Design, Relational Database, Conceptual Data Modeling and Entity Relationship Diagram Overview, Entities, Attributes and Relationship, Extended Entity Relationship Diagram (EERD), Example of Entity Relationship Diagram, Anomalies, Normalization, Denormalization, Introduction to Oracle 11g on Cloud, Using Data Definition Language (DDL) in Oracle 11g, Using Data Manipulation Language (DML) and Data Control Language (DCL) in Oracle 11g, Structured Query Language basics, Advanced SQL, Examples of SQL, Introduction to Sequence and Synonyms with implementation in Oracle 11g, Indexes in Databases Implementing Indexes in Oracle 11g, Transactions and Concurrency Problems in Databases, Locks and granularity in Databases. |
|
|
|
| Course Instructor |
Sheraz Pervaiz
MS in Software Technology Stuttgart University of Applied Sciences, Germany
|
| Books
|
Database Management Systems
by Raghu Ramakrishnan and Johannes Gehrke |
Database Modeling and Design
by Toby Teory, Sam Lightstone, Tom Nadaeu, H.V.Jagadish |
Database System by Thomas Connolly and Carolyn Beg |
Database System Concepts by Silberschatz-Korth-Sudarshan |
Data Modeling and Relational Database Design
by Jan Speelpenning, Patrice Daux, Jeff Gallus |
Oracle Database 11g: A Beginners Guider
by Ian Abramson, Michael Abbey, Michael J Corey and Michelle Malche |
Oracle Database 11g: SQL Fundamentals by Salome Clement, Brian Pottle, Puja Singh |
|