Online SQL eLearning Training
From Online Training Directory
Administering Microsoft SQL Server 2000 SQL



This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.
more...
Database Design Concepts


During this course you will learn the basic concepts of database design, the SQL language and how to design and implement a simple relational database.
more...
Administering Microsoft SQL Server 2000 (SQL)


This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.
more...
From Serebra Learning Corporation
Oracle Applications Release 11i: Workflow - Part 1
Oracle Applications Release 11i: Workflow - Part 1 course introduces the learner to the architecture and advanced notification components of Oracle Workflow 2.5. In this course, the learner will gain an insight into the use of Workflow in business processes and methods for planning and creating a Workflow process. Oracle Workflow gives end users and technical personnel the ability to automate and
more...
Microsoft SQL Server 7.0: System Administration - Part 1
This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 2
This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 3
This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 5
This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 1
This is the first course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 2
This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 3
This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 5
This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft Visual InterDev 6.0: Accessing Remote Data
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services
more...
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 2
This is the second course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions.
more...
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 3
This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions.
more...
Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 1
This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.
more...
Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 8
This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1
This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2
This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes and Client/Server Cache;
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5
This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data
more...
JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ
This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.
more...
Relational Database Design and Administration
This course covers the design methodologies and techniques utilized when building an application based on a Relational Database Management System (RDBMS), using Structured Query Language (SQL). The course is based on RDBMS technology and will identify and explain the details and implementation. Designed for individuals in the design and administration of relational databases.
more...
Visual Basic 6 0 Database Access Part I
...es using the industry standard Structured Query Language (SQL). It explains how SQL is used with client tools built in Visual Basic, to create powerful queries and statements for a server-side database. Finally, this course describes how you can use data controls to access database information. It explains how you can use the Data Environment Designer to create connections, commands, and
more...
Security in a Microsoft SQL Server 2000 Environment
To explain how to plan and implement security on a SQL 2000 database Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
...rity. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course discusses the merits of using SQL stored procedures for business services and data integrity checks. It describes how to create, write, and debug stored
more...
What Microsoft NET Means for IT Professionals
To introduce the concepts and components of Microsoft .NET Business managers, IT professionals
more...
Data Integration with C 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Data Integration with Visual Basic 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
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 C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
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 Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
XML Data Access in VB NET
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
Oracle Application Server 10g mod_plsql CGI Scripts and Database Providers
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g
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 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000
more...
Troubleshooting and Disaster Recovery of SharePoint 2003
To describe troubleshooting and the implementation of a disaster recovery strategy for SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies
more...
Project Server 2003 Installation and Configuration
To install and configure IIS 6.0, SQL Server, and SharePoint for Project Server 2003 Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Project Server 2003 Implementing Project Server and Planning Client Deployment
To install Project Server 2003 and plan client deployment Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Project Server 2003 Planning Security Operations
To plan and implement the Project Server 2003 security structure and operations Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Maintaining and Securing Data in SharePoint 2003
To describe how to configure and maintain databases and implement security measures in SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies
more...
Planning for Deployment of Microsoft Biztalk 2000
To describe the planning and design of a BizTalk Server 2000 deployment IT professionals and administrators seeking to gain competency in the use of Microsoft BizTalk Server 2000; candidates for Microsoft Exam 70-230: Designing and Implementing Solutions with Microsoft BizTalk Server 2000, Enterprise Edition
more...
DB2 Application Programming I Rel 4 x
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers.
more...
DB2 Application Programming II Rel 4 x
This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers
more...
OS 390 Designing DB2 Data Warehouse
...of relational databases, DB2 database objects, and common SQL that is run in a relational database management environment. The course ""walks"" the student through basic functions: setting up and maintaining a database, and accessing DB2 data interactively and through applications. Finally, it covers the fundamentals of database management, including security, data control and recovery, and
more...
OS 390 COBOL
...ducing of 3270 screen formats using MAP. Some fundamental SQL and traditional relational database manipulation topics are covered. IMS access includes the use of DL/1 calls.The course contains a unit devoted to a number of varied OS/390 COBOL techniques including use of the special Millennium Language Extensions which permits the continued operation of programs based on a 2-digit year with
more...
Web Technologies
This WestNet e-Learning module explores the Web technologies, such as JavaScript and databases, used to enhance basic Web page functionality.
more...
Cisco CallManager Fundamentals
To explain how to deploy a Cisco CallManager server in a cluster using a supported IP telephony deployment model IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Monitoring and Managing IP Telephony Using Internal Server Tools
To demonstrate how to manage and monitor an IP telephony solution using internal server tools IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Monitoring IP Telephony
To recognize the tools of the IP telephony environment and how to maintain it, and monitor and troubleshoot the Cisco CallManager system IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Fundamentals of Cisco CallManager
To deploy a Cisco CallManager server in a cluster using a supported IP Telephony deployment model. IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Relational Database Concepts Structured Query Language
...SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL). This course is designed to help individuals who want to achieve basic proficiency in Structure Query Language and
more...
Transporting and Loading Data in Oracle9i
To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators
more...
Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators
more...
SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators
more...
Subqueries Reporting and User-Access Control in Oracle 9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Development Platform in Oracle9i
To explain the Oracle9i database enhancements that support the Oracle9i database development platform Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Tuning Systems and Applications in Oracle9i
To describe how to tune systems and applications in Oracle9i Anyone wishing to learn about Oracle9i database performance tuning
more...
Oracle Database 10g The SQL Loader and PL SQL Release 2
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
Using the Scheduler to Automate Tasks in Oracle 10g
To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators
more...
PL SQL Packages
To create and work with Oracle 10g packages Database administrators, application developers, and database operators
more...
Oracle-Supplied Packages and DBMS_SCHEDULER
To use Oracle-supplied packages Database administrators, application developers, and database operators
more...
Managing Dependencies
To manage dependencies and recompile PL/SQL units Database administrators, application developers, and database operators
more...
Manipulating Large Objects in PL SQL
To use LOBs and the DBMS_LOB package Database administrators, application developers, and database operators
more...
PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators
more...
Dynamic SQL and Metadata
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
more...
Oracle Database 10g New Resource Scheduling and Task-Management Features
To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Tuning Performance-monitoring and Analysis Features
To use Oracle 10g's new tuning, performance-monitoring, and analysis features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Introduction to PL SQL
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL Database administrators, application developers, and database operators
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
more...
Using Control Structures
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct Database administrators, application developers, and database operators
more...
Using Composite Data Types
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records Database administrators, application developers, and database operators
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL Database administrators, application developers, and database operators
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators
more...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators
more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
Regular Expressions and User Access in Oracle Database 10g
To demonstrate how to use regular expression support and control user access in Oracle 10g Database administrators, application developers, and database operators
more...
Administering Data Placement in a DB2 UDB
To describe the administration and placement of data in a DB2 UDB database Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Accessing Data and Manipulating DB2 UDB Database Objects
To access data and manipulate database objects Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
Manipulating Data with DB2 UDB
To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
Installing Configuring and Upgrading SQL Server 2000
To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Overview of SQL Server 2000
To provide a high-level overview of SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Managing SQL Server 2000 Databases
To guide students in configuring, performing, and automating routine administrative tasks Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
SQL Server 2000 Databases
To describe how to create and modify SQL Server 2000 databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Backing Up SQL Server 2000 Databases
To explain how to back up SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Restoring SQL Server 2000 Databases
To describe the process involved in restoring SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
SQL Server 2000 Replication
To describe how to implement the SQL 2000 replication models Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Monitoring SQL Server 2000 Performance
To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Monitoring a DB2UDB
To explain how to monitor a DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Office XP for the Advanced User
To provide an overview of the new features and feature enhancements in the following Microsoft Office XP applications - Access, Publisher, FrontPage, and SharePoint Team Services Advanced end-user
more...
Advanced Database Features in Access 2002
To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
more...
Microsoft Office 2000 - Intermediate Access
To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of creating and enhancing a report, working with queries, and integrating data End-users seeking to become familiar with Microsoft Access 2000; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2000 at Core level
more...
Advanced Querying in Access 2003
To use advanced queries such as joins, parameter, action, and SQL queries Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
more...
Creating Queries Forms with Access 2002
The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course
more...
Getting Started with Access 2003
The Getting Started with Access 2003 course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database
more...
Oracle Database 10g - SQL Fundamentals I Part 1
In this course learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally the learners will be introduced to the powerful SQL programming language and its features.
more...
Oracle Application Server 10g Administration Part 3
Oracle Application Server 10g is an integrated standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing configuring OC4J applications maintaining OC4J Application pages OracleAS Portal managing portal users and groups exporting and importing portal objects and Oracle portal advanced
more...
IBM DB2 UDB Essentials Pt 1 - Fundamentals of DB2 UDB Programming
This course is the first of two that cover the fundamentals of IBM DB2. It introduces the IBM DB2 UDB family and the key elements of database management services. Comprehensive coverage is given to SQL from the end-user's perspective - writing and running SQL and the application of SQL to business intelligence. The latter half of the course covers SQL and programming - the principle elements of
more...
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
...introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the learner
more...
