Online Database The eLearning

DATABASE DESIGN DATABASE DESIGN  more...

DATABASE FUNDAMENTALS DATABASE FUNDAMENTALS  more...

Access 2002 Advanced Access 2002: Advanced Microsoft Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database  more...

Access 2002 Intermediate Access 2002: Intermediate Microsoft Lesson 1: The Access Interface Introduction Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using  more...

Access 2002 Basic Access 2002: Basic Microsoft Lesson 1: The Access Interface & Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status  more...

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

Configuring SQL Server 2005 Configuring SQL Server 2005 Microsoft 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 Creating and Implementing Database Objects in SQL Server 2005 Microsoft To create and implement key database objects in SQL Server 2005  more...

Retrieving Data and Running Queries in SQL Server 2005 Retrieving Data and Running Queries in SQL Server 2005 Microsoft 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 SQL Server 2005 Messaging and Querying Tools Microsoft To implement Service Broker components and use full-text search in SQL Server 2005  more...

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

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

Monitoring and Diagnosing Database Problems in SQL Server 2005 Monitoring and Diagnosing Database Problems in SQL Server 2005 Microsoft 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 SQL Server 2005 High Availability and Disaster Recovery Microsoft To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005  more...

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

An Overview of Database Design An Overview of Database Design To describe the process of relational database design to model real-world concepts  more...

The Database Design Methodology The Database Design Methodology To describe and apply the techniques of the database design life cycle to build a relational database  more...

An Introduction to Database Systems An Introduction to Database Systems To explain the main concepts of database systems  more...

Relational Databases Relational Databases To describe the concepts of relational databases  more...

Database Data Management Database Data Management To describe database data management and data access  more...

Oracle Application Server 10g mod_pl sql CGI Scripts and Database Providers Oracle Application Server 10g: mod_pl sql, CGI Scripts, and Database Providers Oracle To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS  more...

Discover Access 2007 Level 3 Discover Access 2007: Level 3 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Discover Access 2007 Level 2 Discover Access 2007: Level 2 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Discover Access 2007 Level 1 Discover Access 2007: Level 1 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Oracle Database 11g PL SQL Variables Attributes and Executable Statements Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle 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 Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle 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...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle 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 Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle 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 Oracle Database 11g: Data Dictionary Views and Large Data Sets Oracle 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 Oracle Database 11g: Managing Data in Different Time Zones Oracle 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 10g New Installation and Configuration Features Oracle Database 10g: New Installation and Configuration Features Oracle To discuss the new installation and configuration features of Oracle 10g  more...

Oracle Database 10g New Data Loading Features Oracle Database 10g: New Data Loading Features Oracle To discuss new data loading features in Oracle 10g  more...

Oracle Database 10g New Automatic Management and Management Infrastructure Feat Oracle Database 10g: New Automatic Management and Management Infrastructure Feat Oracle To identify the new automatic management and management infrastructure features of Oracle 10g  more...

Oracle Database 10g New Resource Scheduling and Task-Management Features Oracle Database 10g: New Resource, Scheduling, and Task-Management Features Oracle To identify the new resource, scheduling, and task-management features of Oracle 10g  more...

Oracle Database 10g New Space Management Features Oracle Database 10g: New Space Management Features Oracle To identify the new space management features of Oracle 10g  more...

Oracle Database 10g New Storage Features Oracle Database 10g: New Storage Features Oracle To identify the new storage features of Oracle Database 10g  more...

Oracle Database 10g New Tuning Performance-monitoring and Analysis Features Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features Oracle To use Oracle 10g's new tuning, performance-monitoring, and analysis features  more...

Oracle Database 10g New Backup and Recovery Features Oracle Database 10g: New Backup and Recovery Features Oracle To use Oracle 10g's new backup and recovery features  more...

Oracle Database 10g Using Flashback Oracle Database 10g: Using Flashback Oracle To recognize Oracle 10g's Flashback technology and use Flashback features  more...

Oracle Database 10g New Features in Security and Software Maintenance Oracle Database 10g: New Features in Security and Software Maintenance Oracle To use the new security and software upgrade features in Oracle 10g  more...

Oracle Database 10g New Features in VLDB Support Oracle Database 10g: New Features in VLDB Support Oracle To use Oracle 10g's new VLDB support features  more...

Oracle Database 10g Miscellaneous New Features Oracle Database 10g: Miscellaneous New Features Oracle To recognize how various new features are used in Oracle 10g  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...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Oracle 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 Group and Datetime Functions in Oracle Database 10g Oracle To demonstrate how to use group and datetime functions in Oracle 10g  more...

