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
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
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
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 Methodology
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
First Normal Form
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form (BCNF
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
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 Relations
Data Control Language
Relational Algebra
Introduction to Relational Algebra
Defining Relational Algebra
Selection
Projection
Cartesian Product
Union
Difference
Intersection
Joins
Transactions and Database Security
Introduction to Database
Transactions and Security
Transactions
Concurrency Control
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: