Microsoft Access 2002 Level 2 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. Students will also learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. more...
Microsoft Access 2002 Level 3 Students will be introduced to advanced features and gain a more complete understanding of how to effectively create and use the primary database objects in Access. Various maintenance features are also covered, teaching students ways to better manage multi-user databases. 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. more...
Access 2000 Level 2 In this intermediate course, students will gain a more complete understanding of how to effectively create and use 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. more...
Access 2000 Level 3 In this advanced course, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, and how to use Access as a development tool. Various maintenance and security features are covered in the course, teaching students ways to better manage multi-user databases. more...
Access 2000 MOUS This comprehensive course teaches students both the basic and the more advanced elements that compose an Access database. 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. more...
Access 2002 MOUS This course introduces students to the new features in Microsoft Access 2002 that set it apart from Access 2000. This includes speech recognition and the new Task Pane, as well as basic elements that compose an Access database. As the course becomes more advanced, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access and how to more...
J2EE Connectivity Part 3: RMI and JDBC This third course in the series covers using RMI and JDBC. It teaches how to use Java Remote Method Invocation for creating and using remote objects and the criteria and tradeoffs involved in selecting distribution technologies. The sections about JDBC provide an introduction to the API and an overview of how to create JDBC programs, it also covers the function of the JDBC 2 Optional Package API. more...
OS 390 Designing DB2 Data Warehouse ... significant characteristics of relational databases, DB2 database objects, and common SQL that is run in a relational database management environment. The course ""walks"" the student through basic functions: setting up and maintaining a database, and accessing DB2 data interactively and through applications. Finally, it covers the fundamentals of database management, including security, data more...
Microsoft Access 97 Advanced ...iduals learn how to add complex objects to a form, manage database objects, create macros and modules and maintain a database. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long after course completion.Related Exam: Microsoft Officemore...
Microsoft Access 2000 Advanced This highly interactive CBT contains five units that cover advanced Access 2000 skills. Through step by step instruction with realistic simulation, students learn how to manage objects, create macros, graphical reports, understand modules, and maintain a database. People wishing to learn the advanced features of Access 2000. more...
ECDL ICDL 4 Module 5 Database - Getting Started with Access 2003 To outline the concepts and processes for creating and navigating an Access 2003 database. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain more...
Oracle 8i PL/SQL - Database Objects and Security This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL. more...
Oracle 8i DBA - Understanding Storage Allocation ...database objects. It discusses tables clusters and index-organized tables. This course explains the different types of tables supported by Oracle 8i the structure of a row the different data types supported by Oracle 8i and the guidelines to create a table. Further the course covers how to create the cluster the cluster index and the tables in the cluster. The course also covers how to create more...
Oracle9i SQL: DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. more...
MS Office 2000: Access for Professionals II This course teaches the student how create queries, forms and reports. The student will also look at integrating data with other applications and exporting database objects to the Web. more...
Oracle SQL: DML and DDL 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. more...
Oracle9i SQL: DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create update and delete the database objects. The participants also learn to add rows update and delete existing rows from a table. more...
Oracle Designer First Class: Design and Generation This is the second course in a two-part series based on the ILT course Oracle Designer: First Class. The course takes students along a streamlined path through the Oracle Designer development environment. Transforming the analysis model into design level definitions refining the data and application designs and generating database objects and simple WebServer applications are covered. This course more...
Oracle SQL Specifics: Creating and Managing Database Objects This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes more...
Visual Basic 6: Database Connectivity This course is the second course of the three courses in the VB Databases curriculum. The title of this course is VB 6.0 Database Connectivity. This course teaches students to evaluate and use several connectivity options, such as DAO, RDO, and ADO to connect to a database through a VB application. more...
SQL Basic Skills This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements. more...
Oracle SQL PL SQL Using Procedure Builder Curriculum ...ming 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 of four Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle more...
Oracle9i SQL DML and DDL ... The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables. Learn To: o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Identify the DMLmore...
IBM DB2 Universal Database V6 1 App Devel Curriculum ...v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and more...
IBM DB2 Universal Database V6 1 App Devel Curriculum ...v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and more...
IBM DB2 Universal Database V6 1 Admin Curriculum ...v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn 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 Universalmore...
IBM DB2 Universal Database V6 1 Admin Curriculum ...v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn 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 Universalmore...
Oracle Designer 6i First Class Design Generation ...refining the data and application designs, and generating database objects and simple WebServer applications. This course is part of an Oracle integrated curriculum and forms the core course to all the Oracle Designer courses. Learn To: o Identify how to transform the analysis model into design definitions. o Identify how to refine, generate and build the database design. o Identify how more...
Access 2000 Proficient User ... a hyperlink to a file by using the Datasheet view. Copy database objects to Excel by using the drag and drop method. Export a database object to a Web page. Back up a database by using the Backup utility. Restore a database from a backup copy by using the Backup utility. Compact an open database. Unit 3: Access 2000 Forms Duration: 2 Hour(s) Create a form by using the Formmore...
Access 2000 Fundamentals ...dentify the object views available in Access 2000. Print database objects. Create a new database in Access 2000. Access help on a specified subject by using the office Assistant. Unit 2: Access 2000 Tables Duration: 2 - 3 Hour(s) Create a table by using the Table Wizard. Create a table by using the Design view. Create a table by entering data directly in the Data sheet view. more...
Oracle Database 10g SQL Fundamentals I Part 2 ...ing transactions in SQL.
Identify guidelines for naming database objects.
Identify the syntax for creating a table.
Identify the syntax for defining constraints.
Identify the syntax for altering and dropping a table.
Identify features of views.
Identify syntax for performing various tasks for managing views.
Identify the syntax for creating a sequence.
Identify the syntax for more...
SQL and PL SQL DML and DDL ... 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: more...
Access XP Fundamentals ...Open a database by using Microsoft Access. Match database objects with their features. Identify the functions of each database object view. Create a blank database. Identify the options available when creating a database by using a database template. Get help by using the Office Assistant. Identify features of the Help Window. Unit 2: more...
MS Office 2003 Introduction to Office 2003 This course will give new Office users a quick jump-start on the major applications in the suite. It will include a broad overview of the components of Office 2003, followed by a quick introduction to Word, Excel, Access, and PowerPoint. Learn To To match Office core applications with their functions. To identify common interface features more...
Advanced PL/SQL Programming ...s course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL. After completing this course, the student will be able to:
Create PL/SQL packages
Manage PL/SQL packages
Identify various Oracle server-supplied packages
Use stored functions in PL/SQL packages more...
Managing Oracle8 Objects ...d to acquaint users with the concepts of managing various database objects, such as datafiles, tables, indexes, clusters, views, sequences, synonyms and schema objects. After completing this course, the user will be able to:
Monitor multiple databases
Manage rollback segments
Manage and alter tablespaces
Manage datafiles
Alter datafile availability
Manage and alter tables
Describe and more...
Oracle8 Backup and Recovery - II Oracle8 Backup and Recovery - II WBT is the second course of the two courses in the Oracle8 Backup and Recovery curriculum. The Oracle8 Backup and Recovery curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-015. This course is designed to acquaint users with the concepts of backup and recovery operations of an Oracle database. It cites, in detail, more...