Online SQL eLearning - Training Resources

Java 2 -- Advanced Enterprise Java ...ill also learn about the different interfaces in the java.sql package. Finally, you will be able to write the code for adding, updating, and deleting records from a database. The second unit explains native methods and the procedure for invoking a native method. It explains how to write the native method implementations in C or C++. The unit also describes the Java Native Interface (JNI) and  more...

SQL Server 2000 - XML-Enabled Applications Using SQL 2000 This course is designed to teach students the basics of SQL and XML in building and combining applications where database functions are required This course will give students a good understanding of how to use SQL 2000 in building and integrating applications that use or require a database and are enabled with XML. Course includes a primer for SQL and XML calls for SQL. Course also covers using  more...

SQL Server 2000 Complete Course ...SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000. This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases, manage, monitor and  more...

Microsoft Access Gain a solid understanding of this powerful database management system Course is designed to provide the end user, with little or no prior experience using Microsoft Access, a solid understanding of the basic commands and features of this powerful database management system. As an introductory level class, topics to be covered include how to design, create, organize, display and query a database  more...

Database Design Concepts ...you will learn the basic concepts of database design, the SQL language and how to design and implement a simple relational database. The course is suitable for all kinds of audiences, as it starts with the very basic concepts of database design and presents the subject in an easy manner. Coursework focuses on the real-life implementation of database solutions and on practical design and  more...

Database Management ... relational PC-based database model including coverage of SQL. A highly useful methodology for designing databases is presented and illustrated through a variety of examples. This course is designed for anyone interested in gaining familiarity with database management. Someone taking this course should have some experience using a computer in a windows environment. No programming experience is  more...

Crystal Reports XI ...rivers, inner and outer joins, Structured Query Language (SQL), and updating and verifying data sources Your Crystal Reports XI training is presented by Jason Manibog, he has been in the IT business for the past eight years, five of those as a trainer/consultant. He has conducted numerous classes in Crystal Reports, from versions eight through 11 and has done a wide variety of consultations in  more...

Database Deployment and Data Distribution recognize how to design, deploy and utilize database deployment and database distribution solutions  more...

Designing Access to SQL Server Data recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data  more...

Designing Efficient Application Access recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management  more...

Designing Queries in SQL 2005 recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language  more...

Designing a SQL Server 2005 Cursor Strategy recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...

Designing a SQL Server 2005 Transaction Strategy recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005  more...

SQL Server 2005 Error Handling Techniques recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005  more...

Optimizing Query Performance and Index Strategies recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...

Optimizing Storage in SQL Server 2005 recognize how to optimize database storage and SQL Server performance  more...

Scaling Applications and Resolving Performance Issues recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result  more...

Designing Security for a Database Server Infrastructure for SQL Server 2005 To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment  more...

Designing the Physical Database for SQL Server 2005 To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures  more...

Designing a Database Server High Availability Solution for SQL Server 2005 To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution  more...

Designing a Database Failover Solution for SQL Server 2005 To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database  more...

Designing a Database Server Data Recovery Solution for SQL Server 2005 To select the appropriate data backup and recovery solution for a SQL Server 2005 database  more...

Optimizing SQL Server 2005 Performance To identify ways of optimizing the performance of SQL Server 2005  more...

Optimizing a Database Data Recovery Plan for SQL Server 2005 To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario  more...

Monitoring and Maintaining a Database in SQL Server 2005 To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005  more...

Managing Database Data in a SQL Server 2005 Environment To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database  more...

Managing Data Between Servers and Databases To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005  more...

Managing and Maintaining Database Security in SQL Server 2005 To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server  more...

Designing an Application Solution for SQL Server 2005 recognize how to design and build a database model and a physical database, and how to secure it  more...

Designing Database Objects recognize how to design database objects according to your requirements  more...

Programming with SQL Server 2005 recognize how to implement SQL Server 2005 programming features to work with database data  more...

Using XML recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language  more...

