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.
- 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.