Online Creating Queries How Queries eLearning

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators  more...

Exchanging Data with Excel 2007 In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage  more...

Webmaster Essentials WebMaster is a title given to an individual responsible for maintaining a web site and responding to queries about it. In this course, the student will learn how to create a web site. The student will choose communications connections and server platforms for the web site development. The student will then use HTML and CGI to develop simple and complex web sites. This course is designed for  more...

Using Advanced Data Management Techniques The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files,  more...

MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries.  more...

Online Access 2000 MOS Series This series is designed to help users prepare for Microsoft Access 2000 MOS certification. It shows how to create, plan, and modify databases and tables in Access 2000. It also covers sorting and filtering, creating queries, forms and reports, and advanced tasks such as saving Access objects as Web pages, importing data, and adding hyperlinks.  more...

Online Access 2002 Series This series shows how to create, plan, and modify databases and database objects in Access 2002. Courses cover the following topics: understanding relational databases, creating and planning databases, selecting and printing database objects, creating tables, entering records, modifying tables and field properties, using advanced sorts, finding records, applying and removing filters, establishing  more...