Database Management

A database is an organized collection of data, generally stored and accessed electronically from a computer system. The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. Database Management System provides the capability to govern a database function. The DBMS software additionally encompasses the core facilities provided to administer the database.

This course comprises 10 lessons covering database management. Each lesson includes a combination of open readings, YouTube videos, and hands-on learning activities.

Preparation

This is a second-semester, college-level course. Learners should already be familiar with introductory computer concepts and Information Systems concepts, and have advanced or proficient-level computer skills. Familiarity with database applications and database software is also helpful.

Lessons

1. Introduction
2. Query by Example
3. SQL
4. Advanced SQL
5. Data Definition Language
6. Data Control Language
7. Normalization
8. E-R Diagrams
9. Database Design
10. Database Functions
11. Database Administration
12. NoSQL
13. ODBC

See Also

• Databases
• Database Fundamentals
• Database Applications
• Database Software
• Wikibooks:Subject:Database management systems

Bibliography

• McFadyen, Ron. (2016). Relational Databases and Microsoft Access, 3rd Edition.
• Pratt, Philip J., and Adamski, Joseph J. (2012). Concepts of Database Management, 7th Edition. Cengage. ISBN 9781111825911
• Watt, Adrienne, and Eng, Nelson. Database Design, 2nd Edition. BCCampus.
• Wikibooks: Database Design
• Wikibooks: Structured Query Language