CIW Database Design Specialist

Hours: 40 / Access Length: 12 Months / Delivery: Online, Self-Paced
Retail Price: $419.00

Course Overview:

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.

Topics Include:

• Relational database fundamentals
• Database planning
• Database design methodology, including logical and physical database design
• Optimization and normalization
• Structured Query Language (SQL)
• Relational algebra
• Transactions and database security

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 before taking this course. The Database Design Specialist courseware does not provide entry-level computer literacy.

Average Salary - $71,382 for Database Design Specialist

The 2015 annual mean salary of an IT professional who has been awarded the CIW Database Design Specialist certification is $71,382. This salary was calculated based on the 14,000+ IT professionals who responded to the 2016 IT Skills and Salary survey that was conducted by Global Knowledge in September of 2015.

Target Audience:

• IT managers/directors
• Application developers
• Web development professionals
• Software programmers
• Enterprise developers

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.

Course Outline:

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

All necessary materials (online eBook) are included.

Certification(s):

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.

System Requirements:

Internet Connectivity Requirements:

• Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.

NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system.  This is due to the potential high download and upload latency of cellular connections.   Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.

Hardware Requirements:

• CPU: 1 GHz or higher
• RAM: 4 GB or higher
• Resolution: 1280 x 720 or higher.  1920x1080 resolution is recommended for the best experience.
• Speakers / Headphones
• Microphone for Webinar or Live Online sessions.

Operating System Requirements:

• Windows 7 or higher.
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions
  

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

Basic Software Requirements (These are recommendations of software to use):

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is described in the above course outline.