CLR Integration recognize how to use CLR integration in SQL Server 2005 to create, implement and work with data, and how to execute .NET assemblies to achieve this  more...

Database Testing and Code Management recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005  more...

Developing Applications that Use SQL Server Support Services recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker  more...

Developing Applications that Use SQL Server Business Intelligence Services recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements  more...

Oracle Database 11g Database Performance and Space Management To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.  more...

Oracle Database 11g Getting Started with SQL and PL SQL New Features To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements  more...

Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations  more...

Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...

Oracle Database 11g Using SQL to Query Your Database To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle Database 11g Conversion Functions Group Functions and Joins To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Introduction to Oracle and SQL in Oracle9i To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...

SQL Functions in Oracle9i To describe how to use SQL functions for data retrieval  more...

Subqueries Reporting and User-Access Control in Oracle9i To describe the use of subqueries, reporting, and user-access control in an Oracle9i database  more...

Defining and Manipulating Data in Oracle9i To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...

Oracle Database 10g Database Interfaces Release 2 To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces  more...

Oracle Database 10g The SQL Loader and PL SQL Release 2 To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...

Oracle Database 11g Change Management Overview and SQL Plan Management outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  more...

Oracle Database 11g Partitioning and Storage-Related Enhancements identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  more...

Oracle Database 11g Diagnostic Enhancements and Using the Data Recovery Advisor recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.  more...

Oracle Database 11g Managing the Schema Data and Concurrency Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency  more...

Introduction to Oracle and SQL in Oracle Database 10g To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...

SQL Functions in Oracle Database 10g To describe how to use SQL functions for data retrieval  more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases  more...

Group and Datetime Functions in Oracle Database 10g To demonstrate how to use group and datetime functions in Oracle 10g  more...

Subqueries and Hierarchical Queries in Oracle Database 10g To demonstrate how to use subqueries and hierarchical queries in Oracle 10g  more...

Regular Expressions and User Access in Oracle Database 10g To demonstrate how to use regular expression support and control user access in Oracle 10g  more...

Creating and Managing Tables and Constraints in Oracle Database 10g To demonstrate how to create and manage tables and constraints in Oracle 10g  more...

Database Objects in Oracle Database 10g To demonstrate how to create database views, sequences, indexes, and synonyms  more...

Managing Database Objects in Oracle Database 10g To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g  more...

Manipulating Data in Oracle Database 10g To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements  more...

Introduction to PL SQL To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL  more...

Using PL SQL with an Oracle Server To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block  more...

Using Control Structures To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct  more...

Using Composite Data Types To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records  more...

Explicit Cursors and Exception Errors To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled  more...

Creating Stored Procedures and Functions To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...

PL SQL Packages To create and work with Oracle 10g packages  more...

Oracle-Supplied Packages and DBMS_SCHEDULER To use Oracle-supplied packages  more...

Managing Dependencies To manage dependencies and recompile PL/SQL units  more...

Manipulating Large Objects in PL SQL To use LOBs and the DBMS_LOB package  more...

PL SQL Triggers To create and manage triggers  more...

Dynamic SQL and Metadata To write dynamic SQL and use the DBMS_METADATA package  more...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Controlling User Access and Managing Schema Objects To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Data Dictionary Views and Large Data Sets To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...

Oracle Database 11g Managing Data in Different Time Zones To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g PL SQL Variables Attributes and Executable Statements To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Implementing Security for SQL in VB NET Applications To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

SQL Server 2000 High Availability To describe the high availability of SQL Server 2000  more...

SQL Server 2000 XML and the Web To outline the relationship between SQL Server 2000, XML, and the Web  more...

Overview of SQL Server 2000 To provide a high-level overview of SQL Server  more...

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases  more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000  more...

SQL Server 2000 XML and the Web To outline the relationship between SQL Server 2000, XML, and the Web  more...

Designing and Implementing Security in SQL Server 2000 To use programming logic to implement security and describe the different levels of security  more...

The SQL Server 2000 Logical Data Model To describe SQL Server data entities and their normalization  more...

