Online Use Sql eLearning

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

Introduction to Oracle and SQL in Oracle Database 10g Introduction to Oracle and SQL in Oracle Database 10g Oracle 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 SQL Functions in Oracle Database 10g Oracle To describe how to use SQL functions for data retrieval  more...

Explicit Cursors and Exception Errors Explicit Cursors and Exception Errors Oracle 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...

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

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

Oracle Database 10g Database Interfaces Oracle Database 10g: Database Interfaces Oracle 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 Oracle Database 10g: The SQL*Loader and PL/SQL Oracle To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...

Oracle Database 11g Getting Started with SQL and PL SQL New Features Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle 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...

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

CLR Integration CLR Integration Microsoft 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...

Developing Applications that Use SQL Server Support Services Developing Applications that Use SQL Server Support Services Microsoft 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 Developing Applications that Use SQL Server Business Intelligence Services Microsoft recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements  more...

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Data Management Localization Encryption in Linux Data Management, Localization, & Encryption in Linux CompTIA CompTIA Linux Powered by LPI LX0-102 CompTIA Linux The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and Linux data security using GnuPG and OpenSSH. This course  more...

Querying XML Data With XPath and XQuery Querying XML Data With XPath and XQuery The XML Path Language, XPath, is designed to allow the developer to select specific parts of an XML document. XPath is also used extensively with the XML query language, or XQuery. This course will cover how to use these languages to both navigate and query XML data. Specific topics covered include XPath basics, XPath functions, as well XQuery built-in  more...

Data Management Localization Encryption in Linux Data Management, Localization & Encryption in Linux Linux Professional Institute LPI: Junior Level Linux Professional Exam 102: Junior Level Linux Professional (LPIC-1) The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and  more...

Advanced Querying in Access 2003 Advanced Querying in Access 2003 Microsoft To use advanced queries such as joins, parameter, action, and SQL queries  more...

Advanced Data Management in Access 2007 Advanced Data Management in Access 2007 Microsoft You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports,  more...

Using Query Notifications Synchronizing Data With VB 2008 Using Query Notifications & Synchronizing Data With VB 2008 Microsoft Query notifications, coupled with ADO.NET synchronization services, allow developers to create applications with the ability to display up-to-date data at all times. This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific  more...

SQL Server 2008 Security Management SQL Server 2008: Security Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Microsoft SQL Server 2008 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified  more...

SQL Server 2008 Database Management SQL Server 2008: Database Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks  more...

SQL Server 2008 Database Monitoring and Performance ... same data in a database. This course demonstrates how to use SQL Server Profiler, the Database Engine Tuning Advisor, Resource Monitor, and the data collector to monitor and tune the performance of the database. It also addresses how to use the Windows System Monitor, Activity Monitor, and how to detect and resolve locks. This course is one of a series in the SkillSoft learning path that  more...

SQL Server 2008 Backups Restores and Database Snapshots SQL Server 2008: Backups, Restores and Database Snapshots Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data  more...

Creating Modifying Table Index Partitions in SQL Server 2008 Creating & Modifying Table & Index Partitions in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables  more...

Running Queries Manipulating Data in SQL Server 2008 Running Queries & Manipulating Data in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query  more...

Creating Implementing Programming Objects in SQL Server 2008 Creating & Implementing Programming Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not  more...

Querying Managing XML Data inSQL Server 2008 Querying & Managing XML Data inSQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) XML has been integrated into SQL Server 2008 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 also provides support for  more...

Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes Using SQL Server 2008 Messaging, Full-Text Search, Scripts & Track Changes Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows  more...

Gathering Performance Data in SQL Server 2008 ...s how to view execution plans for transactions and how to use SQL Server Profiler to monitor the databases. It also demonstrates how to tune a database using a workload in Database Engine Tuning Advisor tool and how to use DMVs and catalog views to view system metadata. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS:  more...

Implementing SQL Server 2008 Integration Services Implementing SQL Server 2008 Integration Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core,  more...

Deploying SQL Server 2008 Integration Services Package Deploying SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an  more...

Implementing SQL Server 2008 Reporting Services Solutions Implementing SQL Server 2008 Reporting Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and  more...

Deploying Delivering SQL Server 2008 Reporting Services Reports Deploying & Delivering SQL Server 2008 Reporting Services Reports Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and  more...

Maintaining SQL Server 2008 Reporting Services Maintaining SQL Server 2008 Reporting Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course  more...

Implementing SQL Server 2008 Analysis Services Solutions Implementing SQL Server 2008 Analysis Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business.  more...

