CIW Database Design Specialist
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Duration
Flexible
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. Database Design Methodology 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.
The CIW Database Design Specialist course prepares candidates to take the CIW Database Design Specialist exam, which if passed earns the individual the Database Design Specialist certification. Candidates who also have the CIW JavaScript Specialist certification and the CIW Perl Specialist certification earn the advanced CIW Web Development Professional certification in addition.
Important information
Price for Emagister users: We are offering a 20% discount this month for all enrolments that are paid in full and made online.
Facilities
Location
Start date
Start date
About this course
Key Topics
The CIW Database Design Specialist Course is divided into following lessons:
Lesson 1: Introduction to Databases
Lesson 2: Relational Database Fundamentals
Lesson 3: Database Planning
Lesson 4: Overview of Database Design Methodology
Lesson 5: Normalization
Lesson 6: Logical Database Design
Lesson 7: Physical Database Design
Lesson 8: Structured Query Language
Lesson 9: Relational Algebra
Lesson 10: Transactions and Database Security
No prior knowledge of the Database Design is necessary. However, 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.
This CIW Database Design Specialist Course will prepare you for following certification:
CIW Database Design Specialist Certification
Exam Code: 1D0-541
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 16 years
Subjects
- Database training
- Database Design
- Database
- Design
- IT
- Database Management
Teachers and trainers (1)
Support Advisor
Support Advisor
Course programme
Lesson 1: 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
Lesson 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 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 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 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 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 7: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
Lesson 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 9: Relational Algebra
- Introduction to Relational Algebra
- Defining Relational Algebra
- Selection
- Projection
- Cartesian Product
- Union
- Difference
- Intersection
- Joins
Lesson 10: Transactions and Database Security
- Introduction to Database Transactions and Security
- Transactions
- Concurrency Control
- Database Security
CIW Database Design Specialist