Database Fundamentals

From Wikiversity
Jump to navigation Jump to search

Database Fundamentals introduces database concepts, including relational databases, tables and data types, data selection and manipulation, views, stored procedures, functions, normalization, constraints, indexes, security, and backup and restore.

This course is comprised of 12 lessons covering database fundamentals. Each lesson includes a combination of Wikipedia readings, YouTube videos, and hands-on learning activities. The course also assists learners in preparing for Microsoft Exam 98-364: Database Fundamentals certification.

Preparation[edit]

This is a second-semester, college-level course. Learners should already be familiar with Information Systems concepts. Familiarity with Database Software is also helpful.

Lessons[edit]

  1. Introduction
  2. Tables and Data Types
  3. Selecting Data
  4. Manipulating Data
  5. Views
  6. Stored Procedures
  7. Functions
  8. Normalization
  9. Constraints
  10. Indexes
  11. Security
  12. Backup and Restore

See Also[edit]

References[edit]

Sciences humaines.svg Educational level: this is a tertiary (university) resource.
Fileshare.png Type classification: this resource is a course.