Designing a Database Server Infrastructure for SQL Server 2005 Designing a Database Server Infrastructure for SQL Server 2005 Microsoft To specify the appropriate requirements for implementing SQL Server 2005, identify suitable instance and physical storage strategies, and determine the appropriate way to design a database consolidation plan, given a SQL Server scenario  more...

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

Regular Expressions and User Access in Oracle Database 10g Regular Expressions and User Access in Oracle Database 10g Oracle 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 Creating and Managing Tables and Constraints in Oracle Database 10g Oracle To demonstrate how to create and manage tables and constraints in Oracle 10g  more...

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

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

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

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

Using PL SQL with an Oracle Server Using PL/SQL with an Oracle Server Oracle 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 Using Control Structures Oracle 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 Using Composite Data Types Oracle 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 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...

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

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

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

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

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

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

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

Oracle Database 10g Installing Oracle Database 10g Oracle Database 10g: Installing Oracle Database 10g Oracle To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software  more...

Oracle Database 10g Creating Databases Oracle Database 10g: Creating Databases Oracle To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant  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 Database Control and Storage Structures Oracle Database 10g: Database Control and Storage Structures Oracle To explain the fundamentals of Oracle database control and how to use tablespaces  more...

Oracle Database 10g Users and Security Oracle Database 10g: Users and Security Oracle To explain how to manage users, implement security, and audit database activity on an Oracle 10g database  more...

Oracle Database 10g Managing Schema Objects and Data Oracle Database 10g: Managing Schema Objects and Data Oracle To demonstrate how to manage schema objects and data in an Oracle 10g database  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 10g Oracle Net Services and Shared Servers Oracle Database 10g: Oracle Net Services and Shared Servers Oracle To provide an overview of Oracle Net Services and Shared Server  more...

Oracle Database 10g Monitoring and Maintenance Oracle Database 10g: Monitoring and Maintenance Oracle To demonstrate how to control database performance and configure proactive database maintenance  more...

Oracle Database 10g Managing Undo Data and Lock Conflicts Oracle Database 10g: Managing Undo Data and Lock Conflicts Oracle To discuss how to manage undo data and manage lock conflicts in an Oracle database  more...

Oracle Database 10g Managing Backup and Recovery Oracle Database 10g: Managing Backup and Recovery Oracle To discuss how to manage backup and recovery 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...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements Oracle 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 Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements Oracle 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 Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousin Oracle 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 Oracle Database 11g: Using SQL to Query Your Database Oracle 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 Oracle Database 11g: Conversion Functions, Group Functions, and Joins Oracle 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 Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle 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 Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle 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...

Managing Data and Distributing Reports with Crystal Reports XI Managing Data and Distributing Reports with Crystal Reports XI SAP To recognize how to manipulate data and distribute reports  more...

Reporting Basics with Crystal Reports XI Reporting Basics with Crystal Reports XI SAP To recognize how to create a report in Crystal Reports XI  more...

Data Integration with Visual Basic 2005 and ASP NET 2 0 Data Integration with Visual Basic 2005 and ASP.NET 2.0 Microsoft To configure data controls and to establish and configure database connections in .NET 2.0 web applications  more...

Data Integration Database Environments and XML Handling with Visual Basic 2005 Data Integration, Database Environments, and XML Handling with Visual Basic 2005 Microsoft To identify how to configure database connections and handle XML data in Windows Forms applications  more...

Data Integration with C 2005 and ASP NET 2 0 Data Integration with C# 2005 and ASP.NET 2.0 Microsoft To configure data controls and to establish and configure database connections in .NET 2.0 web applications  more...

Data Integration Database Environments and XML Handling with C 2005 Data Integration, Database Environments, and XML Handling with C# 2005 Microsoft To identify how to configure database connections and handle XML data in Windows Forms applications  more...

Access XP Proficient Expert Access XP Proficient & Expert Microsoft DiscoverWare's Discover Access XP is an interactive productivity tool for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts  more...

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

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

Programming with SQL Server 2005 Programming with SQL Server 2005 Microsoft recognize how to implement SQL Server 2005 programming features to work with database data  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...

Database Testing and Code Management Database Testing and Code Management Microsoft 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 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...

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

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