Managing SQL Server 2008 Analysis Services Solutions ...rvices, how you can process SSAS objects, and how you can use SQL Server Profiler to monitor analysis services.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist  more...

Managing SSIS Packages in SQL Server 2008 Managing SSIS Packages in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course  more...

Oracle Database 11g Managing PL SQL Code Dependencies Oracle Database 11g: Managing PL/SQL Code & Dependencies Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...

Oracle Database 11g PL SQL Code Dependency Management Oracle Database 11g: PL/SQL Code & Dependency Management Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

Oracle Database 11g Performance Tuning Methodology Tools Oracle Database 11g: Performance Tuning Methodology & Tools Oracle Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool, Enterprise Manager, can be used to monitor an  more...

Oracle Database 11g Using AWR Defining Problems Oracle Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  more...

Oracle Database 11g SQL Performance Database Replay Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...

Oracle Database 11g Segment Space I O and Performance Tuning Oracle Database 11g: Segment Space, I/O and Performance Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...c sampling, and manipulating optimizer statistics. if you use SQL statements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each literal, you use a bind variable, then in theory that extra parse activity is eliminated. Listing the  more...

Oracle Database 11g Firewalls Oracle Connection Manager and SQL Plus Security Oracle Database 11g: Firewalls, Oracle Connection Manager and SQL*Plus Security Oracle There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals: security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,  more...

Oracle Database 11g R2 Using Change Management Solutions Oracle Database 11g R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements Oracle Database 11g R2: Intelligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded  more...

Oracle Database 11g R2 Diagnosability Enhancements ...ecks and viewing the reports. It also demonstrates how to use SQL Repair Advisor and SQL Test Case Builder. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements Oracle Database 11g R2: SQL Monitoring & Performance Enhancements Oracle Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the  more...

Oracle Database 11g R2 Application Performance Enhancements Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup Oracle Database 11g R2: Oracle Scheduler & Secure Backup Oracle Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing  more...

Oracle Database 11g R2 Moving Data Oracle Support Oracle Database 11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also  more...

Administering Microsoft ® SQL Server 2000 (SQL) This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases. This course is design to help students master the concept of administering Microsoft? SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade,  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...

Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you  more...

Database Management This course features coverage of the important aspects of the 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  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 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 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 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...

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  more...

Oracle Database 10g SQL Fundamentals I Part 2 In this course, the 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  more...

Oracle Database 10g PL SQL Fundamentals Part 1 In this course, the learner will get familiar with the procedural language to access Oracle database. 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  more...

Oracle Database 10g SQL Fundamentals I Part 1 In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, 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  more...

Oracle SQL Specifics Retrieving and Formatting Data Course Overview 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  more...

Oracle SQL Specifics Creating and Managing Database Objects ...ol transactions. Control DBA and user access. Use SQL*Plus commands. C ontent Emphasis Skills-Based A udience Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL and first course in this series, Oracle SQL Specifics: Retrieving and Formatting Data (Course 60116). T otal Learning Time 6 - 8  more...

Oracle SQL and SQL Plus Advanced SELECT Statements Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write  more...

Oracle SQL Tuning Diagnostics and Tuning Schema Course Overview 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  more...

Oracle SQL Tuning Tuning SQL and the Optimizer Course Overview This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse  more...

Oracle Form Builder Handling Multiple Object Relationships Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items. L  more...

Oracle Form Builder Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.  more...

Oracle Report Builder Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...

Oracle Report Builder Enhancing Reports Course Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  more...

Oracle Report Builder Controlling Reports Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants 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  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first 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 procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle8 Database Administration - Create Databases Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...

Oracle8 Database Administration - Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To:  more...

Oracle8 Performance Tuning Managing Memory and Disk I O Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for 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  more...

Oracle Form Builder R6 Forms Fundamentals Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  more...

Oracle Form Builder R6 Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...

Oracle Form Builder R6 Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...

Oracle Reports R6 Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  more...

SQL Server 7 0 System Administration - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the methods and attributes of SQL Server 7.0 replication. Identify and apply techniques for planning and setting up SQL Server 7.0 replication. Identify the procedures  more...

SQL Server 7 0 - Implementing a Database - Part 1 Course Overview This is the first course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

SQL Server 7 0 System Administration - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how  more...

SQL Server 7 0 System Administration - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Automate SQL Server 7.0 administrative tasks. Identify and use the SQL Server 7.0 tools for transferring and transforming data. Identify and use the tools for monitoring and  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...

