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.

PreparationEdit

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.

LessonsEdit

  1. Introduction
  2. Query by Example
  3. SQL
  4. Advanced SQL
  5. Normalization
  6. Database Design
  7. Database Functions
  8. Database Administration
  9. NoSQL
  10. ODBC

See AlsoEdit

BibliographyEdit

  • 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

ReferencesEdit