CIW

Database Design Specialist v1.1

Lessons
Lab
TestPrep
Get A Free Trial

About This Course

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

Physical Database Design

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

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
3

Relational Algebra

  • Joining Relations

Database Design Specialist v1.1

$127

Buy Now

Related Courses

All Course
1D0-541-v1.1 - CIW: Database Design Specialist v1.1
Lessons Lab TestPrep AI Tutor

CIW: Database Design Specialist v1.1

ISBN: 9781644591086
1D0-541-v1.1
Try $249.00 Buy
1D0-61A-v2.2 - CIW: Internet Business Associate (1D0-61A)
Lessons TestPrep AI Tutor

CIW: Internet Business Associate (1D0-61A)

ISBN: 9781644590126
1D0-61A-v2.2
Try $199.00 Buy
1D0-61B-v2.2 - CIW: Site Development Associate (1D0-61B)
Lessons Lab Lab TestPrep AI Tutor

CIW: Site Development Associate (1D0-61B)

ISBN: 9781644590294
1D0-61B-v2.2
Try $199.00 Buy
1D0-61C-v2.2 - CIW: Network Technology Associate (1D0-61C)
Lessons Lab TestPrep AI Tutor

CIW: Network Technology Associate (1D0-61C)

ISBN: 9781644590454
1D0-61C-v2.2
Try $199.00 Buy
1D0-621 - CIW: User Interface Designer (1D0-621)
Lessons TestPrep AI Tutor

CIW: User Interface Designer (1D0-621)

ISBN: 9781616917128
1D0-621
Try $249.00 Buy
1D0-622-v1.2 - CIW: Data Analyst (1D0-622)
Lessons Lab TestPrep AI Tutor

CIW: Data Analyst (1D0-622)

ISBN: 9781644592359
1D0-622-v1.2
Try $249.00 Buy
1D0-623v2_0.AC1 - CIW: Social Media Strategist - V2.0 (1D0-623v2.0)
Lessons TestPrep AI Tutor

CIW: Social Media Strategist - V2.0 (1D0-623v2.0)

ISBN: 9781644592465
1D0-623v2_0.AC1
Try $249.00 Buy