Instructor Led Relational Data Training Classes

CIW Database Specialist Part 1: Introduction to Database Design ...ages of a flatfile database. Identify the problems that relational databases were developed to overcome. Identify requirements and scope for the analysis phase. Identify guidelines for processing information in the analysis phase. Identify criteria for selecting a database management system (DBMS) during the design phase. Topics Include Unit 1: Relational Databases Identify features  more...

CIW Database Specialist Part 2: Logical and Physical Design ...tabase design. Identify the types of relationships in a relational data model. Identify methods of resolving complex relationships. Identify characteristics of physical database design. Identify guidelines for creating base relations. Identify keywords used in data definition language (DDL). Topics Include Unit 1: Normalization Identify features of normalization. Identify  more...

Implementing a Microsoft SQL Server 2005 Database ...rking knowledge of Transact-SQL.   Working knowledge of relational databases.   Some experience with database design.   In addition, it is recommended, but not required, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.   Course Outline Module 1: Creating Databases and Database Files This module explains how to create  more...

Designing Microsoft SQL Server 2005 Server-Side Solutions This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005T. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to  more...

Jakarta Struts ...n mappings, form beans, and request forwarding.  They use relational data at the model layer and learn to configure JDBC data sources under Struts.  Throughout, the course emphasizes the great facility in Struts of using XML declarations to replace boilerplate Java coding.  The course then shifts from these controller techniques to a focus on presentation.  Students learn to use various  more...

Advanced Java Programming ...database using JDBC and perform a simple query.  Update relational data using JDBC to execute updates, inserts and deletes.  Use prepared statements to produce reusable database queries and optimize execution time.   Use callable statements to access database procedures.   Use scrollable and updatable results sets for more robust solutions.  Use commit, rollback, and savepoint to build  more...

Object and Data Modeling Workshop ...agrams to entity relationship diagrams (ERD) for use with Relational Data Base Management Systems (RDBMS). Understand the BA role on a Data Warehousing project and how to transition from relational transaction databases to a data warehouse. Use the Rational ROSE modeling tool to model business requirements. What you will learn: Principles of Object Oriented Analysis Benefit of  more...

Updating Your Database Development Skills to Microsoft SQL Server 2005 ...Query   Lab 3: Working with XML ? Retrieving XML from Relational Data   ? Storing XML Natively in the Databases   ? Using XQuery with xml Methods   After completing this module, students will be able to: ? Use enhanced XML features in SQL Server 2005.   ? Use the xml data type for typed and untyped XML.   ? Use XQuery expressions with XML data.   Module 4: Using Service Broker The  more...

Jakarta Struts Training This advanced Jakarta Struts training course shows JSP and servlet programmers how to build Model-2' Web applications using the Jakarta Struts project from Apache. Students learn the Jakarta Struts architecture and see how it captures a great deal of pre-existing best practice in Web application development. They build applications from scratch using the Struts 1.1 code base advancing through  more...

Introduction to Programming ...of data storage and management. Students will learn about relational data, entity relationships, and primary and foreign keys. They will also learn how XML can be used to describe and structure data. Lessons ? Introduction to Managing Data   ? Using the Entity Relationship Model   ? Sorting Data by Using Keys   ? Using XML   After completing this module, students will be able to: ?  more...

The JSP Standard Tag Library ... The SQL actions, which dramatically simplify access to relational data from a JSP The XML actions, which give JSPs a simple, powerful framework by which to parse, address and transform XML data using XPath and XSLT Each individual tag in each library is covered, with precise syntactic rules shown in a standard format in the student guide, and JSTL techniques and best practices are  more...