Overview
Course Title: Database Foundations Administration
Course Duration: 12 Weeks
Course Description:
This course introduces the foundations of database systems and provides comprehensive knowledge about database administration. Students will be proficient in database design, implementation, troubleshooting, maintenance, security, and more. They will learn using popular relational database management systems (RDBMS) and get hands-on experience with real-world database problems.
Course Objectives:
Upon completing this course, students will be able to:
- Understand the foundations of database systems and the principles of database design.
- Gain knowledge in using SQL for querying databases and manipulating data.
- Learn to administer a database, ensuring its performance, security, and availability.
- Develop an understanding of data modeling and normalization.
- Get hands-on experience with backup, recovery, and disaster planning techniques.
Course Content:
Week 1 & 2: Introduction to Database Systems
- Database Systems: An Overview
- Role and Responsibilities of a Database Administrator
- Understanding Data Models
- Relational Database Management System (RDBMS)
Week 3 & 4: Database Design and Data Modeling
- Data Modeling and ER Diagrams
- Understanding Normalization
- Database Design: Logical and Physical
Week 5 & 6: SQL and Database Querying
- Introduction to SQL
- DDL, DML, and DCL commands in SQL
- Advanced SQL Topics: Stored Procedures, Triggers, Indexes
Week 7 & 8: Database Administration
- Database Storage and Indexing
- Database Performance Tuning
- Database Backup and Recovery
- Transaction Management and Concurrency Control
Week 9 & 10: Database Security and Integrity
- Principles of Database Security
- User Management and Access Control
- Ensuring Data Integrity
- Auditing and Compliance
Week 11: Advanced Topics
- Introduction to NoSQL Databases
- Data Warehousing and OLAP
- Understanding Big Data and its Implications on Databases
Week 12: Course Review and Real-world Project
- Review of Key Topics
- Real-world Project: Design, Implementation, and Administration of a Database System
Methods of Instruction:
- Lectures
- Hands-on Lab Sessions
- Group Discussions
- Project-Based Learning
Assessment Methods:
- Weekly Assignments: 40%
- Mid-Term Exam: 20%
- Final Project: 30%
- Class Participation: 10%
Suggested Readings:
- “Database Systems: Design, Implementation, & Management” by Carlos Coronel and Steven Morris
- “SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL” by John L. Viescas and Michael J. Hernandez
Recommended Software:
- MySQL
- PostgreSQL
- MongoDB (For NoSQL)
Please note that this is an introductory course outline. The actual course material and the pace of teaching may vary based on the learning capabilities of the students and any changes in the technology trends up to the course delivery date.
Course Features
- Lectures 8
- Quizzes 0
- Duration 30 hours
- Skill level All levels
- Language English
- Students 35
- Certificate No
- Assessments Yes