This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Learn To:
Declaring PL/SQL Variables
Working with Composite Data Types
Creating the Executable Section
Using Explicit Cursors
Writing Control Structures
Including Exception Handling

Please Login or Register (Quick) to see the download links.

In this course, students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail.

Students learn about manipulating large data sets and storing and retrieving dates according to different time zones. They are also taught the concepts of controlling access and privileges for schema objects.

Learn to:
Control privileges at the object and system level
Use grouping operations to create reports
Manage Schema Objects
Search data using Advanced Sub-queries, and retrieve hierarchical data
Manipulate data in the Oracle database by using sub-queries
Use Regular Expression support

Please Login or Register (Quick) to see the download links.

D17108GC21

This course offers students an introduction to Oracle Database 10g Database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
This course also introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Demonstrations and hands-on practices reinforce the fundamental concepts.

Learn To:
Use SQL Statements to retrieve data from tables and employ SQL functions to generate and retrieve customized data
Declare PL/SQL Variables and Work with Composite data types
Run data manipulation statements (DML) to update data in the Oracle Database 10g
Write Control Structures and work with Explicit Cursors
Create and Manage Tables
Handle Exceptions

Please Login or Register (Quick) to see the download links.

Microsoft’s IIS 7 is a radical departure from previous versions of IIS, and it promises administrators a new level of control over their Web servers, with its modular design and a flexible, extensible architecture that creates new opportunities for customization. This book guides you beyond the networking technology and concepts you already know and teaches you the crucial new features of IIS 7 that will help you succeed with this dramatically different Web server.

From navigating the new interface to adjusting settings entirely in XML to configuring IIS 7 for maximum security, this book covers the techniques, tricks, and basic instruction you need to take full advantage of IIS 7. Special sidebars provide information that can help developers coordinate efforts with administrators right from the start of projects to get the best outcomes.

Please Login or Register (Quick) to see the download links.

PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. This book is perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books. With concepts explained in plain English, the new edition starts with the basics of the PHP language, and explains how to work with MySQL, the popular open source database. You then learn how to put the two together to generate dynamic content.

Please Login or Register (Quick) to see the download links.

This book teaches Business Analysts to model business processes in JBoss jBPM and generate workflow application code from their models without Java coding expertise. It is a full toolkit for anyone wanting to implement Business Process Management correctly, covering tasks common to all BPM implementations, although it is focused on popular, free, open-source jBPM, with its flexible, scalable process engine, pluggable modular architecture, and easy programming model (jPDL) blending the best of Java and declarative techniques. The practical approach with step-by-step instructions uses a realistic case study to explore and explain BPM, model creation, and implementation. It covers: efficient, standards-friendly mapping of business processes; using the jBPM toolset to work with business process maps, analyze process execution data, and for ongoing process improvement; setting up business rules: task assignments, escalation points; process variables; automating activities and decisions.

Please Login or Register (Quick) to see the download links.