UMAG-CSCU373.AC1

Database Design Specialist

Intermediate Self-paced · 1 year access

15 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

10 Interactive Lessons · 90 topics

01 Introduction to Databases 9 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

02 Relational Database Fundamentals 12 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

03 Database Planning 8 topics

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

04 Overview of Database Design Methodology 7 topics

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

05 Normalization 9 topics

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

06 Logical Database Design 9 topics

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

07 Physical Database Design 10 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

08 Structured Query Language 8 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

09 Relational Algebra 12 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

10 Transactions and Database Security 6 topics

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

Hands-On Labs Our edge

15 LiveLabs

Using a Flat-File Database
Using MySQL Workbench
Creating Base Relations for the ProAudio Database
Creating Relations and Adding CHECK Constraints
Creating Views
Creating Users and Granting Privileges

Labs run in your browser — nothing to install.

02 / FAQs

Questions before you start

Prepare for Database Design Specialist

One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.

1 year of full access
15 LiveLab included
Certificate of completion

Try Free

No credit card required