Online Database Objects eLearning

Access 2002 Basic ...2002: Basic Microsoft 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  more...

Creating and Implementing Database Objects in SQL Server 2005 Creating and Implementing Database Objects in SQL Server 2005 Microsoft To create and implement key database objects in SQL Server 2005  more...

Database Objects in Oracle Database 10g Database Objects in Oracle Database 10g Oracle To demonstrate how to create database views, sequences, indexes, and synonyms  more...

Managing Database Objects in Oracle Database 10g Managing Database Objects in Oracle Database 10g Oracle To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g  more...

Oracle Database 11g Getting Started with SQL and PL SQL New Features Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Access XP Proficient Expert ...ase? - What Is Access XP? - Access XP Capabilities - Database Objects Planning Basics - Planning Basics Define Tables - What Is A Table? - Defining Tables Define Fields - What Is A Field? - Defining Fields - Identify Primary Keys Define Relationships - What Is A Relationship? - One-To-Many Relationships - Many-To-Many Relationships - One-To-One Relationships Review  more...

Designing Database Objects Designing Database Objects Microsoft recognize how to design database objects according to your requirements  more...

Designing the Physical Database for SQL Server 2005 Designing the Physical Database for SQL Server 2005 Microsoft To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures  more...

Access 2003 Programmability Access 2003 Programmability Microsoft To use macros and Visual Basic for Applications to add interactivity to database objects  more...

Creating Implementing Database Objects in SQL Server 2008 ...Database Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 database to meet business requirements, administrators and developers must fully understand how  more...

Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes ... into SQL Server and offers cmdlets to perform actions on database objects using methods within SQL Server Management Object (SMO) models, and to run scripts to perform tasks within SQL Server. Developers can also use Database Mail to send messages to mail accounts within a profile. This course demonstrates how to implement Server Broker, change tracking, full-text search, and Database Mail. It  more...

Access 2000 Expert ...standing 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 skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in  more...

Access 2000 Level 2 ...standing 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. This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will  more...

Access 2000 Level 3 ...standing 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. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students  more...

Access 2000 MOUS ...standing of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This comprehensive course teaches students both the basic and the more advanced elements that compose an Access database. Students will learn how to create their own databases in Access and use the basic tools of the Access application:  more...

Access 2002 ...standing of how to effectively create and use the primary database objects in Access. The course also shows how to work with individual fields to ensure that overall database structure is consistent and correct. A variety of techniques will be taught in order to make data entry faster, easier, and less error-prone. As the course becomes more advanced, students will use Microsoft Access as a  more...

Access 2002 MOUS ...standing of how to effectively create and use the primary 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  more...

Microsoft Access 2002 Expert ...standing of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is  more...

Microsoft Access 2002 Level 2 ...standing 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. This intermediate course strives to broaden and develop the basic database design skills that students  more...

Microsoft Access 2002 Level 3 ...standing 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. 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  more...

Office 2000 Advanced ...standing of how to effectively create and use the primary database objects including tables, queries, forms, reports, and data access pages. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Mastery of Microsoft PowerPoint 2000 will empower an experienced user to apply advanced visual effects,  more...

Office 2000 Intermediate ... 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 working with HTML and hyperlinks, using the Query Wizard, and customizing reports. Students will also be introduced to advanced components of Microsoft PowerPoint 2000, such as using masters,  more...

Access 2007 Level 2 ...mplete 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 already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office  more...

Access 2000 User Series ...toReports & the Report Wizard 4.6 Page Setup 5.0 Printing Database Objects (5 Minutes) 5.1 Printing Table Datasheets 5.2 Printing Queries 5.3 Printing Forms 5.4 Printing Reports 6.0 Getting Help (8 Minutes) 6.1 The Office Assistant & Index Searching 6.2 Context-Sensitive Help & Printing Help Topics 7.0 Database Maintenance & Shortcuts (12 Minutes) 7.1 Backing Up and Restoring a Database 7.2  more...

Access 2000 Beginning ...toReports & the Report Wizard 4.6 Page Setup 5.0 Printing Database Objects (5 Minutes) 5.1 Printing Table Datasheets 5.2 Printing Queries 5.3 Printing Forms 5.4 Printing Reports 6.0 Getting Help (8 Minutes) 6.1 The Office Assistant & Index Searching 6.2 Context-Sensitive Help & Printing Help Topics 7.0 Database Maintenance & Shortcuts (12 Minutes) 7.1 Backing Up and Restoring a Database 7.2  more...

Accessing Data and Manipulating DB2 UDB Database Objects To access data and manipulate database objects  more...

Defining and Manipulating Data in Oracle9i To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...

Oracle Database 10g SQL Fundamentals I Part 2 ...ng 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  more...

Oracle Database Administration Workshop I Part 2 ...dentify features of schemas. Identify rules for naming database objects. Match data types in Oracle Database 10g with their features. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database. Deployment: Self-Study Language Options: US English Total Learning  more...

Oracle SQL Specifics Retrieving and Formatting Data ...dentify three Relational Model concepts. Match the five database objects to their definitions. Identify features of Oracle's object relational database management system (ORDBMS), Oracle8. Identify how Oracle8 extends the capabilities of the Oracle7 server. Identify characteristics of object systems. Identify tasks performed by the Oracle DBMS. Unit 2: The Oracle SELECT  more...

Oracle SQL Specifics Creating and Managing Database Objects ...To: Create and manage tables. Use the Oracle database objects: views, sequences, and indexes. Control transactions. Control DBA and user access. Use SQL*Plus commands. C ontent Emphasis Skills-Based A udience Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL and first course in  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ... available for the optimizer. Create the appropriate database objects before starting to tune SQL statements. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, and Designer/Developers. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Performance Duration: 2 - 3 Hour(s) Identify the  more...

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...

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 Form  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...

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...

IBM DB2 Universal Database V6 1--Fundamentals ...he basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic  more...

IBM DB2 Universal Database V6 1--Fundamentals ...he basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 ...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 Information Server (IIS).  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...

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 DML  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...

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...

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 Universal  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 Universal  more...

IBM DB2 Universal Database V6 1--Fundamentals ...he basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic  more...

IBM DB2 Universal Database V6 1--Fundamentals ...he basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  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 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...