This course covers the fundamental concepts in database technology, including storage structures, access methods, recovery, concurrency, and integrity. The relational model and its implementation will be covered in depth together with an overview of SQL and its role in application development. The course will also present an overview of database administration, including modeling and design activities. A substantial part of the course involves the development of an understanding of database concepts.
Course Outcomes
- Define common database terminology.
- Create Entity Relationship Diagrams (ERD).
- Design and create a relational database using the normalization process.
- Use Structured Query Language (SQL) to manipulate data.
- Follow best practices in secure database design.