Total Training Time
30-40 hours
Training Course Description / Outline
This CIS Database Specialist Suite Computer Based Training CBT 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 suite 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 with this computer based training course.
CBT Exam 1D0-441
This Computer Based Training Suite consists of four courses:
CIW Database Specialist Part 1: Introduction to Database Design
CIW Database Specialist Part 2: Logical and Physical Design
CIW Database Specialist Part 3: Database Interaction and JDBC
CIW Database Specialist Part 4: Advanced JDBC
CBT Product Features
CIW Co-Developed Courses
Pre Assessments
Post Assesments
No need for internet access.
Step By Step Audio Narration
The most realistic exam simulations
120 Day Exam Pass Guarantee
30 Day Money Back Guarantee
Certificate of Completion
Learn To
Identify features of a database.
Identify disadvantages of a flat-file database.
Identify features of normalization.
Identify features of functional dependency.
Identify features of first normal form (1NF).
Identify features of Structured Query Language (SQL).
Match the SQL data types with their characteristics.
Match data definition language (DDL) commands with their functions.
Identify functions of DatabaseMetaData methods.
Identify methods for determining database schema.
Match the ResultSetMetaData methods with their descriptions.
Identify characteristics of try and catch blocks.
Much more.
|
