123-CBT Computer Based Training
Excel 2000 Intermediate LESSON_STR
Excel 2000 Intermediate
Lesson 1 : Getting To Know The Worksheet Window, Introduction, Opening Excel, Splitting Your Worksheet Vertically, Splitting Your Worksheet Horizontally, Removing The Split Bars From Your Worksheet, Freezing Panes, Unfreezing Panes, Freezing Multiple Panes, Unfreezing Multiple Panes, Hiding Columns And Rows Using The Format Menu, Hiding Columns And Rows Using Your Mouse, Inserting Columns And Rows, Removing A Column, Inserting Multiple Columns, Inserting Cells, Cell Descriptions, Review
Lesson 2 : The Function Wizard, Introduction, The Function Wizard, Calculating An Average, Calculating A Median, Calculating A Standard Deviation, Creating A Chart, Formatting Chart Components, Changing The Fill Color, The Gradient Tab, Selecting A more...
Excel 2002 Basic Lesson 1: The Excel 2002 Interface Introduction Lesson Objectives Opening Excel About Workbooks The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Hiding The Task Pane Showing The Task Pane The Formula Bar The Insert Function Button The Name Box The Worksheet Area Column Headings Row Headings The Select All Button The Vertical Scroll Bar The Horizontal Scroll Bar Sheet Tabs Inserting A Worksheet The Insert Dialog Box Renaming A Worksheet Changing Sheet Tab Order Deleting A Worksheet The Tab Scrolling Buttons The Status Bar Overview Of Menus The File Menu The Edit Menu The View Menu more...
Word 2002 Advanced Lesson 1: Building Tables & Charts Introduction Lesson Objectives Opening Word The Task Pane Inserting Headers & Footers Inserting A Picture In A Header Formatting Text In A Header Defining A Style The Style & Formatting Task Pane Switching Between Headers & Footers Inserting Text In A Footer Inserting Page Numbers Inserting A Section Break Creating A Different Header & Footer Creating A New Linked Or Embedded Object Deleting A Linked Or Embedded Object Inserting A Linked Or Embedded Object From File Drawing A Table Using The Eraser Centering A Table Text Wrapping Borders & Shading Entering Data In A Table Merging Cells Splitting Cells Using AutoSum Inserting A Row Calculating An Average Manually Resizing Rows & Columns Distributing Columns & Rows Specifying more...
Word 2002 Intermediate Lesson 1: New Features, AutoCorrect & AutoText Introduction Lesson Objectives Opening Word Overview Of Task Panes Opening An Existing Document Switching Between Task Panes The Clipboard Task Pane The Basic Search Task Pane Hiding The Task Pane The Ask A Question List Box Hiding White Spaces Showing White Spaces Multiple Selections Revealing Formatting Comparing Formatting AutoCorrect Demonstration The AutoCorrect Options Button AutoCorrect Options AutoCorrect Exceptions Multilingual AutoCorrect The What's This? Feature Creating An AutoCorrect Entry Verifying Changes Creating An AutoCorrect Entry For A Graphic Deleting An AutoCorrect Entry About AutoText Entries Smart Tags Creating An AutoText Entry Lesson 2: Tables & Charts Introduction Lesson Objectives more...
Word 2002 Basic Lesson 1: Touring The Word Window Introduction Lesson Objectives Opening Word 2002 The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Showing & Hiding The Task Pane Horizontal Ruler Overview The Status Bar Exploring Views Print Layout View Normal View Web Layout View Outline View The Vertical Scroll Bar Browsing By Object The Horizontal Scroll Bar Overview Of Menus The File Menu The Edit Menu The View Menu The Insert Menu The Format Menu The Tools Menu The Table Menu The Window Menu The Help Menu The Ask A Question List Box ToolTips The New Blank Document Button The Open Button The more...
NetWare 5 Administration Curriculum The Novell NetWare 5 Administration Curriculum consists of the following courses:
Novell NetWare 5 Administration - Part 1
Novell NetWare 5 Administration - Part 2
Novell NetWare 5 Administration - Part 3
Novell NetWare 5 Administration - Part 4
Novell NetWare 5 Administration - Part 5
To review individual course descriptions, please return to the previous page and select the desired title(s). more...
Access 2002 Advanced Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database Opening A Converted Database The Upsizing Wizard Object Linking & Embedding Creating A New Table Switching To Datasheet View Entering An Object In A Table The Insert Object Command Linking An Object Viewing Objects Inserting A New Object Verifying A Link Importing Data Into Access The Import Spreadsheet Wizard Viewing Imported Data Linking Tables Properties Of Linked Tables Inserting Hyperlinks Setting Hyperlink more...
Access 2002 Intermediate Lesson 1: The Access Interface Introduction Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using Replace Filtering By Form Removing A Filter Creating An Advanced Filter Applying More Than One Filter Sorting In Form View Applying The Last Known Filter Printing Data In Form Style Compacting Databases & Projects Lesson 2: Fields & Field Properties Introduction Opening Access Opening A Sample Database Opening A Table In Design View The Table Design Window Switching Between Views Design View Controls Opening A Form more...
Access 2002 Basic Lesson 1: The Access Interface & Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status Bar Database Objects Opening A Sample Database About The Northwind Database The Main Switchboard The Database Window The Database Window Toolbar The Objects Bar Expanding & Minimizing The Objects Bar Selecting An Object Opening An Object Tables Fields & Records Field & Record Selectors Selecting A Record Navigating Records Creating A New Record Sorting Records Design View Primary Keys Data Types Switching Views more...
NetWare 5 Administration Curriculum The Novell NetWare 5 Administration Curriculum consists of the following courses:
Novell NetWare 5 Administration - Part 1
Novell NetWare 5 Administration - Part 2
Novell NetWare 5 Administration - Part 3
Novell NetWare 5 Administration - Part 4
Novell NetWare 5 Administration - Part 5
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 previous page and select the desired title(s). more...
Windows NT 4 0 Administration Fundamentals - Part 2 Course Overview This is the second course in a two part series which provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and multiple-domain Windows NT 4.0-based network. This series is intended to prepare the learner for Microsoft's self-administered exam 803 on Windows NT 4.0 Administration. L earn To: Create and administer network printers. Audit and monitor the server resources. Make backups and restore data from a tape. C ontent Emphasis Skills-Based A udience This course is inteneded for IT Professionals who perform post-installation administration of Windows NT Server and Windows NT Workstation, including management of accounts, account policies, disk resources, printers, more...
Windows NT 4 0 Administration Fundamentals - Part 2 Course Overview This is the second course in a two part series which provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and multiple-domain Windows NT 4.0-based network. This series is intended to prepare the learner for Microsoft's self-administered exam 803 on Windows NT 4.0 Administration. L earn To: Create and administer network printers. Audit and monitor the server resources. Make backups and restore data from a tape. C ontent Emphasis Skills-Based A udience This course is inteneded for IT Professionals who perform post-installation administration of Windows NT Server and Windows NT Workstation, including management of accounts, account policies, disk resources, printers, more...
Windows NT 4 0 Administration Curriculum Course Overview
This course series presents the prerequisite knowledge for individuals seeking MCSE certification. To become a Microsoft Certified Systems Engineer you are required to pass four operating systems exams and two elective exams that provide a valid and reliable measure of technical proficiency and expertise.
L earn To:
Microsoft Class - 803 Administering Microsoft Windows NT 4.0
C ontent Emphasis
Skills-Based
A udience
This series is intended for professionals seeking MCSE certification.
Course Contents
Course Series: Administering Microsoft Windows NT 4.0
Course Series 71401 - 71402
This two part series provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and more...
Windows NT 4 0 Administration Curriculum Course Overview
This course series presents the prerequisite knowledge for individuals seeking MCSE certification. To become a Microsoft Certified Systems Engineer you are required to pass four operating systems exams and two elective exams that provide a valid and reliable measure of technical proficiency and expertise.
L earn To:
Microsoft Class - 803 Administering Microsoft Windows NT 4.0
C ontent Emphasis
Skills-Based
A udience
This series is intended for professionals seeking MCSE certification.
Course Contents
Course Series: Administering Microsoft Windows NT 4.0
Course Series 71401 - 71402
This two part series provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and more...
Windows NT 4 0 Administration Fundamentals - Part 1 Course Overview
This is the first course in a two part series which provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and multiple-domain Windows NT 4.0-based network. This series is intended to prepare the learner for Microsoft's self-administered exam 803 on Windows NT 4.0 Administration.
L earn To:
Identify the features of Windows NT 4.0 interface, create and customize user and group accounts.
Administer rights and policies for user and group accounts and configure the user environment.
Manage and secure resources with shared folders and NTFS permissions.
C ontent Emphasis
Skills-Based
A udience
This course is intended for IT professionals who perform post-installation more...
Windows NT 4 0 Administration Fundamentals - Part 1 Course Overview This is the first course in a two part series which provides the knowledge and skills necessary to perform post-installation and day-to-day administration tasks in a single-domain and multiple-domain Windows NT 4.0-based network. This series is intended to prepare the learner for Microsoft's self-administered exam 803 on Windows NT 4.0 Administration. L earn To: Identify the features of Windows NT 4.0 interface, create and customize user and group accounts. Administer rights and policies for user and group accounts and configure the user environment. Manage and secure resources with shared folders and NTFS permissions. C ontent Emphasis Skills-Based A udience This course is intended for IT professionals who perform post-installation more...
Windows NT 4 0 User Fundamentals Course Overview
This multimedia self-paced learning course will instruct you on working with Microsoft Windows NT 4.0 Workstation. 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 path based on the knowledge and skills demonstrated. Mastery tests at the end of each unit allow you to verify your understanding of key skills and guide you back to any content that warrants further study.
L earn To:
Perform tasks from the Desktop.
Understand the basics of using Windows NT 4.0 Workstation.
Use Explorer to view and manipulate files and folders 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 developing reports for different environments. This course is based on Oracle's ILT course, Oracle Developer: Build Reports. L earn To: Identify and modify the regions of a report template. Identify the steps to register your own predefined template and add an image to it. Create and reference user parameters in a query. Create valid lists of values for parameter input. Identify the 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 enhance matrix reports by modifying the objects in Data Model editor and the Layout Model editor. This course is based on Oracle's ILT course, Oracle Developer: Build Reports. L earn To: Enhance a report by modifying properties of a query, changing group structure an filtering data in a group. Build a report by creating queries. Enhance a report by creating columns. Identify the 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 report definitions from Developer/2000 Release 1 to Oracle Reports Release 6. This course is based on Oracle's ILT course, Oracle Developer: Build Reports. L earn To: Identify the features and components of Report Builder. Identify standard report design styles. Label the options in the Runtime Previewer. Run a report in Oracle Developer. Match a report's executable filenames, the 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 modify the relations between two associated blocks. Finally, the course provides information on the new features available in Oracle Developer. L earn To: Implement the methods to use additional data sources on which to base data blocks. Work with Oracle8 objects in Form Builder. Understand the concepts behind reusability and the procedures to reuse components, objects, and code. 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: Identify the rules, types, and functions of Key triggers. Create a Key trigger and write the code that associates the key triggers with the user interface. Write code that responds to mouse events. Write the code to manage windows and canvases by using built-ins and triggers. Invoke multiple forms by using built-ins and pass data between forms by using parameter lists. Work with record groups. 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: Identify the benefits of using Project Builder. Match the terms used in Project Builder with their definitions. Create an empty stand-alone project using the Project Wizard. Add files to an empty project by using Project Wizard. Add an entire subdirectory of files as a stand-alone project. Create a new connection to the Oracle database by using the pop-up menu. List the operations that it 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 communication formats used by Form Builder. Write the code to handle errors, suppress system messages, create alerts and control alerts at run time. Run a form module in debug mode. Identify the concepts related to debugging PL/SQL code. Debug PL/SQL code. Identify the process involved in querying a data block. Write triggers to query a data block. Manipulate the query process. 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 items by creating triggers containing built-in subprograms. L earn To: Create input and non-input items. Identify the features and uses of LOVs. Create LOVs manually and using the LOV Wizard. Create and use editors. Create and set properties for a window and a content canvas. Create and set properties for stacked, toolbar, and tab canvases. Identify trigger events, components, 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 Oracle Developer. Identify the features of the Form Builder environment. Run and create a basic form module. Customize a form module. C ontent Emphasis Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT 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 will use Oracle tools to diagnose and resolve contention, given the possible causes of contention. Finally, the participants will be introduced to the features of Oracle Expert, create a tuning session, gather, view and edit the input data, analyze the collected data using rules, review tuning recommendations and implement tuning recommendations.
L earn To:
Determine an appropriate block 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 buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines.
L earn To:
Identify application tuning issues that will impact database performance.
Identify the contents and functions of the shared pool.
Identify how the Buffer Cache is managed and tuned.
Learn how to tune the Redo Log Buffer.
Learn about database 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 overview the operating system tuning issues.
L earn To:
Identify the roles of individuals involved in the tuning process.
Identify different tuning goals.
Define the steps associated with the tuning process.
Identify the location and usefulness of the alert log file.
Identify the location and usefulness of the background and user process trace files.
Identify different types of 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 between peers. Participants will learn how to implement a basic connection between a client and a server node using various naming methods. Participants will also configure a Names server and Connection Manager. The different methods used to determine network problems and the security risks are also presented. Utilities such as logging, training, and Trace Assistant will be covered. Finally, the 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 peers. Participants will learn how to implement a basic connection between a client and a server node using various naming methods. Participants will also configure a Names server and Connection Manager. The different methods used to determine network problems and the security risks are also presented. Utilities such as logging, training, and Trace Assistant will be covered. Finally, the security 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 recover from the loss of a Recovery Catalog and Control File. Finally, this course will present the features and usage guidelines of a standby database and how to manage one.
L earn To:
Identify the ways of handling different types of errors.
Diagnose errors and detect corruption by using different tools.
Understand the recovery process for a database running in noarchive mode and 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 be presented with the components and features of Recovery Manager and how to maintain a recovery catalog. Finally, the user will learn how to perform physical backups with and without RMAN.
L earn To:
Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
Describe the structures and processes in the Oracle architecture.
Identify the 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 password limits.
Manage system and object privileges.
Control the administration of privileges in a database.
Keep track of the events occurring in a database.
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with 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 earn To:
Identify the characteristics of various tables and datatypes.
Create and manage tables.
Retrieve table information from the data dictionary.
Identify the characteristics and types of triggers and constraints.
Implement and maintain data integrity.
Retrieve information from the data dictionary.
Implement clusters and index-organized tables ( IOTs).
Load and 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 how storage structure components work.
Manage rollback segments.
Manage temporary segments.
Manage indexes.
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken more...
Oracle8 Certified Database Administrator Curriculum NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (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) more...
Oracle8 Database Administration - Create Databases Course Overview
This course is the second 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 storage structure components, managing rollback segments, temporary segments, 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 groups.
Redo log members.
Control files.
Identify the process of log switches and checkpoints.
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:
Identify Oracle architectural components.
Use the Server Manager line mode and the Oracle
Enterprise Manager (OEM) interface.
Manage an Oracle instance.
Learn about the features of National Language Support (NLS).
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators and technical support professionals. Prior 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 a report template. Modify template regions Register a predefined template. Add an image to a predefined template. Create and reference user and system parameters. Create valid lists of values for parameter input. Identify different types of triggers in report, data and layout models. Create report-level, data model, and layout model triggers. Identify the functions of the SRW 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 Data Model. Understand the Layout Model layers. Enhance a report by modifying the layout in the Layout Model editor. Understand the contents of a file at runtime. Control the pagination of the contents and other objects in the report output by modifying the object properties. Enhance the matrix reports by modifying the objects in the Data Model and the Layout Model. C ontent 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 definitions from Developer/2000 Release 1 to Developer/2000 Release 2. L earn To: Identify the features and components of Report Builder. Identify standard report design styles. Invoke Report Builder. Identify the destinations for a report. Identify the options in the Live Previewer. Run a report in Developer/2000. Match a report's executable filenames, the Report Builder module 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 earn To:
Implement the methods to use additional data sources on which to base data blocks.
Include charts, reports, and timers in Forms modules by using wizards and built-ins.
Understand the concepts behind reusability and procedures to reuse components, objects, and code.
Implement the new Oracle Server error handling features accessible to Form Builder.
C ontent Emphasis 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 earn To: Identify the rules, types, and functions of Key triggers. Write an application that responds to mouse events. Write the codes to manage windows and canvases by using built-ins and triggers. Create and modify relations between two associated blocks by using Object Navigator and programmatic control. Invoke multiple forms by using built-ins and pass data between forms by 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 Builder. Create a project. Establish dependencies. Deliver a project. Create a menu module containing menus, menu items, menu toolbars, and pop-up menus in Form Builder. Manage a menu module by control. Customize and implement security by using built-ins and substitution parameters. C ontent Emphasis Skills-Based A udience Application developers, database administrators, more...
Oracle Cert App Developer Track for Developer 2000 R2 Curriculum NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder: Enhancing the User Interface (ID#387) Oracle Form Builder: 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 descriptions of the communication formats used by Form Builder.
Write codes to detect errors, suppress system messages, create alerts, and control alerts at runtime.
Run a form module in Debug mode.
Identify the concepts related to debugging a PL/SQL code.
Debug a PL/SQL code.
Identify the process involved in querying a data block.
Write triggers to query a data block.
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 items.
Create Lists of Values (LOVs) and Editors that are Form Builder objects to supplement the text item object.
Create and set properties for Windows and Canvases.
Identify the events associated, components, and execution hierarchy of triggers.
Add functionality to input and non-input items by creating triggers containing built-ins.
C ontent Emphasis
Skills-Based
A 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 and capabilities of Developer/2000.
Identify the features of the Form Builder environment.
Run and create a basic form module.
Customize a form module.
C ontent Emphasis
Skills-Based
A udience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and more...
SQL and PL SQL DML and DDL Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, 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 how to control both user and object level security in an Oracle database. L earn To: Create tables and integrity constraints. Manipulate data using DML. Alter tables and constraints. Create more...
SQL and PL SQL Data Retrieval Techniques Course Overview This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that contain common group functions. Restrict more...
SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. L earn To: Identify relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write SQL SELECT queries. Customize SQL queries 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 parsed code.
Identify the factors in SQL code design that affect response time.
Identify the methods to improve network performance.
Identify the differences in optimization approaches.
Influence the cost-based optimization to improve performance.
C ontent Emphasis
Skills-Based
A udience
Application Developers, Database Administrators, and Designer/Developers.
T otal 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 clusters. Participants will then be able to test the results of their tuning efforts using performance analysis tools.
L earn To:
Identify the need and areas for tuning the performance of SQL statements.
Identify tuning steps.
Identify the tools that help you test an diagnose performance problems with a SQL statement.
Use efficient data access methods that are available for the 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 using SQL*Plus runtime variables.
Identify the SQL*Plus commands associated with line editing, file manipulation, and script creation.
Write the commands and queries to enhance query output.
C ontent Emphasis
Skills-Based
A udience
Application developers, database administrators, system designers/developers, and technical support professionals. Learners should be familiar with the 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 subqueries.
Write multiple-row and multiple-column subqueries.
Write correlated subqueries.
Write queries using number DECODE and character functions.
Write hierarchical queries and format hierarchical reports.
Write compound queries by using set operators and control the order of the output of the compound queries.
C ontent Emphasis
Skills-Based
A udience
Application 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 views, sequences, indexes and synonyms. Additionally, users will learn how to control database access, add new users, and provide alternative names for objects using synonyms. Finally, participants will learn how to format query output, control the SQL*Plus environment, and specify variables at runtime.
L earn To:
Create and manage tables.
Use the Oracle database objects: views, 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 learn how SQL functions can be used in SQL SELECT statements to extract data from the database and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.
L earn more...
SQL and PL SQL PL SQL Basics Course Overview 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 easy-to-understand examples ensure that the concepts are amply illustrated. L earn To: Identify the features and benefits of PL/SQL and understand the PL/SQL program constructs. Identify the PL/SQL datatypes Identify how to declare PL/SQL variables and identify the PL/SQL programming conventions. Retrieve and manipulate data from the database by using PL/SQL commands 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 concepts and terminology of data warehousing.
Identify the different processes and tasks involved in an integrated warehouse environment.
Identify the different data warehouse architectures.
Identify the different data warehouse models.
Identify the range of Oracle products that may be employed for a warehouse implementation.
C ontent Emphasis
Skills-Based
A udience more...
Object Analysis Design Design Implementation Course Overview
This is the second title in a series of two, and covers the same material as the second half of the Instructor Led course Object Oriented Analysis and Design Using UML. This course teaches students the principles and terminology of object oriented development. It follows on from the first title in the series Object Analysis and Design: Requirements and Analysis and teaches the student how to apply a development process to move a project from requirements capture through to implementation. It also teaches a number of object-to-relational mapping techniques.
L earn To:
How to apply a development process to move a project from requirements capture through to implementation
A number of object-to-relational mapping techniques.
C ontent Emphasis
Conceptual more...
Object Analysis Design Requirements Analysis Course Overview
This is the first title in a series of two, and covers the same material as the first half of the Instructor Led course Object Oriented Analysis and Design Using UML. This course teaches students the principles and terminology of object oriented development, and how to apply object oriented techniques to define systems using the notation of the Unified Modeling Language (UML).
L earn To:
The principles and terminology of object oriented development
How to apply object oriented techniques to define systems using the notation of the Unified Modeling Language (UML).
C ontent Emphasis
Conceptual
A udience
This course is aimed at business managers, business analysts, technical analysts, database designers, and anyone responsible for analysis and more...
MCSE Windows 2000 Core Curriculum The Complete MCSE Windows 2000 Core Curriculum includes the following courses: Windows 2000: Administration--Part 1 ( User Accts.) (ID#7579) Windows 2000: Administration--Part 2 (Groups & Resource Mgmt.) (ID#7581) Windows 2000: Administration--Part 3 (Computer Mgmt.) (ID#7583) Windows 2000: Installation, Config., & Admin.--Part 1(Installation) (ID#7587) Windows 2000: Installation, Config., & Admin.--Part 2(File Sys.&Hardware Config.) (ID#7589) Windows 2000: Installation, Config., & Admin.--Part 3(Resource Optimization) (ID#7591) Windows 2000: Installation, Config., & Admin.--Part 4(Enterprise Admin.) (ID#7593) Windows 2000: Installation, Config., & Admin.--Part 5(Network Imp.) (ID#7595) Windows 2000: Installation, Config., & Admin.--Part 6(Server Organization) (ID#7597) Windows more...
MCSE Windows 2000 Curriculum The Complete MCSE Windows 2000 Curriculum includes the following courses: Microsoft Windows 2000--Technical Overview (ID#976) Microsoft Windows 2000--New Features (ID#977) Windows 2000: Administration--Part 1 (User Accts.) (ID#7579) Windows 2000: Administration--Part 2 (Groups & Resource Mgmt.) (ID#7581) Windows 2000: Administration--Part 3 (Computer Mgmt.) (ID#7583) Windows 2000: Installation, Config., & Admin.--Part 1(Installation) (ID#7587) Windows 2000: Installation, Config., & Admin.--Part 2(File Sys.&Hardware Config.) (ID#7589) Windows 2000: Installation, Config., & Admin.--Part 3(Resource Optimization) (ID#7591) Windows 2000: Installation, Config., & Admin.--Part 4(Enterprise Admin.) (ID#7593) Windows 2000: Installation, Config., & Admin.--Part 5(Network Imp.) (ID#7595) more...
Project 2000 Proficient User Course Overview This second course in the two-part series will add to the skills and knowledge gained in the first course. In this course, students will gain proficiency with Project Central, be able to customize a Project plan and use advanced functions. L earn To: Perform advanced functions to manage a project. Manage multiple projects, tasks, and resources. Create and applying a template to create a new project. Customize tables, views, groups, outlines, filters, timescales, bar styles, custom forms, and the accessibility and user options. Track projects and customize Project Central. C ontent Emphasis Skills-Based A udience This course is intended for end users that use the fundamental capabilities of Microsoft Project 2000. Participants should have a more...
Project 2000 Fundamentals Course Overview As the first in a two-part series, this course will provide learners with a foundation for using Project 2000. Learners will be given a thorough overview of the features of Project. Learners also will be taught how to create, communicate and track a Project plan. L earn To: Identify the uses of the new features in MS Project 2000. Create a project file. Create and schedule tasks in MS Project 2000. Add, assign, and modify resources, add costs on resources, and create and assign calendars in MS Project 2000. Track the schedules, work and costs of a project plan visually, display the actual plan with the baseline plan, set reminders, and send workgroup messages. Communicate project information by creating and modifying standard task reports, enhancing more...
Windows 2000 Dir Services Infrastructure--Part 5 Remote Installation Course Overview This course will provide the knowledge and skills necessary for experienced support professionals to use Remote Installation Services to deploy Windows 2000, and how to configure RIS security. L earn To: Identify the benefits of configuration management. Identify the method used to deploy Windows 2000 Professional by means of RIS. Identify the guidelines for configuring client computer names and locations. Identify the guidelines for pre-staging client computers. Identify the features of image management for remote installations. Identify the functions of answer files in configuring a CD-based image for installing Windows 2000 Professional. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical more...
Windows 2000 Dir Services Infrastructure--Part 5 Remote Installation Course Overview This course will provide the knowledge and skills necessary for experienced support professionals to use Remote Installation Services to deploy Windows 2000, and how to configure RIS security. L earn To: Identify the benefits of configuration management. Identify the method used to deploy Windows 2000 Professional by means of RIS. Identify the guidelines for configuring client computer names and locations. Identify the guidelines for pre-staging client computers. Identify the features of image management for remote installations. Identify the functions of answer files in configuring a CD-based image for installing Windows 2000 Professional. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users more...
Windows 2000 Dir Services Infrastructure--Part 4 Advanced Admin Course Overview This course focuses on how to implement and troubleshoot group policy. How to manage and troubleshoot user environments using group policy, and how to manage and troubleshoot software deployment using group policy. L earn To: Create a Group Policy object. Configure administrative template settings. Deploy software by using Group Policy. Redirect user folders by using Group Policy. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Group Policy Implementation Duration: 1 - 2 Hour(s) Identify the types of Group Policy settings that can be more...
Windows 2000 Dir Services Infrastructure--Part 4 Advanced Admin Course Overview This course focuses on how to implement and troubleshoot group policy. How to manage and troubleshoot user environments using group policy, and how to manage and troubleshoot software deployment using group policy. L earn To: Create a Group Policy object. Configure administrative template settings. Deploy software by using Group Policy. Redirect user folders by using Group Policy. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Group Policy Implementation Duration: 1 - 2 Hour(s) Identify the types of Group Policy settings that can be more...
Windows 2000 Dir Services Infrastructure--Part 3 Physical Structure Course Overview This course focuses on the physical structures involved in implementing and administering a Windows 2000 directory services infrastructure. It also covers how to backup and restore Active Directory. Managing Active Directory performance and troubleshooting Active Directory replication is also covered. L earn To: Identify the features of the Physical Topology. Identify the features of Sites and Replication Traffic. Identify the features of Maintenance Recovery. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Physical Topology Duration: 2 - more...
Windows 2000 Dir Services Infrastructure--Part 3 Physical Structure Course Overview This course focuses on the physical structures involved in implementing and administering a Windows 2000 directory services infrastructure. It also covers how to backup and restore Active Directory. Managing Active Directory performance and troubleshooting Active Directory replication is also covered. L earn To: Identify the features of the Physical Topology. Identify the features of Sites and Replication Traffic. Identify the features of Maintenance Recovery. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Physical Topology Duration: 2 - 3 more...
Windows 2000 Dir Services Infrastructure--Part 2 Logical Structure Course Overview This course focuses on the logical structures involved in implementing and administering a Windows 2000 directory services infrastructure. It also teaches how to manage active directory objects. L earn To: Identify Active Directory Logical Models. Perform Active Directory Administration. Delegate Administrative Authority. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Active Directory Logical Models Duration: 2 - 3 Hour(s) Identify the guidelines for selecting a single domain. Identify the guidelines for selecting a domain tree. more...
Windows 2000 Dir Services Infrastructure--Part 2 Logical Structure Course Overview This course focuses on the logical structures involved in implementing and administering a Windows 2000 directory services infrastructure. It also teaches how to manage active directory objects. L earn To: Identify Active Directory Logical Models. Perform Active Directory Administration. Delegate Administrative Authority. C ontent Emphasis Skills-Based A udience This course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Active Directory Logical Models Duration: 2 - 3 Hour(s) Identify the guidelines for selecting a single domain. Identify the guidelines for selecting a domain tree. Identify 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 course is intended for experienced technical users with responsibility for implementing and administering a Windows 2000 network. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Active Directory Concepts Duration: 2 - 3 Hour(s) Identify the key features of Active Directory. Identify the main components of Active Directory. Identify the naming and name resolution 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 courses.
L earn To:
Identify the concepts of process modeling.
Identify the purpose and use of process modeling.
Place process modeling in the context of system development methods.
Identify the basic diagramming techniques of a process model.
Use basic diagramming techniques to build a simple process model.
Refine a simple process model with more detail to fully illustrate 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 part of Oracle's integrated curriculum. It is designed to act as an alternative prerequisite to a large number of ILT courses in related curricula areas, such as Server Developer/2000 and Designer/2000.
L earn To:
Model hierarchies and roles.
Model exclusive entities and relationships.
Model data which reflects changes over time.
Resolve fan traps and chasm traps.
Consider 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 part of Oracle's integrated curriculum. It is designed to act as an alternative prerequisite to a large number of ILT courses in related curricula areas, such as Server Developer/2000 and Designer/2000.
L earn To:
Consider the approaches to information modeling.
Understand the components of the Entity Relationship Model.
Understand the need for detailed definitions of attributes, more...
Building Cisco Remote Access Networks Part 4 This is the fourth in a four-part curriculum that prepares the learner to take the Building Cisco Remote Access Networks ( BCRAN) exam. The course focuses on two main areas - quality of service and user access security.
Learn To:
Identify features of quality of service ( QoS).
Identify types of problems that can occur when merging different traffic streams.
Identify the issues that can affect QoS.
Identify features of Cisco security.
Identify features of Cisco Secure Access Control Server (ACS).
Identify features of authentication, authorization, and accounting (AAA).
Audience:
This curriculum is designed for network administrators who are responsible for implementing and troubleshooting WAN and remote access solutions. They desire the knowledge and skills necessary more...
Building Cisco Remote Access Networks - Part 3 This is the third in a four-part curriculum that prepares the learner to take the Building Cisco Remote Access Networks ( BCRAN) exam. The course focuses on ISDN, with coverage of ISDN BRI, PRI and DDR. Optimizing usage of DDR interfaces is covered. The course closes with comprehensive coverage of Frame Relay connections.
Learn To:
Identify features of Integrated Services Digital Network (ISDN) technology.
Identify commands used to configure an Integrated Services Digital Network (ISDN) Basic Rate Interface (BRI) connection.
Identify commands used to configure caller identification (ID) screening.
Identify features of Integrated Services Digital Network (ISDN) Dial-on-Demand Routing (DDR).
Identify commands used to configure Dial-on-Demand Routing (DDR) for Basic Rate more...
Building Cisco Remote Access Networks - Part 2 This is the second in a four-part curriculum that prepares the learner to take the Building Cisco Remote Access Networks ( BCRAN) v2.0 exam. The course offers an overview of cable and DSL technology, the configuration and troubleshooting of DSL, Virtual Private Networks, and the creation of IKE and IPSec security policies.
Learn To:
Identify features of broadband technology.
Identify features of Network Address Translation (NAT).
Identify commands for translating an address.
Identify features of cable technology.
Identify features of digital signals over radio frequency (RF) channels.
Identify features of cable technologies.
Identify tasks for configuring the customer premises equipment (CPE) as the Point-to-Point Protocol over Ethernet (PPPoE) client.
Identify more...
Building Cisco Remote Access Networks Part 1 This is the first in a four-part curriculum that prepares the learner to take the Building Cisco Remote Access Networks ( BCRAN) v2.0 exam. The course starts with coverage of the basics of WAN technologies and components. The areas then covered are: security in expanding networks, the configuration of asynchronous connections, and controlling network access through PPP.
Learn To:
Identify characteristics of WAN connections.
Identify features of circuit-switched connections.
Identify features of packet-switched connections.
Identify characteristics of modulation and demodulation.
Identify features of cabling technologies.
Identify modem modulation standards.
Identify features of Point-to-Point Protocol (PPP).
Identify commands used to enable Point-to-Point Protocol more...
Building Cisco Remote Access Networks Curriculum The Building Cisco Remote Access Networks Curriculum includes the following courses: Building Cisco Remote Access Networks: Part 1 Building Cisco Remote Access Networks: Part 2 Building Cisco Remote Access Networks: Part 3 Building Cisco Remote Access Networks: Part 4 To review individual course descriptions, please return to the previous page and select the desired title(s). more...
C Foundation for Non-C Programmers - Part 2 Course Overview This is the second part of a two-part series which is designed to teach non-C programmers the fundamentals of C++ programming. This series is based on ANSI C++ and is not environment or vendor-specific. This course introduces the skills needed to be able to begin to use C++'s Object-Oriented (OO) features. Students will hearn how to create, use, and extend classes, as well as how to populate those classes with members and functions. They will also learn how to instantiate objects, incorporate error handling, and perform simple I/O. L earn To: Identify the features of object-oriented programming. Declare a class. Create an object to a class. Invoke and access member functions. Identify the function of a pointer. Manipulate member functions. Declare more...
C Foundation for Non-C Programmers - Part 1 Course Overview This is the first part of a two-part series which is designed to teach non-C programmers the fundamentals of C++ programming. This series is based on ANSI C++ and is not environment or vendor-specific. This course will teach students the basic skills and knowledge necessary to be able to write, compile, and run basic C++ applications. Students will learn the language fundamentals, such as syntax, data types, and operators. In addition, they will learn how to create expressions and statements, apply flow control, and create and call functions. L earn To: Identify the basic program structure in C++. Identify the different compilers. Identify the process of creating an executable program. Identify basic and complex data types used in C++. Identify the more...
C Programming - Part 4 Course Overview This is the last course in a four-part series on C++ Programming, which is based on ANSI C++. This course is designed to give learners some of the practical skills needed to be able to write and compile user-ready C++ applications. Learners will acquire skills needed to perform runtime exception handling, incorporate standard libraries, and create well-designed class hierarchies. L earn To: Implement the C++ exception-handling mechanism to enable programs to recognize and respond to run-time errors. Instantiate and manipulate C++ collections. Identify classes in the I/O library. Create file and string streams. C ontent Emphasis Skills-Based A udience Application developers, software engineers, systems engineers, and programming specialists more...
C Programming - Part 3 Course Overview This course is the third in a four-part series on C++ Programming, which is based on ANSI C++. This course will give students the skills and knowledge needed to better manage their C++ objects and classes. Students will learn how to handle references and dynamic memory allocation, as well as take advantage of polymorphism, overloading, and templates. L earn To: Identify the features of types of polymorphism. Implement operator and functions overloading within guidelines. Identify virtual functions and abstract classes using pure virtual functions. Declare a function template. Overload a function template. Create a class template. Use a class template. Manage the memory used by objects. Identify the concepts of reference counting and garbage more...
C Programming - Part 2 Course Overview This course is the second in a four-part series on C++ Programming, which is based on ANSI C++. The focus of this course will be on the object-oriented (OO) capabilities of C++. Students will gain the skills and knowledge needed to effectively create and manage classes, work with functions and operators, and take advantage of inheritance. L earn To: Override the assignment operate. Initialize objects. Convert data types. Identify the issues related to inheritance. Identify the effect of access specifiers on inheritance. Implement inheritance. Identify friend relationships, containment relationships, and associative relationships. Implement friend relationships, containment relationships, and associative relationships. C ontent Emphasis more...
C Programming - Part 1 Course Overview This course is the first in a four-part series on C++ Programming, which is based on AN |