Online SQL eLearning

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

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

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

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

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

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

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

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

SAP BusinessObjects Web Intelligence ... user. You do not have to know structured query language (SQL) to take advantage of the power offered by Web Intelligence. You can easily create and publish high-quality reports that contain drill downs, and allow readers to track changes and share business information across the enterprise. This course provides an introduction to BusinessObjects Web Intelligence, highlighting some of its key  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...

Backing Up Restoring Troubleshooting Essentials 2010 ... within their organizations. Essentials uses databases in SQL Server to store all the data that is recorded during the management of the computers, and these databases need to be backed up to ensure this information is not lost. If there is a failure, there also needs to be a documented plan for restoring the data to have Essential back online with minimal downtime. To troubleshoot issues with  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 ... This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific topics covered include using query notifications, and SqlDependency and SqlCacheDependency. Topics also look at the various aspects of synchronizing data, including creating a synchronization services application and configuring  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  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  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  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  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  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 ...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 fully understand how to design, create,  more...

Creating Modifying Table Index Partitions in SQL Server 2008 ...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 to be spread across multiple filegroups,  more...

Running Queries Manipulating Data in SQL Server 2008 ...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 Edit window of the Management Studio  more...

Performing Advanced Query Techniques in SQL Server 2008 ...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 information, such as totals, the CUBE,  more...

Creating Implementing Programming Objects in SQL Server 2008 ...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 retrieve the desired results. You can group  more...

Querying Managing XML Data inSQL Server 2008 ...SQL 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 using FOR XML to extract  more...

Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes ...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 ...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. The SQL Server Profiler  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 ...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, SQL Server  more...

Configuring SQL Server 2008 Integration Services Package ...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 that provide  more...

Deploying SQL Server 2008 Integration Services Package ...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 overview  more...

Implementing SQL Server 2008 Reporting Services Solutions ...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 enhancements  more...

Deploying Delivering SQL Server 2008 Reporting Services Reports ...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 formatted, it is time to make  more...

Maintaining SQL Server 2008 Reporting Services ...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 outlines the  more...

Implementing SQL Server 2008 Analysis Services Solutions ...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. This course  more...

Querying Cubes Working with Data Mining in SSAS ... 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 multi-dimensional data. It will introduce  more...

Managing SQL Server 2008 Analysis Services Solutions ...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 ...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 gives an overview of the  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 ...ment. 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 Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies,  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 ...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, SQL*Plus AUTOTRACE command  more...

Oracle Database 11g SQL Performance Database Replay ...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 Analyzer to ascertain  more...

Oracle Database 11g Tuning PGA Temporary Space AMM ...ic 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 generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues and demonstrates how to size the PGA memory and  more...

Oracle Database 11g Segment Space I O and Performance Tuning ...to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating manual storage and thereby increasing your ability to manage larger databases (and more of them) with increased efficiency. This course discusses the implementation and tuning of ASM using a variety  more...

Oracle Database 11g Architecture SQL Tuning Optimization ...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 manipulate the database, helps to  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 ...uery 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 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  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning ...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 interpreting the output of the tkprof command.  more...

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

Oracle Database 11g Firewalls Oracle Connection Manager and SQL Plus Security ...le 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 ...Intelligent Data Placement, as well as table compression, SQL Access Advisor, and segment creation. It is one of a series of courses 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 the Oracle Database 10g Administrator Certified Professional (10g DBA OCP) to achieve Oracle  more...

Oracle Database 11g R2 Using Change Management Solutions ...under the umbrella of Change Management. These consist of SQL Performance Analyzer, SQL Plan Management, and Database Replay. This course identifies each of these change management solutions and demonstrates how to use them to analyze SQL statements, test upgrades, and capture and analyze workloads. It is one of a series of courses in the SkillSoft learning path that covers the objectives for  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements .... Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to automatically tune SQL  more...

Oracle Database 11g R2 Diagnosability Enhancements ...ication, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health checks and viewing the  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements ...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 database using  more...

Oracle Database 11g R2 Application Performance Enhancements ...t provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed means for storing the results of PL/SQL functions in the SGA, so that  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup ...while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option rather than maintaining a local backup infrastructure. This course demonstrates how to use Oracle Schedule to create email  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing ...can be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. Security requirements have been a matter of individual concern until recently,  more...

Oracle Database 11g R2 Moving Data Oracle Support ...s ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This course explores how to move data using Data Pump Wizards or the command line. Working with the Enterprise Manager  more...

Administering Microsoft ® SQL Server 2000 (SQL) ...ills 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, configure and tune SQL Server 2000 databases, manage users  more...

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

SQL Server 2000 Implementing and Designing Databases This course teaches you to design, implement, administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000. This course prepares you to design and implement database solutions by using Microsoft SQL Server 2000. This course covers subjects such as: Developing a Logical Data Model, Implementing the Physical Database, Retrieving and Modifying Data, Programming  more...

SQL Server 2000 Administration This course will teach techniques for installing, configuring, and administering SQL Server 2000. This course is designed to teach the student all the necessary knowledge to successfully pass the Microsoft exam 70-228 required for MCDBA. (Installing, Configuring, and Administering Microsoft SQL Server 2000.) This indepth course covers all necessary materials to accomplish outcomes listed below.  more...

SQL Server 2000 Data Warehousing This course will teach you the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Micorsoft SQL Server 2000 This course will teach you the ins and outs of in Micorsoft SQL Server 2000 by providing the knowledge and skills necessary to understand the underlying design and principles of a data warehouse. You will  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 ...rivers, inner and outer joins, Structured Query Language (SQL), and updating and verifying data sources Your Crystal Reports XI training is presented by Jason Manibog, he has been in the IT business for the past eight years, five of those as a trainer/consultant. He has conducted numerous classes in Crystal Reports, from versions eight through 11 and has done a wide variety of consultations in  more...

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

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

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

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

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

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

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

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

Dreamweaver MX Web Applications ...ow to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion  more...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Oracle Database 10g SQL Fundamentals I Part 2 ...he learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify the code for  more...

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

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

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

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

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

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

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

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

Oracle SQL and SQL Plus Advanced SELECT Statements ...e 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 single-row subqueries. Write  more...

Oracle SQL and SQL Plus SQL Plus and Reporting ... second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries using SQL*Plus runtime  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ...rview This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters.  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...view 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 of  more...