From Serebra Learning Corporation
XML Implementation in Enterprise 
The
XML:
Implementation in
Enterprise WBT is the second course in the XML curriculum. This course is meant for
Web programmers in a multi-tier enterprise system who want to use XML to transport and exchange business data over the
Internet. The course details the role of XML and related technologies in enterprise computing. It also describes the procedures for using XML Schemas for ensuring
more...
Win2000 Active Directory Design Advanced Active Directory Concepts 
...implementation plan, by covering methods of extending the schema,
Active Directory data recovery and maintenance, and setup and upgrade strategies. First, you will learn about expanding and modifying the schema, prerequisites, implications of these changes, and methods for altering schema components. The course covers Active Directory data storage, transactions, maintenance, backup and
more...
Building a Data Warehouse 
The
Building a
Data Warehousing WBT is the second course in the
Data Warehousing curriculum. It provides students with an overview of the core technologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
more...
SQL Server 7.0 Management Part I 
This course is designed to teach the skills necessary to take full advantage of
SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data:
Transact-SQL at the command-line level and
SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the
more...
XML Schemas 


...Schemas is a more formal approach in document structure and validation. Schemas work in a similar fashion as a
DTD but can provide more stringent control over an
XML document and as a result, schemas are becoming more popular in the IT industry. This course will cover the rules and specifications in developing a schema including
Data types, simple and complex elements while retaining the
more...
Advanced NDS Tools and Diagnostics Part 3 
This is the final course in a three part series and instructs the learner how to resolve common
NDS issues. Beginning with hard disk upgrades the course covers time synchronization and schema issues as well as how to recover from server and communication failure.
more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema 
This course is the first in a two-part series on
SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views
B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will
more...
From 123-CBT Computer Based Training
NDS 8 0 Advanced Tools Diagnostics Part 3 

...disk upgrades, the course covers time synchronization and schema issues, as well as how to recover from server and communication failure. Learn To Covers the server operations performed for
NDS maintenance. How to remove a server, modify server identity, upgrade hardware, recover a failed server, NDS disaster recovery, and remote access server maintenance. Cover
more...
Oracle9i Database Admin Recover Databases 

...he command line interface. Import objects into a schema by using the command line interface function. Audience The intended audience for this course include
Database Administrators, IT managers, and technical professionals. There are no required prerequisites. Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits
Language more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies 

...sional data analysis. Identify the functions of the star schema model. Identify the new
OLAP SQL functions in
DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new features of federated databases. Identify the new
more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies 

...sional data analysis. Identify the functions of the star schema model. Identify the new
OLAP SQL functions in
DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new features of federated databases. Identify the new
more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects 

...ction by using
Transact-SQL. Identify characteristics of schema binding. Identify the features of stored procedures. Identify the considerations for creating stored procedures. Identify the features of encrypting stored procedures. Identify the characteristics of triggers. Identify the advantages of using triggers. Identify guidelines for creating triggers. Audience The intended
more...
IBM DB2 Universal Database V6 1--App Development 

...ions. Use different application objects in
DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use
SQL within an application. Use dynamic SQL within an application. C ontent
Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database
more...
IBM DB2 Universal Database V6 1--App Development 

...ions. Use different application objects in
DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use
SQL within an application. Use dynamic SQL within an application. C ontent
Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database
more...
Oracle8i Database Admin Manage Data Storage 

...two collection datatypes. Create a table by using
Oracle Schema Manager. Identify the guidelines to be followed while creating tables. Identify the value for the
PCTFREE parameter in a given situation. Match the row chaining and row migration events with the situations that trigger them. Copy an existing table by using Oracle Schema Manager. Identify the storage parameters that when
more...
Oracle8i Database Admin Manage Storage Structures 

