Back To CIW Training Courses

CIW Database Specialist Training CBT

Price: $645.00

CBT Course Overview:

The Self Study Store Computer Based Training CIW Database Specialist course teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models. It also teaches students about normalization, and logical and physical database design. This training course will cover the normalization about the first, second, and third normal forms, and also about Boyce-Codd Normal Form, logical database design resolving relationships, creating a logical data model, and the various integrity constraints, physical database design which introduces physical design, creating enterprise constraints, and database performance and access. SQL, relational algebra, transactions and database security, and an introduction to the JDBC is also covered along with SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. Metadata, improving JDBC programs, and building applications using JDBC is covered. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and Application Development in JDBC are also covered. This course is mapped to the Master CIW Enterprise Developer certification training program and exam 1D0-441.

Total Training Duration:

32 hours

CBT Course Modules:

• CIW Database Specialist CBT Part 1: Introduction to Database Design Course
• CIW Database Specialist CBT Part 2: Logical and Physical Design Course
• CIW Database Specialist CBT Part 3: Database Interaction and JDBC Course
• CIW Database Specialist CBT Part 4: Advanced JDBC

Training Course Topics:

• Learn features of a database.
• Learn disadvantages of a flat-file database.
• Learn the problems that relational databases were developed to overcome.
• Learn requirements and scope for the analysis phase.
• Learn guidelines for processing information in the analysis phase.
• Learn criteria for selecting a database management system (DBMS) during the design phase.
• Learn features of normalization.
• Learn features of functional dependency.
• Learn features of first normal form (1NF).
• Learn considerations for creating a logical database design.
• Learn the types of relationships in a relational data model.
• Learn methods of resolving complex relationships.
• Learn characteristics of physical database design.
• Learn guidelines for creating base relations.
• Learn keywords used in data definition language (DDL).
• Learn features of Structured Query Language (SQL).
• Match the SQL data types with their characteristics.
• Match data definition language (DDL) commands with their functions.
• Learn the fundamental operations in relational algebra.
• Learn characteristics of the selection operation.
• Learn characteristics of the projection operation.
• Learn features of a transaction.
• Learn features of concurrency control.
• Learn features of concurrency control methods.
• Learn features of a Java system architecture.
• Learn features of JDBC.
• Match JDBC driver types with their functions.
• Much more.

The Computer Based Training CIW Database Specialist intended audiences for this curriculum include individuals who design, implement, and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance, database developers, enterprise developers, application developers, software engineers, and Web developers. Recommend competency in object-oriented theory and Java programming.