CIW

Database Design Specialist

(UMAG-CSCU373.AC1)
Lessons
Lab (Add-on)
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to Databases

  • Introduction to Databases
  • Data Formats
  • What Is a Database?
  • File-Based Databases
  • The Evolution of Databases
  • Relational Databases and Database Management Systems (DBMSs)
  • Origins of Relational Databases
  • Lesson Summary
  • Optional Lab
2

Relational Database Fundamentals

  • Introduction to Relational Databases
  • Multitier Database Architecture
  • Relational Model Terminology
  • Using Tables to Represent Data
  • Characteristics of Relations
  • Data Models
  • Entities and Data Relationships
  • Relational Integrity
  • Database Languages
  • Data Dictionaries
  • Lesson Summary
  • Optional Lab
3

Database Planning

  • Introduction to Database Planning
  • Database Design Life Cycle
  • Database Requirements Document
  • ProAudio Case Study
  • Selecting a DBMS
  • Selecting an Application Interface
  • Lesson Summary
  • Optional Lab
4

Overview of Database Design Methodology

  • Introduction to Database Design Methodology
  • Effects of Poor Database Design Practices
  • Database Design Phases
  • Conceptual Database Design
  • Entity-Relationship (ER) Models
  • Lesson Summary
  • Optional Lab
5

Normalization

  • Introduction to Normalization
  • What Is Normalization?
  • Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Boyce-Codd Normal Form (BCNF)
  • Lesson Summary
  • Optional Lab
6

Logical Database Design

  • Introduction to Logical Database Design
  • Logical Database Design
  • Creating a Logical Data Model
  • Using a Database Definition Language
  • Validating the Logical Data Model
  • Defining Integrity Constraints
  • Creating an Enterprise Data Model
  • Lesson Summary
  • Optional Lab
7

Physical Database Design

  • Introduction to Physical Database Design
  • Physical Database Design
  • MySQL Workbench
  • Creating Enterprise Constraints
  • Using Secondary Indexes
  • Denormalization
  • Creating User Views
  • Designing Database Access Rules
  • Lesson Summary
  • Optional Lab
8

Structured Query Language

  • Introduction to Structured Query Language
  • SQL Basics
  • Data Definition Language
  • Data Manipulation Language
  • Retrieving Data from Relations
  • Data Control Language
  • Lesson Summary
  • Optional Lab
9

Relational Algebra

  • Introduction to Relational Algebra
  • Defining Relational Algebra
  • Selection
  • Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Joins
  • The Division Operation
  • Lesson Summary
  • Optional Lab
10

Transactions and Database Security

  • Introduction to Database Transactions and Security
  • Transactions
  • Concurrency Control
  • Transaction Support in SQL
  • Database Security
  • Lesson Summary

1

Introduction to Databases

  • Using a Flat-File Database
2

Relational Database Fundamentals

  • Using MySQL Workbench
3

Physical Database Design

  • Creating Base Relations for the ProAudio Database
  • Creating Relations and Adding CHECK Constraints
  • Creating Views
  • Creating Users and Granting Privileges
4

Structured Query Language

  • Using the INSERT Statement
  • Dropping a Schema
  • Creating a Schema
  • Using DDL
  • Deleting and Updating Records
  • Using the IN, BETWEEN, and LIKE Operators
  • Retrieving Records from a Database
5

Relational Algebra

  • Joining Relations
  • Using Relational Algebra

Related Courses

All Courses