|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||
Query Training Seminars and Classes
From Serebra Learning Corporation
Microsoft Access 2000 - Experts
   Deelnemers aan deze cursus leren de meer geavanceerde functies van Microsoft Access 2000 gebruiken. Na voltooiing van deze cursus kunnen studenten query s maken en verfijnen, formulieren in de Ontwerpweergave maken, wijzigen en verbeteren, rapporten wijzigen en verbeteren en de prestaties van een Access 2000-database beveiligen en verbeteren. more...Microsoft Excel for Windows 95 Advanced Topics
This multimedia self-paced learning course will instruct you on working with the advanced skills of Excel 95 necessary to maximize your productivity. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Mastery tests at the end of each unit allow you to verify more...Microsoft Access for Windows 95 Fundamentals
This multimedia self-paced learning course will instruct you on working with Microsoft Access for Windows 95. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a personalized study more...Microsoft Excel 97 Expert User
This multimedia self-paced learning course will instruct you on working with the advanced features and functions of Microsoft Excel 97. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to more...Microsoft Access 97 - Part 1
This course is the first of a two part series which will cover the skills necessary for the Expert User certification exam. The unique Skill Builder instruction uses simulation, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a more...Microsoft Excel 2000 Expert User
This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. more...Microsoft Access 2000 Fundamentals
This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data. more...Microsoft Access 2000 Expert User
This course provides participants the knowledge to use the advanced features of Microsoft Access 2000. At the completion of this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database. 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 Visual InterDev 6.0: Implementing Server Technologies
This is the final 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 identify the features and installation requirements of Microsoft Transaction Server (MTS) and the features of MTS components; more...Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
This is the fourth 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 methods of aggregating and accessing data from relational data structures; identify the methods of data access from 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...Netscape Application Server
This course addresses a key component of the Netscape Application Platform, the Netscape Application Server (NAS), and is specifically targeted at developers who want to understand and implement this technology. This course will begin with an overview of the Server's features and then examine its capabilities and benefits. Next, developing and deploying NAS applications will be covered. Finally, more...JDBC Application Development Part 1: Introduction and Architecture
This first course in the series provides the foundation for the rest of the course series. It introduces learners to the JDBC API and explains how it is used to access any database from Java. It also covers the basics of working with relational database systems, how to use JDBC to design multi-tier database applications, and an overview of the major steps in the JDBC program. more...JDBC Application Development Part 2: Creating Database Programs
This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases. more...Microsoft Access 2000 Utente esperto
Questo corso consente di acquisire le nozioni necessarie per utilizzare le funzioni avanzate di Microsoft Access 2000. Al termine del corso lo studente sara in grado di creare e perfezionare le query; creare, modificare e migliorare le maschere in visualizzazione Struttura; creare, modificare e migliorare i report e proteggere e migliorare le prestazioni di un database in Access 2000. more...Microsoft Excel 2002 Utente Esperto
In questo corso verranno descritte funzionalita interessanti per l'utente esperto del programma Excel 2002. Nel corso verra descritto come integrare modelli e database. Nella sezione Funzionalita delle cartelle di lavoro verranno descritte le cartelle di lavoro condivise e il consolidamento dei dati tra le cartelle di lavoro. Nella sezione conclusiva, Analisi dei dati e automatizzazione, verra 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
...ation in databases 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, more...Consulting with the External Client Simulation
...y management company, on the possible acquisition of Data Query Limited, a database management company. You are taking over the client from Clark who is retiring. Clark will make an excellent resource to you throughout the sim. The simulation is based on the SkillSoft series "Consulting with the External Client" and contains links to the following SkillSoft courses: CONS0111, CONS0112, and more...XML Implementation in Enterprise
The XML: Implementation in Enterprise WBT is the second course in the XML curriculum. This course is meant for Web programmers in a multi-tier enterprise system who want to use XML to transport and exchange business data over the Internet. The course details the role of XML and related technologies in enterprise computing. It also describes the procedures for using XML Schemas for ensuring more...Working with Complex Data in ColdFusion MX
To describe how to work with queries, arrays, and structures in ColdFusion MX Existing ColdFusion 5 users wishing to gain experience in advanced ColdFusion MX development; web and enterprise application developers who have had an introduction to ColdFusion development and wish to learn advanced development techniques more...Enhancing ColdFusion MX Applications
To describe how to enhance ColdFusion MX applications by adding error-handling, search, and data-exchange functionalities to them Existing ColdFusion 5 users wishing to gain experience in advanced ColdFusion MX development; web and enterprise application developers who have had an introduction to ColdFusion development and wish to learn advanced development techniques more...Getting Started with ColdFusion MX
To introduce and demonstrate the fundamental concepts, tools, and features of ColdFusion MX Web professionals and developers that want to create dynamic web sites using ColdFusion more...Introducing Dreamweaver MX and ASP NET
To introduce the student to Dreamweaver MX and ASP.NET and explain how to use them to publish database content, reuse code, and navigate through DataSets Web professionals; home users and end users wishing to use Dreamweaver MX to create database-driven web applications built on ASP.NET technology 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...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...Text Editing and Printing in UNIX
To describe how to use the vi text editor and how to print documents End users and IT professionals working in a UNIX environment for the first time more...Win2000 Netwk Infra Design Designing a Network Strategy
...ourse introduces the role of DNS in a network, covers the query resolution process of a DNS server, and describes the benefits of integrating DNS with DHCP and WINS. The design considerations for deploying DNS on a network and for planning the DNS namespace and zones, as well as DNS server requirements, are also covered in this course. Finally, the course introduces the three methods of DNS more...Win2000 Netwk Infra Design Designing a WINS Dfs Strategy
...cy network, and describes the WINS client interaction and query forwarding. You will also learn about the use of WINS proxy for integrating WINS enabled client with non-WINS clients in a routed environment. The course also describes how to ensure the availability of WINS servers, secure data transfer, and optimize the performance of WINS. You will learn to identify the deployment strategy in more...Microsoft SMS 2003 Managing Collections Queries and Reports
To explain how to manage collections, queries and reports in SMS 2003 Systems administrators, systems engineers, systems analysts, IT consultants, and support professionals with responsibility for planning, implementing, and maintaining Microsoft Systems Management Server 2003 more...Planning and implementing Group Policy
To identify how to plan and implement group policy Systems administrators, systems engineers, systems analysts, IT consultants, and support professionals with responsibility for planning, implementing, and maintaining Microsoft Windows Server 2003 Active Directory; learners preparing for MCSE certification exams more...Printing and Documentation in Linux
To identify how to install printers and print filters in Linux and administer printing and Linux documentation Students wishing to acquire the basic skills required as a Linux system administrator 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...Security administration in Check Point Logging and SmartView Tracker
To identify the components of SmartView Tracker and the data it can access and to be able to use that data to block intruders system administrators, security managers, network engineers, and consultants who manage Check Point NG VPN-1/FireWall-1 gateway deployments more...Fundamentals of Data Warehousing
The Fundamentals of Data Warehousing WBT is the first course in the Data Warehousing curriculum. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses and models. It also provides students with the preliminary knowledge for planning and implementing data warehouses. People who have a fairly good knowledge of the concepts more...Relational Database Concepts Structured Query Language
...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 more...Database Structures in Oracle9i
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files Anyone wanting to learn about Oracle9i database administration 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...Using Flashback Technology in Oracle 10g
To outline the considerations and procedures for using Flashback features Oracle database administrators and database operators more...Oracle Database 10g Using Flashback
To recognize Oracle 10g's Flashback technology and use Flashback 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 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...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...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...SAP R 3 3 0 Fundamentals
Now you can learn the functionality and capabilities of the SAP R/3 3.0 System, designed for the open system environment, as well as understand the advantages for business and the user. This course will help you differentiate between each integrated application module of the SAP R/3 3.0 system. Through the use of examples of system functions, you will get the user's perspective of the more...Advanced Database Design in Access 2002
To provide an overview of advanced database design 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...Microsoft Office 2000 - Excel for Power Users
To bring proficient users of Excel 2000 to an advanced level of competence in using macros and sharing, displaying, formatting, and analyzing data End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert 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...Advanced Data Exchange in Excel 2003
To describe how to use Excel 2003 to share data between people, applications, and on the Web End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent more...Using Advanced Data Management Techniques
The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files, 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...Searching the Internet
The Searching the Internet WBT is meant for acquainting the students with the basic concepts of searching on the Internet and the proper usage of various search techniques. End-users who want to search the Internet effectively. more...Microsoft Access 2000 Intermediate
This highly interactive CBT contains six units that cover intermediate Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create complex queries, forms, and reports, share Access information with other programs, and add objects to a form. Related Exam: MOUS Access 2000 Expert. Designed to teach intermediate Access skills. more...ECDL ICDL 4 Module 5 Database - Access 2003 Queries and Reports
To outline the processes for creating and modifying queries and reports. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain competency in using more...Navigating Oracle Applications 11i
This series teaches learners how to access and navigate within Oracle Applications release 11i. The course covers Oracle Applications 11i Interface navigation tips manipulating data using Find mode and Query mode and also accessing online help. Learners are taught to enter data retrieve information in the form of a query maintain data use flexfields and access online help. Additionally this more...IBM IMS Essentials Part 1: IMS Database Manager
In IBM IMS Essentials Part 1: Database Manager you are introduced to the IMS Database Manager. IMS hierarchical databases are covered and the Data Language/I (DL/I) function codes used to query and update the databases within application programs. You are introduced to database change logging and the various database recovery utilities used in IMS. Finally you learn about IMS hierarchic access more...IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
...r 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 should be able to write more...MS Access 2003 Fundamentals
This course maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries. more...CIW Internetworking Professional Part 4: Network Management
This is the fourth course in a five part series that will provide instruction on the features of network management. This course will provide an overview of management functional areas and the network management model. It will also introduce the features and functions of SNMP. The student will learn how to install and configure SNMP and SNMP agents. This course will also introduce the features and more...SQL Server 7.0 Data Warehousing SQL Part I
...erstanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming replication administration security and configuration/optimization. Data Warehousing sometimes called Decision Support System (DSS) is a multi-step process of collecting cleansing and storing data for use in more...SQL Server 7.0 Developing SQL Client/Server Part I
... available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the primary factors in implementing a client/server application are the client/server architecture the client-side more...SQL Server 7.0 Developing SQL Client/Server Part II
... available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the primary factors in implementing a client/server application are the client/server architecture the client-side more...SQL Server 7.0 Advanced Features Part I
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced more...SQL Server 7.0 Advanced Features Part II
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances more...SQL Server 7.0 Web Integration
This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web more...Oracle 8i DBA - Oracle Server and Database Architecture
This course is aimed to familiarize you with the basic concepts of Oracle 8i Architecture and Oracle Enterprise Manager. This course will introduce you to the concepts of Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal more...MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. more...MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. more...Microsoft Access 2002 Proficient User
This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases. more...Microsoft Access 2002 Expert User
This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports. more...Oracle9i SQL: Data Retrieval Techniques
This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. more...Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention
The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. more...MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation how to create and manage indexes as well as learn how to optimize query performance and how to analyze queries. more...Oracle SQL: DML and DDL
...nment this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify these data objects. Learners also learn how to insert update and delete data using SQL's Data Manipulation Language and learn to control database transactions. Finally the course teaches more...Oracle PL/SQL: Basics
This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous more...Oracle9i PL/SQL: Basics
The Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. more...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 indexes more...Oracle SQL and SQL*Plus: SQL*Plus and Reporting
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 indexes more...IBM DB2 Universal Database V6.1 Fundamentals
This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX Windows or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1 creating and accessing database objects basic Structured Query Language (SQL) and managing more...SQL Basic Skills
This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements. more...Optimizing a SQL 7.0 Data Warehouse
The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the more...QMF Essentials (Ver 3.1)
Teaches the creation of data base queries using three languages: SQL, Prompted Query Mode and Query by Example (QBE). more...Relational Database Concepts
Teaches practical and useful information about database management systems, their design and environment. more...MS Access 97
This course is easy to use whether you are a new or experienced user. Effectiveness is our number-one priority in developing our tutorials. Instructions are presented in easy to understand graphical formats instead of just on screen text; applications simulations offer realistic practice opportunities; and interactive exercises keep people engaged throughout the lesson. more...Advanced SQL Programming
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029. more...Optimizing a MS SQL Server 7.0 Data Warehouse
This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019). more...Microsoft Access 97 Training
Access 97 Training will provide the learner with the fundamental concepts and basic skills necessary to efficiently use the Access 97 application, Microsoft's powerful database program. more...
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
 ...tify the characteristics of the Oracle shared server. o Query a dispatcher process to determine the process status using the V$DISPATCHER view. Audience The intended audience for this course includes database administrators and application developers, regardless of role or experience level. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA more...Oracle9i Database Admin Manage an Instance
