CIW: Database Design Specialist v1.1
CIW 1D0-541-v1.1
CIW: Database Design Specialist v1.1
ISBN: 978-1-64459-108-6CIW 1D0-541-v1.1
Database Design Specialist v1.1
This course includes
Lessons
TestPrep
Hands-On Labs
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
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
Hands-On Labs
8+ LiveLab | 00+ Minutes
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
6
Physical Database Design
- Creating Base Relations for the ProAudio Database
- Creating Relations and Adding CHECK Constraints
7
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
8
Relational Algebra
- Joining Relations