SQL Server 7 0 - Implementing a Database - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and  more...

SQL Server 7 0 - Implementing a Database - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 Course Overview This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, 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;  more...

SQL and PL SQL PL SQL Basics Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

SQL and PL SQL Data Retrieval Techniques ... to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that  more...

SQL and PL SQL DML and DDL Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  more...

Oracle8i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. 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...

Oracle8i Performance Tuning Architecture Strategy Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for 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.  more...

Oracle PL SQL Procedures Functions Packages 61114 Course Overview This course is the second in a series of three 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  more...

Oracle PL SQL Database Programming Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

Oracle SQL for End Users--Part 1 Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the  more...

Oracle SQL for End Users--Part 2 Course Overview This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to 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. General categories include system administrators, database administrators, application developers, systems analysts, and  more...

SQL Server 2000 Database Admin Part 2 Manag Databases ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to 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. General categories include system administrators, database administrators, application developers, systems analysts, and  more...

SQL Server 2000 Database Admin Part 3 Security Data Recovery ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to 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. General categories include system administrators, database administrators, application developers, systems analysts, and  more...

SQL Server 2000 Database Admin Part 4 Managing Data ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to 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. General categories include system administrators, database administrators, application developers, systems analysts, and  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server Course Overview This is the first course in a five part series that presents students with both theoretical 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  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data Course Overview This is the second course in a five 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  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator. In addition, students  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should also be familiar with the role of the database administrator. In addition,  more...

SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Learners are expected to have experience with using the Microsoft Windows 2000 operating system. Learners are also expected to have an understanding of basic relational database concepts and have knowledge of basic Transact-SQL syntax. In addition,  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...erate 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: system administrators, database administrators, application developers, system analysts, and software engineers. Students are  more...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries ...erate 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: system administrators, database administrators, application developers, system analysts, and software engineers. Students are  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...

BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000 Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements  more...

BizTalk Server 2000 Part 3 Monitoring Orchestration Course Overview This is the third course in a five part series that deals with the tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three  more...

BizTalk Server 2000 Part 4 Components Solutions Troubleshooting Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application  more...

BizTalk Server 2000 Part 5 Secruity Optimization Course Overview This is the last course in a five part series that deals with the securing of the BizTalk Server 2000 environment and the configuring of servers and groups of servers and optimization of server group performance. This course covers the use of tools and utilities to monitor the status of the BizTalk Server 2000 environment. Learn To • Identify Microsoft Windows 2000 and  more...

Oracle9i SQL Basic SELECT Statements This course covers relational 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  more...

Oracle9i SQL Data Retrieval Techniques This course 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 DML and DDL The Oracle 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.  more...

Oracle9i Database Admin Manage Data Storage ...ts, 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 and process of transportable tablespaces and the restrictions while using them. Audience The intended audience for  more...

Oracle9i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...

Oracle9i Database Admin Set Up Oracle Net Services Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To •  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the  more...

Crystal Reports 8 5 Introductory Report Design Part 2 Course Overview This is the second course in a two part series that builds on the information taught in the first course, Crystal Reports 8.5: Introductory Report Design Part 1 (13889). Learners will be working with formulas, linking reports, working with Cross-tabs, formatting sections, creating charts, and creating geographical maps. After completing this course, learners will be able to use  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum The courses in this curriculum 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  more...

Oracle 9i New Features Backup Recovery Performance Tuning This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned  more...

Commerce Server 2000 Design Impl Part 3 Pipelines This is the third course in a five part series that focuses on pipelines and their use in running ad campaigns. It covers how to define and run a pipeline in Microsoft Commerce Server 2000, and how to create custom components - Scriptor and Compiled - that can be added to a pipeline. The course also covers the code used to implement campaigns built and designed by Commerce Server 2000. Learn To:  more...

Database Technologies Introduction to SQL The second in a two-part series, this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

Windows 2000 Implementing Security Part 2 This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: • To identify guidelines for planning  more...

Windows 2000 Implementing Security Part 2 This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: • To identify guidelines for planning  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 Course Overview This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server 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,  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...

IBM DB2 Universal Database V6 1--App Development ...amming, 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. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application  more...

IBM DB2 Universal Database V6 1--App Development ...amming, 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. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application  more...

Commerce Server 2000 Design Impl Part 5 Infra Sec Admin This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and  more...

Microsoft NET Tech Overview Part 1 NET Platform Framework This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such  more...

Oracle Database 10g PL SQL Fundamentals Part 3 In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements  more...