Using T-SQL in SQL Server 2000 To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements  more...

SQL Server 2000 Indexes To describe and show how to create and manage indexes  more...

SQL Server 2000 Programming Business Logic To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic  more...

SQL Server 2000 Transactions and Distributed Data To demonstrate how to utilize transactions and distributed data  more...

Analyzing and Optimizing SQL Server 2000 Queries To show how to analyze and optimize queries  more...

Installing SQL Server 2005 To install SQL Server 2005 and upgrade to SQL Server 2005 from previous versions  more...

Configuring SQL Server 2005 To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration  more...

Creating and Implementing Database Objects in SQL Server 2005 To create and implement key database objects in SQL Server 2005  more...

Retrieving Data and Running Queries in SQL Server 2005 To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005  more...

SQL Server 2005 Messaging and Querying Tools To implement Service Broker components and use full-text search in SQL Server 2005  more...

Managing and Maintaining SQL Server 2005 Databases To manage and maintain SQL Server 2005 databases  more...

SQL Server 2005 Database Performance and Optimization To monitor and optimize database performance using SQL Server utilities  more...

Monitoring and Diagnosing Database Problems in SQL Server 2005 To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)  more...

SQL Server 2005 High Availability and Disaster Recovery To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005  more...

SQL Server 2005 Backup and Restores To back up and restore a database in SQL Server 2005  more...

Manipulating Data with DB2 UDB To execute queries using SQL  more...

Overview of SQL Server 2000 To provide a high-level overview of SQL Server  more...

Installing Configuring and Upgrading SQL Server 2000 To describe how to install, configure, and upgrade SQL Server  more...

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases  more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000  more...

Security in a Microsoft SQL Server 2000 Environment To explain how to plan and implement security on a SQL 2000 database  more...

Managing SQL Server 2000 Databases To guide students in configuring, performing, and automating routine administrative tasks  more...

Backing Up SQL Server 2000 Databases To explain how to back up SQL Server databases  more...

Restoring SQL Server 2000 Databases To describe the process involved in restoring SQL Server databases  more...

SQL Server 2000 Replication To describe how to implement the SQL 2000 replication models  more...

Monitoring SQL Server 2000 Performance To explain how to monitor SQL Server for optimal performance  more...

Implementing Security for SQL in C NET Applications To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques  more...

Small Business Server 2000 To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000  more...

Project Server 2003 Installation and Configuration To install and configure IIS 6.0, SQL Server, and SharePoint for Project Server 2003  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum ...iculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum consists of four Skill  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ... Learning Time 6 to 8 hours 64332 Objectives Unit 1: SQL Statement Tuning 1 - 2 hours o Match the optimizer modes with their descriptions. o Match the OPTIMIZER_MODE parameter values with their description. o Identify the methods of creating stored outlines. o Set the value of the USE_STORED_OUTLINES parameter. o Match the values of the USE_PRIVATE_OUTLINES parameter with their  more...

Oracle9i Database Admin Set Up Oracle Net Services ...atabase administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total  more...

Oracle9i Database Admin Recover Databases ...149; Recover a database in the NOARCHIVELOG mode by using SQL*Plus. • Restore a database in the NOARCHIVELOG mode by using RMAN. • Sequence the steps to recover a failed database when it is in the ARCHIVELOG mode. • Store the archived logs in a new location by using the ALTER SYSTEM command. • Perform a offline database recovery by using SQL*Plus. • Perform an  more...

Oracle9i Database Admin Perform Database Backups ...stem utilities, Oracle9i utilities such as RMAN, standard SQL*Plus commands, and the Oracle Enterprise Manager Console. Students assess the status of critical database files using SQL*Plus commands. In addition, students create a standby database, identify the steps involved in synchronizing a standby database, and activate, refresh, and update a standby database. Learn To • Identify  more...

