"SkillBuilders Advanced Tutorials"

Java

JSP Programming and Deployment

JavaBeans and JSP

What is a JavaBean and how are they implemented in JSP and servlets

Intro to Custom Tags

A brief introductio to Custom Tags.

Custom Tag Basics

A discussion of the API, Tag Libraries, Tag Handlers and installing the Tag Library.

Custom Tag Advanced Features

Working with Tags with Attributes, getting Page Information and Handling Exceptions

Custom Tag: Tag Bodies

Working with Tag Bodies: Including, Repeating, Manipulating and accessing the parent.

Fundamentals of EJB

Deploying Entity Beans

How to deploy an Entity Bean. The importance of ejb-jar.xml.

The Bean Class Revisited

Life cyscle methods, bean context and handling EJB references

Using Exceptions in EJB

Overview of exceptions in EJB. A discussion of appliaction and system exceptions.

Transactions in EJB

Introduction to transactions in EJB. Container managed vs. Bean managed transactions.

Bean Managed Persistance

A thorough discussion of container managed vs. bean managed persistance.

Other EJB Issues

Such as Getting the Environment, using threads and design issues . . .

Introduction to Java

Applet Basics

How to implement a java applet

Component Basics

What are components and how are hey used in java GUI applications?

Colors, Fonts & Borders

The use of colors, fonts and border attributes to improve the visual display

Event Handling

How does java handle events?

Collections

A discussion of how objects can be organized and manipulated as collections

Inner Classes

How classes can be nested in a java program.

Handling Exceptions

Coding programs that trap problems and isolate the user from exceptions

Java and MultiThreading

A discussion of multiThreading concepts and techniques

Containers

How containers are used in GUI java applications

Layout Managers

Simplify your design process with a Layout Manager

GUI application Development

A discussion of Stand alone containers, WIndow events and menus

Where to Go with Java

What's next in your java learning path? A introduction to some more advanced concepts

Java Servlets Programming and Deployment

Configuring Web Apps

How to configure the web application: context and servlet parameters, servlet aliases

Talking to Clients

A discussion of hhtp clients, session management and cookies.

Other Servlet Issues

This lesson describes mulit-threading, logging and handling errors

Application Life Cycle

The application life cycle Event Listeners

Servlet Filters

What are filters? How and where should we use them?

Oracle10g

SQL, PL/SQL, 9i and 10g New Features

Oracle10g PL/SQL Enhancements

This is a succinct summary of the enhancements that Oracle10g brings to PL/SQL. Note that this is excerpted from our Oracle10g New Features by Example book.

Oracle9i Functions

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Oracle9i Advanced Data Access

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Oracle9i Grouping Data

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Oracle9i DML and Transaction Control

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

SQL*Plus Reporting

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Oracle9i Tables and Constraints

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Views & Synonyms

This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.

Oracle10g Flashback Enhancements

This lesson, intended for Oracle DBA's, is an excerpt from our Oracle10g New Features Overview by Example book. It will help you prepare for Oracle Certification exam 1Z0-040.

Oracle10g: Intro to DataGuard

This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle10g Dataguard

Oracle9i Performance and Tuning Enhancements

This lesson, intended for Oracle DBA's and Oracle Developers, is an excerpt from our Oracle9i Differences for DBAs book.

Oracle 10g RMAN Enhancements

This lesson, intended for Oracle DBA's, is an excerpt from our Oracle10g New Features Overview by Example book. It will help you prepare for Oracle Certification exam 1Z0-040.

Introduction to Oracle Recovery Manager (RMAN)

This lesson, intended for Oracle DBA's, is an excerpt from our Backup & Recovery with RMAN book.

Using Server Parameter Files (SPFILE) with an Oracle Database

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle9i Differences for DBAs book.

Oracle9i SGA Management

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle9i Differences for DBAs book. This tutorial covers SGA-related parameters such as DB_CACHE_SIZE and SGA_MAX_SIZE, multiple database block size support (subcaches), how to dynamically change shared memory allocations (including examples of v$sga_dynamic_components) and the cache advisories.

XML

XML Overview

Standard Schemas

A survey of industry schemas including finXML.

XML in Action

A discussion ovendor support, XML related products and some case studies.

Web Services

How does Web Services fit in this picture?

XML and Java

A discussion about using XML in java applications.

XML and Databases

This lesson discusses what databases are XML friendly.

XML and IT

A discussion of where XML should be used in your IT environment and how to's to make your task simpler.

Oracle9i

Oracle Database Administration

Lesson 13. Managing Oracle Tables

This lesson begins with a brief overview of the eight different types of tables that the Oracle Database provides. The remainder of the lesson will concentrate on the most common type of table – heap tables. Not only will you learn how to create heap tables, you will also learn the practical management skills you will need for day to day table management tasks such as managing concurrency with INITRANS and MAXTRANS, moving tables, using DBMS_STATS to collect statistics for the cost based optimizer, increasing performance by turning off redo logging, compressing tables and simple techniques for measuring DML performance.

Lesson 14. Oracle B-Tree Indexes

This lesson covers Oracle B-tree indexes. We will learn what they are, what makes them work (organization) and many other things that will let you put them to good use, including turning off redo logging when creating indexes to increase performance, collecting statistics with DBMS_STATS, making intelligent decisions on what columns should be indexed, when and how to create multi-column (composite) indexes, using index compression and when and where to create indexes.

Lesson 15. Oracle Table Constraints

This lesson will teach you about Oracle table constraints. After you learn what they are, we will discuss what I hope are the most common techniques and issues related to constraints, including creating contraints, violating constraints, using the NOVALIDATE option to add a constraint without validating existing data, disabling constraints and dropping and renaming constraints. As always, you will also learn about the Oracle data dictionary views related to this topic.

Lesson 16. Managing Undo

Using Automatic Undo Mangement (AUM) to manage undo in the Oracle database.

Lesson 17. Managing Redo Logs

Effective management of Oracle Redo Logs

Lesson 18. Managing Control Files

How to protect, add, backup and recreate Oracle Control files

Lesson 19. Introduction to RMAN

An introduction to Oracle RMAN. You will learn what it is and how to make use of basic, critical backup and recovery techniques.

Lesson 20. Logical Backups - Import and Export

A lesson describing using the import and export utilities to perform logical backups of the Oracle database.

Lesson 21. Loading with SQL*Loader

Loading data with the Oracle SQL*Loader utility.

Lesson 22. Introduction to Oracle Networking

A practical introduction to get you started with Oracle Net.

Lesson 23. Creating a new Database

A discussion on using the Database Configuration Assistant to create a new database.

Appendix A. User Managed Backup & Recovery

An overview discussing database failure scenarios; strategies; archiving; hot and cold user-managed backups; complete user-managed recovery and point-in-time recovery.

Appendix B.Implementing Partitioning

A brief discussion of Oracle partitioning

Appendix C. Other Table Types

A description of other Oracle table types including: IOTs; temp tables; Indexed Clustered; Hash Clustered; Nested and Object tables.

Appendix D. Fine Grained Auditing

An introduction to Fine Grained Auditing in the Oracle Database.

Oracle SQL Tuning for Developers and DBAs

Lesson 7 Access Paths

This guide to many of the techniques Oracle uses to retrieve data.

Lesson 8 CBO Transformations

This lesson provides an introduction to some of the techiques CBO will use to transform a query, including bitmap conversions, OR to UNION and view merging.

Lesson 9 SQL Coding Tips

This lesson provides suggestions, ideas and tips for improving the performance of SQL statements.

Lesson 10 Join Methods

This provides a practical introduction to the join methods available to the Oracle9i cost-based optimizer.

Lesson 11 Bind Variables

This lesson is a discussion emphasizing the importance of bind variables and "shared pool reuse".

Lesson 12 Table Types

This provides an introduction to the affect that the Oracle table types (and related options) have on SQL performance.

Lesson 13 More B-Tree Indexes

A further study of B-Tree Indexes

Lesson 14 Other Indexes

This lesson provides an introduction to bitmap, bitmap join and function-based indexes in Oracle9i.

Appendix A Hints

A partial list of optimizer hints

Appendix B Oracle10g Tuning Features

An excerpt from SkillBuilders' Oracle10g New Features By Example book.

Appendix C Concurreny Control

A discussion of Concurrency control concepts, row lock architecture, locking rules, types of locks and application locking issues.

Web Services

Web Services Overview

Security: An introduction to XML Digital Signature, Encryption and More

This lesson provides a look at Security issues and technologies in Web Services.

Web Services in the Industry: Companies, Products, and More

A sampling of who is using Web Services and what they are doing with this technology.