Description

Overview

This course will teach students about information systems risk. Topics covered include risk identification, assessment, evaluation, response, and monitoring, as well as information systems control design and implementation.

Series Taught By: John Glover

Available CEUs for Course Series Completion: 6
Students can earn up to 6 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More

Course Details

  • 12:11:00 Hours
  • 12 Months Access
  • Presented by highly qualified, industry leading experts

About this Course

In this series of videos, we will cover key concepts and best practices for designing a relational database. Many problems that arise in using databases can be traced back to poor initial design. We will walk through the entire design process, from initial concept, through the design phase, ending with a fully functional database. This course is not platform specific; however, some concepts are demonstrated with Access on Windows operating system.

Objectives

  • Understand the database development process
  • Understand the relational model and relational database management system
  • Assess data and information requirements
  • Construct conceptual data models
  • Develop logical data models

Audience

  • Candidate planning to enroll for this course should have mastered the fundamentals of programming and basic data structures.

Your Content Goes Here

Course Outline

Top of Form

RELATIONAL DATABASE BASICS

  • Overview
  • History, Terms And Definitions
  • History, Terms And Definitions Part 2
  • Data Normalization
  • Data Normalization Part 2
  • Data Normalization Part 3

DESIGNING THE DATABASE

  • Designing A Database
  • Designing A Database Part 2
  • Designing A Database Part 3

CREATING MODELS

  • Creating Database Models
  • Creating Database Models Part 2
  • Finalizing The Model

DATA INTEGRITY

  • Entity Integrity
  • Referential Integrity
  • Referential Integrity Part 2
  • Domain Integrity
  • Domain Integrity Part 2
  • Domain Integrity Part 3
  • Domain Integrity Part 4

QUERY BASICS

  • Getting Started With Queries
  • Getting Started With Queries Part 2
  • Getting Started With Queries Part 3
  • Querying Multiple Tables
  • Querying Multiple Tables Part 2
  • Querying Multiple Tables Part 3