Oracle9i Database Admin Manage Security ...ies (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation  more...

Oracle9i Database Admin Manage Data Storage ...nship information and trigger information by using Oracle SQL*Plus Worksheet. • Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. • Identify the uses of the export and import utilities, the export modes, and the export paths. • Reorganize data using export and import, identify the features  more...

Oracle9i Database Admin Manage Storage Structures ...s 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation  more...

Oracle9i Database Admin Create a Database ...eve data dictionary information. • Execute catproc.sql and identify the uses of administrative scripts categories. • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of Oracle-supplied packages. • Retrieve information about stored objects, identify the common situations when dependent objects may have  more...

Oracle9i Database Admin Manage an Instance Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Oracle9i SQL DML and DDL ...SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The  more...

Oracle9i SQL Data Retrieval Techniques ...ourse covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o  more...

Oracle9i SQL Basic SELECT Statements ...al database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational model. o Match the  more...

Oracle9i SQL Curriculum The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Certified Database Administrator Track Curriculum The Complete Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the  more...

BizTalk Server 2000 Part 5 Secruity Optimization ...o • Identify Microsoft Windows 2000 and Microsoft SQL Server 2000 security features that are used by Microsoft BizTalk Server 2000. • Identify the tasks that can be performed by the BizTalk Server Administrators group and by the Windows 2000 Administrators group. • Identify features of logon properties and service accounts in the Microsoft BizTalk Server 2000 environment.  more...

BizTalk Server 2000 Part 4 Components Solutions Troubleshooting ...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74313 Objectives Unit 1: BizTalk Components 2 - 3 hours  more...

BizTalk Server 2000 Part 3 Monitoring Orchestration ...t Internet Information Services (IIS), ASP, and Microsoft SQL Server Enterprise Edition. Content Emphasis Conceptual Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74312 Objectives Unit 1: BizTalk Orchestration Designer 3 - 4  more...

BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting ...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74311 Objectives Unit 1: BizTalk Mapper 2 - 3 hours  more...

BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000 ...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74310 Objectives Unit 1: BizTalk Server 2000 Overview 1 -  more...

BizTalk Server 2000 Curriculum Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business  more...

MCDBA Curriculum Version II The Complete MCDBA Curriculum includes the following curriculums: Microsoft Windows 2000 Administration Curriculum (ID#7578) Microsoft Windows 2000 Installation, Configuration & Admin. Curriculum (ID#7586) Microsoft SQL Server 2000: Database Administration Curriculum (ID#7895) Microsoft SQL Server 2000: Designing & Implementing Databases Curriculum (ID#7901) MS Win 2000 Network  more...

CIW E-Commerce Designer Part 4 Site Implementation ...le8 package. Identify the main capabilities of Microsoft SQL Server. Audience Candidates for this exam design and implement commerce-driven Web sites, identify customer needs, monitor customer usage patterns, determine order processes and service after sales, and consider how e-business solutions can increase sales. Candidates include system administrators, application developers, and  more...

IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence .... Identify the guidelines for enabling dynamic to static SQL conversion. Identify the modes of the conversion mechanism. Identify the features of the DB2 Capture Utility (DB2CAP). Identify the features of DB2 Everyplace. Identify the DB2 Connect enhancements. Identify the functions of DB2 connection concentration. Audience The audience for this course includes database administrators,  more...

IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence .... Identify the guidelines for enabling dynamic to static SQL conversion. Identify the modes of the conversion mechanism. Identify the features of the DB2 Capture Utility (DB2CAP). Identify the features of DB2 Everyplace. Identify the DB2 Connect enhancements. Identify the functions of DB2 connection concentration. Audience The audience for this course includes database administrators,  more...

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ...series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify the optional tools of the DB2 family. Identify the  more...

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ...series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify the optional tools of the DB2 family. Identify the  more...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries ...iderations for defining views. Create a view by using an SQL Query Analyzer template. Audience Candidates for this course operate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include:  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...ruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for  more...

SQL Server 2000 Querying with Transact SQL Curriculum The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks ...l course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...ive part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects ...ive part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics.  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data ...ive part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical modeling. Identify the login authentication modes  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server ... and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify the features and functions of SQL Server 2000 services. Match the basic types of statements used in  more...

SQL Server 2000 Designing Implementing Databases Curriculum ...SQL Server 2000 Designing & Implementing Database Curriculum includes the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing Indexes)  more...

SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000 ...that deals with managing, monitoring, and troubleshooting SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring. Identify guidelines for performance tuning. Identify the  more...

SQL Server 2000 Database Admin Part 4 Managing Data ...ntify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of distributed data. Identify the different methods of distributing data. Identify the features of the publisher-subscriber metaphor. Identify the  more...

SQL Server 2000 Database Admin Part 3 Security Data Recovery ...ies that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000. Learn To Identify how login accounts are processed. Identify the characteristics of the two authentication modes. Sequence the steps to implement an authentication mode. Identify the guidelines for preventing data loss. Match database recovery  more...

SQL Server 2000 Database Admin Part 2 Manag Databases ...ll teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database information by using SQL Server Enterprise Manager. Match the different  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 ...al and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum hardware requirements for SQL Server 2000. Identify the typical hardware optimization  more...

SQL Server 2000 Database Administration Curriculum ...SQL Server 2000 Database Administration Curriculum includes the following courses: MS SQL Server 2000: Database Admin. Part 1(Install. SQL Server 2000) MS SQL Server 2000: Database Admin. Part 2(Managing Databases) MS SQL Server 2000: Database Admin. Part 3(Security & Data Recovery) MS SQL Server 2000: Database Admin. Part 4(Managing Data) MS SQL Server 2000: Database Admin. Part  more...

IBM DB2 Universal Database V6 1--App Development ... or OS/2 platforms. This course will teach students about SQL application development, application development objects, embedded SQL programming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application.  more...

IBM DB2 Universal Database V6 1--App Development ... or OS/2 platforms. This course will teach students about SQL application development, application development objects, embedded SQL programming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application.  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ws, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ws, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431  more...

IBM DB2 Universal Database V6 1--Administration ...s, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM  more...

IBM DB2 Universal Database V6 1--Administration ...s, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM  more...

IBM DB2 Universal Database V6 1--Fundamentals ...essing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database  more...

IBM DB2 Universal Database V6 1--Fundamentals ...essing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...ws, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration Certification: This curriculum will help candidates prepare for the  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...ws, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration Certification: This curriculum will help candidates prepare for the  more...

Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum ...6/6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the User  more...

Oracle PL SQL Database Programming ...he computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1 - 2  more...

Oracle PL SQL Procedures Functions Packages ...ree titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create and use packages. C ontent Emphasis Skills-Based A  more...

Oracle Designer 6i Curriculum The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the  more...

OCDBA8i Curriculum ...BA8i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an Instance(ID#7476)  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ...sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools to diagnose and resolve contention, given the possible causes of contention. Finally, the participants will be introduced to the features  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...ime 6 - 8 Hour(s) Course Contents Unit 1: Tuning SQL Duration: 1.5 - 2 Hour(s) Explain the plan for a query by using the EXPLAIN PLAN statement. Inspect the performance of a plan by setting up trace at the session level. Match the TKPROF options with their respective descriptions. Generate an execution plan at the system level for a SQL statement by using AUTOTRACE. Identify  more...

Oracle8i Performance Tuning Architecture Strategy ...rovide. Identify the functions performed by the utlbstat.sql and utlestat.sql scripts. Match sections of the report.txt output with potential problems and areas of focus for tuning. Locate Oracle supplied scripts used to provide additional statistics. Order the key steps in the Oracle Expert Tuning Methodology. Unit 4: Considerations for Tuning Applications Duration: 1 Hour(s)  more...

Oracle8i Database Admin Manage Security ...port Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help  more...

Oracle8i Database Admin Manage Data Storage ...port Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database  more...

Oracle8i Database Admin Manage Storage Structures ...port Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help  more...

Oracle8i Database Admin Create Databases ...ieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT  more...

Oracle8i Database Admin Manage an Instance ...port Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8  more...

Oracle Database 10g Administration Workshop II Part 3 ...quence the steps for configuring Flashback Database using SQL. Identify features of block corruption. Identify features of the DBVERIFY utility. Identify features of the ANALYZE command. Identify features of the advisory framework. Sequence the steps in an advisor tuning session. Sequence the steps for creating a custom Automatic Database Diagnostic Monitor (ADDM) task manually.  more...

SQL Server 7 0 Database Design Curriculum ...SQL Server 7.0 Database Design Curriculum consists of the following courses: SQL Server 7.0 Implementing a Database - Part 1 SQL Server 7.0 Implementing a Database - Part 2 SQL Server 7.0 Implementing a Database - Part 3 SQL Server 7.0 Implementing a Database - Part 4 SQL Server 7.0 Implementing a Database - Part 5 To review individual course descriptions, please return to the  more...

Oracle Reports R6 Control Reports ...oping templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and developing reports for different environments. This course is based on Oracle's ILT course, Oracle Developer: Build Reports. L earn To: Identify and modify the regions of a report template. Identify the steps to register your own predefined  more...

Oracle Reports R6 Enhance Reports ...ave knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first part in this  more...

Oracle Reports R6 Report Fundamentals ...ave knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit  more...

Oracle Form Builder R6 Including Reusable Oracle Components ...ave knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first five parts of the Oracle  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically ...ave knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle  more...

Oracle Form Builder R6 Project Builder and Menu Modules ...ave knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first three parts of the Oracle  more...

Oracle Form Builder R6 Writing and Debugging Code ... course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the communication formats used by Form Builder. Write the code to handle errors, suppress system messages, create alerts and control  more...

Oracle Form Builder R6 Enhancing the User Interface ...ave knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first part of the Oracle Developer  more...

Oracle Form Builder R6 Forms Fundamentals ...ave knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools to diagnose and resolve contention, given the possible causes of contention. Finally, the participants will be introduced to the features  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...me 6 - 8 Hour(s) Course Contents Unit 1: Tuning SQL Duration: 1.5 - 2 Hour(s) Identify the characteristics of a star query. Sequence the steps of a hash join process when a hash join is built. Use the EXPLAIN PLAN statement to explain the plan for a query. Perform the procedure to set trace up at the session level to look at the performance of a plan. Perform the steps to  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery ... taking this course, participants should be familiar with SQL and PL/SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the Oracle8 Database Administration series, courses 61311, 61312, 61313, 61314, and 61315, and have taken the first part of the Oracle8 Backup and Recovery series, course 61321. T otal Learning Time 6 -  more...

Oracle8 Backup and Recovery - Strategies and Backups ... taking this course, participants should be familiar with SQL and PL/SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the Oracle8 Database Administration series, courses 61311, 61312, 61313, 61314, and 61315. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Backup and Recovery Architecture  more...

Oracle8 Database Administration - Manage Security ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112, 60113, and 60114. In addition, participants should have taken the first four parts of the Oracle8 Database Administration series, courses 61311, 61312, 61313, and 61314. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Users  more...

Oracle8 Database Administration - Manage Data ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first three parts of the Oracle8 Database Administration series, courses 61311, 61312, and 61313. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Tables Duration: 1 - 2  more...

Oracle8 Database Administration - Manage Storage Structures ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first two parts of the Oracle8 Database Administration series, courses 61311 and 61312. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Storage Structures Duration: 1 - 2 Hour(s)  more...

Oracle8 Certified Database Administrator Curriculum ...tor Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage  more...

Oracle8 Database Administration - Create Databases ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first part of the Oracle8 Database Administration series, course 61311. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1 - Creating a Database: Procedure Duration: 1 - 2 Hour(s)  more...

Oracle8 Database Administration - Manage an Instance ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Architecture Components Duration: 1 - 2 Hour(s) Identify the tasks of a database administrator. Match the terms associated with establishing a database connection  more...

Oracle Report Builder Controlling Reports ...rticipants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of a report template. Modify template regions Register a predefined template. Add an image to a predefined template. Create and reference user and  more...

Oracle Report Builder Enhancing Reports ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. In addition, participants should have taken the first part in this series, course 61221. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Enhancing a Report - Data Model Duration: 1 - 2  more...

Oracle Report Builder Report Fundamentals ... to taking this course, participants should familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developer/2000 Report Builder Duration: 1.5 - 2 Hour(s) Identify the feature of Developer/2000 Match the components of Developer/2000  more...

Oracle Form Builder Including Reusable Oracle Components ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first five parts of the Oracle Form Builder series, courses 61211, 61212, 61213, 61214 and 61215. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Additional Data Sources  more...

Oracle Form Builder Handling Multiple Object Relationships ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first four parts of the Oracle Form Builder series, courses 61211, 61212, 61213, and 61214. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Key Triggers and Mouse Events  more...

Oracle Form Builder Managing Module Types ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition participants should have taken the first three parts of the Oracle Form Builder series, courses 61211, 61212, and 61213. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Project Builder Duration: 3 - 4 Hour(s)  more...

Oracle Cert App Developer Track for Developer 2000 R2 Curriculum ...000 Release 2 consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder:  more...

Oracle Form Builder Writing and Debugging Code ...participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify the descriptions of the communication formats used by Form Builder. Write codes to detect errors, suppress system messages, create alerts, and control  more...

Oracle Form Builder Enhancing the User Interface ... taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first part of the Oracle Form Builder series: Course 61211, Oracle Form Builder: Forms Fundamentals. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Creating Duration: 2 Hour(s)  more...

Oracle Workflow 11i10 Business Event System Subscriptions ...onsultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Events, Subscriptions, and Activities Identify features of business events. Identify options that enable you to define and  more...

Oracle Workflow 11i10 Interacting with Processes Notifications ...SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers. Learn To: Identify options for testing a workflow process. Identify options for administering workflow processes by using the Administrator Monitor. Identify options for administering workflow processes by using the Self-Service Monitor. Audience: The target audience is  more...

Oracle Workflow 11i10 Workflow APIs Procedures Error Handling ...his course covers Workflow Engine, background engines, PL/SQL procedures, workflow process APIs, Business Event System APIs, and error handling. It also covers abstract data types used by the Business Event System, event data generate functions, queue handlers, and subscription rule functions, and the error-handling features of workflow processes. Learn To: Identify features of the  more...

Oracle Workflow 11i10 Configuring Oracle Workflow Components ...onsultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Setting Up Oracle Workflow Identify the mandatory steps for setting up Oracle Workflow. Identify options that enable you to  more...

Oracle Workflow 11i10 Managing Customizing Workflow Processes ...SQL documents. It also covers how to include PL/SQL documents in messages. Further, it covers forced synchronous processes, selector/callback functions, standard API used to define selector/callback functions, and the code to define a selector/callback function. It also covers master/detail coordination activities. In addition, it covers how to customize and protect workflows. Finally, it  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 ...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0. L earn To: Identify the  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache;  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for optimizing aggregation  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 ...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data; and  more...

SQL Server 7 0 Designing Implementing Data Warehouses Curriculum ...esigning and Implementing Data Warehouses Using Microsoft SQL Server 7.0 Curriculum consists of the following courses: MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 MS SQL Server 7.0: Designing and Implementing Data  more...

SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 ...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and identify the guidelines for  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...atabase, maintain data integrity and import data. Write SQL statements to access data from tables and manipulate the data. Implement data access in applications through stored procedure model and cursors. Create transactions and implement locking strategies. C ontent Emphasis Skills-Based A udience This course is designed for programmers looking to develop applications  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 ...source editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft Message Queue Server (MSMQ). Describe two-tier and three-tier applications. Identify the element of Microsoft Transaction Server (MTS) environment and the steps to configure a client to use an MTS component. Install and configure Visual SourceSafe (VSS) and establish the source-code control environment.  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...rver solutions. L earn To: Identify features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets, modifying data and executing stored procedures. C ontent Emphasis Skills-Based A udience This course is designed for programmers  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2 ...d deploy packages in MTS. Implement security in MTS and SQL Server. C ontent Emphasis Skills-Based A udience This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should have completed the first course in this series. T otal Learning Time 6 - 8 Hour(s) Course  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 ...jects to access and manipulate data sources. Understand SQL Server security implementations. Implement an appropriate cursor for a recordset object. C ontent Emphasis Skills-Based A udience This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series. T  more...

Visual InterDev 6 0 Accessing Remote Data ...g recordset size. Manipulate database records by using SQL, stored procedures, data access models and cursors. Implement business rules by using triggers. Identify the components of Remote Data Services (RDS). Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS). Identify the benefits of using COM components. Create a  more...

Visual InterDev 6 0 Accessing Remote Data ...g recordset size. Manipulate database records by using SQL, stored procedures, data access models and cursors. Implement business rules by using triggers. Identify the components of Remote Data Services (RDS). Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS). Identify the benefits of using COM components. Create a  more...

