Course Description
This course covers database concepts, logical models, and internal data models (network, hierarchical, relational). It also covers the use of database management systems, database administration and SQL.
Learning Objectives
- Demonstrate an understanding of Database terminology.
- Understand the difference between traditional file systems and database systems.
- Know the advantages and disadvantages of file systems and database systems.
- Demonstrate knowledge of database systems types and the DBMS functions.
- Demonstrate an understanding of the database system environment.
- Understanding why database design is important.
- Understand the characteristics, advantages and disadvantages of the main database models: Hierarchical, Network, Relational, Entity-Relationship and Object-Oriented.
- Demonstrate knowledge of the E-R Model details (characteristics, design, and normalization).
- Demonstrate knowledge of Relational Model details (characteristics, design, normalization, data structure and implementation).
- Demonstrate knowledge of the steps in the database development process.
- Demonstrate an understanding of how basic and intermediate-level database queries are expressed using the Structured Query Language (SQL).
- Demonstrated an understanding of how tables are created with SQL*PLUS.
- Apply Security principles to design and development of database systems and database structures.
- Describe common security models of database management systems.
- Identify and describe common security concerns in database management systems.