Database Fundamentals

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

* * *

Download Learning Guide

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 comprises 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 | edit source]

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 | edit source]

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 | edit source]

* Databases
* Database Applications
* Database Software
* Exam 98-364: Database Fundamentals
* Information Systems

## References

[edit | edit source]

* Microsoft: Database Fundamentals Exam Details
* Microsoft Official Academic Course (2011). Exam 98-364: Database Administration Fundamentals. Wiley. ISBN 9781118026885
* Microsoft Virtual Academy: Database Fundamentals

| Educational level: this is a tertiary (university) resource.

|