...y the situations that lead to the creation of various non-schema object segments. Identify the situations that lead to the creation of various non-schema object segments. Identify the considerations behind the precedence order of storage parameters. Coalesce free space in a given tablespace by using
Oracle Tablespace Manager. Identify the correct sets of objects and their fragmentation
more...
Oracle Database 10g Administration Workshop II Part 3 

This course covers various functions of the
Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery 

...ps in which a table is imported.
Import objects into a schema.
Sequence steps to start an
Oracle database with a missing data file.
Identify the methods to enable parallel recovery, recover from lost control file,
Recovery Catalog, data file corruptions.
Identify the features and usage guidelines of standby database.
Manage standby database and identify the characteristics of
more...
Oracle8 Database Administration - Manage Security 

Course Overview
This course is the last in a five-part series covering the database administration strategies and procedures provided in
Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security.
L earn To:
Define and maintain the security domains for users in a given environment.
Define and maintain a named set of resources and
more...
Oracle8 Database Administration - Manage Data 

...two collection datatypes.
Create a table by using
Oracle Schema Manager.
Identify the guidelines to be followed while creating tables.
Identify the value for the
PCTFREE parameter in a given situation.
Match the row chaining and row migration events with the situations that trigger them.
Copy an existing table by using Oracle Schema Manager.
Identify the storage parameters that when
more...
Oracle8 Database Administration - Manage Storage Structures 

...y the situations that lead to the creation of various non-schema object segments.
Identify the situations that lead to the creation of various non-schema object segments.
Identify the considerations behind the precedence order of storage parameters.
Coalesce free space in a given tablespace by using
Oracle Tablespace Manager.
Identify the correct sets of objects and their fragmentation
more...
NetWare and Windows NT Integration - Part 2 

...TDS name space structure.
Identify the advantages of
NDS schema extensibility over
NTDS schema extensibility.
Identify the advantages of NDS distributed architecture over NTDS distributed architecture.
Identify the advantages of NDS network security over NTDS network security.
Identify the advantages of the NDS authentication process NDS over the NTDS authentication process.
Identify the
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 

... 2 Hour(s) Match the components of a multidimensional schema with their descriptions. Identify the benefits of
MDX SELECT statement as compared to
SQL. Match the
MDX expressions with their examples. Match the different methods of axis content specification with their examples. Match the keywords for dimension specification with their definitions. Match the groups of MDX advanced
more...
Oracle Database 10g SQL Fundamentals I Part 2 

...features of
SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. .
Learn To:
Identify the code for using the
INSERT statement.
Identify the code for
more...
Oracle SQL Tuning Diagnostics and Tuning Schema 

...e statements with their functions.
Unit 3:
Tuning the
Schema
Duration: 2 Hour(s)
Identify the levels of B*-tree index structure.
Identify the features of a B*-tree index scan.
Identify the columns on which a B*-tree index should ideally be created.
Create a B*-tree index by using
SQL commands.
Identify the features of bitmapped indexes.
Identify the advantages of bitmapped
more...
Site Server 3 0 Implementation - Part 2 

...erform the steps to test a catalog. Identify the catalog schema that allows site visitors to find information using
Search. Perform the steps to modify an existing
Web page to search catalog categories. Perform the steps to specify the predefined query strings. Perform the steps to examine a query. Identify ways to optimize cataloging performance. Identify the factors to be considered to
more...
XML Building XML-Based Web Applications Part 5 

... understanding of the mechanisms of data validation using schemas within
XML and a knowledge of the applications of XML within business and commercial environments. The course begins with a coverage of validation within XML and the advantages of schemas over
DTDs. The elements of an
XDR schema are covered along with the writing and extending of an XDR schema. Schema coverage is completed with a
more...
XML Building XML-Based Web Applications Part 5 

... understanding of the mechanisms of data validation using schemas within
XML and a knowledge of the applications of XML within business and commercial environments. The course begins with a coverage of validation within XML and the advantages of schemas over
DTDs. The elements of an
XDR schema are covered along with the writing and extending of an XDR schema. Schema coverage is completed with a
more...