Online Creating Databases To eLearning

ASP NET Using Visual Basic This five-day course provides a comprehensive and practical hands-on introduction to developing Web applications using ASP.NET 2.0 and Visual Basic. It also introduces Web services. ASP.NET is introduced as a new Web programming platform that overcomes a number of limitations of ASP. Its architecture is outlined, including the role of compilation, the Page class and code-behind. Web Forms are  more...

ASP NET Using C This five-day course provides a comprehensive and practical hands-on introduction to developing Web applications using ASP.NET 2.0 and C#. It also introduces Web services. ASP.NET is introduced as a new Web programming platform that overcomes a number of limitations of ASP. Its architecture is outlined, including the role of compilation, the Page class and code-behind. Web Forms are introduced,  more...

Relational Database Concepts Structured Query Language This course introduces the Structured Query Language (SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL). This course is designed to help individuals who want to  more...

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

Managing Data using Works 6 0 The Managing Data using Works 6.0 course is the first course in the Works Suite 2002 curriculum. This course acquaints the users with the applications of the Works Suite and the different components of the Works application. It teaches the users to use the Task Launcher to start various tasks in Works and complete them using different wizards and templates. Additionally, it explains the different  more...

Microsoft Works Suite 2004 - Creating Databases This course helps the learner create databases by covering Works Database essentials, working with data, and performing common tasks. It also covers database fundamentals such as database interface and database views. The course includes related topics such as manipulating data, performing common tasks, and working with forms and reports. A home computer user with basic to intermediate skills who  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...

Database Administration in Access 2003 To implement methods of securing, sharing, replicating, and optimizing the performance of Access 2003 databases Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003  more...

Lotus Notes R5 for End-Users Advanced The purpose of this course is to provide tools to help the student learn how to use advanced features of Lotus Notes Version 5.0. Notes is a very powerful collaborative software. This course will take the student to the next level of complexity with Notes. The course will step the student through the advanced functions in Mail, Calendars, searching, building and customizing databases and creating  more...

Microsoft SQL Server 7.0: System Administration - Part 2 This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

JDBC Application Development Part 2: Creating Database Programs This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases.  more...

JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.  more...

Java Servlets Part 3: Databases, Chaining, Security, Applets and Beans This final course in the series teaches about servlet security and how to use servlets with other Java APIs. It covers creating databases using JDBC and servlets, creating content using servlet chaining, security issues with servlets, applet-servlet communication, and using and creating servlet beans.  more...

Actuate Developer Workbench Fundamentals Actuate Developer Workbench Fundamentals WBT is meant for users who want to create reports based on data contained in databases. The course describes the features of Actuate Developer Workbench, and familiarizes users with creating simple and complex reports. Users who want to create simple and complex reports using Actuate Developer Workbench.  more...

Microsoft Works 2003 - Creating Databases The Works 2003: Creating Databases course explores the database interface, and the student then learns about entering data, and database tables, and forms.  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...

Lotus Notes 6 - Moving to IBM Lotus Notes 6 The first course introduces the Lotus Notes 6 environment and capabilities and the basics of Notes navigation using bookmarks and other navigation tools. The learner is given instruction in the establishment of their mail environment including such procedures as setting up a filing system for incoming messages customizing outgoing messages and managing the Address book. They are also given  more...

IBM DB2 UDB Essentials Part 4 - Advanced SQL This course teaches the learner how to make use of advanced SQL techniques to access DB2 databases in different environments. Indepth coverage is given to creating SQL objects Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/390 VM/VSE AS/400 UNIX  more...

SQL Server 7.0 Management Part I This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the  more...

MS SQL Server 2000: Database Administration Part 2: Managing Databases This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects.  more...

Microsoft Access 2002 Fundamentals This course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables.  more...

Oracle9i Database Administration: Create a Database The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain  more...

Lotus Notes 4.6 Mail This course is designed to provide students with the skills and knowledge of Lotus Notes and discusses the relationship between database, documents, forms and views.  more...

Microsoft Access 2002 Fundamentals This course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases and establishing relationships between tables.  more...

Oracle8i Database Administration: Create a Database This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. 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.  more...

Oracle8 Database Administration - Create Database 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.  more...

IBM DB2 Universal Database V6.1 Fundamentals This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX Windows or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1 creating and accessing database objects basic Structured Query Language (SQL) and managing  more...

Database Technologies Part 2: Introduction to SQL The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a  more...

Excel 2003 This series is designed for beginning and intermediate Excel users. This series teaches learners about creating and editing spreadsheets, what's new in the 2003 version, the Excel interface, navigating, editing, and working with text, values, and formulas, printing, formatting, creating charts and databases, and using images and hypertext in a spreadsheet.  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...