CIW Database Design Specialist

Hours: 40 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 40
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 - $101,510 for Database Administrators

The 2023 median annual salary for a Database Administrator is $101,510, according to the U.S. Bureau of Labor Statistics (BLS). This salary is based on national data for professionals managing and maintaining databases across various industries. Additionally, Database Architects, who design and implement database systems, earn a median annual wage of $134,700.

These figures were reported in the Occupational Outlook Handbook published by the BLS in 2024, reflecting the most recent industry trends and salary data.

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

  • Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
  • Minimum Speed: 10 Mbps download / 5 Mbps upload

Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.

Hardware

  • Processor: Dual-core 2.0 GHz or higher
  • Memory (RAM): 8 GB or higher (4 GB minimum)
  • Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
  • Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)

Operating Systems

  • Windows: Windows 10 or Windows 11
  • Mac: macOS 13 (Ventura) or newer
  • ChromeOS / Linux: Latest supported release

Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.

Web Browsers

  • Google Chrome (Latest version — Recommended)
  • Mozilla Firefox (Latest version)
  • Microsoft Edge (Latest version)
  • Apple Safari (Latest version)

Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.

Recommended Software

The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):

  • Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
  • PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer


** The course outlines displayed on this website are subject to change at any time without prior notice. **