CIW: Database Design Specialist v1.1
(1D0-541-v1.1)
/ ISBN: 9781644591086
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Mentoring (Add-on)
CIW: Database Design Specialist v1.1
Start your prep for the 1D0-541 certification exam with the CIW: Database Design Specialist v1.1 course and lab. Lab delivers hands-on experience replacing expensive physical labs. The 1D0-541 study guide covers the 1D0-541 certification exam objectives and teaches candidates about relational database fundamentals, relational database design and application; relational algebra and databases; normalization and database design; structured query language (SQL); and transactions, currency control, database security, and many more.
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
-
10+ Lessons
-
371+ Quizzes
-
62+ Flashcards
-
62+ Glossary of terms
TestPrep
-
50+ Pre Assessment Questions
-
3+ Full Length Tests
-
82+ Post Assessment Questions
-
150+ Practice Test Questions
LiveLab (Add-on)
-
15+ LiveLab
Video Lessons
-
10+ Videos
-
54+ Minutes
- 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 (Live Labs)
- Using a Flat-File Database
- Using MySQL Workbench
- Creating Base Relations for the ProAudio Database
- Creating Relations and Adding CHECK Constraints
- Creating Views
- Creating Users and Granting Privileges
- 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
- Joining Relations
- Using Relational Algebra
| What are the prerequisites for this exam? | Here are the pre-requisites:
|
|---|---|
| What is the exam registration fee? | USD 150 |
| Where do I take the exam? | http://www.pearsonvue.com/CIW or PSI www.examslocal.com |
| 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:
|
| What is the validity of the certification? | CIW certifications do not expire. |
| Where can I find more information about this exam? | To know more about the 1D0-541, click here. |
| What are the career opportunities after passing this exam? |
|
×