... connection. • Identify the stages in processing a query and the memory structures used in query processing. • Identify the steps of DML processing and the memory structures involved in DML processing. • Identify the uses of SCN and the features of a process commit. • Identify the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA. • Identify more...Oracle9i SQL Data Retrieval Techniques
...g subqueries. o Identify the characteristics of each subquery type. o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement. o Identify the characteristics of substitution variables. o Prompt the user for a number value at run time by using a substitution variable. o Prompt the user for a character value at run time by using a substitution variable. more...Oracle9i SQL Basic SELECT Statements
... for constructing basic SQL SELECT statement. o Write a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories of datatypes. o Match the character datatypes with their descriptions. o Identify the features of the NUMBER datatype. more...SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries
...r using subqueries. Create a derived table by using a subquery. Create a single-value subquery. Identify the functions of views. Identify the considerations for defining views. Create a view by using an SQL Query Analyzer template. Audience Candidates for this course operate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and more...SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data
...the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a more...SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify more...SQL Server 2000 Design Implement Databases Part 4 Managing Indexes
...eate and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes table. Identify guidelines for creating indexes. Identify the considerations for creating unique indexes. Identify the considerations for more...IBM DB2 Universal Database V6 1--Fundamentals
...creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). more...IBM DB2 Universal Database V6 1--Fundamentals
...creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). more...Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention
...ntify the characteristics of row migration and chaining. Query a table to detect chained and migrated rows by using the ANALYZE TABLE command. Remove the chained and migrated rows from a given table by using a four-step procedure. Reclaim the space from the high water mark by using an ALTER TABLE command. Query the results of an ANALYZE command to evaluate Oracle data block usage. Monitor more...Oracle8i Performance Tuning Managing Memory Disk I O
...L Duration: 1.5 - 2 Hour(s) Explain the plan for a query by using the EXPLAIN PLAN statement. Inspect the performance of a plan by setting up trace at the session level. Match the TKPROF options with their respective descriptions. Generate an execution plan at the system level for a SQL statement by using AUTOTRACE. Identify the characteristics of optimizer modes. Set the optimizer more...Oracle8i Database Admin Manage Storage Structures
...iven segment by using Oracle SQL*Plus Worksheet. Write a query to check the extents for a given segment by using Oracle SQL*Plus Worksheet. Unit 2: Managing Rollback Segments Duration: 1 - 2 Hour(s) Identify the purposes of rollback segments. Identify the rollback segment type given its description. Sequence the steps for the process in which rollback segments are used by more...Oracle8i Database Admin Manage an Instance
...tion stored in them. Sequence the stages in processing a query. Identify the combinations of the shared pool components and the information stored in them. Identify the characteristics of the database buffer cache. Match the contents of the Program Global Area (PGA) with their uses. Identify the steps in the execute phase of a given DML statement. Identify the uses of a rollback segment. more...Oracle Database 10g Administration Workshop II Part 3 ...he Recycle Bin.
Identify features of Flashback Versions Query.
Sequence the steps to perform Flashback Versions Query using Enterprise Manager (EM).
Match various pseudocolumns used in the Flashback Versions Query syntax with their descriptions.
Identify features of Flashback Transaction Query.
Identify features of Flashback Table.
Identify considerations related to a Flashback | ||||||||||