Get certified for the CIW Database Design Specialist certification exam with the CIW Database Design Specialist v1.1 course and lab. The 1D0-541 study guide covers the certification exam objectives and teaches candidates about relational database fundamentals, relational database design and application, relational algebra and databases, structured query language (SQL), and transactions, currency control and database security. The lab provides a hands-on learning experience in a safe and online environment.
What will you get:
The CIW Database Design Specialist certification is an introductory vendor-neutral credential for individuals pursuing product-focused database specialization. The CIW 1D0-541 exam validates a candidate’s skills and knowledge in various aspects of DB2, Oracle Database 11g, MS SQL and MySQL. The CIW 1D0-541 certification exam is designed for professionals working in the application, web and software development and IT management fields.
Lessons 1: Introduction to Databases
- Introduction to Databases
- Data Formats
- What Is a Database?
- File-Based Databases
- The Evolution of Databases
- Relational Databases and Database Management Systems (DBMSs)
- Origins of Relational Databases
Lessons 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
Lessons 3: Database Planning
- Introduction to Database Planning
- Database Design Life Cycle
- Database Requirements Document
- ProAudio Case Study
- Selecting a DBMS
- Selecting an Application Interface
Lessons 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
Lessons 5: Normalisation
- Introduction to Normalisation
- What Is Normalisation?
- Normal Forms
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form (BCNF)
Lessons 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
Lessons 7: Physical Database Design
- Introduction to Physical Database Design
- Physical Database Design
- MySQL Workbench
- Creating Enterprise Constraints
- Using Secondary Indexes
- Denormalisation
- Creating User Views
- Designing Database Access Rules
Lessons 8: Structured Query Language
- Introduction to Structured Query Language
- SQL Basics
- Data Definition Language
- Data Manipulation Language
- Retrieving Data from Relations
- Data Control Language
Lessons 9: Relational Algebra
- Defining Relational Algebra
- Selection
- Projection
- Cartesian Product
- Union
- Difference
- Intersection
- Joins
- The Division Operation
Lessons 10: Transactions and Database Security
- Introduction to Database Transactions and Security
- Transactions
- Concurrency Control
- Transaction Support in SQL
- Database Security
Hands-on LAB Activities
Introduction to Databases
- Using a Flat-File Database
Relational Database Fundamentals
- Using MySQL Workbench
Physical Database Design
- Creating Base Relations for the ProAudio Database
- Creating Relations and Adding CHECK Constraints
- Creating Views
- Creating Users and Granting Privileges
Structured Query Language
- Using the INSERT Statement
- Dropping a Schema
- Creating a Schema
- Using DDL
- Deleting and Updating Records
- Using the IN, BETWEEN, and LIKE Operators
- Retrieving Records from a Database
Relational Algebra
- Joining Relations
- Using Relational Algebra
Exam FAQs
Here are the pre-requisites: Basic knowledge of the purpose and function of a database Familiarity with an operating system such as Microsoft Windows 7
The fee is GBP £150
PSI
Standard: