The CIW Database Design Specialist Course teaches students how to plan and design relational databases. You will learn about the theory behind relational databases, relational database nomenclature, and relational algebra.

The course includes sections on Structured Query Language (SQL) and optimising databases through normalisation. You will apply your knowledge with hands-on labs designed to teach the intricacies of database design methodology.

The CIW Database Design Specialist course prepares candidates to take the CIW ID0-541 exam. This qualification is also one third of the CIW Web Development Professional certification. Passing each of the individual exams earns you the related certification, and passing all three exams would earn you the CIW Web Development Professional Certification.

Purchase a CIW Exam Voucher: You can order a PSI Exam Voucher for £100.00 when ordering via our website (Valid for 12 months from purchase). The exam voucher can be added to your order as an additional extra in your shopping cart.

CIW Official Training ProviderDistance Learning Centre is proud to be an authorised training partner for CIW course materials and we offer the official Certified Internet Webmaster (CIW) self study courses.

The CIW JavaScript Specialist Course includes the following items:

  • Official CIW course books covering the complete CIW JavaScript Specialist 1D0-635 syllabus.
  • CIW Online Exercises (Online).
  • CIW Review Questions (Online).
  • CIW Practice Exams (Online).
  • Supplementary Student Files.
CIW Web Development Professional


  • Web application developers
  • Software developers
  • Application programmers
  • Client/server developers
  • Web architects

The CIW Database Design Specialist Course includes the following items:

  • CIW Database Design Specialist Course Book

The CIW Database Design Specialist course provides introductory vendor-neutral training for individuals planning to pursue product-focused database specialisation. This course introduces you to DB2, Oracle Database 11g, MS SQL and mySQL. You will also learn about Structured Query Language (SQL) and database optimisation through normalisation.

Skills Taught:

  • Relational database fundamentals.
  • Database planning.
  • Database design methodology, including logical and physical database design.
  • Optimisation and normalisation.
  • Structured Query Language (SQL).
  • Relational algebra.
  • Transactions and database security.

Please Note: Students will also receive the course book in a HTML format as part of their online license.

  • CIW Database Design Specialist Online Exercises (Online Access - 1 Year License)

The Online Exercises test knowledge of the topics presented in the course books and help students prepare for the certification exam. The Exercises are presented in a variety of formats including flash cards, matching exercises, true-false questions, crossword puzzles and fill-in-the-blank exercises.

  • CIW Database Design Specialist Online Review Questions (Online Access - 1 Year License)

The CIW Course Review modules are designed to assess knowledge of the concepts, skills and best practices taught in the Official CIW books. Each online module contains multiple-choice reviews and quizzes that cover book content lesson by lesson. Once you have mastered the CIW Course Review modules, you are better prepared to take the CIW Examinations.

  • CIW Database Design Specialist Practice Exams (Online Access - 1 Year License)

The CIW Practice Exams consist of a variety of tests designed to help reinforce learning and assess the students’ knowledge of specific skills objectives.

CIW Practice Exams consist of the following:

  1. Objective Reviews and Quizzes
  2. Reinforcement Tests
  3. Self-Assessment Tests
  4. Practice Exams
  • CIW Database Design Specialist Student Files (Online Access - 1 Year License)

Supplemental materials are provided for students. Materials include some elements required to complete the coursework and other optional elements that are provided for your interest or further study.

  • PSI Exam Voucher (Optional - £100.00)

PSI Testing is a remote video proctoring service and allows you to take CIW exams from the comfort of your own home or office. The system requires an active webcam and stable high speed Internet connection. A live proctor will visually monitor the student and the exam during the entire testing session.

Please Note: Extensions for the online content can be purchased if you need to extend your studies. We will email students prior to their access expiring to see if they require a one-year extension.


The course does not have any pre-requisites although we do recommend completing the CIW Foundations Associate Course prior to studying these courses. It is recommended that students have a good knowledge of general IT and 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 CIW Database Design Specialist does not provide entry-level computer literacy.

Apple Mac Users: We recommend this course is completed on a PC with the Windows Operating System. The course can be run on an Apple Macs using software such as Boot Camp, Parallels Desktop 7, VMware fusion or CrossOver Mac although we cannot support any issues that may occur with PC-Based software running on a Mac.

Course Duration & Support:

Students may register at any time. The course is designed as a self-study course but you do have full support from our own support team and from CIW. As the course is self study you can complete in as little or as long a time as you prefer, and we do not impose a cut-off date for study.

CIW Database Design SpecialistCIW Examinations:

On Completion of this curriculum, you can apply for the internationally recognised CIW Database Design Specialist 1D0-541 Examination. CIW exams can be sat at registered Pearson VUE testing centres or via the PSI Remote testing system. The CIW Database Design Specialist exam consists of 50 multiple choice/multiple answer questions over 90 minutes and the passing score is 75%.

You can locate Pearson Vue testing centres and schedule examinations on the Pearson Vue Website. Pearson Vue currently charge £90.00 + VAT for CIW exams.

View Testimonials
Submit a Testimonial