Scroll to top button

CIW: Database Design Specialist v1.1

ISBN : 9781644591086

Prepare for the CIW 1D0-541 exam with the CIW Database Design Specialist course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course or training. The course and lab completely cover the 1D0-541 exam objectives and teach you how to work with transactions, database security, database planning, database design methodology (including logical and physical database design), and relational database fundamentals.

The CIW Database Design Specialist certification is an introductory vendor-neutral credential for individuals pursuing product-focused database specialization. The CIW 1D0-541 exam covers various aspects of DB2, Oracle Database 11g, MS SQL, and MySQL. The CIW 1D0-541 exam is designed for professionals working in the application, web, and software development and IT management fields.

Lessons
Lessons
10+
Quizzes
372+
Flashcards
62+
Glossary of terms
62+
TestPrep
Pre Assessment Questions
50+
Full Length Tests
3+
Post Assessment Questions
82+
LiveLab (Add-on Component)
livelab
15+

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
10+
Minutes
54+
Exam related FAQs
What are the prerequisites for this exam?

Here are the pre-requisite:

  • Basic knowledge of the purpose and function of a database
  • Familiarity with an operating system such as Microsoft Windows 7
What is the exam registration fee? USD 150
Where do I take the exam? Pearson VUE
What is the format of the exam? The exam consists of linear, multiple choice, fill in the blank, fact-based, and situational questions.
How many questions are asked in the exam? The exam contains 50 questions.
What is the duration of the exam? 90 minutes
What is the passing score? 75%
What is the exam's retake policy?

Here are the retake policies:

  • If a candidate passes a CIW exam, he will not be allowed to retake that CIW exam.
  • A 24-hour waiting period is required between the first and second attempt exam.
  • 30 calendar days waiting period from the date of the previous sitting before any third or subsequent sitting exam.
What is the validity of the certification? CIW certifications do not expire unless CIW changes its policy.
Where can I find more information about this exam? To know more about the 1D0-541-v1.1, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Enterprise developers
  • IT managers/directors
  • Application developers
  • Software programmers
  • 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
  • Lesson Summary
  • Optional Lab
  • 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 Summary
  • Optional Lab
  • Introduction to Database Planning
  • Database Design Life Cycle
  • Database Requirements Document
  • ProAudio Case Study
  • Selecting a DBMS
  • Selecting an Application Interface
  • Lesson Summary
  • Optional Lab
  • Introduction to Database Design Methodology
  • Effects of Poor Database Design Practices
  • Database Design Phases
  • Conceptual Database Design
  • Entity-Relationship (ER) Models
  • Lesson Summary
  • Optional Lab
  • Introduction to Normalization
  • What Is Normalization?
  • Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Boyce-Codd Normal Form (BCNF)
  • Lesson Summary
  • Optional Lab
  • 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 Summary
  • Optional Lab
  • Introduction to Physical Database Design
  • Physical Database Design
  • MySQL Workbench
  • Creating Enterprise Constraints
  • Using Secondary Indexes
  • Denormalization
  • Creating User Views
  • Designing Database Access Rules
  • Lesson Summary
  • Optional Lab
  • Introduction to Structured Query Language
  • SQL Basics
  • Data Definition Language
  • Data Manipulation Language
  • Retrieving Data from Relations
  • Data Control Language
  • Lesson Summary
  • Optional Lab
  • Introduction to Relational Algebra
  • Defining Relational Algebra
  • Selection
  • Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Joins
  • The Division Operation
  • Lesson Summary
  • Optional Lab
  • Introduction to Database Transactions and Security
  • Transactions
  • Concurrency Control
  • Transaction Support in SQL
  • Database Security
  • Lesson Summary

Hands on Activities (LiveLab)

×