Online Sql Developer eLearning

Oracle Database 11g Getting Started with SQL and PL SQL New Features Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Querying XML Data With XPath and XQuery Querying XML Data With XPath and XQuery The XML Path Language, XPath, is designed to allow the developer to select specific parts of an XML document. XPath is also used extensively with the XML query language, or XQuery. This course will cover how to use these languages to both navigate and query XML data. Specific topics covered include XPath basics, XPath functions, as well XQuery built-in  more...

Creating Implementing Programming Objects in SQL Server 2008 Creating & Implementing Programming Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  more...

Oracle Form Builder Forms Fundamentals Course Overview This course is the first in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features, components, and capabilities of Developer/2000. In addition, this course will help participants learn how to run, create, and customize a form module. L earn To: Identify the key features,  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  more...

Oracle Form Builder Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help 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  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 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 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 Form Builder Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.  more...

Oracle Report Builder Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...

Oracle Report Builder Enhancing Reports Course Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  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 R6 Forms Fundamentals Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  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 Form Builder R6 Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this 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  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 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 Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...

Oracle Reports R6 Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  more...

Oracle Reports R6 Enhance Reports Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  more...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

SQL and PL SQL Data Retrieval Techniques Course Overview This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries.  more...

SQL and PL SQL DML and DDL Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  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  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...

Office XP - Planning Collaborative Solutions Curriculum The Microsoft Office XP - Planning Collaborative Solutions Curriculum presents the learner with a comprehensive introduction to SharePoint Team Services and the principal technologies within Office XP that facilitate sharing of line-of-business data. The curriculum begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user  more...

Office XP Collaborative Solutions Part 2 This is the second course in a two-part series that provides the learner with an introduction to Knowledge Management, and how SharePoint Portal Server facilitates this. Topics include, portal server's difference from team services, principal areas of data sharing within SharePoint Portal Server, data access and search mechanisms. Digital dashboards are covered in considerable detail of setup,  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  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...

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

CIW Database Specialist Part 3 Database Interaction JDBC This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins,  more...

CIW Database Specialist Part 4 Advanced JDBC This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and  more...

Oracle Database 10g PL SQL Fundamentals Part 2 ...ation Developers, Database Designers, System Analysts, PL/SQL Developer, Technical Consultant, Forms Developer, and Portal Developer. Deployment: Self-Study Language Options: US English Total Learning Time: 8 hours Objectives: Unit 1: PL/SQL Blocks Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named blocks  more...