Online Databases eLearning - Training Resources

eMarketing 1.1 eMarketing Association`s complete basic e-marketing course. 5 Lessons covering the basics of eMarketing. Each lesson is sent via e-mail and Internet link over a four week period. At the completion of the 5 Lessons there is a final exam administered via e-mail. Students Passing the final exam are given a personalized certificate of completion from the e-Marketing Association.eMarketing Business  more...

Learn MS Access 2000 online with eBooks! ...uild typical business documents, spreadsheets, slides and databases. The Series has trained over 650,000 students throughout North American universities, colleges, and business schools where it is distributed by McGraw-Hill; the largest, most reputable book publisher in the world. The product you are about to purchase is the same high quality software training system proven in thousands of  more...

Works 2000 Level 1 ... Microsoft Works 2000. Students will learn a little about databases and spreadsheets, as well as learn to create, modify, and save text documents using Microsoft Word. This course will introduce students to the basic functionalities of Microsoft Works 2000. Students will learn how to organize their schedules and manage their time and money by using and editing spreadsheets and databases.  more...

Using Databases ...ssing the needs of library professionals using electronic databases. Using Databases This in-depth course will concentrate on addressing the needs of library professionals using electronic databases. As you progress through the course you will gain a general knowledge of the terminology used in online searching and develop the skills needed to analyze various types of search requests. This  more...

Understanding Globalization: Preparing for the 21st Century Interactive course covers economic, political, and cultural dimensions of Globalization. Globalization is the process of integrating national economies, political structures, and cultures into a single, world-wide, interdependent system. In this course we will explore the basics of Globalization: what it is and how to understand it as an economic, political and a cultural phenomenon. This  more...

SQL Server 2000 Complete Course This course is a complete set of 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,  more...

Office 2000 Intermediate ...such Microsoft Excel 2000 features as working with lists, databases, and functions; formatting and linking worksheets; and using 3-D references and Microsoft Map. Through Microsoft Access, students will learn how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Some other skills students will learn include  more...

Office XP (2002) Advanced ...so students will be shown how to better manage multi-user databases. Summarizing list data with outlining and learning how to create and remove custom filters are features of advanced Excel. In advanced PowerPoint, students will learn how to import data from other Microsoft applications. They will also learn how to add video and sound clips and modify charts and tables in their presentations.  more...

Microsoft Works Suite 2002 Level 1 ...heir time and money by using and editing spreadsheets and databases in this introductory course. Microsoft Works 2002 will also teach students how to create, modify, and save documents using Microsoft Word. This course will introduce students to the basic functionalities of Microsoft Works 2002. Students will learn how to organize their schedules and manage their time and money by using and  more...

Microsoft Access 2002 Core This course will introduce students to the new features in Microsoft Access 2002, including speech recognition and the new Task Pane, as well as teaching them database creation and how to create and use tables, forms, filters and sorts, queries, and reports. This course will introduce students to the new features in Microsoft Access 2002 that set it apart from Access 2000, including speech  more...

Microsoft Access 2002 Expert ...vered, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In  more...

Microsoft Access 2002 Level 1 ...gned and set up. After they learn how to create their own databases in Access, students will receive instruction in how to create and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data. This course will also cover the new features in Access  more...

Microsoft Access 2002 Level 2 ...riety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports,  more...

Microsoft Access 2002 Level 3 ...vered, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In  more...

Microsoft Access XP Certification Our Access XP gives you powerful new tools for managing your data. Welcome to Microsoft Access XP Certification Our Access XP gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show  more...

Microsoft Access 2003 (Levels 1-2-3) Our Access 2003 gives you powerful new tools for managing your data. Microsoft Access 2003 (Levels 1-2-3) Our Access 2003 gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show you  more...

Lotus Notes 5.0 Level 1 ...5.0 so they can easily send and receive e-mail and manage databases. Specifically, students will learn the basics of sending and receiving e-mail, working with file attachments, formatting messages, and managing messages. Students will also learn how to use the calendar to schedule meetings and appointments, and how to use the to-do list to assign and keep up with tasks. All of these skills  more...

FrontPage 2000 Level 2 ...ms, developing dynamic Web pages using DHTML, integrating databases, publishing Webs, and working with forms and tables. This course teaches students the additional advanced features of Microsoft FrontPage 2000. Students will learn advanced Web development techniques, such as using HTML, designing frames pages, creating interactive forms, and developing dynamic Web pages using DHTML. They  more...

Front Desk Agent- Instructor Led ...s access to comprehensive and frequently updated national databases of tourism jobs sponsored by industry leading organizations such as ASTA and ISTTE. Benefits of Front Desk Agent: The Front Desk Agent Quantum Learning's Front Desk Agent Tourism Career Sampler is an informal and interactive program loaded with background knowledge, definitions, skills, practical exercises, suggested career  more...

Excel 2007 Level 2 This course familiarizes students with intermediate-level spreadsheet features. Students will learn how to convert older workbooks to the new default XML-based file format; customize the Quick Access toolbar; use logical and financial functions; format worksheets using themes, styles, and page breaks; use 3-D references; ready workbooks for the Web; use templates to create workbooks; and insert  more...

Excel 2000 Level 2 ...such Microsoft Excel 2000 features as working with lists, databases, templates, and functions; formatting and linking worksheets; and using 3-D references and Microsoft Map. Students will also learn how to use Excel to save and work with files as Web pages. This course introduces students to such Microsoft Excel 2000 features as working with lists, databases, and functions; formatting and  more...

Excel 2000 MOUS ...pulating charts. Students will learn to work with lists, databases, and functions; format and link spreadsheets; and use 3-D references and Microsoft Map. Students will use Excel and the Web to save and work with files and Web pages. Selected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps. Students  more...

Excel 2000 Proficient This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Students will also learn how to save and work with files as Web pages. This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting  more...

Excel 2000 ...he students get more advanced, they will work with lists, databases, and functions; format and link worksheets; and use 3-D references and Microsoft Map. Selected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps. Students will also learn how to apply the advanced features of Microsoft Excel 2000 to work  more...

Database Management ...overage 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 required However some experience using  more...

Crystal Reports 8 ... One of the greatest challenges in working with data and databases is creating useful, effective, and efficient reports that people will use to enhance the business capabilities of their companies. Upon completion of this course, the student will be able to quickly create and customize reports that will be useful and informative using Crystal Reports 8. The student will learn how to configure,  more...

Access 2007 Level 1 This entry-level course introduces students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. They will learn the importance of establishing relationships, as well as how to establish and edit relationships and enforce referential integrity. Access 2007 Level 1 This  more...

Access 2007 Level 2 Access 2007 Level 2 strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office Access 2007, including tables, queries, forms, and reports. Access 2007 Level 2 Strives to broaden and develop the basic database design skills that students  more...

Access 2000 Level 3 ...ourse, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In  more...

Access 2000 MOUS ...ss database. Students will learn how to create their own databases in Access and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. Students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. Access will be used as a development tool as the course becomes more advanced.  more...

Access 2000 Proficient ... as some techniques designed to make data entry in Access databases faster, easier, and less error-prone. This comprehensive course teaches students both the basic and more advanced elements that compose an Access database. Students will learn how to create their own databases in Access; and learn how to create and use the basic tools of the Access application: tables, forms, filters and  more...

Access 2002 This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective database should be designed and set up. As the course becomes more advanced, students will use Microsoft Access as a development tool. The course strives to broaden and develop the basic database skills that students already possess. This course  more...

Access 2002 MOUS ...y database objects in Access and how to manage multi-user databases. This course introduces students to the new features in Microsoft Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane, as well as basic elements that compose an Access database. Students will receive instruction in how to create and use basic tools of the Access application:  more...

Access 2000 Expert This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This advanced course strives to broaden and develop the intermediate database design  more...

Access 2000 Level 1 ... up. The students will also learn how to create their own databases and how to enter and manipulate data. This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective database should be designed and set up. After they learn how to create their own databases in Access, students will receive instruction in how  more...

Access 2000 Level 2 ...e the primary database objects in Access; how to maintain databases by backup, as well as how to compact and repair them; and how to employ techniques designed to make data entry faster, easier, and less error-prone. This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to  more...

Access 2000 ...d customize reports. They will also learn how to maintain databases as backups, as well as compacting and repairing them. Students will also use Access as a development tool in the most advanced sections of the course. This course teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various maintenance  more...

Managing Data Between Servers and Databases To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005  more...

Oracle Database 11g Using RMAN for Recovery To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.  more...

Oracle Database 10g Creating Databases Release 2 To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant  more...

Oracle Database 11g Using RMAN Enhancements Flashback and LogMiner identify ways of using Oracle Database 11g's enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.  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  more...

Advanced Database Recovery and Repair in Oracle 10g To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases  more...

Microsoft Office 2000 - Advanced FrontPage To provide advanced users of FrontPage 2000 with skills in using navigation, themes, frames, forms, and databases on a web site  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...

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

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

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

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases  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...

Starting to Program with Perl To use Perl to create basic and object-oriented data-driven applications and to interact with CGI scripts and MySQL databases  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  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum ...urses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum consists  more...

Oracle9i Database Admin Recover Databases ...ith and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export and import utilities, user managed recovery, fast-start on demand rollback, recovery  more...

Oracle9i Database Fundamentals II Curriculum The Oracle9i Database: Fundamentals II Curriculum includes the following courses: Oracle9i Database Admin.: Perform Database Backups Oracle9i Database Admin.: Recover Databases Oracle9i Database Admin.: Set Up Oracle Net Services To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Database Admin Create a Database ...ddition, this course discusses how to create and maintain databases. The course also covers the new features of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility. Learn To • Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories. • Identify the requirements and factors  more...

BizTalk Server 2000 Part 4 Components Solutions Troubleshooting ... use BizTalk's features and tools, manage the four server databases and manage the queues that BizTalk Server 2000 uses. The course continues to build upon the scenario companies that form the scenario core of the curriculum, presenting contexts of business requirements and considerations. Learn To • Identify key features of application integration components (AICs). • Identify  more...

MCDBA Curriculum Version II The Complete MCDBA Curriculum includes the following curriculums: Microsoft Windows 2000 Administration Curriculum (ID#7578) Microsoft Windows 2000 Installation, Configuration & Admin. Curriculum (ID#7586) Microsoft SQL Server 2000: Database Administration Curriculum (ID#7895) Microsoft SQL Server 2000: Designing & Implementing Databases Curriculum (ID#7901) MS Win 2000 Network  more...

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ... Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify the optional tools of the DB2 family. Identify the techniques of multidimensional data analysis. Identify the functions of  more...

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ... Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify the optional tools of the DB2 family. Identify the techniques of multidimensional data analysis. Identify the functions of  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 Course Overview 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. Learn To Identify the features of clustered indexes. Identify the features of nonclustered  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects Course Overview This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server ... to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify the features and functions of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with their functions. Match Data Control  more...

SQL Server 2000 Designing Implementing Databases Curriculum ...lowing courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing Indexes) MS SQL Server 2000: Design & Implement Databases Part 5(Dist. Data & Locks)  more...

SQL Server 2000 Database Admin Part 2 Manag Databases ... series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database information by using SQL Server Enterprise Manager.  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 ...nattended installation. Identify the types of SQL Server databases. Identify the database objects related to SQL Server. Identify the features of the SQL Server 2000 object-naming standard. Audience Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet  more...

SQL Server 2000 Database Administration Curriculum The MS SQL Server 2000 Database Administration Curriculum includes the following courses: MS SQL Server 2000: Database Admin. Part 1(Install. SQL Server 2000) MS SQL Server 2000: Database Admin. Part 2(Managing Databases) MS SQL Server 2000: Database Admin. Part 3(Security & Data Recovery) MS SQL Server 2000: Database Admin. Part 4(Managing Data) MS SQL Server 2000: Database Admin. Part  more...

IBM DB2 Universal Database V6 1--App Development ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB  more...

IBM DB2 Universal Database V6 1--App Development ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. When coupled with appropriate on-the-job experience, these courses will help prepare  more...

IBM DB2 Universal Database V6 1--Administration ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When  more...

IBM DB2 Universal Database V6 1--Administration ... of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. In addition, participants should have taken the first part of this series, IBM DB2 UDB V6.1 Fundamentals (course 13431). When  more...

IBM DB2 Universal Database V6 1--Fundamentals ...ects, 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). Manage database operations. C  more...

IBM DB2 Universal Database V6 1--Fundamentals ...ects, 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). Manage database operations. C  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ... how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration Certification: This curriculum will help candidates prepare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows NT. L  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ... how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration Certification: This curriculum will help candidates prepare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows NT. L  more...

Exchange 2000 Server--Part 2 Configuring ...formation Store (IS). Identify the features of multiple databases and storage groups. Identify the features of data recovery and transaction logging. Identify the browsers that are supported by Microsoft Outlook Web Access. Identify the issues that affect the secure use of Outlook Web Access security. Identify the methods to gain access to a mailbox from a single-server environment.  more...

GroupWise 5 5 Admin Part 3--System Maintenance ...uling maintenance events, and maintaining directory store databases. Identify backing up databases and domain databases. C ontent Emphasis Skills-Based A udience System Administrators who are responsible for the setup, maintenance, and administration of a corporate groupware communication installation. Students should have administration experience with NetWare Administrator  more...

GroupWise 5 5 Admin Part 2--Clients Post Offices ...he message store. Identify the attributes of the message databases within the OFMSG directory. Identify the attributes of the prime user database within the OFUSER directory. Identify the attributes of the OFFILES directory. Identify the processes that move message components to the message store. Sequence the steps used to move items between the input and output queues. Identify the  more...

OCDBA8i Curriculum ...e an Instance(ID#7476) Oracle 8i Database Admin.: Create Databases(ID#7477) Oracle 8i Database Admin.: Manage Storage Structures(ID#7478) Oracle 8i Database Admin.: Manage Data Storage(ID#7479) Oracle 8i Database Admin.: Manage Security(ID#7480) Oracle 8i Network Administration: Net8 Architecture & Strategy(ID#7489) Oracle 8i Network Administration: Net8 Additional Config. &  more...

Oracle8i Database Admin Create Databases ...ments, and indexes. In addition, creating and maintaining databases will be covered. L earn To: Identify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C  more...

Oracle8i Database Administration Curriculum The Oracle 8i Database Administration Curriculum includes the following courses: Oracle 8i Database Admin.: Manage an Instance Oracle 8i Database Admin.: Create Databases Oracle 8i Database Admin.: Manage Storage Structures Oracle 8i Database Admin.: Manage Data Storage Oracle 8i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page  more...

Lotus Domino R5 System Admin Part 5 Advanced Notes Mail Routing Course Overview This is the fifth course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to identify the contents of the different mail routing documents in a Domino directory; configure mailing options, such as forwarding address, messaging size, priorities and shared mail; and  more...

Lotus Domino R5 System Admin Part 1 Planning a Notes Domino Infrastructure ...ould be selected for the given Domino network. Match the databases in Domino with their purposes. Identify the functions of the views in Domino Directory. Identify the views in the Server category of Domino Directory based on their functions. Identify the view in Certification Log that displays data in a specified format. Identify the views in Server Log that perform a specific function.  more...

Lotus Domino R5 Development Part 8 Application Architecture ...thods that enable you to split an application in multiple databases. Identify the tools that can be used for integrating Domino with heterogeneous applications. Identify the functions of Domino Global Workbench (DGW). Sequence the steps involved in the process of internationalization of an application by using DGW. Identify the issues that can arise when building applications for  more...

Access 2000 Expert User Course Overview 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. L earn To: Create  more...

Access 2000 Proficient User Course Overview This course is intended for end users that are looking to use the intermediate skills of Microsoft Access 2000. At the completion of this course, students will learn how to use Access 2000 to maintain tables and table data; manage Access 2000 data; create and modify forms; and create and modify report formats. L earn To: Use Access 2000 to maintain tables and table  more...

Access 2000 Fundamentals ...ta. L earn To: Identify the concepts related to databases and the features of Access 2000. Create and maintain tables and table data. Locate and manipulate data. C ontent Emphasis Skills-Based A udience This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. T otal Learning Time 6 - 8 Hour(s)  more...

Access 2000 Curriculum The Microsoft Access 2000 Curriculum includes the following courses: Microsoft Access 2000 Fundamentals Microsoft Access 2000 Proficient User Microsoft Access 2000 Expert User To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

SQL Server 7 0 Database Design Curriculum The SQL Server 7.0 Database Design Curriculum consists of the following courses: SQL Server 7.0 Implementing a Database - Part 1 SQL Server 7.0 Implementing a Database - Part 2 SQL Server 7.0 Implementing a Database - Part 3 SQL Server 7.0 Implementing a Database - Part 4 SQL Server 7.0 Implementing a Database - Part 5 To review individual course descriptions, please return to the  more...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

Oracle Reports R6 Enhance Reports Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  more...

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

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

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

Oracle Form Builder R6 Project Builder and Menu Modules Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:  more...

Oracle Form Builder R6 Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the  more...

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

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

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...

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

Oracle8 Performance Tuning Curriculum The Oracle8 Performance Tuning Curriculum consists of the following courses: Oracle8 Performance Tuning: Strategies and Techniques Oracle8 Performance Tuning: Managing Memory and Disk I/O Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

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

Oracle8 Network Administration Net8 Configuration and Troubleshooting Course Overview This is the second course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established  more...

Oracle8 Network Administration Curriculum The Oracle8 Network Administration Curriculum consists of the following courses: Oracle8 Network Administration: Net8 Architecture and Configuration Oracle8 Network Administration: Net8 Configuration and Troubleshooting To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Network Administration Net8 Architecture Configuration Course Overview This is the first course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between  more...

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

Oracle8 Backup and Recovery Curriculum The Oracle8 Backup and Recovery Curriculum consists of the following courses: Oracle8 Backup and Recovery - Strategies and Backups Oracle8 Backup and Recovery - Troubleshooting and Recovery To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Backup and Recovery - Strategies and Backups Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...

Oracle8 Database Administration - Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...

Oracle8 Database Administration - Manage Data Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

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

Oracle8 Certified Database Administrator Curriculum ...stance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage Structures (ID#430) Oracle8 Database Administration - Manage Data Storage (ID#434) Oracle8 Database Administration - Manage Security (ID#438) Oracle8 Backup and Recovery - Strategies and Backups (ID#441) Oracle8 Backup and Recovery - Troubleshooting and  more...

Oracle8 Database Administration - Create Databases ...ments, and indexes. In addition, creating and maintaining databases will be covered. L earn To: Plan and create a database. Create the data dictionary view. Use the data dictionary view to retrieve information. Identify the properties and benefits of using stored procedures and packages. Plan for the creation of redo log files. Plan for the maintenance of redo log  more...

Oracle8 Database Administration Curriculum The Oracle8 Certified Database Administration Curriculum consists of the following courses: Oracle8 Database Administration - Manage and Instance Oracle8 Database Administration - Create Database Oracle8 Database Administration - Manage Storage Structures Oracle8 Database Administration - Manage Data Oracle8 Database Administration - Manage Security To review individual course  more...

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

Oracle Report Builder Controlling Reports Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...

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

Oracle Developer 2000 Build Reports Curriculum The Developer/2000: Build Reports Curriculum consists of the following courses: Oracle Report Builder: Report Fundamentals Oracle Report Builder: Enhancing Reports Oracle Report Builder: Controlling Reports To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

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

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

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

Oracle Developer 2000 Build Forms II Curriculum The Developer/2000: Build Forms II Curriculum consists of the following courses: Oracle Form Builder: Managing Module Types Oracle Form Builder: Handling Multiple Object Relationships Oracle Form Builder: Including Reusable Oracle Components To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Form Builder Managing Module Types Course Overview This course is the fourth in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will introduce participants to Project Builder and teach them how to create and manage a menu module. In addition, users will learn how to customize and implement menu security. L earn To: Identify the benefits and terminology of Project  more...

Oracle Form Builder Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify the  more...

Oracle Form Builder Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and non-input  more...

Lotus Notes R5 Managing and Sharing Information ...manage Web pages in Lotus Notes; and subscribe to various databases to obtain information based on selection criteria. L earn To: Design and manage forms and views. Search domains, address books and the Internet for information. 0 Automate routine tasks by using agents. Browse the Web by using the Personal Web Navigator. Manage Web pages in Lotus Notes. Subscribe to  more...

Lotus Notes R5 Managing and Sharing Information ...manage Web pages in Lotus Notes; and subscribe to various databases to obtain information based on selection criteria. L earn To: Design and manage forms and views. Search domains, address books and the Internet for information. 0 Automate routine tasks by using agents. Browse the Web by using the Personal Web Navigator. Manage Web pages in Lotus Notes. Subscribe to various  more...

Lotus Notes R5 Messaging and Working Remotely ...tion: 2 - 3 Hour(s) Open a mail database by using the Databases bookmark folder. Match mail folders and mail views with their contents. Send a mail message. Attach a file to a mail message. Send a bookmark in a mail message. Preview a mail message in the preview pane. Reply to a mail message. Forward a mail message. Set up the Out of Office mail agent. Print a mail message. Open a  more...

Lotus Notes R5 Messaging and Working Remotely ...tion: 2 - 3 Hour(s) Open a mail database by using the Databases bookmark folder. Match mail folders and mail views with their contents. Send a mail message. Attach a file to a mail message. Send a bookmark in a mail message. Preview a mail message in the preview pane. Reply to a mail message. Forward a mail message. Set up the Out of Office mail agent. Print a mail message. Open a  more...

Lotus Notes R5 Collecting and Organizing Information ... a Workspace page by using Smarticons. Unit 3: Notes Databases Duration: 2 Hour(s) Open a Notes database by adding its icon on the workspace. Display the About document for a database by using the Open Database dialog box. Determine the access level for a database by using the status bar. Arrange database icons on the workspace. Navigate the contents of a database by using  more...

Lotus Notes R5 Collecting and Organizing Information ...e a Workspace page by using Smarticons. Unit 3: Notes Databases Duration: 2 Hour(s) Open a Notes database by adding its icon on the workspace. Display the About document for a database by using the Open Database dialog box. Determine the access level for a database by using the status bar. Arrange database icons on the workspace. Navigate the contents of a database by using  more...

Exchange Server 5 5 Concepts and Administration - Part 3 ... Duration: 1 - 2 Hour(s) Match the Microsoft Exchange databases with their functions. Match the log files with their functions. Sequence the steps performed by Microsoft Exchange to manage the online backup operations of a split transaction. Identify the advantages of enabling database circular logging. Identify the benefits of storing log files separately from database files. Run the  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 ...emory used by Microsoft SQL Server 7.0. Match the system databases with their features. Identify the server management features available in Microsoft SQL Server 7.0. Identify the features of multiserver administration in Microsoft SQL Server 7.0. Register a remote server by using the Register Server Wizard. Create a master server by using the Make Master Server Wizard. Create a target  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...r(s) Course Contents Unit 1: Creating and Accessing Databases Duration: 3 - 4 Hour(s) Identify the features of SQL Server 7.0. Identify the features of physical database architecture components. Modify the properties of a database by using Enterprise Manager. Create a table by using Enterprise Manager. Create an index by using Enterprise Manager. Create a relationship between  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 5 ...tly building desktop applications and accessing corporate databases. Participants should have completed the first four courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: ActiveX Document Duration: 1 - 2 Hour(s) Identify the benefits of using ActiveX documents. Create a new ActiveX document project. Compile an ActiveX document. Convert a  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 4 ...tly building desktop applications and accessing corporate databases. Participants should have completed the first three courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: MTS Transaction Services Duration: 2 - 3 Hour(s) Match the ACID properties of a Microsoft Transaction Server (MTS) transaction with their purpose. Identify the properties of  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...tly building desktop applications and accessing corporate databases. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: SQL Server in Enterprise Solutions Duration: 3 - 4 Hour(s) Identify the features of SQL Server that make it suitable for an Enterprise Solution. Identify the Data Integrity  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2 ...tly building desktop applications and accessing corporate databases. Participants should have completed the first course in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Microsoft Transaction Server (MTS) Duration: 2 - 3 Hour(s) Identify the features of MTS. Identify the system requirements for installing MTS on a computer. Identify the uses of  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 1 ...tly building desktop applications and accessing corporate databases. Participants should have completed Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 (Courses 72590 - 72594). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Microsoft Enterprise Development Strategy Duration: 2 - 3 Hour(s) Identify the features of client/server  more...

Competitive Intelligence Analysis Dissemination ...gence. Identify the three types of databases. Follow the steps for choosing a database. Identify the steps for preparing information for analysis. Identify the guidelines for performing ethical competitive intelligence. Use the guidelines for performing ethical competitive  more...

Oracle 11i10 System Admin Workflow Applications Manager ...tify options to monitor system alerts, logs, metrics, and databases in Oracle Applications Manager (OAM). Identify options provided by Oracle Applications Manager (OAM) to monitor forms. Identify features provided by Oracle Applications Manager (OAM) for monitoring JServ instances. Identify key concepts related to managing hosts in Oracle Applications Manager (OAM). Identify features  more...

Oracle Database 10g Adminsitration Workshop I Part 3 ...ime: 4 hours Objectives: Unit 1: Working with Databases Identify security practices and principles that are implemented in Oracle Database 10g. Identify advantages of revoking unnecessary privileges from the user group PUBLIC. Identify guidelines for restricting dictionary and directory access. Identify guidelines for restricting administrative privileges and remote  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER) model.  more...

Data Modeling - Create Basic Models Course Overview This is the first course in a two-part series which covers Data Modeling. You will begin by learning a top-down, systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as  more...

Data Modeling - Develop Depth to Your Models Course Overview This is the second course in a two-part series which covers Data Modeling. You will begin by learning a top-down, systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as  more...

Process and Function Modeling Course Overview Participants learn how to systematically describe the work performed by an organization using the Process Model. The process modeling technique is used to model the functional requirements of business, and should be used in conjunction with information modeling. This course can be used as part of an integrated Oracle curriculum and to supplement many of Oracle's Designer/2000  more...

Introduction to Data Warehousing Course Overview This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse. L earn To: Identify the basic  more...

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

Oracle SQL Specifics Creating and Managing Database Objects Course Overview 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  more...

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

Oracle SQL and SQL Plus SQL Plus and Reporting Course Overview This is the 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  more...

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

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

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

Oracle Developer 2000 Build Forms I Curriculum The Developer/2000: Build Forms I Curriculum consists of the following courses: Oracle Form Builder: Forms Fundamentals Oracle Form Builder: Enhancing the User Interface Oracle Form Builder: Writing and Debugging Code To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

SQL Server 7 0 - Implementing a Database - Part 1 ... processing. Perform the skills to construct and manage databases. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474). T otal Learning Time 6 - 8  more...

SQL Server 7 0 System Administration - Part 2 ...atabase structure. Understand the basics of SQL Server databases and how to create databases and other objects. Modify databases; manage data on multiple disks; assess database size requirements and to plan for growth. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for installing, configuring, administering and  more...

SQL Server 7 0 System Administration - Part 3 ... a system administrator. Restore damaged or incomplete databases. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) Course  more...

Lotus Notes 6 New Features of IBM Lotus Notes 6 ... Identify features of bookmark links to databases in Lotus Notes 6. Identify features of window access in Lotus Notes 6. Identify features of toolbar use in Lotus Notes 6. Customize the Lotus Notes 6 Status bar. Identify types of Welcome Pages in Lotus Notes 6.  more...

Lotus Notes 6 Moving to IBM Lotus Notes 6 ... list. The course then offers a unit on the management of databases, discussions and the personal journal, a unit on the use of Search tools and the organization of information using bookmarks, and a unit on the features of document creation, for example, table use and customization, the use of sections, formatting, and links in documents. Learn To To identify  more...

Microsoft Works Suite 2005 Creating Databases ...databases by covering Works Database essentials such as working with databases, fields, records, forms, and reports. It also covers database fundamentals such as the Works Database interface and database views. Learn To: Identify components of the Works Database interface. Create a database from an existing template. Identify the steps to create a blank database. Audience: A  more...

Crystal Reports v10 Introduction to Report Design Part 1 ...s and its environment. It also covers the fundamentals of databases and the key concepts associated with relational databases. In this course, you will learn to plan, create, preview, save, and distribute reports. Learn To: Identify the features of Crystal Reports v10. Open an existing report in Crystal Reports v10. Identify the key concepts of databases. Identify the options  more...

Lotus Domino R5 System Admin Part 9 Managing a Notes Domino Env Course Overview This is the ninth course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to identify the components of Domino Administrator, the server list, tabs, and tools; and manage a Domino environment. L earn To: Identify the components of Domino Administrator, the  more...

Windows 2000 Dir Services Infrastructure--Part 1 Active Dir Install Course Overview This course focuses on providing the knowledge and skills necessary for experienced support professionals to install, configure and troubleshoot Active Directory. L earn To: Identify Active Directory Concepts. Identify the features of a Domain Name System (DNS) Server. How to install Active Directory. C ontent Emphasis Skills-Based A udience This  more...

Oracle Database 10g New Features for Administrators Part 4 ... Identify tasks to be performed for configuring Flashback Databases. Identify features of the SYSAUX tablespace. Identify the steps to relocate SYSAUX occupants by using Enterprise Manager (EM). Identify conditions for renaming tablespaces in Oracle Database 10g. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have  more...

Oracle Database 10g New Features for Administrators Part 5 ...c storage management, upgrade methods, RMAN backup, flash databases, VPD enhancements, and statistical aggregation. Learn To: Identify features of Automatic Storage Management (ASM). Identify tasks in the process for creating an ASM-enabled database instance. Identify options for administering an Automatic Storage Management (ASM) instance. Identify options for upgrading to  more...

IBM DB2 Universal Database V6 1--Fundamentals ...ects, 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). Manage database operations. C  more...

IBM DB2 Universal Database V6 1--Fundamentals ...ects, 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). Manage database operations. C  more...

XML Programming--Part 2 DOM SAX XSLT ...the Extensible Linking Language (XLL), and using XML with databases, and developing XML-based enterprise applications. L earn To: Identify the features and functions of APIs used to interact with a parser. Identify the functions and features of Document Object Model (DOM) in XML. Identify the features of Document Object Model (DOM) specification. Identify the functions and  more...

XML Programming--Part 2 DOM SAX XSLT ...the Extensible Linking Language (XLL), and using XML with databases, and developing XML-based enterprise applications. L earn To: Identify the features and functions of APIs used to interact with a parser. Identify the functions and features of Document Object Model (DOM) in XML. Identify the features of Document Object Model (DOM) specification. Identify the functions and  more...

Office XP-New Features Curriculum ...ffice environment producing documents/spreadsheets and/or databases/Web pages. The audience for this curriculum may have job titles such as, Secretary, Clerk, Typist, CSR, Office Manager, Web Designer-Developer, System Administrator, Database Administrator. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA  more...

Office XP New Features Part 1 Overview Word Excel PowerPoint ...ffice environment producing documents/spreadsheets and/or databases/Web pages. The audience for this course may have job titles such as, Secretary, Clerk, Typist, CSR, Office Manager, Web Designer-Developer, System Administrator, Database Administrator. This course presents the learner with the first of two sets of new features available in the new Microsoft Office XP software. Content  more...

Office XP New Features Part 2 Access Outlook FrontPage ... work in an office environment producing and working with databases, e-mail, or Internet software. A high level of computer skill is not required for New Features Part 1 but learners will have had some prior experience with Microsoft Office software. However, New Features Part 2 requires a higher level of skill as its emphasis lies in databases and networking software. Learners will need a  more...

Access XP Fundamentals ...is course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables. Learn To • Identify advantages of a relational database. • Identify the basics of a relational database. • Sequence the steps for planning a relational database. • Create a table in Datasheet  more...

Access XP Proficient User ...s of data queries, work with forms and link data to other databases. Learn To • Create a single-table query in Design view. • Create a multiple-table query in Design view. • Create a simple query by using the Simple Query Wizard. • Identify features of the Form Wizard. • Identify features of the AutoForm Wizard. • Add a record to a form. •  more...

Access XP Expert User ...ssibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s). Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language  more...

Commerce Server 2000 Design Implementation Curriculum The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design  more...

Commerce Server 2000 Design Impl Part 1 Intro ...ver (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74116 Objectives Unit 1:  more...

Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs ...ver (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first part of this series 74116. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language  more...

Commerce Server 2000 Design Impl Part 3 Pipelines ...ver (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first two parts of this series 74116 and 74117. Deployment Options Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English  more...

i-Net Part 3 Web Site Development ...rs 14188 Objectives Unit 1: Programming Languages and Databases 1 - 2 hours o Identify programming technologies used by Web servers and clients. o Match server-side programming languages with their characteristics. o Match client-side programming languages with their characteristics. o Identify features of relational and non-relational databases. o Match technologies used to  more...

Workflow Mgmt Part 1 Process Mapping Automation This is the first course in a two part series that deals with transferring data, managing replication services, and maintaining high availability. This course will cover business process and workflow, process mapping techniques and tools, and workflow automation. Learn To: o Identify the characteristics of a business process. o Identify advantages of business process thinking. o Match  more...

Workflow Mgmt Part 2 Workflow Products This is the second course in a two part series that teaches students how to deal with key vendor workflow products. This course will cover an introduction to workflow products, key vendor strategies and GroupWare. Learn To: o Match workflow architecture structural layers with their features. o Identify the characteristics of role definition in a workflow architecture. o Match types of  more...

Database Technologies Relational Database Fundamentals ...l introduce the learner to the fundamentals of relational databases and relational database design, including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what'  more...

Database Technologies Introduction to SQL ... aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and querying data). Learn To: o Identify what SQL is, why and where it is used. o Identify how to retrieve data from a database. o Identify how to order, limit, and group their query results using various SQL clauses, keywords, and operators. o  more...

Works 2003 Curriculum The Works 2003 Curriculum includes the following courses: Works 2003: Introduction Works 2003: Creating Documents Works 2003: Creating Spreadsheets Works 2003: Creating Databases To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Works 2003 Creating Databases ...Databases course explores the database interface, and the student then learns about entering data, and database tables, and forms. Learn To Identify components of the Works Database interface. Create a database from a template. Identify options for creating a blank database. Deployment Options  more...

Access 2003 Proficient User ...rse teaches about backing up and compacting and repairing databases. Learn To To identify options in the Form Wizard. To identify AutoForms in the New Form dialog box. To identify elements of a PivotChart. To identify options in the Report Wizard. To  more...

Lotus Notes 6 New Features of IBM Lotus Notes 6 ... Identify features of bookmark links to databases in Lotus Notes 6. Identify features of window access in Lotus Notes 6. Identify features of toolbar use in Lotus Notes 6. Customize the Lotus Notes 6 Status bar. Identify types of Welcome Pages in Lotus Notes 6.  more...

Lotus Notes 6 Moving to IBM Lotus Notes 6 ... list. The course then offers a unit on the management of databases, discussions and the personal journal, a unit on the use of Search tools and the organization of information using bookmarks, and a unit on the features of document creation, for example, table use and customization, the use of sections, formatting, and links in documents. Learn To To identify  more...

Lotus Notes Domino R5 Development Part 1 Basic Concepts ... using the Calendar pane. Unit 3: Working with Domino Databases Duration: 2 Hour(s) Match the components of a Domino database with their functions. Match the types of fields in a Domino R5 database with their functions. Match the form elements with their uses. Identify the features of the types of Domino database views. Match the folder types in Domino R5 with their definitions.  more...

Lotus Domino R5 Development Part 2 Application Devel Fundamentals ...ify the elements of the database; and automate and secure databases by using Domino Designer. L earn To: Create a database in Domino Designer and identify the elements of the database. Automate and secure databases by using Domino Designer. C ontent Emphasis Skills-Based A udience This course series is for webmasters, application developers, and graphic designers with  more...

Dreamweaver UltraDev 4 ...Web site that is not database-driven. Unit 2: UltraDev: Databases and Data Sources 1 - 2 hours • Configure an application server by using the Site menu. • Create a database connection by using an existing DSN. • Create a DSN by using the Data Source Name (DSN) dialog box. • Create a database connection by using a connection string. • Create a recordset by  more...

CIW Site Designer Curriculum ...uding XML, HTTP servers, cookies, plug-ins, Java applets, databases and standards organizations. This curriculum consists of five Skill Builder courses: Course 87021 CIW Site Designer Part 1: Web Design Concepts and Site Development Course 87022 CIW Site Designer Part 2: Basic Web Technologies Course 87023 CIW Site Designer Part 3: Using FrontPage, Dreamweaver and HomeSite Course 87024 CIW Site  more...

CIW Site Designer Part 5 Advanced Web Tech Web Site Publishing ...uding XML, HTTP servers, cookies, plug-ins, Java applets, databases and standards organizations. This course also teaches the final step in Web site design - publishing the site. Learn To • Identify the various Markup languages such as HTML, XML, and XHTML. • Identify the HTML limitations, XML advantages and XML rules. • Identify certain concepts related to HTTP servers  more...

CIW Application Developer CGI Using Perl Fundamentals Curriculum ...onally, the curriculum will cover how to manage files and databases, and CGI security issues. This curriclum consists of two Skill Builder courses: Course 87051 CIW Fundamentals of CGI Using Perl Part 1: CGI and Perl Basics Course 87052 CIW Fundamentals of CGI Using Perl Part 2: Advanced Features Learn To See individual course descriptions for specific course objectives and scope.  more...

CIW Fundamentals of CGI Using Perl Part 2 Advanced Features ...eoretical and practical instruction on managing files and databases. This course will cover manipulating files, databases, and CGI security issues. Learn To • Identify the syntax used to save form data by using the param method. • Identify characteristics of the save method. • Identify the syntax used to modify form data. • Identify characteristics of database  more...

CIW Application Developer Dynamic Server Pages Curriculum ...ntals, string manipulation and file input/output, PHP and databases. This curriculum consists of three Skill Builder courses: Course 87053 CIW Dynamic Server Pages Part 1 Course 87054 CIW Dynamic Server Pages Part 2 Course 87055 CIW Dynamic Server Pages Part 3 Learn To See individual course descriptions for specific course objectives and scope. Audience The audience for this  more...

CIW Dynamic Server Pages Part 1 ...s, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and advanced programming concepts of PHP. • Identify string manipulations and file input/output operations. • Identify relational databases and SQL Application development by using PHP and MySQL. Audience The audience for this course includes  more...

CIW Database Specialist Part 1 Introduction to Database Design ...a four part series that teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models. Learn To: o Identify features of a database. o Identify  more...

Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites ...ver (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first three parts of this series 74116 thru 74118. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language  more...

Commerce Server 2000 Design Impl Part 5 Infra Sec Admin ...ver (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first four parts of this series 74116 thru 74119. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language  more...

IMS Essentials Curriculum ...S Transaction Manager (IMS TM). It also covers data entry databases (DEDBs) and expedited message handling (EMH). This curriculum consists of three Skill Builder courses: IMS Essentials Part 1: IMS Database Manager IMS Essentials Part 2: IMS Transaction Manager IMS Essentials Part 3: DEDBs, Advanced IMS Systems, and DB2 Learn To See individual course descriptions for specific  more...

e-Business Part 3 Choosing Tools Technologies ...ers, web servers, web application servers and web enabled databases. Learn To: a Identify browser types. a Identify the capabilities of browsers. a Identify the impact of browsers on e-Business. a Identify programming methods. a Match the programming languages suitable for e-Business with their characteristics. a Identify the features of  more...

IMS Essentials Part 1 IMS Database Manager ... 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 methods and about optimizing DL/I access methods.  more...

IMS Essentials Part 3 DEDBs Advanced IMS Systems DB2 ...Advanced IMS Systems, and DB2, you learn about data entry databases (DEDBs) and expedited message handling (EMH). The Advanced IMS Systems section introduces DBCTL and the concept of data sharing in IMS. The Common Service Layer (CSL) architecture is explained. Finally, the relationship between IMS and DB2 is explained, including the IMS to DB2 attachment. This course is current to IMS v.8, but  more...

Implementing Managing MS Exchange Server 2003 Maintaining ...ange Server 2003. Identify advantages of using multiple databases and storage groups. Identify steps to create a storage group and add a database to it. Identify steps to move transaction logs and databases. Unit 2: Disaster Recovery Identify features of various backup strategies. Identify key aspects of various backup processes. Identify key aspects of backing up Microsoft  more...