Online Sql You eLearning - Training Resources

Java 2 -- Advanced Enterprise Java This course contains 3 units: Java Database Connectivity (JDBC), Java Native Interface, and The Debugger. Each unit covers detail the elements of Java necessary to implement these features and functions as you program in the Advanced Enterprise Java language. The first unit explains the concept of Java Database Connectivity (JDBC). It covers the features and functions of JDBC and the differences  more...

SQL Server 2000 Complete Course This course is a complete set of SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000. This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases,  more...

Database Design Concepts During this course you will learn the basic concepts of database design, the SQL language and how to design and implement a simple relational database. The course is suitable for all kinds of audiences, as it starts with the very basic concepts of database design and presents the subject in an easy manner. Coursework focuses on the real-life implementation of database solutions and on practical  more...

Database Management This course features coverage of the important aspects of the relational PC-based database model including coverage of SQL. A highly useful methodology for designing databases is presented and illustrated through a variety of examples. This course is designed for anyone interested in gaining familiarity with database management. Someone taking this course should have some experience using a  more...

Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you  more...

Oracle Database 11g Change Management Overview and SQL Plan Management outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...

Oracle Database 11g Partitioning and Storage-Related Enhancements identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  more...

Oracle9i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle Database 10g Administration Workshop II Part 3 This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of Flashback  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle Form Builder Handling Multiple Object Relationships Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items. L  more...

Oracle Workflow 11i10 Business Event System Subscriptions This course covers business events, event subscriptions, and event activities. It specifies the features and options to define and maintain business events, event subscriptions, and event activities. It also covers several standard activities that help manage the contents of event messages. Learn To: Identify features of business events. Identify options that enable you to define and  more...

Oracle Workflow 11i10 Interacting with Processes Notifications Oracle users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers. Learn To: Identify options for testing a workflow process. Identify options for administering workflow processes by using the Administrator Monitor. Identify options for administering workflow processes by using the  more...

Oracle Workflow 11i10 Configuring Oracle Workflow Components This course covers the mandatory and optional tasks that are performed to set up Oracle Workflow. It also covers features of service components and specific service components including agent listeners and notification mailers. Finally, it covers queue propagation and agent activity details. Learn To: Identify the mandatory steps for setting up Oracle Workflow. Identify options that  more...

Oracle Workflow 11i10 Managing Customizing Workflow Processes This course covers features, types, and attributes of PL/SQL documents. It also covers how to include PL/SQL documents in messages. Further, it covers forced synchronous processes, selector/callback functions, standard API used to define selector/callback functions, and the code to define a selector/callback function. It also covers master/detail coordination activities. In addition, it covers how  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 Course Overview This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models;  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 Course Overview This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions. L earn To: Identify features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets,  more...

Oracle Workflow 11i10 Communications Function Activities This course covers the fundamentals of Oracle Workflow processes. This course covers function activities, activity details, activity attributes, and standard assign activity. You'll learn about Oracle Workflow directory service, local directory service tables, and loading roles in a workflow process definition. The course also covers systems, agents, and external system registration. Finally, it  more...

Oracle Database Administration Workshop I Part 2 Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed  more...

Introduction to Data Warehousing Course Overview This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse. L earn To: Identify the basic  more...

Oracle SQL Specifics Creating and Managing Database Objects Course Overview 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  more...

Oracle SQL Tuning Diagnostics and Tuning Schema Course Overview This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 2 The course deals with fundamentals Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify, and automate business processes. Learn To: Identify features of item type attributes. Define attributes for Oracle Workflow. Identify guidelines for defining lookups. Identify features of Workflow testing.  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 3 The course deals with fundamentals Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 3, you will learn about Activities, Events, and Workflow APIs. Learn To: Identify the steps to define a function activity. Identify tasks to be performed to define activity  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 1 The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. Learn To: Identify features of Workflow-driven business processes. Identify features of business processes integration using Oracle Workflow. Match Oracle Workflow database  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 4 The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 4, you will learn about workflow configuration, Workflow Manager, and utilities. Learn To: Identify necessary setup steps for Oracle Workflow. Identify issues involved  more...

Oracle Database 10g New Features for Administrators Part 4 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash recovery  more...

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...

MS Project Server 2003 Introduction Part 1 This course is the first part of a two-part series. This course will focus on introduction to Project Server 2003. It will also explain the software components of Project Server 2003, its architecture, and the configuration planning process. Learn To: Identify features of Microsoft Office Project Server 2003. Match the software components of Microsoft Office Project Server 2003 with  more...

MS Project Server 2003 Introduction Part 2 This course introduces you to the capabilities of Microsoft Office Project Server 2003. It includes how to plan, install, and configure the platform, as well as plan for client access across the organization. Learn To: Configure SQL Server authentication for Microsoft Office Project Server 2003. Identify features of SQL Server 2000 Analysis Services. Sequence the steps to manually  more...

Oracle Database 10g PL SQL Fundamentals Part 2 This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn To: Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named blocks  more...

Oracle Database 10g PL SQL Fundamentals Part 3 In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements with  more...