Database Courses

Access 2003 - Level 1

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.
 

Access 2003 - Level 2

Microsoft® Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel.
 

Access 2003 - Level 3

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.
 

Access 2007 - Level 1

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access 2007 relational database application.
 

Access 2007 - Level 2

You have the basic skills needed to work with Microsoft® Office Access™ 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
 

Access 2007 - Level 3

Your training in and use of Microsoft® Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
 

Access 2007 - New Features

You have worked with Microsoft® Office Access™ 2003 (or earlier), and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course, you will be introduced to the new features available in Microsoft® Office Access 2007.
 

Microsoft SQL Server 2005 - Maintaining a Microsoft SQL Server 2005 Database (Microsoft Course 2780B)

The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes learning how to establish monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.
 

Relational Database Design - A Practical Approach

Students will learn the general principles involved in designing a database that complies with the relational database model.
 

SQL - Advanced Querying (Second Edition)

In the course SQL: Fundamentals of Querying (Second Edition), you examined the fundamentals of SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables. In this course, SQL: Advanced Querying (Second Edition), you will create advanced SQL queries, and manipulate and index tables.
 

SQL Server 2000 - Database Design

This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
 

SQL Server 2000 - Querying with Transact-SQL

This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.