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.[1]

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

Preparation

edit

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

edit
  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

edit

Bibliography

edit
  • 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

References

edit