Database Design Specialist v1.1

This course includes
Lessons
TestPrep
Hand-on Lab

Lessons

10+ Lessons | 260+ Quizzes | 62+ Flashcards | 62+ Glossary of terms

TestPrep

50+ Pre Assessment Questions | 3+ Full Length Tests | 82+ Post Assessment Questions | 150+ Practice Test Questions

Hand on lab

8+ LiveLab | 00+ Minutes

Video Lessons

10+ Videos | 54+ Minutes

Here's what you will learn

Download Course Outline

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 10: Transactions and Database Security

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

Hands-on LAB Activities

Physical Database Design

  • Creating Base Relations for the ProAudio Database
  • Creating Relations and Adding CHECK Constraints

Structured Query Language

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

Relational Algebra

  • Joining Relations