Online Sql Code 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 2005 Error Handling Techniques recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005  more...

Database Testing and Code Management recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005  more...

Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...

Oracle Database 11g PL SQL Variables Attributes and Executable Statements To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming 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  more...

IBM DB2 Universal Database V6 1--App Development Course Overview This course will provide application developers with the specific skills and knowledge needed to be successful in an IBM DB2 Universal Database (UDB) V6.1 application development environment for UNIX, Windows or OS/2 platforms. This course will teach students about SQL application development, application development objects, embedded SQL programming, and dynamic SQL programming.  more...

IBM DB2 Universal Database V6 1--App Development Course Overview This course will provide application developers with the specific skills and knowledge needed to be successful in an IBM DB2 Universal Database (UDB) V6.1 application development environment for UNIX, Windows or OS/2 platforms. This course will teach students about SQL application development, application development objects, embedded SQL programming, and dynamic SQL programming.  more...

Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum The Complete Oracle Internet App. Dev. Track for Forms Developer R6/6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer:  more...

Oracle PL SQL Database Programming Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...

Oracle PL SQL Procedures Functions Packages 61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create  more...

Oracle Form Builder R6 Including Reusable Oracle Components ... Identify the order of preference for the location of PL/SQL code. Identify the Oracle8 Server features supported by client side PL/SQL8. Complete the code to dynamically perform database operations by using FORMS_DDL. Identify the errors that are caused by the failure of implicit DML statements. Complete the code for the ON-ERROR trigger to display error information caused by an implicit  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...

Oracle Form Builder R6 Project Builder and Menu Modules Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:  more...

Oracle Form Builder R6 Writing and Debugging Code ... course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the communication formats used by Form Builder. Write the code to handle errors, suppress system messages, create alerts and control  more...

Oracle Form Builder R6 Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...

Oracle Report Builder Controlling Reports Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...

Oracle Form Builder Including Reusable Oracle Components ... Identify the order of preference for the location of PL/SQL code. Identify the features of error messages caused by failed Form Builder calls to the Oracle Server. Match the predefined error messages with the DML declarative constraint violations that generate them. Complete the code for the ON-ERROR trigger to display error information caused by an implicit call to the Oracle Server.  more...

Oracle Form Builder Handling Multiple Object Relationships ...nctions of key triggers in a form module. Type in the PL/SQL code to associate a built-in with the DO_KEY built-in. Match the mouse system variables with their functions. Specify the mouse movement trigger for a specific function. Create a mouse button action trigger for a specified task by using PL/SQL Editor. Identify the guidelines to follow while implementing the drag-and-drop  more...

Oracle Form Builder Managing Module Types Course Overview This course is the fourth in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will introduce participants to Project Builder and teach them how to create and manage a menu module. In addition, users will learn how to customize and implement menu security. L earn To: Identify the benefits and terminology of Project  more...

Oracle Cert App Developer Track for Developer 2000 R2 Curriculum NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses:  more...

Oracle Form Builder Writing and Debugging Code ...participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify the descriptions of the communication formats used by Form Builder. Write codes to detect errors, suppress system messages, create alerts, and control  more...

Oracle Form Builder Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and non-input  more...

Oracle Workflow 11i10 Workflow APIs Procedures Error Handling This course covers Workflow Engine, background engines, PL/SQL procedures, workflow process APIs, Business Event System APIs, and error handling. It also covers abstract data types used by the Business Event System, event data generate functions, queue handlers, and subscription rule functions, and the error-handling features of workflow processes. Learn To: Identify features of the  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...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft  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...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...

Visual InterDev 6 0 Accessing Remote Data C ourse Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of  more...

Visual InterDev 6 0 Accessing Remote Data Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote  more...

Visual InterDev 6 0 Active Server Pages and Data Access C ourse Overview This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script;  more...

Oracle Database 10g SQL Fundamentals I Part 2 In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify the  more...

Oracle Database Administration Workshop I Part 2 ... at length. Attention has been paid to DML and also to PL/SQL code, which is Oracle's proprietary fourth generation programming language that enables Oracle applications to interact over different operating systems and hardware platforms. Learn To: Identify features of database user accounts and profiles in Oracle Database 10g. Identify options you can configure when creating a  more...

Oracle SQL and SQL Plus SQL Plus and Reporting Course Overview This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ... for the reuse of parsed code. Identify the factors in SQL code design that affect response time. Identify the methods to improve network performance. Identify the differences in optimization approaches. Influence the cost-based optimization to improve performance. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, and  more...

SQL and PL SQL PL SQL Basics ..., and WHILE LOOP looping constructs to control flow in PL/SQL code. Declare and reference PL/SQL records and PL/SQL tables Identify the types and features of LOB datatypes. Understand cursors, how to operate explicit cursors, work with explicit cursor attributes Use the advanced functionality of explicit cursors. Understand the basic concepts of exceptions, trap predefined,  more...

Oracle Database 10g New Features for Administrators Part 3 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 Resource Manager, job Scheduler, tablespace monitoring, shrinking segments, and partitioning enhancements. Learn To: Identify features of Resource Manager in Oracle Database 10g. Identify  more...

Commerce Server 2000 Design Impl Part 3 Pipelines This is the third course in a five part series that focuses on pipelines and their use in running ad campaigns. It covers how to define and run a pipeline in Microsoft Commerce Server 2000, and how to create custom components - Scriptor and Compiled - that can be added to a pipeline. The course also covers the code used to implement campaigns built and designed by Commerce Server 2000. Learn To:  more...

Enterprise Connectivity with J2EE V1 4 JAXP and JDBC This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity. Learn To: Match terms used in XML with their descriptions. Identify features of Simple API for XML (SAX) parsing. Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed. Match features of JDBC with the application development  more...

Enterprise Connectivity with J2EE V1 4 JAXP and JDBC This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity. Learn To: Match terms used in XML with their descriptions. Identify features of Simple API for XML (SAX) parsing. Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed. Match features of JDBC with the application development  more...

CIW Dynamic Server Pages Part 1 Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and  more...

CIW Dynamic Server Pages Part 3 Course Overview This is the final course in a three part series that students will learn about ActiveX Data Objects, error handling and dubugging ASP applications, project management in application development, and data integrity and security issues. Learn To • Identify the situations in which ADO would be used. • Identify ASP application development, error handling, and  more...

Microsoft NET Tech Overview Part 1 NET Platform Framework This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such  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 .... Sequence the steps to enable native compilation of PL/SQL code. 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 Time: 8 hours Objectives: Unit 1: Dynamic SQL Statements Match the  more...