Designing Efficient Application Access Designing Efficient Application Access Microsoft 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 Designing Queries in SQL 2005 Microsoft 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 Designing a SQL Server 2005 Cursor Strategy Microsoft recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...

Designing a SQL Server 2005 Transaction Strategy Designing a SQL Server 2005 Transaction Strategy Microsoft 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 SQL Server 2005 Error Handling Techniques Microsoft 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 Optimizing Query Performance and Index Strategies Microsoft recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...

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

Scaling Applications and Resolving Performance Issues Scaling Applications and Resolving Performance Issues Microsoft 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 Designing Security for a Database Server Infrastructure for SQL Server 2005 Microsoft 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 Designing the Physical Database for SQL Server 2005 Microsoft 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 Designing a Database Server High Availability Solution for SQL Server 2005 Microsoft 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 Designing a Database Failover Solution for SQL Server 2005 Microsoft 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 Designing a Database Server Data Recovery Solution for SQL Server 2005 Microsoft To select the appropriate data backup and recovery solution for a SQL Server 2005 database  more...

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

Optimizing a Database Data Recovery Plan for SQL Server 2005 Optimizing a Database Data Recovery Plan for SQL Server 2005 Microsoft 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 Monitoring and Maintaining a Database in SQL Server 2005 Microsoft 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 Managing Database Data in a SQL Server 2005 Environment Microsoft 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 Managing Data Between Servers and Databases Microsoft 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 Managing and Maintaining Database Security in SQL Server 2005 Microsoft 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...

MICROSOFT SQL SERVER 2005 DESIGNING DATABASE SOLUTIONS MICROSOFT SQL SERVER 2005: DESIGNING DATABASE SOLUTIONS Microsoft  more...

MICROSOFT SQL SERVER 2005 DESIGNING OPTIMIZING DATA ACCESS MICROSOFT SQL SERVER 2005: DESIGNING & OPTIMIZING DATA ACCESS Microsoft  more...

ORACLE DATABASE 11G PL SQL FUNDAMENTALS ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS Oracle  more...

ORACLE DATABASE 11G SQL FUNDAMENTALS II ORACLE DATABASE 11G: SQL FUNDAMENTALS II Oracle  more...

Oracle 11g DBA OCA Library Oracle 11g DBA OCA Library Oracle Oracle Database 11g Administrator Certified Associate Oracle Database Administrator 11g Certfied Associate Library  more...

CISSP Domain Application Development Security CISSP Domain: Application Development Security (ISC)2 CISSP - Certified Information Systems Security Professional Certified Information Systems Security Professional (CISSP) 2nd Edition Poorly written applications can allow an attacker to exploit coding errors and thus interrupt the orderly processes of the application. This course discusses methods to increase the security of application  more...

MICROSOFT SQL SERVER 2005 IMPLEMENTATION AND MAINTENANCE MICROSOFT SQL SERVER 2005: IMPLEMENTATION AND MAINTENANCE Microsoft  more...

MICROSOFT SQL SERVER 2005 INFRASTRUCTURE DESIGN MICROSOFT SQL SERVER 2005: INFRASTRUCTURE DESIGN Microsoft  more...

MICROSOFT SQL SERVER 2005 DATABASE MAINTENANCE MICROSOFT SQL SERVER 2005: DATABASE MAINTENANCE Microsoft  more...

ORACLE DATABASE 10g NEW FEATURES ORACLE DATABASE 10g: NEW FEATURES Oracle  more...

ORACLE DATABASE 10g SQL FUNDAMENTALS I II ORACLE DATABASE 10g: SQL FUNDAMENTALS I & II Oracle  more...

ORACLE DATABASE 10g PROGRAMMING WITH PL SQL I ORACLE DATABASE 10g: PROGRAMMING WITH PL/SQL I Oracle  more...

ORACLE DATABASE 10g DEVELOPING PL SQL PROGRAM UNITS ORACLE DATABASE 10g: DEVELOPING PL/SQL PROGRAM UNITS Oracle  more...

ORACLE DATABASE 10g ADMINISTRATION WORKSHOP I RELEASE 2 ORACLE DATABASE 10g: ADMINISTRATION WORKSHOP I RELEASE 2 Oracle  more...

Oracle Database 11g R2 Database Architecture Recovery Operations Oracle Database 11g R2: Database Architecture & Recovery Operations Oracle An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as  more...

Oracle Database 11g R2 The RMAN Catalog Creataing Backups Oracle Database 11g R2: The RMAN Catalog & Creataing Backups Oracle RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various  more...

ORACLE DATABASE 11G ADMINISTRATION WORKSHOP II R2 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II R2 Oracle  more...

Oracle Database 11g R2 Managing Database Space Duplication Oracle Database 11g R2: Managing Database Space & Duplication Oracle To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace  more...

Oracle Database 11g R2 Managing Databse Resources The Scheduler Oracle Database 11g R2: Managing Databse Resources & The Scheduler Oracle By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control  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...

Oracle Database 11g R2 Database Diagnostics Flashsback Technologies Oracle Database 11g R2: Database Diagnostics & Flashsback Technologies Oracle Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic  more...

Oracle Database 11g R2 Performing Restore Recovery Tasks Oracle Database 11g R2: Performing Restore & Recovery Tasks Oracle As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying  more...

Oracle Database 11g R2 Using Monitoring Tuning RMAN Oracle Database 11g R2: Using, Monitoring & Tuning RMAN Oracle Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an  more...

ORACLE DATABASE 11g SQL PL SQL NEW FEATURES ORACLE DATABASE 11g: SQL & PL/SQL NEW FEATURES Oracle  more...

ORACLE DATABASE 11g SQL FUNDAMENTALS I ORACLE DATABASE 11g: SQL FUNDAMENTALS I Oracle  more...

Cisco IINS 1 0 Perimeter Security Cisco IINS 1.0: Perimeter Security Cisco Cisco Certified Network Associate Security (CCNA Security) 640-553 Implementing Cisco IOS Network Security 1.0 Traffic from outside a closed network that has a destination inside a closed network passes through the network perimeter. The routers at the network perimeter are an important initial point of network security. This course explains how to  more...

Internet-based Database-based Attacks Internet-based & Database-based Attacks Internet-based attacks and the mechanisms used to both accomplish and to defend against them is a staple of both hackers and ethical hackers today. This course examines how to hack web servers, and conversely, how to defend against those attacks, how to examine web applications for vulnerabilities, and how to fix them, how web-based password cracking  more...

DNS Zones Replication in Windows Server 2008 DNS Zones & Replication in Windows Server 2008 Microsoft Microsoft Certified Technology Specialist Windows Server 2008, Network Infrastructure Configuration (Exam 70-642) The DNS namespace is subdivided into different DNS zones, which are hosted by a specific authoritative server or group of servers. Zones define the DNS namespace for authoritative servers that resolve client queries. This  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...

Exchange Server 2010 High Availability Exchange Server 2010 High Availability Microsoft Microsoft Certified Technology Specialist Exchange Server 2010, Configuration (Exam 70-662) With e-mail becoming one of the most popular choices for business communications, it is now more important than ever for e-mail to always be accessible to users. Exchange Server 2010 introduces Database Availability Groups (DAG), which ensures e-mail  more...

Cisco Route 1 0 Implementing an OSPF-Based Solution Cisco Route 1.0: Implementing an OSPF-Based Solution Cisco Cisco Certified Design Professional (CCDP ) 642-902 Implementing Cisco IP Routing (ROUTE) v1.0 Configuring Open Shortest Path First (OSPF) in today's networks is an important skill to have as a network administrator. You will need to understand the primary configuration commands for single-area and multiarea OSPF designs, and the  more...

Cisco Route 1 0 The OSPF Routing Protocol Cisco Route 1.0: The OSPF Routing Protocol Cisco Cisco Certified Design Professional (CCDP ) 642-902 Implementing Cisco IP Routing (ROUTE) v1.0 Open Shortest Path First (OSPF) is one of the most commonly used IP routing protocols in today's networks. It is an open standard that is used by both enterprise and service provider networks. OSPF has several functions and five packet types to  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...

CRYSTAL REPORTS XI REPORT WRITING BASICS CRYSTAL REPORTS XI: REPORT WRITING BASICS SAP  more...

Getting Started with Access 2003 Getting Started with Access 2003 Microsoft To create and navigate an Access 2003 database  more...

Working with Data and Presentation in Access 2003 Working with Data and Presentation in Access 2003 Microsoft To use PivotTables, PivotCharts, and other applications to present and handle database data  more...

Access 2003 Programmability Access 2003 Programmability Microsoft To use macros and Visual Basic for Applications to add interactivity to database objects  more...

Database Administration in Access 2003 Database Administration in Access 2003 Microsoft To implement methods of securing, sharing, replicating, and optimizing the performance of Access 2003 databases  more...

Exchanging Data with Excel 2007 Exchanging Data with Excel 2007 Microsoft In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in  more...

Business Contact Manager with Outlook 2007 Business Contact Manager with Outlook 2007 Microsoft Microsoft Outlook 2007 with Business Contact Manager helps to save time and improve sales and marketing to ensure excellent customer service by providing customer and contact management in one central location. It allows you to easily manage all your contacts, customer information, and opportunities in one location making it easier to find  more...

Getting Started with Access 2007 Getting Started with Access 2007 Microsoft With Access 2007, Microsoft introduces some of the most significant changes to Access in years. Most notable is the intuitive new user interface that replaces the traditional menus and toolbars with features like the Ribbon, the Quick Access Toolbar, and the Microsoft Office button. This course provides an introduction to Access 2007 and  more...

Basic Access 2007 Tables Basic Access 2007 Tables Microsoft Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive,  more...

Queries and Reports in Access 2007 Queries and Reports in Access 2007 Microsoft Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores  more...

Importing and Exporting Data and Data Presentation in Access 2007 Importing and Exporting Data and Data Presentation in Access 2007 Microsoft Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and  more...

Programmability and Administration in Access 2007 Programmability and Administration in Access 2007 Microsoft Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving  more...

Database Administration in Access 2007 Database Administration in Access 2007 Microsoft Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a  more...

Advanced Database Design in Access 2002 Advanced Database Design in Access 2002 Microsoft To provide an overview of advanced database design in Access 2002  more...

Advanced Database Features in Access 2002 Advanced Database Features in Access 2002 Microsoft To demonstrate a range of advanced database features in Access 2002  more...

Data Integration With VB 2008 Data Integration With VB 2008 Microsoft Visual Studio 2008 and the .NET Framework 3.5 allow developers to data-bind Windows Forms elements and create a database-connected Windows Forms applications. This course explores how to integrate data capabilities into Windows Forms. Topics in this course cover database connections, using LINQ in Windows Forms, using data-bound controls, connection  more...

Database Environments XML Handling with VB 2008 Database Environments & XML Handling with VB 2008 Microsoft Visual Studio 2008 and the .NET Framework 3.5 allow developers to configure database connections and handle XML data in Windows Forms applications. This course first looks at how to work with different database environments and how to create Windows Forms applications that can handle asynchronous and binary large object (BLOB)  more...

SQL Server 2008 Installation SQL Server 2008: Installation Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow administrators  more...

SQL Server 2008 Instance Database Configuration SQL Server 2008: Instance & Database Configuration Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 is  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 Data Management SQL Server 2008: Data Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to  more...

SQL Server 2008 Database Monitoring and Performance SQL Server 2008: Database Monitoring and Performance Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) To keep SQL Server 2008 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to  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...

SQL Server 2008 High Availability and Disaster Recovery SQL Server 2008: High Availability and Disaster Recovery Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and  more...

SQL SERVER 2008 IMPLEMENTATION AND MAINTENANCE SQL SERVER 2008: IMPLEMENTATION AND MAINTENANCE Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)  more...

Creating Implementing Database Objects in SQL Server 2008 Creating & Implementing Database Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 database to meet business requirements, administrators and developers must  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...

Performing Advanced Query Techniques in SQL Server 2008 Performing Advanced Query Techniques in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup  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 Gathering Performance Data in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) In order to keep SQL Server 2008 running as efficiently as possible, SQL Server 2008 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor.  more...

SQL SERVER 2008 DATABASE DEVELOPMENT SQL SERVER 2008: DATABASE DEVELOPMENT Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)  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...

Configuring SQL Server 2008 Integration Services Package Configuring SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks  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...

Querying Cubes Working with Data Mining in SSAS Querying Cubes & Working with Data Mining in SSAS Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying  more...

Managing SQL Server 2008 Analysis Services Solutions Managing 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 provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It  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...

SQL SERVER 2008 BUSINESS INTELLIGENCE DEVELOPMENT MAINTENANCE SQL SERVER 2008: BUSINESS INTELLIGENCE DEVELOPMENT & MAINTENANCE Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)  more...

Oracle Database 11g Subprograms Packages Exception Handling in PL SQL Oracle Database 11g: Subprograms, Packages & Exception Handling in PL/SQL Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations in PL SQL Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations in PL/SQL Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Managing Code Oracle Database 11g: Using Triggers, the PL/SQL Compiler & Managing Code Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  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 DEVELOP PL SQL PROGRAM UNITS ORACLE DATABASE 11G: DEVELOP PL/SQL PROGRAM UNITS Oracle  more...

Oracle Database 11g Querying a Database with SQL Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 11g Conversion Funct Conditional Expressions Group Funct Joins Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 Schema Objects Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 Managing Data Dictionary Views Large Data Sets Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 Time Zones Datetime Functions Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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 Suqueries Regular Expressions Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...

1Z0-047 Oracle Database 11g SQL Expert 1Z0-047 Oracle Database 11g SQL Expert Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert  more...

Oracle Database 11g Getting Started with PL SQL Oracle Database 11g: Getting Started with PL/SQL Oracle 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 Loops Control Structures Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle 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...

Oracle Database 11g Using Data Types INDEX BY Tables Cursors Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle 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 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 Subprograms Packages Exception Handling Oracle Database 11g: Subprograms, Packages & Exception Handling Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Oracle Database 11g: Using Triggers & the PL/SQL Compiler Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  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 PROGRAM WITH PL SQL ORACLE DATABASE 11G: PROGRAM WITH PL/SQL Oracle  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 Metrics Alerts Baselines AWR Tools Services Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools & Services Oracle Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This  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 Database11g Shared Pool Buffer Cache Tuning Oracle Database11g: Shared Pool & Buffer Cache Tuning Oracle The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also  more...

Oracle Database 11g Tuning PGA Temporary Space AMM Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  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 PERFORMANCE TUNING ORACLE DATABASE 11G: PERFORMANCE TUNING Oracle  more...

Oracle Database 11g Architecture SQL Tuning Optimization Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and  more...

Oracle Database 11g Indexes Access Paths and Join Operations Oracle Database 11g: Indexes, Access Paths and Join Operations Oracle Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such  more...

Oracle Database 11g Execution Plans and Star Transformations Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing Oracle Database 11g: Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...

ORACLE DATABASE 11G SQL TUNING ORACLE DATABASE 11G: SQL TUNING Oracle  more...

Oracle Database 11g Configuring OSB Security Oracle Database 11g: Configuring OSB & Security Oracle Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the Oracle backup and recovery options, as well as terminology, interface options, and backup management features. Additionally, it explores how to  more...

Oracle Database 11g Securing Domain Data In Oracle Secure Backup Oracle Database 11g: Securing Domain & Data In Oracle Secure Backup Oracle Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can also associate an OSB user with multiple Windows domain accounts or a single account that applies to all Windows domains.  more...

Oracle Database 11g RMAN and Oracle Secure Backup Oracle Database 11g: RMAN and Oracle Secure Backup Oracle RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes integrated disk and tape backup, how to register the administrative server in Enterprise Manager, checking RMAN backup and recovery  more...

Oracle Database 11g Managing Backups Infrastructure Oracle Database 11g: Managing Backups & Infrastructure Oracle Restoring files is easily accomplished using the Oracle Secure Backup catalog. This course demonstrates how to browse the catalog for file-system backup data, create catalog-based restore requests, and perform file-system restoration. In addition, this course explores the Oracle Secure Backup processes, configuring defaults and  more...

Oracle Dabase 11g Tape Vaulting Duplication Tuning Oracle Dabase 11g: Tape Vaulting, Duplication & Tuning Oracle Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as vaulting. This course covers configuring and using tape vaulting and a tape vaulting environment, viewing tape rotation reports, and  more...

ORACLE DATABASE 11G SECURE BACKUP ORACLE DATABASE 11G: SECURE BACKUP Oracle  more...

Oracle Database 11g Installation of Clusterware RAC Oracle Database 11g: Installation of Clusterware & RAC Oracle Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to  more...

Oracle Database 11g RAC Database Oracle Clusterware Admin Oracle Database 11g: RAC Database & Oracle Clusterware Admin. Oracle Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster database pages to administer a RAC database and how to carry out various administration tasks on Oracle Clusterware. It  more...

Oracle Database 11g RAC Performance Tuning Oracle Database 11g: RAC Performance Tuning Oracle Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the  more...

Oracle Database 11g Configure Manage Use Services in RAC Oracle Database 11g: Configure, Manage & Use Services in RAC Oracle A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces,  more...

Oracle Database 11g Diagnosing Oracle Clusterware Node Management Oracle Database 11g: Diagnosing Oracle Clusterware & Node Management Oracle Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics  more...

Oracle Database 11g High Availability Oracle Database 11g: High Availability Oracle In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load  more...