Visual InterDev 6 0 Active Server Pages and Data Access ...d in the login authentication process for connecting to a SQL Server database. Add the connection information for connecting to a SQL Server database. Add a data connection to a project. Identify the features of a data command. Match the Query Designer panes with their functions. Add a data command to the data environment. Identify the data display and data manipulation controls.  more...

Oracle Workflow 11i10 Communications Function Activities ...onsultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Systems and Agents Identify features of systems. Identify features of agents. Identify options that enable you to define and  more...

Oracle Workflow 11i10 Components Planning Workflow Processes ...onsultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 2 hours Objectives: Unit 1: Introduction to Oracle Workflow Identify benefits of Oracle Workflow. Identify features of workflow processes. Identify  more...

Oracle Workflow 11i10 Developing Processes ...onsultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Oracle Workflow Process Identify guidelines for diagramming a workflow process. Define an item type. Define a process  more...

Oracle Database 10g SQL Fundamentals I Part 2 ...he learner will learn how to use the advanced 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  more...

Oracle Database 10g PL SQL Fundamentals Curriculum The Oracle Database 10g: PL/SQL Fundamentals Curriculum includes the following courses: Oracle Database 10g: PL/SQL Fundamentals (Part 1) Oracle Database 10g: PL/SQL Fundamentals (Part 2) Oracle Database 10g: PL/SQL Fundamentals (Part 3) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Database 10g PL SQL Fundamentals Part 1 ... The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as stored functions, stored procedures, and packages along with some standard Oracle supplied packages  more...

Oracle Database 10g SQL Fundamentals I Curriculum The Oracle Database 10g: SQL Fundamentals I Curriculum includes the following courses: Oracle Database 10g: SQL Fundamentals I (Part 1) Oracle Database 10g: SQL Fundamentals I (Part 2) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...tionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER) model. Identify features of Relational Database Management System (RDBMS). Identify the SQL statement to retrieve data from tables.  more...

Oracle Database Administration Workshop I Part 2 ... at length. Attention has been paid to DML and also to PL/SQL code, which is Oracle's proprietary fourth generation programming language that enables Oracle applications to interact over different operating systems and hardware platforms. Learn To: Identify features of database user accounts and profiles in Oracle Database 10g. Identify options you can configure when creating a  more...

Introduction to Data Warehousing ...dentify the components of the Data Mart suite. Match the SQL*Loader mechanisms with their functions. Identify the features of Gateways. Match the modules of Designer/2000 with their functions. Match the types of query techniques with their features. Identify the features of the Discoverer query and reporting tool. Match the Express Analyzer tools with their features. Identify the  more...

Oracle SQL Specifics Retrieving and Formatting Data ... This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL  more...

Oracle SQL Specifics Creating and Managing Database Objects ... This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views, sequences,  more...