Welcome, please login

Not Registered? sign up

Support / Contact

Shopping Cart

Check Out

Unlimited Video Training

Why PrepLogic?

Video Training

Practice Exams

Audio Training

More Training

Free Previews

Exam Vouchers

PrepLogic Blog

About this LearnSmart Video Training:
Gain in-depth knowledge of CIW's Database Specialist - Design from industry expert Wayne Snyder. Wayne's expert insight and energetic instruction creates an incredibly comprehensive learning environment. When you complete this training, you will be comfortable with the concepts underlying enterprise data model design, design and write platform independent applications to access Oracle, Sybase, Informix, Microsoft SQL Server and DB2 databases. You will also be prepared for the Master CIW Enterprise Developer Exam 1D0-441.


	Learn Everything for CIW Database Specialist (1D0-441) Use CIW Database Specialist (1D0-441) LearnSmart Video Training to learn all of the most important skills and pass your certification exam. When you complete this CBT course, you'll be an expert on the following "must-know" skills for your certification: Session 1 Section A: Introduction to Databases What is a Database? Flat File Databases Relational Databases RDMS & Disadvantages Section B: Relational Database Fundamentals Application Components Client & Server Tiers Relational Model Entities & Primary Keys Data Modeling Entry Types Database Terminology Section C: Database Planning Database Strategy Design Application Requirements Document Interview Strategy DBMS Selection Application Interface Section D: Database Design Methodology Design Problems Anomalies Phases of DB Design Identify Entities Identify Attributes & Domains Relationships Identify Relationships Candidate & Primary Keys Entity-Relationship Model IE Model Relationship Types Chen Data Model Section E: Database Normalization Normal Forms First Normal Form Rules Primary Key Second Normal Form Rules Using Second Normal Form Third Normal Form Rules Boyce-Codd Normal Form Data Normalization Session 2 Section A: Logical Database Design Identify Relationships Resolve Many to Many Relationships Complex Relationships Recursive Relationships Relationship Attributes Redundant Relationships Database Definition Language Domain Definitions Validate Logical Model Referential Integrity Foreign Key Constraints Cascade, Set Null & Set Default Data Integrity Section B: Physical Database Design Using DDL & DBMS Syntax Requirements Enterprise Constraints Using Constraints Multiple Constraints Constraints & Updates Foreign Key Constraints Secondary Indexes Denormalization Denormalize Foreign Keys Creating User Views Grant Statement Section C: Intro to SQL Standards Structured Query Language Data Types Session 3 Section A: SQL DDL Create Schema & Alter Command Alter & Drop Domain DML & Insert & Delete Update & Select Using Select & Distinct Where Clause Using Where Using Multiple Boolean Statements Using Like Statements Order-By Clause DCL, Grant & Revoke Section B: Relational Algebra Selection & Projection Cartesian Product & Union Difference & Intersection Theta-Join & Equi-Join Natural Join & Outer Join Relationship Diagram Using & Refining Joins Distinct Join & Three-way Join Using Outer Join Section C: Transactions & Database Security Transaction ACID Properties Dirty Read 7 Non-repeatable Read Phantom Reads Serialability Locking Timestamp & Optimistic Control Security Session 4 Section A: Introduction to JDBC The JDBC API Relationship Databases SQL/DDL Data Types Insert & Delete Update & Select 2-Tier Architecture 3-Tier Architecture Section B: Getting Started JDBC API Installing JDBC JDBC-ODBC Bridge & Native API JDBC-Net & Pure Java Loading a Driver New Statement Class for Name Establishing a Connection Using getConnection Connection Interface Section C: Executing SQL Statements Statement Interface executeQuery getXXX Methods Using ResultSet executeUpdate Using executeUpdate Execute Statement & Transactions Using Transactions Section D: Prepared Statements & Stored Procedures Overview Creating Prepared Statements Setting Parameters Using Prepared Statements Stored Procedures Creating Stored Procedure Using Stored Procedures Session 5 Section A: Metadata Database Metadata Using DatabaseMetaData Objects getProcedures & getTables Using getTables getTables Result Set ResultSetMetaData Using getResultSetMetaData Section B: SQL Exceptions SQL Exception Class Try & Catch Blocks SQL Exception Methods Using Try & Catch Section C: Scrollable & Updatable Result Sets Scrollable Result Set Creating ScrollableResultSet Using Next, Previous & Absolute Updatable Result Set Using Updatable Result Set UpdateXXX Methods Section D: Batch Updates Overview Batch Methods createStatement Batch BatchUpdateException Using BatchUpdateException Section E: Building Applications Using JDBC Overview Interface Setup Using getStatements Create Tables


	With 15 hours of instruction on DVD-ROM (or 5 CDs), PrepLogic's CIW Database Specialist Design LearnSmart Video Training will help you prepare for the 1D0-441 exam. No other outside training is needed! In this comprehensive training, leading expert instructor Wayne Snyder teaches you the fundamentals of database design, database design methodology and application design with Java. Using his skilled background and a variety of visual resources, sample programs and clear step-by-step instructions, Wayne is able to clearly communicate information to you in a way that's easy to understand. When you've completed this LearnSmart Video Training, you will be comfortable with the concepts underlying enterprise data model design, and able to design and write platform independent applications too access Oracle, Sybase, Informix, Microsoft SQL Server and DB2 databases.


	CIW’s exam 1D0-441, CIW Database Specialist, is an elective requirement for the CIW Professional certification, and one of the requirements for the Master CIW Enterprise Developer certification. It is designed for candidates who are responsible for designing, implementing and maintaining database schemas; designing and developing database client applications and components; and performing database administration and maintenance. These candidates typically fulfill these roles: application developers, programmers, enterprise developers, Web developers and database developers. The prerequisites for this exam are: 1) to fill out the on-line CIW Certification Agreement; and 2) to hold the CIW Associate certification. CIW also recommends, but does not require, that students seeking Master CIW Enterprise Developer status to take (and pass) the CIW Web Languages (JavaScript and Perl), CIW Application Developer, Sun/jCert Java Programmer, and CIW Object-Oriented Analysis and Design with UML exams prior to the CIW Database Specialist exam. The pass score for this form-based multiple choice exam is 75%. There are 54 questions and the exam has a duration of 75 minutes. The topics covered by this exam include: Database management systems (DBMS), and advantages and disadvantages of using a DBMS Relational model terminology, relational tables and their characteristics Database design life cycle and aspects of database planning Relational database design methodology and phases of database design Normalization processes and normal forms Design issues related to logical and physical database design Database definition languages Structured Query Language (SQL) commands and syntax Relational algebra and concepts related to relational algebra JDBC API architecture and implementation of relational database management systems Establishment of database connections Table and query manipulation in a database using JDBC SQL statement storage and execution Prepared statements and stored procedures with database management systems (DBMS) DBMS or database metadata Scrollable and updatable result sets Batch updates (a new function of JDBC 2.0 that increases efficiency) Graphical database clients


	LearnSmart Video Training is so effective because it specifically meets the needs of the people who need it most. LearnSmart helps busy people learn everything they need to pass the exam without spending a lot of money, or sacrificing a lot of time at work or at home. You'll learn every topic, objective and domain from the most experienced IT trainers. And it's easy to use and engaging, so you can learn whenever and wherever you get the chance. Skip your classes, use LearnSmart Video Training and never open a book again.

CIW (1D0-441)

Database Specialist LearnSmart Video Training

Item: 010629

• 15 Hours of CBT • 1 DVD-ROM (or 5 CDs) • Self-paced learning • Industry expert instructors • Money Back Guarantee
just $440

Choose Your Media

Money Back Guarantee

CIW Server Administrator (ID0-450) LearnSmar...
Only $425

CIW Site Designer (1D0-420) LearnSmart Vide...
Only $355

Server 2003 Network Infrastructure (70-291...
Only $425



	Windows 7, Windows Vista; Windows XP Home / Professional 750 MHz processor or faster 64-MB RAM (128 MB if running Windows XP or Vista) 130 MB available hard disk space Super VGA (800x600) or higher resolution DVD-ROM or CD-ROM Drive 16-bit sound card Speakers or headphones Windows Media Player 9 or newer .NET Framework 2.0

Privacy Policy | Support | About PrepLogic | Contact Us

Copyright © PrepLogic.

CISSP® and (ISC)2® are registered marks of the International Information Systems Security Certification Consortium, Inc. PrepLogic and the material presented are not affiliated with or endorsed by (ISC)2®.

All trademarks and registered trademarks appearing within PrepLogic products and within the preplogic.com website are the property of their respective owners. Unless otherwise stated, PrepLogic is not affiliated with nor endorsed by these trademark owners.