Database Design Specialist is the third course* in the CIW Web Development series. The Database Design Specialist course (formerly titled Database Design Methodology) 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 optimizing databases through normalization. You will apply your knowledge with hands-on labs designed to teach the intricacies of database design methodology.
*The courseware is not required to sit for the certification exam.
Candidates who also pass the CIW Database Design Specialist exam and CIW Advanced HTML5 & CSS3 Specialist exams can earn the advanced CIW Web Development Professional certification in addition.
Curriculum
- 1 Section
- 10 Lessons
- 150 Hours
- Lessons10
- 1.1Lesson 1 – Introduction to Databases
- 1.2Lesson 2 – Relational Database
- 1.3Lesson 3 – Database Planning
- 1.4Lesson 4 – Overview of Database Design Methodology
- 1.5Lesson 5 – Normalization
- 1.6Lesson 6 – Logical Database Design
- 1.7Lesson 7 – Physical Database Design
- 1.8Lesson 8 – Structured Query Language
- 1.9Lesson 9 – Relational Algebra
- 1.10Lesson 10 – Transactions and Database Security
Features
- Exam ID: 1D0-541
- Number of Questions: 50
- Passing Score: 75%
- Time Limit: 90 minutes
- Valid for: Three Years