CIW Database Design Specialist Course

Subtotal	£0.00

Course Format:Online Course

Self-Study Time:Approximately 120 Hours (Self-Study)

Delivery Time:2-3 Working Days (Email)

4.9

Based on 227 reviews from findcourses.co.uk

Pay in full today:

£400.00

Payment in full on checkout by Card or Paypal

3 monthly payments:

£133.33

Pay over 3 payments on checkout with Klarna

6 monthly payments:

£48.00

1 payment of £160.00 taken now 5 further payments of £48.00 - taken monthly with GoCardless

6 Month Payment Option Details:
1 initial payment of £160.00 followed by 5 monthly payments of £48.00 by Direct Debit

Enrol Today

Course Description

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 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.

The CIW Database Design Specialist Course includes the following items:

One year License to the official CIW 1D0-541 Database Design Specialist online course materials. This includes: Pre-Assessment, Exercises, Quizes and Flashcards, Videos, and Practice Exams.
CIW Live Labs
An optional PSI Online Exam Voucher to cover the cost of your CIW Exam (£120.00).

CIW Authorised Training Partner

Distance 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.

This course is one of three titles that makes up the CIW Web Development Professional Series of qualifications. Each course represents an individual CIW exam:

CIW JavaScript Specialist
CIW Perl Specialist
CIW Database Design Specialist

The CIW Database Design Specialist Course includes the following units:

The following topics are covered: Introduction to Databases; What Is a Database?; File-Based Databases; The Evolution of Databases; Relational Databases and Database Management Systems (DBMSs); and Origins of Relational Databases.

The following topics are covered: 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; and Data Dictionaries.

The following topics are covered: Introduction to Database Planning; Database Design Life Cycle; Database Requirements Document; ProAudio Case Study; Selecting a DBMS; and Selecting an Application Interface.

The following topics are covered: Introduction to Database Design Methodology; Effects of Poor Database Design Practices; Database Design Phases; Conceptual Database Design; and Entity-Relationship (ER) Models.

The following topics are covered: Introduction to Normalization; What Is Normalization?; Normal Forms; First Normal Form; Second Normal Form; Third Normal Form; and Boyce-Codd Normal Form (BCNF).

The following topics are covered: 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; and Creating an Enterprise Data Model.

The following topics are covered: Introduction to Physical Database Design; Physical Database Design; MySQL Query Browser; Creating Enterprise Constraints; Using Secondary Indexes; Denormalization; Creating User Views; and Designing Database Access Rules.

The following topics are covered: Introduction to Structured Query Language SQL Basics; Data Definition Language; Data Manipulation Language; Retrieving Data from Relations; and Data Control Language.

The following topics are covered: Introduction to Relational Algebra; Defining Relational Algebra; Selection; Projection; Cartesian Product; Union; Difference; Intersection; and Joins.

The following topics are covered: Introduction to Database Transactions and Security Transactions Concurrency Control; and Database Security.

Additional Online CIW Course Content

Exercises, Quizzes and Flashcards

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts while the Glossary defines the key terms. There are over 800 unique questions including pre-assessment, quizzes, exercises, and post assessment.

Videos and How To:

The course includes videos to help understand concepts. It also includes How Tos that help learners in accomplishing certain tasks.

Practice Tests

The CIW Practice tests are full length tests that closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Practice Test Features:

Full Remediation: Each question comes with detailed remediation explaining not only why an answer option is correct, but also why it is incorrect.
Unlimited Practice: Each test can be taken an unlimited number of times until the learner feels they are prepared. Learners can review the test and read detailed remediation. Detailed test history is also available.
Learn, Test and Review Mode: Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Please Note - Digital Course Materials: As the Official CIW Course Materials are a digital license, we cannot offer refunds once the access code has been issued to students. We advise students access a Free Trial of the course content from our Online Portal prior to purchase to make sure you are happy with the format and course content. 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 3 or 6 month extension.

CIW Live Labs

Live Labs gives access to a real computer equipment, networked together and conveniently accessible over the internet. The Live Labs have equipment such as a computer, server, switch or router in it so that a user is free to configure.

The benefits of live-labs are:

Exam based practical tasks
Real equipment, absolutely no simulations
Access to the latest industry technologies
Available anytime, anywhere on any device
Break and Reset functionality
No hardware costs

CIW Exam Voucher (Optional) - £120.00

Exam Vouchers are available to arrange exams through PSI Testing. The exams are available at selected in-house testing centres or through PSI's remote video proctoring service which allows you to take CIW exams from the comfort of your own home or office.

The remote testing 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: CIW Exam Vouchers can only be purchased alongside CIW Course Materials.

Prerequisites

The course does not have any pre-requisites although we do recommend completing the CIW Foundations Associate Course prior to studying this course. 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.

Course Duration & Online Support

You can register at any time and have 12 months access to the course from enrolment. The course is designed as a self-study course, but if you have any problems you can email our support email service. As the course is self-study you can complete in as little or as long a time as you prefer.

