Expand+Entry Requirements / Prerequisites
•It is recommended that students have a basic knowledge of the purpose and function of a database. Also, students should be familiar with an operating system such as Microsoft Windows XP before taking this course.
...

Hide-Entry Requirements / Prerequisites
•It is recommended that students have a basic knowledge of the purpose and function of a database. Also, students should be familiar with an operating system such as Microsoft Windows XP before taking this course.

Technical Requirements
• This is an online course delivered over the internet. The following technical requirements apply: 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Expand+Course Details
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 myS...

Hide-Course Details
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. The Database Design Specialist course teaches students how to plan and design relational databases. You will learn about the theory behind relational databases, relational database nomenclature, and relational algebra. The course includes sections on Structured Query Language (SQL) and optimizing databases through normalization. You will apply your knowledge with hands-on labs designed to teach the intricacies of database design methodology.

CMIT is an approved CIW training provider and provide CIW official training materials. Students are provided with the following resources:
•Official Course manuals – covering the entire syllabus.
•eLearning resources – access to movies, course review questions, exercises and flash cards.
•Virtual Labs – Virtual labs are designed to teach, in an engaging manner, about the most important, cutting-edge concepts in Web design.
•Exam Study Guide – condensed study material on the specific skills objectives you need to master for the exams.
•Exam Pre-Assessment and Practice Exams

Who should complete this course?
•Professionals in all industries can benefit from the CIW Database Design Specialist certification: including IT managers/directors, Application developers, Web development professionals, Software programmers, and Enterprise developers.

Expand+Topics covered in this Course
Introduction to Database
•File-Based Databases
•Relational Databases and Database
•Management Systems (DBMSs)
•Origins of Relational Databases
•Introduction to Relational Databases
•Multitier Database Architecture...

Hide-Topics covered in this Course
Introduction to Database
•File-Based Databases
•Relational Databases and Database
•Management Systems (DBMSs)
•Origins of Relational Databases
•Introduction to Relational Databases
•Multitier Database Architecture
•Relational Model Terminology
•Using Tables to Represent Data
•Characteristics of Relations
•Data Models
•Relational Integrity
•Database Languages
•Data Dictionaries

Database Planning
•Introduction to Database Planning
•Database Design Life Cycle
•Database Requirements Document
•ProAudio Case Study
•Selecting a DBMS
•Selecting an Application Interface

Overview of Database Design
•Introduction to Database Design Methodology
•Effects of Poor Database Design Practices
•Database Design Phases
•Conceptual Database Design
•Entity-Relationship (ER) Models

Normalization
•Introduction to Normalization
•What Is Normalization?
•Normal Forms
•Boyce-Codd Normal Form (BCNF)
•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

Physical Database Design
•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

Structured Query Language
•Introduction to Structured Query
•Language
•SQL Basics
•Data Definition Language
•Data Manipulation Language
•Retrieving Data from Relation
•Data Control Language

Relational Algebra
•Introduction to Relational Algebra
•Projection
•Cartesian Product
•Union
•Difference
•Intersection
•Joins

Transactions and Database
•Security
•Introduction to Database
•Transactions and Security
•Concurrency Control
•Database Security
•Web Teams