• Home
uCertify Logo
  • Search Titles
  • Career Tracks
  • platform
    • Learn
    • Course
    • Lab
    • Test
    • Mobile App
    • Create
  • partner with us
    • Educator
    • Publisher
    • Request Demo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Request Demo
  • Search Titles
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Career Tracks
  • Technology
    • Learn
    • Course
    • Lab
    • Test
    • Learn Smart App
    • Create
  • I am...
    • Professional (Self-Paced Learner)
    • Educator
    • Publisher
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Help
    • Keyboard Shortcuts
    • Features
    • Send Feedback
Scroll to top button

CIW: Database Design Specialist v1.1

(1D0-541-v1.1) / ISBN: 9781644591086
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Mentoring (Add-on)
1D0-541-v1.1 : CIW: Database Design Specialist v1.1
Share
$200.99
Try This Course
Are you an instructor?
Request a free evaluation copy

CIW: Database Design Specialist v1.1

Create new career opportunities by being Database Design Specialist with the CIW: Database Design Specialist v1.1 course and lab. The lab provides a hands-on learning experience in a safe, online environment. 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, database security, and many more.
Here's what you will 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
  • 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
Here's what you will learn
Download Course Outline
Lesson 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
  • Lesson Summary
  • Optional Lab
Lesson 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
  • Lesson Summary
  • Optional Lab
Lesson 3: Database Planning
  • 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
Lesson 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
  • Lesson Summary
  • Optional Lab
Lesson 5: Normalization
  • 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
Lesson 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
  • Lesson Summary
  • Optional Lab
Lesson 7: Physical Database Design
  • 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
Lesson 8: Structured Query Language
  • Introduction to Structured Query Language
  • SQL Basics
  • Data Definition Language
  • Data Manipulation Language
  • Retrieving Data from Relations
  • Data Control Language
  • Lesson Summary
  • Optional Lab
Lesson 9: Relational Algebra
  • Introduction to Relational Algebra
  • Defining Relational Algebra
  • Selection
  • Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Joins
  • The Division Operation
  • Lesson Summary
  • Optional Lab
Lesson 10: Transactions and Database Security
  • Introduction to Database Transactions and Security
  • Transactions
  • Concurrency Control
  • Transaction Support in SQL
  • Database Security
  • Lesson Summary

Hands on Activities (Live Labs)

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
What are the prerequisites for this exam?

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
What is the exam registration fee? USD 150
Where do I take the exam? Pearson VUE  or PSI
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.
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?
  • Web Developer
  • IT Manager/Director
  • Enterprise Developer
  • Application Developer
  • Software Programmer
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

ucertify logo
uCertify provides Courses, Lab, TestPrep for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, Axelos and many more.

The logos and certification names are the trademarks of their respective owners.
Connect
  • About Us
  • Awards
  • Contact Us
  • Sitemap
  • Careers
  • Partners with us
  • Platform
Resources
  • Titles Catalog
  • Vendors
  • Certifications
  • Exams
  • Blog
  • Sitemap

Subscribe To Our Newsletters
Sign up for our monthly newsletter to get the latest news, updates and amazing offers delivered directly in your inbox.
Accessibility Terms & Conditions Privacy Statement
© 2002-2020 uCertify. All Rights Reserved
uCertify App
android app image
ios app image
We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept