MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Database Design Methodology

Admission

Application developers, programmers, enterprise developers, Web developers, and database developers.


Database Design Methodology
Exam # Duration Language Level Type Classroom Code Fees
-- 24 English Professional Course Classroom Cs240 0 LE
Description :

Database Design Methodology teaches trainees how to plan and design relational databases. Trainees will learn about the theory behind the relational databases, relational databases nomenclature, and relational algebra. The course includes sections on the Structure Query Language (SQL) and optimizing databases through normalization. Trainees will apply their knowledge with hands-on labs designed to teach the intricacies of database design methodology.



Objectives :
  • Define and describe database management systems (SBMSs), and identify the advantages and disadvantages of using a DBMS.
  • Define relational model terminology, and describe relational tables and their characteristics.
  • Explain the database design life cycle, and discuss the various aspects of database planning.
  • Describe relational database design methodology, and discuss the phases of database design.
  • Discuss the normalization process, and describe normal forms.
  • Identify design issues related to logical and physical database design, use database definition languages, define and use the Structure Query Language (SQL), and identify SQL commands and syntax.
  • Define relational algebra, and explain concepts related to relational algebra.


Topics :
Introduction to Databases
o Introduction to Databases
o What Is a Database?
o File-Based Databases
o The Evolution of Databases
o Relational Databases and Database
o Management Systems (DBMSs)
o Origins of Relational Databases
Relational Database Fundamentals
o Introduction to Relational Databases
o Multitier Database Architecture
o Relational Model Terminology
o Using Tables to Represent Data
o Characteristics of Relations
o Data Models
o Entities and Data Relationships
o Relational Integrity
o Database Languages
o Data Dictionaries
Database Planning
o Introduction to Database Planning
o Database Design Life Cycle
o Database Requirements Document
o ProAudio Case Study
o Selecting a DBMS
o Selecting an Application Interface
Overview of Database Design Methodology
o Introduction to Database Design
o Methodology
o Effects of Poor Database Design
o Practices
o Database Design Phases
o Conceptual Database Design
o Entity-Relationship (ER) Models
Normalization
o Introduction to Normalization
o What Is Normalization?
o Normal Forms
o First Normal Form
o Second Normal Form
o Third Normal Form
o Boyce-Codd Normal Form (BCNF
Logical Database Design
o Introduction to Logical Database
o Design
o Logical Database Design
o Creating a Logical Data Model
o Using a Database Definition
o Language
o Validating the Logical Data Model
o Defining Integrity Constraints
o Creating an Enterprise Data Model
Physical Database Design
o Introduction to Physical Database
o Design
o Physical Database Design
o MySQL Query Browser
o Creating Enterprise Constraints
o Using Secondary Indexes
o Denormalization
o Creating User Views
o Designing Database Access Rules
Structured Query Language
o Introduction to Structured Query
o Language
o SQL Basics
o Data Definition Language
o Data Manipulation Language
o Retrieving Data from Relations
o Data Control Language
Relational Algebra
o Introduction to Relational Algebra
o Defining Relational Algebra
o Selection
o Projection
o Cartesian Product
o Union
o Difference
o Intersection
o Joins
Transactions and Database Security
o Introduction to Database
o Transactions and Security
o Transactions
o Concurrency Control
o Database Security




Recommended Knowledge :

Computer literacy and familiarity with an operating system such as Microsoft Windows XP before taking this course is a requirement. It is also recommended that trainee have a basic knowledge of the purpose and function of a database.

Recommended Course(s) :

Windows XP Core


Training Materials :

CIW Official Curriculum


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This course is the first course in the CIW Database Specialist series.

Category :
DataBase


The Instructor: