Questions about ICCP exams - Calling all IT/MIS Students

[zefrench]

Well I got a 70, the minimun needed for passing this exam to be awarded credit through Excelsior.

It was a lot of reading, this exam is not "an intro to SQL" or "intro to DB management". It is for people with 10 -15 years in the field, thus it required quite a bit.

Here is the list of books I used, starting with the basics.



Book used for study

SQL For Dummies, 5th Edition, Allen G. Taylor
Chapter 1, Relational Database Fundamentals
Chapter 2, SQL Fundamentals
Chapter 3, The Components of SQL
Chapter 5, Building a Multitable Relational Database
Chapter 13, Providing Database Security
Chapter 14, Protecting Data



Fundamentals of Database Systems, Third Edition, Ramez Elmasri
Chapter 1, Databases and Database Users
Chapter 2, Database System Concepts and Architecture
Chapter 3, Data Modeling Using the Entity-Relationship Model
Chapter 4, Enhanced Entity-Relationship and Object Modeling
Chapter 5, Record Storage and Primary File Organizations
Chapter 6, Index Structures for Files
Chapter 20, Concurrency Control Techniques
Chapter 26, Data Warehousing And Data Mining


Database Administration: The Complete Guide to Practices and Procedures, 1st edition, Craig S. Mullins
Chapter 1, What is a DBA?
Chapter 3, Data Modeling and Normalization
Chapter 4, Database Design
Chapter 6, Design Reviews
Chapter 7, Database Change Management

the first chapter was available at: InformIT: Database Administration: The Complete Guide to Practices and Procedures

Slides on Distributed DBMS
http://hamilton.bell.ac.uk/databases/doc...cture4.pdf

Intro on Data Flow Diagrams (DFD)
Data Flow Diagrams - Free Online Tutorial

Reverse Engineering a DBMS
http://www.oracle.com/technology/product...tadata.pdf

I tried reading Hoffer, Jeffrey A. Modern Database Management. 8th. Pearson Prentice Hall, 2006 but find it too detailed.