CIW Database Design Specialist

  • کد آزمون : 1D0-541
  • تعداد سوالات : 50
  • نمره قبولی : 75%
  • مدت زمان : 90 دقیقه
  • هزینه مدرک :
  • پیش نیاز :

توضیح درباره مدرک

The CIW Database Design Specialist course provides introductory vendor-neutral training for individuals planning to pursue product-focused database specialization. This course introduces you to DB2, Oracle Database 11g, MS SQL and mySQL. You will also learn about Structured Query Language (SQL) and database optimization through normalization.

سرفصل ها

  • Introduction to Databases
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Introduction to Physical Database Design
  • Physical Database Design
  • MySQL Query Browser
  • Creating Enterprise Constraints
  • Using Secondary Indexes
  • Denormalization
  • Creating User Views
  • Designing Database Access Rules
  • Lesson Summary
  • Optional Lab
  • Introduction to Structured Query Language
  • SQL Basics
  • Data Definition Language
  • Data Manipulation Language
  • Retrieving Data from Relations
  • Data Control Language
  • Lesson Summary
  • Optional Lab
  • Introduction to Relational Algebra
  • Defining Relational Algebra
  • Selection
  • Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Joins
  • Lesson Summary
  • Optional Lab
  • Introduction to Database Transactions and Security
  • Transactions
  • Concurrency Control
  • Database Security
  • Lesson Summary