CIW Database Design Specialist 1D0-541 Examination

On Completion of this curriculum, you can apply for the internationally recognised CIW Database Design Specialist 1D0-541 Examination. The CIW Database Design Specialist exam consists of 50 multiple choice/multiple answer questions over 90 minutes and the passing score is 75%.

CIW exams are completed through PSI Exams. Learners can purchase an exam voucher through ourselves for £120.00, or they can register and arrange exams with PSI Exams. The exams are available as remote exams or at selected exam centres through the PSI Bridge 2 System website.

Let us know if you have a question about this course and we will get back to you ASAP.

Alex Capeling

CIW Web Foundations Associate Course

"The course material was brilliant and has given me an excellent foundation for any line of work I could imagine. Anyone looking into Computers, IT, Networks etc. will be mad not to look into this course. Also my Tutor (Michael Verinder) was first class; rapid responses (within an hour at most), very knowledgeable, friendly, professional and of course very supportive. Couldn't have asked for more. Loved it. I will definitely be coming back for any other courses I decide to do, got some decisions to make now but I feel confident in coming back should I decide to."

Martin Nyahasha

CIW JavaScript Specialist Course

"I passed the exam with a 85% mark. I wish I had attempted it much earlier than I did! The material more or less matches what you get on the exam if one sticks to practicing based on it. I would recommend the course to all the beginners in JavaScript programming language."

Steve Gravener

CIW Web Foundations Associate Course

"All of my interactions with the sales/admin team have been an extremely positive experience, the staff have been very helpful and responded to all of my queries within a short amount of time. I found the combination of digital and physical materials worked well, and enjoyed the content. I particularly liked how the online quizzes at the end of each lesson were set up to consolidate the new information. I enjoyed learning with the Distance Learning Centre and will definitely complete further courses with them in future."

Stephen Hall

CIW Web Foundations Associate Course

"I have just completed my CIW Foundation Course and am pleased to say that I have passed the Foundation exam. I thought the course was excellent, as was the prompt and helpful assistance I received when needed. With a good blend of theory and practical labs I would certainly recommend this course to anyone wanting to gain a comprehensive grounding in the fundamentals of Internet Technology and I am looking forward to continuing my learning by taking the CIW Web Design Specialist Course."

Kathy Turner

CIW Courses

"I have thoroughly enjoyed this course. I found it very informative and relevant. The facility to test yourself at the end of each chapter and then the practice papers were invaluable in re-enforcing what I had just learnt. The hands on 'labs' also aided and reinforced the learning process."

Simon

CIW Web Design Professional Course

"I recently attained my CIW Web Design Professional accreditation after successfully passing the Foundations, Site Design and E-Commerce courses. I am now turning my attention to the JavaScript module and I hope to complete this ASAP. I would particularly like to thank Mike at the Distance Learning Centre for his help over the last 10 months or so, the level of service has been excellent. Every email was responded to within 24 hours or less, and any issue I had was resolved quickly - a first class customer support."

Mark Taylor

CIW Courses

"Thanks once again for a great course. I had originally been quoted Over £1000 for the CIW Course, so it was a nice surprise to stumble upon your courses at more than half the price. I have found the course well written and included everything I need to pass my exam."

Martin Nicholson

CIW JavaScript Specialist Course

"The quality of information was superb, easy to follow and digest. The online questions were very helpful."

Jeff

CIW Web Design Professional Bundle

"I signed up for the CIW Web Design Professional Bundle Course in 2009 and have recently attained my CIW Professional accreditation after successfully passing the Foundations and Site Design courses. I am now doing the E-Commerce module and hope to complete this ASAP. A big thanks to Mike at the Distance Learning Centre. The level of support has been excellent. From memory every email has been responded to within 24 hours (usually quicker) and every query/issues resolved in a timely manner - truly first class customer support."

This course is eligible for the TOTUM Pro Student Card.

TOTUM PRO is made especially for professional learners, and opens up a whole world of fantastic savings and discounts on everything from dining out and keeping fit to travel abroad... Find Out More

Save money on hundreds of offers for:

Fashion
Eating Out
Music & Technology
Supermarkets
Health & Fitness
Home & Garden
Travel

Similar Courses (12)

Why Study With Us?

Huge Choice of Courses

We currently offer over 250+ diffeent distance learning courses leading to full Ofqual Regulated Qualifications or Accredited Certificates from National Awarding Bodies.

Customer Reviews

We're a top rated home learning provider on the Find Courses / Independent reviews site, Trustpilot - currently rated 9.6/10 for customer service.

Payment Plans

Choose to pay for your course in full, or spread the cost with monthly instalments. Payment plans are interest-free, with no credit checks.

Quick Delivery

We process all applications quickly and most course materials are available to start within 1 to 3 working days!

Tutor Support

All courses are fully supported and tutors are available to answer any questions, mark your assignments and offer feedback and guidance throughout your course.

Study At Your Pace

Work at your own pace. Our team will support you, but won't chase you for work or apply deadlines for submissions.