Intelligentedu
Best New Free Computer IT Training Tutorial Resources


June 30, 2006

Mastering Ajax - 5 Part Tutorial from IBM

AJAX, shorthand for Asynchronous JavaScript and XML, is a Web development technique for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with the server behind the scenes, so that the entire web page does not have to be reloaded each time the user makes a change. This is meant to increase the web page's interactivity, speed, and usability.

The Ajax technique uses a combination of:

  • XHTML (or HTML), CSS, for marking up and styling information.
  • The DOM accessed with a client-side scripting language, especially ECMAScript implementations such as JavaScript and JScript, to dynamically display and interact with the information presented.
  • The XMLHttpRequest object to exchange data asynchronously with the web server. In some Ajax frameworks and in certain situations, an IFrame object is used instead of the XMLHttpRequest object to exchange data with the web server.
  • XML is sometimes used as the format for transferring data between the server and client, although any format will work, including preformatted HTML, plain text, JSON and even EBML.

Like DHTML, LAMP, or SPA, Ajax is not a technology in itself, but a term that refers to the use of a group of technologies together.

Here are 5 excellent Ajax tutorials from IBM that will teach you how to code in this important web development technology.


Mastering Ajax - 5 Part Tutorial from IBM


Mastering Ajax, Part 1: Introduction to Ajax

Ajax, which consists of HTML, JavaScript, DHTML, and DOM, is an outstanding approach that helps you transform clunky Web interfaces into interactive Ajax applications. The author, an Ajax expert, demonstrates how these technologies work together -- from an overview to a detailed look -- to make extremely efficient Web development an easy reality. He also unveils the central concepts of Ajax, including the XMLHttpRequest object.

Mastering Ajax, Part 2: Make asynchronous requests with JavaScript and Ajax
Most Web applications use a request/response model that gets an entire HTML page from the server. The result is a back-and-forth that usually involves clicking a button, waiting for the server, clicking another button, and then waiting some more. With Ajax and the XMLHttpRequest object, you can use a request/response model that never leaves users waiting for a server to respond. In this article, Brett McLaughlin shows you how to create XMLHttpRequest instances in a cross-browser way, construct and send requests, and respond to the server.

Mastering Ajax, Part 3: Advanced requests and responses in Ajax
For many Web developers, making simple requests and receiving simple responses is all they'll ever need, but for developers who want to master Ajax, a complete understanding of HTTP status codes, ready states, and the XMLHttpRequest object is required. In this article, Brett McLaughlin will show you the different status codes and demonstrate how browsers handle each and he will showcase the lesser-used HTTP requests that you can make with Ajax.

Mastering Ajax, Part 4: Exploiting DOM for Web response
The great divide between programmers (who work with back-end applications) and Web programmers (who spend their time writing HTML, CSS, and JavaScript) is long standing. However, the Document Object Model (DOM) bridges the chasm and makes working with both XML on the back end and HTML on the front end possible and an effective tool. In this article, Brett McLaughlin introduces the Document Object Model, explains its use in Web pages, and starts to explore its usage from JavaScript.

Mastering Ajax, Part 5: Manipulate the DOM
Last month Brett introduced the Document Object Model, whose elements work behind the scenes to define your Web pages. This month he dives even deeper into the DOM. Learn how to create, remove, and change the parts of a DOM tree, and take the next step toward updating your Web pages on the fly!



Tags for this post>>

Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 1:20 pm


June 29, 2006

Writing Regular Expressions

A Regular Expression (abbreviated as regexp or regex, with plural forms regexps, regexes, or regexen ) is a string that describes or matches a set of strings, according to certain syntax rules. Regular expressions are used by many text editors and utilities to search and manipulate bodies of text based on certain patterns. Many programming languages support regular expressions for string manipulation. For example, Perl and Tcl have a powerful regular expression engine built directly into their syntax. The set of utilities (including the editor sed and the filter grep ) provided by Unix distributions were the first to popularize the concept of regular expressions.

A regular expression, often called a pattern, is an expression that describes a set of strings. They are usually used to give a concise description of a set, without having to list all elements. For example, the set containing the three strings Handel, Händel, and Haendel can be described by the pattern "H(ä|ae? )ndel" (or alternatively, it is said that the pattern matches each of the three strings). Most formalisms provide the following operations to construct regular expressions.

alternation
A vertical bar separates alternatives. For example, "gray|grey" matches gray or grey, which can commonly be shortened to "gr(a|e)y".

grouping
Parentheses are used to define the scope and precedence of the operators. For example, "gray|grey" and "gr(a|e)y" are different patterns, but they both describe the set containing gray and grey.

quantification
A quantifier after a character or group specifies how often that preceding expression is allowed to occur. The most common quantifiers are ?, *, and +:
?     The question mark indicates there is 0 or 1 of the previous expression. For example, "colou?r" matches both color and colour.
*     The asterisk indicates there are 0, 1 or any number of the previous expression. For example, "go*gle" matches ggle, gogle, google, etc.
+     The plus sign indicates that there is at least 1 of the previous expression. For example, "go+gle" matches gogle, google, etc. (but not ggle ).

These constructions can be combined to form arbitrarily complex expressions, very much like one can construct arithmetical expressions from the numbers and the operations +, -, * and /.

As an example, the pattern "((great )*grand )?(father|mother)" matches any ancestor: father, mother, grand father, grand mother, great grand father, great grand mother, great great grand father, great great grand mother, great great great grand father, great great great grand mother and so on.

Here is a table to help you understand how to write Regular Expressions. This Regular Expression Syntax table describes and gives an example of the characters and sequences that can be used.

Regular Expression Syntax

Character

Description

\

Marks the next character as either a special character or a literal. For example, "n" matches the character "n". "\n" matches a newline character. The sequence "\\" matches "\" and "\(" matches "(".

^

Matches the beginning of input.

$

Matches the end of input.

*

Matches the preceding character zero or more times. For example, "zo*" matches either "z" or "zoo".

+

Matches the preceding character one or more times. For example, "zo+" matches "zoo" but not "z".

?

Matches the preceding character zero or one time. For example, "a?ve?" matches the "ve" in "never".

.

Matches any single character except a newline character.

(pattern )

Matches pattern and remembers the match. The matched substring can be retrieved from the resulting Matches collection, using Item [0]...[n]. To match parentheses characters ( ), use "\(" or "\)".

x|y

Matches either x or y. For example, "z|wood" matches "z" or "wood". "(z|w)oo" matches "zoo" or "wood".

{n}

n is a nonnegative integer. Matches exactly n times. For example, "o{2}" does not match the "o" in "Bob," but matches the first two o's in "foooood".

{n,}

n is a nonnegative integer. Matches at least n times. For example, "o{2,}" does not match the "o" in "Bob" and matches all the o's in "foooood." "o{1,}" is equivalent to "o+". "o{0,}" is equivalent to "o*".

{n,m}

m and n are nonnegative integers. Matches at least n and at most m times. For example, "o{1,3}" matches the first three o's in "fooooood." "o{0,1}" is equivalent to "o?".

[xyz]

A character set. Matches any one of the enclosed characters. For example, "[abc]" matches the "a" in "plain".

[^xyz]

A negative character set. Matches any character not enclosed. For example, "[^abc]" matches the "p" in "plain".

[a-z]

A range of characters. Matches any character in the specified range. For example, "[a-z]" matches any lowercase alphabetic character in the range "a" through "z".

[^m-z]

A negative range characters. Matches any character not in the specified range. For example, "[m-z]" matches any character not in the range "m" through "z".

\b

Matches a word boundary, that is, the position between a word and a space. For example, "er\b" matches the "er" in "never" but not the "er" in "verb".

\B

Matches a non-word boundary. "ea*r\B" matches the "ear" in "never early".

\d

Matches a digit character. Equivalent to [0-9].

\D

Matches a non-digit character. Equivalent to [^0-9].

\f

Matches a form-feed character.

\n

Matches a newline character.

\r

Matches a carriage return character.

\s

Matches any white space including space, tab, form-feed, etc.
Equivalent to "[ \f\n\r\t\v]".

\S

Matches any nonwhite space character.
Equivalent to "[^ \f\n\r\t\v]".

\t

Matches a tab character.

\v

Matches a vertical tab character.

\w

Matches any word character including underscore.
Equivalent to "[A-Za-z0-9_]".

\W

Matches any non-word character.
Equivalent to "[^A-Za-z0-9_]".

\num

Matches num, where num is a positive integer. A reference back to remembered matches. For example, "(.)\1" matches two consecutive identical characters.

\n

Matches n, where n is an octal escape value. Octal escape values must be 1, 2, or 3 digits long. For example, "\11" and "\011" both match a tab character. "\0011" is the equivalent of "\001" & "1". Octal escape values must not exceed 256. If they do, only the first two digits comprise the expression. Allows ASCII codes to be used in regular expressions.

\xn

Matches n, where n is a hexadecimal escape value. Hexadecimal escape values must be exactly two digits long. For example, "\x41" matches "A". "\x041" is equivalent to "\x04" & "1". Allows ASCII codes to be used in regular expressions.






Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:40 pm


June 28, 2006

Learning Guides for XML, XML Security, and Web Services Security

The following are 3 posts from my Web Development Tutorial Blog at Educationonlineforcomputers.com. These are more learning guides and cover the important topics of XML, XML Security, and Web Services Security.


XML Learning Guide

This guide explains what XML is, how it's used, and where it fits into the world of Web services. Here you will find XML articles, tutorials, examples, tips, tools, white papers, expert advice and more to increase your XML knowledge and understanding. XML (Extensible Markup Language) is a flexible way to create common information formats and then consistenly share both the format and the data on the WWW, intranets, and elsewhere. Using a standard way of describing data, as XML allows, enables users to send an intelligent agent (a program) to a target, such as a web site, gather data, make a comparison of the data, and then send back results to the user. 

Table of Contents

   XML Quick Start
   XML Articles
   XML White Papers
   XML Chapter Downloads
   XML Tutorials & Code Examples
   Developer Tools and Downloads
   Industry Quotes about XML
   Q&A with XML Experts
   Products using XML
   Online XML Resources
   XML Specs


XML Security Learning Guide

Securing XML is an essential element in keeping Web services secure. This XML Security Learning Guide is a compilation of resources that review different types of XML security standards and approaches for keeping your XML Web services secure. 

Table of Contents
    XML Security Key Terms and Definitions
    Introduction to XML Security
    OASIS
    WS-Security
    SAML
    XML Signatures & Encryption
    XML Firewalls


Fast Guide to Web Services Security

This SearchWebServices.com guide introduces you to Web Services Security -- highlighting the inherent challenges of securing Web services while providing you with strategies to overcome these challenges. You'll find articles, tips, white papers, expert advice and more to arm yourself against would-be invaders.

Table of Contents
    Web services security standards
    Web services security challenges
    Web services security strategies




Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 1:09 pm


June 26, 2006

IT Security Cookbook - Free Book

Here is a free online book about IT security that covers both security policies and technical security subjects. Read the short introduction first. If you're interested in technical guidelines, rather than organisation / policies, read the practical security summary before looking at the technical sections. There is a lot of new material the autor has written since he wrote this book, please see www.boran.com/security/sp for these security articles.


IT Security Cookbook


Contents/Search

Introduction
High Level Security
Technical Guidelines
Appendices




Filed under: Free Computer and I.T. Books — computer_teacher @ 9:53 am


Learning Guide for SOA or Service-Oriented Architecture

This SearchWebServices.com learning guide introduces you to Service-Oriented Architecture, or SOA. In this SOA learning guide, you'll find articles, tips, expert advice, white papers and more that will explain how SOA fits into the world of Web services.


Learning Guide for SOA or Service-Oriented Architecture


Table of Contents
    SOA Definitions and Introductions
    SOA Integration and Planning
    SOA Development and Design
    SOA, BPM, and Business Analysis
    SOA Security and Governance
    SOA Q&A
    SOA Webcasts
    SOA and Web Services
    Predictions and Commentary

   SOA Definitions and Introductions

   SOA Integration and Planning

   SOA Development and Design

   SOA, BPM, and Business Analysis

   SOA Security and Governance

   SOA Q&A

   SOA Webcasts

   SOA and Web Services

   Predictions and Commentary




Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 1:01 am


June 25, 2006

.NET Learning Guide

This SearchWebServices.com guide introduces you to .NET (dotNet), explains best practices and pitfalls to avoid and provides troubleshooting help and advice. You'll find .NET articles, tutorials, tips, tools, white papers, expert advice and more to increase your .NET knowledge and help you to better understand this technologiy. Microsoft .NET is a set of software technologies for connecting information, users, systems, and devices. This new generation of technology is based on Web services, which are small building-block applications that can connect to each other as well as to other, larger applications over the Internet."


.NET Learning Guide


Table of Contents

   .NET Quick Start
   .NET Expert Advice
   .NET Migration Tips
   .NET White Papers and Chapter Downloads
   .NET Code Samples and Tutorials
   .NET Tools and Downloads
   .NET Online Resources


  .NET Quick Start

  .NET Expert Advice
You'll find much more expert advice on .NET in our Ask-the-Expert feature. Pose your own question to Michele Leroux Bustamante.

Click below for a sampling of Michele's advice to users just like you...

  .NET Migration Tips

  .NET White Papers and Chapter Download

  .NET Code Samples and Tutorials

  .NET Tools and Downloads

  .NET Online Resources




Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:17 pm


June 23, 2006

Learning Guide for Linux Security

Linux Security is one of the most important considerations in any enterprise IT shop, and there are so many resources available it can be difficult to know where to start. Techtarget.com has compiled the following wealth of information in their Linux Security Learning Guide. This will help get you up to speed quickly with learning about and understanding Linux Security.


Learning Guide for Linux Security


Table of Contents
    Making sense of terms and acronyms
    Getting started: Linux Security at a glance
    Best practices: To do and not to do
    Worst case scenarios: When things went wrong
    Security Tools
    Intrusion detection and prevention
    Firewalls: How-tos, tips and products
    Remote security: VPNs, wireless and more
    Security monitoring: Beyond intrusion detection
    Security management: Policies, tools and vigilance
    Other Resources -- bookmark these pages!


Making sense of terms and acronyms


Getting started: Linux Security at a glance

Best practices: To do and not to do

Worst case scenarios: When things went wrong

Security Tools


Intrusion detection and prevention

Firewalls: How-tos, tips and products

Remote security: VPNs, wireless and more

Security monitoring: Beyond intrusion detection

Security management: Policies, tools and vigilance

Other Resources



Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 4:31 pm


June 22, 2006

J2EE Learning Guide

This guide gives you a well presented detailed overview of J2EE and includes articles, tutorials, examples, tips, tools, and expert advice to increase your J2EE knowledge and understanding quickly. J2EE is an abbreviation for Java 2 Platform Enterprise Edition, which is the Java platform designed for the mainframe-scale computing typical of large enterprises. Sun Microsystems (together with industry partners such as IBM) designed J2EE to simplify application development in a thin client tiered environment. J2EE simplifies application development and decreases the need for programming and programmer training by creating standardized, reusable modular components and by enabling the tier to handle many aspects of programming automatically.


J2EE Learning Guide


Table of Contents
   Quick Start
   J2EE Articles
   J2EE Tutorials
   J2EE White Papers and Book Excerpts
   Q&As and Webcasts with J2EE Experts
   Products for Download
   J2EE Code Samples and Applications


J2EE Quick Start


J2EE Articles


J2EE Tutorials


J2EE White Papers and Book Excerpts


Q&As and Webcasts with J2EE Experts


J2EE Specifications


J2EE Products for Download


J2EE Code Samples and Applications


Related Content
   J2EE
   Java Jeopardy at TheServerSide Java Symposium
   JavaOne: What worked and what didn't
   Sun's NetBeans overshadowed by Eclipse
   Java EE 5 gets ratified
   JSF as a weak link for Ajax
   At Sun: Who's the boss?
   Sun's McNealy gives it up
   Enter the BlueDragon: BEA tries to move ColdFusion into SOA
   IceSoft betas JavaScript-free Ajax tool
   It's the architecture stupid
   J2EE Research




Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:28 am


Free On-line Linux Technical Books and Tutorials

Linuxtopia hosts an excellent collection of current, up-to-date Linux Books, Tutorials, and Manuals. These cover many topics, including Gtk+/Gnome, MySQL, Linux Security, Red Hat Enterprise Linux, CentOS Enterprise Linux, Red Hat Fedora Core, Ubuntu, Debian GNU/Linux, Command-Line Tools, C Programming, Perl Scripting, Bash Scripting, Linux Kernel Module Programming, Xen Linux Virtualization, Linux Tools & Utilities, GCC, Linux Debugging, and Linux Developer Tools Guides.


Free On-line Linux Technical Books and Tutorials


Desktop & GUI Toolkit Books Database Books Linux Security Books Linux for Beginners Books Linux System Administration Books Programming and Scripting Books Web Development Books Linux Kernel Programming Books Linux Virtualization Books Linux Installation Guides Linux Tools & Utilities Books Linux Development Tools Books





Filed under: Free Computer and I.T. Books — computer_teacher @ 10:27 am


June 20, 2006

SQL Learning Guide

Whether you are a newbie or a seasoned SQL scripting expert looking to tweak query performance, this learning guide to the Structured Query Language (SQL) has something for you. These seven chapters will assist you with how to script SQL to get the data you need by looking at solutions to real-world problems. The advice listed below comes primarily from SQL guru Rudy Limeback.

SQL Learning Guide


Table of Contents:

   Chapter 1: Answers to some very basic questions
   Chapter 2: Primary and foreign keys
   Chapter 3: Selecting data
   Chapter 4: Updating, inserting, and deleting data
   Chapter 5: Calculations
   Chapter 6: Working with times and dates
   Chapter 7: Performance issues


Chapter 1: Answers to very basic questions


Chapter 2: Primary and foreign keys

Chances are, you are here because you want to know more about how to get the data from a relational database. It helps to know more about how the different tables are connected. That's where primary and foreign keys come in.

What is a primary key? Composite PK? Foreign key? What is a candidate key?

Although you don't have to define a primary key for a table, if you plan on referencing that table, there are many reasons why the primary key is important, even if you think irrelevant data entry is handled at the front end.

You can form your primary key from:

You cannot have two primary keys on a table, but you can use several columns to form a composite primary key. Take note, however, that there is a maximum number of columns it can have. Using composite keys can be a straightforward solution when dealing with M:N relationships. Here is an example of a query that will return the "next" composite primary key from a result set in SQL server.

The most important thing to remember about primary keys is that you must ensure that they are unique. It seems obvious, but defining primary keys can get messy when data rows get moved to other tables. Your database design should take into consideration subtypes and supertypes.

The foreign key must reference a unique key, the primary key. But many foreign keys can reference the same primary key, and optional foreign keys can be NULL. Here's how you can get the surrogate key of the row just inserted.

If you are referencing a composite primary key, your foreign key will be composite as well. You can sometimes run into problems when columns involved in composite keys become orphaned. You can make business rules to prevent childless parents, or you could create assertions to ensure certain conditions always exist.

Here's what the recursive relationship looks like in SQL. If you need recursion, but your DBMS doesn't support it, here is a work-around.


Chapter 3: Selecting data

The key point in comparing data in tables is to realize that the data are not stored in any specific order. To get the first 10, the last 10, or some other arbitrary number of records, you have to define the order in terms of a particular column, using the ORDER BY clause. Here are examples of how to get :

Here's what happens if there are ties. Here is how to get the top 10 using the TOP keyword, even with multiple columns. There is a difference between the ORDER BY and GROUP BY clauses. Here's an explanation of the difference between WHERE and HAVING and an in-depth discussion on the GROUP BY clause.

Here are some examples of how you can use SQL to:

Once you get the right results, you can:

Chapter 4: Updating, inserting, and deleting data

When comparing two or more tables, you can:


Chapter 5: Calculations

You can use SQL to perform calculations on data. Here are a few examples of how to:


Chapter 6: Working with times and dates

Each DBMS has its own way of working with dates. But here are a few examples of how to work time and dates in with your queries to:


Chapter 7: Performance issues

SQL queries can be written in many ways. In this webcast on Oracle SQL tuning secrets, guru Don Burleson discusses a few techniques, including using materialized views, for improving the speed of SQL queries. In excerpts from her book Oracle SQL and Index Internals, author Kimberly Floss explores Oracle's internal mechanisms like the cost-based optimizer and indexing.

Here are some examples that can help you decide what the best solution is:


  More Learning Guides

  • Crash Course: Oracle basics This guide helps you to research, compare or work with the Oracle DBMS. It provides Oracle basics for versions 8.x, 9.x and 10g.

  • Learning guide to Oracle error messages Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.

  • Learning Guide -- Performance tuning Newbies and experts will benefit from this guide; you'll establish a smart approach to tuning, use and interpret Oracle's tuning utilities and identify specific problem areas.

  • Learning guide to PL/SQL This fast guide to PL/SQL can help both newbies and veterans become better acquainted with the language and hone their developer skills.

  • Learning guide: Oracle security This guide covers a wide variety of topics on many aspects of Oracle security to help you lock down your data.

  • Fast Guide: Becoming an Oracle Certified Professional Get expert technical advice on where to begin your certification studies, passing the final exam and putting your certification into effect in the workplace.

  • Guide to Oracle freeware and shareware A library of freeware, shareware or inexpensive tools (less than $100) to help with Oracle administration and development.

  • Learning Guide: Backup and recovery This guide covers everything from the basics of creating a backup and recovery plan to the specifics of using RMAN and other methods of hot and cold backups.

  • Learning Guide: SQL Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide can help you figure out how to get the data you need by looking at solutions to real-world problems.



Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:53 pm


Fast Guide to PL/SQL

PL/SQL is the procedural language extension to the structured query language (SQL) for the Oracle database. It combines a database language with a procedural programming language, which is built on a basic unit called a block. By compiling and storing executable blocks, Oracle can process the PL/SQL quickly and easily.

PL/SQL supports variables, conditions, arrays, and exceptions. Implementations from version 8 of the Oracle RDBMS onwards have included features associated with object-orientation.

The underlying SQL functions as a declarative language. Standard SQL—unlike some functional programming languages—does not require implementations to convert tail calls to jumps. SQL does not readily provide "first row" and "rest of table" accessors, and it cannot easily perform some constructs such as loops. PL/SQL, however, as a Turing-complete procedural language which fills in these gaps, allows Oracle database developers to interface with the underlying relational database in an imperative manner. SQL statements can make explicit in-line calls to PL/SQL functions, or can cause PL/SQL triggers to fire upon pre-defined DML events.

PL/SQL stored procedures (functions, procedures, packages, and triggers) which perform DML get compiled into an Oracle database: to this extent their SQL code can undergo syntax-checking. Programmers working in an Oracle database environment can construct PL/SQL blocks of such functionality to serve as procedures, functions; or they can write in-line segments of PL/SQL within SQL*Plus scripts.

This fast guide from SearchOracle.com provides PL/SQL tips, expert explanations, and web resources and will help both newbies and veterans become better acquainted with this database language and hone their developer skills.


Fast Guide to PL/SQL

Table of Contents

   What is PL/SQL?
   PL/SQL basics
   Language elements
   Details on Oracle datatypes
   Procedures, functions and packages
   Tips on triggers
   Working with stored procedures
   PL/SQL tuning
   Dynamic SQL in PL/SQL
   Additional PL/SQL resources


What is PL/SQL?

The following explanation of PL/SQL is excerpted from "Learning Oracle PL/SQL" by Bill Pribyl & Steven Feuerstein.

"Structured Query Language is a language based on set theory, so it is all about manipulating sets of data. SQL consists of a relatively small number of main commands such as SELECT, INSERT, CREATE, and GRANT; in fact, each statement accomplishes what might take hundreds of lines of procedural code to accomplish. That's one reason SQL-based databases are so widely used. The big joke about the name "SQL" is that it is not really structured, is not just for queries, and (some argue) is not even a real language. Nevertheless, it's the closest thing there is to a lingua franca for relational databases such as Oracle's database server, IBM's DB2 and Microsoft's SQL Server.

"A language extension is a set of features that somehow enhance an existing language. This phrase might imply, incorrectly, that PL/SQL is a special version of SQL. That isn't the case, however. PL/SQL is a programming language in its own right; it has its own syntax, its own rules, and its own compiler. You can write PL/SQL programs with or without any SQL statements. Some authors assert that PL/SQL is a superset of SQL, but that's a bit of an overstatement, because only the most common SQL statements can be used easily in a PL/SQL program.

"PL/SQL, then, is a language that is closely related to SQL, but one that allows you to write programs as an ordered series of statements. Or, if you want a definition of PL/SQL that befits a programmer:

    "PL/SQL is a procedural (Algol-like) language with support for named program units and packages; much of its syntax is borrowed from Ada, and from Oracle's SQL it derives its datatype space and many built-in functions."

PL/SQL basics

PL/SQL offers a variety of benefits to Oracle DBMS users, including the ability to modularize program development, support for error handling, portability across platforms and much more. The following resources will help newbies learn more about the benefits and uses of PL/SQL.

  • PL/SQL definition
  • PL/SQL: What, when, and where
  • SQL vs. PL/SQL
  • Using Oracle PL/SQL
  • Learning Oracle basics
  • Introduction to Oracle design
  • PL/SQL control structures: Best practices
  • Application development: PL/SQL, Java or C++?
  • Moving data: Pro*C, SQL or PL/SQL?
  • Why Oracle wins in a comparison with SQL Server
  • Ask PL/SQL experts Azim Fahmi and Frank Kulash for advice
  • OTN's PL/SQL center
  • What's new in PL/SQL in Oracle10g?
  • Oracle FAQ's PL/SQL FAQ
  • Best Web Links: PL/SQL
  • Fast Guide: Solving common Oracle errors
  • Crash Course: Oracle basics


    Language features

    PL/SQL language elements, as noted in the "PL/SQL User's Guide and Reference," include comments, assignments, statements, procedures, functions, packages, expressions, logical operators, strings, variable names, declarations, types, loop, data functions, exceptions, objects, pipe messages, records, triggers and alerts. Here you'll find tips and advice pertaining to various PL/SQL elements.

    Further down the page, you will find more extensive information on procedures, functions and packages, triggers and stored procedures.

  • PL/SQL control structures: Best practices
  • CASE and PL/SQL
  • DECODE vs. CASE
  • Assignment operators explained
  • Substitution variables
  • Calling variable name packages
  • Processing regular expressions
  • Processing a delimited string
  • Splitting a string
  • Performing string searches on CLOB files
  • Different types of pragma
  • Scripts for dates, days and holidays
  • Dates and DECODE
  • Oracle alert log miner
  • Exception handling
  • Catching PL/SQL error code


    Details on Oracle datatypes

    PL/SQL datatypes, as noted in the "PL/SQL User's Guide and Reference," include numbers, characters, large objects, boolean, date, time and intervals. The following tips and expert advice will offer you methods for working with various datatypes.

    BLOBs and CLOBs

  • BLOB definition
  • Query to find size of BLOB objects
  • Updating a BLOB column without BFILE/create directory options
  • Converting LONGRAW to BLOB
  • Viewing data stored in CLOB
  • Searching on CLOB columns

    CHAR, VARCHAR, VARCHAR2 and LONG RAW

  • VARCHAR2 vs. VARCHAR
  • More on VARCHAR2 vs. VARCHAR
  • VARCHAR2 vs. VARCHAR vs. CHAR
  • Getting the length of a LONG data type and concatenating LONG with VARCHAR2
  • Loading LONG RAW data
  • Converting LONGRAW to BLOB
  • Getting number of bytes in LONG RAW column

    DATE and TIME

  • Scripts for dates, days and holidays
  • Verifying date columns, sending e-mail with PL/SQL
  • Coding for unique calendar year
  • Transfering a table on date change
  • How to pass a date to a stored procedure in Oracle9i
  • Mapping time intervals with Oracle's date arithmetic
  • Adding time using PL/SQL
  • Calculating time differences, excluding weekends

    REF CURSOR

  • REF cursors explained
  • Returning number of rows to a REF CURSOR
  • Closing ref cursor after it's used in a Java program
  • Number of open cursors increasing


    Procedures, functions and packages

    Through a variety of examples, this section can help you better understand how to use, write and build procedures, functions and packages with PL/SQL.

  • PL/SQL control structures: Best practices
  • List the KEPT status for PL/SQL objects in your database
  • Viewing all objects for a specific user
  • Compile all invalid objects
  • Calling a PL/SQL procedure
  • Procedure to create synonyms
  • Displaying the output of PL/SQL procedures
  • Returning more than one value from PL/SQL procedure
  • How to return a set of records from a PL/SQL procedure
  • Trouble with TRUNCATE in a procedure
  • Running SQL*Loader from within PL/SQL procedure
  • Importing/exporting wrapped PL/SQL procedures
  • PL/SQL UTL_SMTP procedure to send e-mail
  • Finding rows with non-printable characters in them (block)
  • Calling a PL/SQL procedure or function from a Java program
  • When to use functions and stored procedures
  • Getting the last inserted sequence value
  • Calling variable name packages
  • Package to search on CLOB columns
  • Package to change foreign keys
  • Pinning vs. caching


    Tips on triggers

    A trigger is a set of statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. They are used to preserve data integrity by consistently checking on or changing data. Here is a list of tips and tricks to help you work with PL/SQL triggers.

  • Trigger definition
  • Disabling and enabling triggers
  • Getting the table name within a trigger
  • Passing parameters to a trigger
  • Trigger to assign rollback segment to export backup
  • Trigger to send automatic e-mail notification of expiring passwords
  • Trigger running a shell process on Unix without pipes
  • How to use Resumable Space Allocation in Oracle9i
  • Using a trigger to replicate 10,000 records daily to SQL Server
  • Non-trigger-based solutions for replicating data to SQL Server
  • Passing new and old in a trigger to a Java stored procedure
  • Trigger on a materialized view (snapshot) table
  • Executing a VB procedure from an Oracle trigger
  • Mutating tables and AUTOCOMMIT
  • How to avoid 'mutating table' errors
  • Assigning new values to entire record in one line
  • Resolving the ORA-06508 error from trigger
  • List the KEPT status for PL/SQL objects in your database
  • Compile all invalid objects
  • Trigger or stored procedure for table transfer?
  • Chapter download: Programming Oracle triggers and stored procedures


    Working with stored procedures

    A stored procedure is a set of statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. Stored procedures are helpful in controlling access to data, preserving data integrity and improving productivity. Here are tips and expert advice for working with PL/SQL stored procedures.

  • Stored procedure definition
  • Why use stored procedures?
  • Stored procedure vs. embedded SQL
  • Trigger or stored procedure for table transfer?
  • When to use functions and stored procedures
  • Executing stored procedures in 9i from SQL Server
  • Time-based stored procedure to check table and update old records
  • Coding stored procedures in Java
  • Error when calling stored procedure
  • Stored procedure to change schema
  • Stored procedure to update across a firewall
  • Implement timeout
  • Insert in a cursor takes hours to complete
  • Accessing non-Oracle databases using stored procedures and JDBC
  • Calling a stored procedure from a trigger
  • Outputting rows to flat file, granting EXECUTE to user
  • Returning rows through stored procedure
  • Creating set of rows through 8i stored procedure
  • How to find which stored procedure is currently running
  • Chapter download: Programming Oracle triggers and stored procedures


    PL/SQL tuning

    Simply tweaking your PL/SQL code may not help identify or eliminate bottlenecks. Here are a few methods for tuning your PL/SQL.

  • Tuning SQL and PL/SQL
  • Improving PL/SQL performance by using collections
  • Getting information about execution times
  • Improving the processing time of a stored procedure
  • Retrieval time for LONGRAW images is slow
  • Oracle PL/SQL built for speed
  • White paper: Oracle SQL and PL/SQL development and maintenance concepts
  • Best Web Links: performance tuning


    Dynamic SQL in PL/SQL

    Dynamic SQL facilitates the automatic generation and execution of program statements. It is useful for building ad hoc query systems and executing DDL inside PL/SQL, and it is often needed in Web-based applications. Here you'll find advice for working with dynamic SQL.

  • Dynamic SQL definition
  • The curse and blessings of dynamic SQL
  • Dynamic SQL
  • Using dynamic SQL
  • An example of dynamic SQL in PL/SQL
  • Creating tables in PL/SQL
  • Changing schema
  • Using dblink when defining cursor in PL/SQL routine
  • Chapter excerpt: "Oracle PL/SQL programming guide to Oracle8i features"
  • Chapter excerpt: "Dynamic SQL"


    Additional PL/SQL resources

    Look into these resources for answers to your more specific PL/SQL questions.

  • Ask PL/SQL experts Azim Fahmi and Frank Kulash for advice
  • OTN's PL/SQL center
  • What's new in PL/SQL in Oracle10g?
  • Oracle FAQ's PL/SQL FAQ
  • Best Web Links: PL/SQL
  • Tips: Oracle database administration
  • Chapter excerpt: "Learning Oracle PL/SQL"
  • Oracle FAQ's list of Oracle PL/SQL books



  • Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:51 pm


    73 Free Oracle Book Chapters and Excerpts

    Searchoracle.com hosts the following 73 free Oracle book chapters and excerpts on their Book Chapter Download Library page. These chapters are taken from books written by Oracle experts and gurus and cover Application Server, Database Administration, Data Warehousing and Business Intelligence, E-Business Suite, Grid Computing, Languages, and Web services. This page is updated often, so check back with it regularly to get more chapters and excerpts as they are posted.


    73 Free Oracle Book Chapters and Excerpts


    Table of Contents

       Application Server
       Database Administration
       Data Warehousing and Business Intelligence
       E-Business Suite
       Grid Computing
       Languages
       Web services


    Application Server

    Oracle Application Server 10g administration handbook
    This six-part series of chapter excerpts are taken from "Oracle Application Server 10g administration handbook," written by John Garmany and Don Burleson, courtesy of Osborne Oracle Press. This book is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. Each excerpt focuses on a different aspect of Oracle Application Server administration. Check back next week for a new excerpt:
    1. Planning for installation
    2. Managing the Oracle HTTP server
    3. The Web Cache
    4. Cache invalidation
    5. Deploying applications using Enterprise Manager
    6. Distributed Configuration Management


    Database Administration

    Oracle disk I/O tuning
    This series of book excerpts is from the soon-to-be-released Rampant TechPress book "Oracle disk I/O tuning," written by Mike Ault. Each excerpt in this series focuses on a different aspect of disk I/O performance and optimization for Oracle databases. Check back frequently for new excerpts.
        1. General disk architecture
        2. Disk layout
        3. Disk performance statistics
        4. Disk capacity -- The two-edged sword
        5. Optimizing ATA performance
        6. ATA tuning in Linux, part 1
        7. ATA tuning in Linux, part 2
        8. ATA tuning in Linux, part 3
        9. ATA tuning in Linux, part 4
        10. ATA tuning in Windows
        11. Tuning the SCSI interface in Windows
        12. SCSI tuning under Linux and Unix
        13. The SCSI bus, part 1
        14. The SCSI bus, part 2
        15. HP-UX SCSI tuning, part 1
        16. HP-UX SCSI tuning, part 2
        17. SCSI tuning under AIX
        18. Automated storage management, part 1
        19. Automated storage management, part 2
        20. Automated storage management, part 3

    Oracle SQL and index internals
    This 12-part series of book excerpts are taken from soon-to-be-released "Oracle SQL and index internals," written by Kimberly Floss and Donald K. Burleson, courtesy of Rampant TechPress. This book explores important internal mechanisms within Oracle and illustrates the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Each excerpt focuses on a different aspect of Oracle10g CBO internals and SQL tuning optimization. Check back frequently for new excerpts:
        1. High performing SQL -- where do you start?
        2. New performance views to identify problem SQL
        3. Identify the resource-intensive code
        4. Tune the code/database for better performance
        5. Methods for creating high-quality code
        6. Know thy database
        7. EXPLAIN and understand
        8. Try different combinations
        9. Revisit when necessary
        10. And if you can't change the code...
        11. Index rebuilds
        12. Histograms and finding the poorly running SQL

    Oracle Database 10g high availability with RAC, Flashback and Data Guard (Chapter 8)
    Chapter 8, "Backup and recovery for high availability environments," helps dispel the myth that backing up a database is not an HA technique -- that backups are the fallback when the database has already gone down, is unavailable, and there is no other choice but to wait for the files to restore from a backup location. Instead, it explains how to get the most from an RMAN backup strategy, and not just for recovery but for assisting with load balancing, maintaining uptime and minimizing downtime, as well as chipping in with RAC and DG maintenance.

    Oracle Database 10g new features (Chapter 1)
    Chapter 1, "Getting started," is the place to start in your effort to learn all about Oracle Database 10g. This chapter will first look at the "grid" and explain what it's all about. Then it moves on to explain how to upgrade to Oracle Database 10g. Specific topics covered include the "grid," upgrading to 10g, the SYSAUX tablespace and Automatic Storage Management (ASM).

    Oracle9i: The complete reference (Chapter 2)
    Chapter 2, "The dangers in a relational database," discusses some of the dangers that both developers and users need to consider when working with a relational database. Combine a relational database with a series of powerful and easy-to-use tools, as Oracle does, and the possibility of being seduced into disaster by its simplicity becomes real. Add in object-oriented and Web capabilities, and the dangers increase. Get help avoiding these dangers and learn the ten commandments of humane design in this chapter.

    Optimizing Oracle performance (Chapter 1)
    This introductory chapter, "Optimizing Oracle performance," discusses what you're doing wrong in performance tuning. It covers some of the root causes of performance issues, problems with commonly-used tuning techniques, requirements of a good method, advances in performance improvements, tools for analyzing response time, an overview of Method R -- a response-based performance improvement method that yields maximum economic value -- evaluation of effectiveness and more.

    Effective Oracle by design (Chapter 7)
    This is Chapter 7 from the McGraw-Hill/Osborne book "Effective Oracle by design" by Tom Kyte. Your application will live and die based on its physical implementation. Choose the wrong data structures, and performance will be crippled and flexibility limited. Choose the correct data structures, and you could have great performance. This chapter looks at some of the things you need to consider when designing your schema. It will then focus on table types, some useful index types, and finally, compression. Also check out Tom Kyte's SearchOracle.com webcast, "Efficient schema design."

    Oracle Database 10g new features: 12 new 10g Features in a Nutshell
    Learn more about 10g's new features and enhancements with these 12 excerpts from the only 10g new features book yet published, "Oracle Database 10g new features" by Mike Ault, Daniel Liu and Madhu Tumma.

    Introduction to Oracle design (Chapter 1)
    This is Chapter 1 from the O'Reilly book "Oracle design" by Dave Ensor and Ian Stevenson. Performance usually makes or breaks a computer system, and design is central to good performance. If your database isn't well-designed from the start, it will be almost impossible for your applications to run efficiently. This chapter explains what is Oracle database design, offers a case study, takes a look at alternative methods and approaches, describes how to plan the design phase and outlines design tasks.


    Data Warehousing and Business Intelligence

    Crystal Reports 9 on Oracle (Chapter 3)
    This is Chapter 3 from the McGraw-Hill Osborne Media book "Crystal Reports 9 on Oracle" by Marie Annette Harper. If you need help exploring connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL expressions and SQL commands. This download covers Oracle SQL basics as they relate to Crystal Reports.


    E-Business Suite

    Oracle E-Business Suite 11i: Implementing core financial applications (Chapter 1)
    This is introductory Chapter 1 from the John Wiley & Sons book "Oracle E-Business Suite 11i: Implementing core financial applications" by Susan Foster. To implement Oracle E-Business Suite 11i as efficiently and effectively as possible, each and every Oracle project team member needs to understand the concepts of a successful business system and a software project. The concepts shared in this chapter hold true for any software project regardless of whether the organization is implementing or upgrading Oracle E-Business Suite 11i. Tune in to a SearchOracle.com webcast with "Oracle E-Business Suite 11i" author Susan Foster. Listen to the webcast now.

    Oracle E-Business Suite 11i: Implementing core financial applications (Chapter 2)
    This is Chapter 2 from the John Wiley & Sons book "Oracle E-Business Suite 11i: Implementing core financial applications." This chapter, entitled "Oracle applications navigation," explains how to navigate through an application, and be comfortable with the data entry and query capabilities. Tune in to a SearchOracle.com webcast with "Oracle E-Business Suite 11i" author Susan Foster. Listen to the webcast now.

    Oracle E-Business Suite Manufacturing & Supply Chain Management (Chapter 8)
    This is Chapter 8 from the McGraw-Hill book "Oracle E-Business Suite Manufacturing & Supply Chain Management" by Bastin Gerald, Nigel King and Dan Natchek. The Oracle Applications suite currently offers two products for material and capacity planning in a manufacturing or distribution environment: Master Scheduling/MRP (MRP) offers single-organization, unconstrained planning of material and resources. Advanced Supply Chain Planning (ASCP) is the next-generation planning tool; it offers multiorganization planning and the option of constraint-based and optimized plans. This chapter, entitled "Planning fundamentals," describes the basic logic common to both planning methods and details the common setup needed by both methods.


    Grid Computing

    Grid computing: Making the global infrastructure a reality (Chapter 11)
    This is Chapter 11 from the John Wiley & Sons book "Grid computing: Making the global infrastructure a reality," edited by Fran Berman, Geoffrey Fox and Tony Hey. Entitled "Condor and the grid," it describes how computer scientists were working to access to large amounts of computing power since the 1960s. But, in the early days, researchers noticed that distributed computing would be difficult; messages would be lost, corrupted or delayed, and precise algorithms had to be used to build an understandable system. It wasn't long after that the Condor project was born: a new system for distributed computing created by Miron Livny at the University of Wisconsin. Tune in to a SearchOracle.com webcast with "Grid computing" editor Geoffrey Fox. Listen to the webcast now.

    The Grid: Blueprint for a new computing infrastructure (Chapter 2)
    This is Chapter 2 from the Morgan Kaufmann book "The Grid: Blueprint for a new computing infrastructure" by Ian Foster and Carl Kesselman. In this introductory chapter, entitled "Computational grids," the authors provide a detailed picture of the expected purpose, shape and architecture of future grid systems. It is structured according to six questions: Why do we need computational grids? What types of applications will grids be used for? Who will use grids? How will grids be used? What is involved in building a grid? And, what problems must be solved to make grids commonplace?


    Languages

    Oracle SQL and index internals
    This 12-part series of book excerpts are taken from soon-to-be-released "Oracle SQL and index internals," written by Kimberly Floss and Donald K. Burleson, courtesy of Rampant TechPress. This book explores important internal mechanisms within Oracle and illustrates the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Each excerpt focuses on a different aspect of Oracle10g CBO internals and SQL tuning optimization. Check back frequently for new excerpts:
        1. High performing SQL -- where do you start?
        2. New performance views to identify problem SQL
        3. Identify the resource-intensive code
        4. Tune the code/database for better performance
        5. Methods for creating high-quality code
        6. Know thy database
        7. EXPLAIN and understand
        8. Try different combinations
        9. Revisit when necessary
        10. And if you can't change the code...
        11. Index rebuilds
        12. Histograms and finding the poorly running SQL

    Programming Oracle triggers and stored procedures (Chapter 3)
    This is Chapter 3 from the Prentice Hall Professional Technical Reference book "Programming Oracle triggers and stored procedures" by Kevin Owens. It is one of several chapters that covers how to enforce business rules with constraints. Declarative constraints provide a core and traditional strategy for business rule enforcement. This chapter explains the how and why of declarative constraints.

    Crystal Reports 9 on Oracle (Chapter 3)
    This is Chapter 3 from the McGraw-Hill Osborne Media book "Crystal Reports 9 on Oracle" by Marie Annette Harper. If you need help exploring connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL expressions and SQL commands. This download covers Oracle SQL basics as they relate to Crystal Reports.

    Analytical processing with Oracle SQL (Chapter 9)
    This is Chapter 9 from the 2002 Addison-Wesley book "Oracle SQL & PL/SQL Handbook" by John Palinski. This chapter, entitled "Analytical processing with Oracle SQL," discusses Oracle analytic functions and their place in developing business intelligence and data warehousing solutions.

    XML for data architects: Designing for reuse and integration (Chapter 8)
    This is Chapter 8 from the Morgan Kaufmann book "XML for data architects: Designing for reuse and integration" by James Bean. This chapter, entitled "W3C XML schemas and reuse," explains what reuse is all about -- a concept that is often misunderstood in information technology -- and describes the syntactical and functional capabilities afforded by W3C XML schemas, which provide support and opportunities for metadata reuse.

    PL/SQL: What, when, and where (Chapter 1)
    This is Chapter 1 from the O'Reilly book "Learning Oracle PL/SQL" by Bill Pribyl and Steven Feuerstein. This chapter offers an introductory look at Procedural Language/Structured Query Language (PL/SQL), explaining what it really is, what it is good for and how it fits into the world.

    Perl meets Oracle (Chapter 1)
    This is Chapter 1 from the 2002 O'Reilly book "PERL for Oracle DBAs" by Andy Duncan and Jared Still. Perl is the world's number one solution for transforming and gluing data together, and Oracle is the world's number one solution for storing that data. How do Oracle DBAs, developers, and users take advantage of everything that Perl has to offer? This chapter sets the scene by introducing you to Perl and how it connects to Oracle.

    PL/SQL control structures: Best practices (Chapter 4)
    This is Chapter 4 from the O'Reilly book "Oracle PL/SQL best practices" by Steven Feuerstein. It identifies a range of PL/SQL constructs that allow you to control the flow of processing -- including the IF statement, FOR, WHILE and simple loops, and the GOTO statement -- and details several best practices you should take into account when you work with these kinds of statements.

    Working with queries at runtime (Chapter 14)
    This is Chapter 14 from the McGraw-Hill book "Oracle 9i JDeveloper Handbook" by Peter Koletzke, Dr. Paul Doresey and Dr. Avrom Faderman. This chapter, entitled "Working with queries at runtime," gives a detailed technical explanation on how to code directly to the BC4J API, how to access an application module and view usages, how to use those usages to retrieve, update and insert data and more.


    Web services

    Oracle9i Web development (Chapter 3)
    This is Chapter 3 from the McGraw-Hill/Osborne book "Oracle9i Web development" by Bradley D. Brown. Entitled "iAS configuration and tuning," this chapter explains why configuring iAS requires an understanding of the configuration of the Apache Web server and its various modules, such as mod_jserv and mod_plsql. To take advantage of features in iAS while maximizing performance, the iAS administrator should be well versed in all the features, and their associated costs and benefits. This chapter will help you understand those features, and explains configuration and tuning techniques. Take our Know-IT-all Quiz to test what you've learned in this chapter.

    XML for data architects: Designing for reuse and integration (Chapter 8)
    This is Chapter 8 from the Morgan Kaufmann book "XML for data architects: Designing for reuse and integration" by James Bean. This chapter, entitled "W3C XML schemas and reuse," explains what reuse is all about -- a concept that is often misunderstood in information technology -- and describes the syntactical and functional capabilities afforded by W3C XML schemas, which provide support and opportunities for metadata reuse.





    Filed under: Free Computer and I.T. Books — computer_teacher @ 9:30 pm


    June 19, 2006

    Web Development Tutorials from the Shadow Fox Network

    The Shadow Fox Network provides quality articles and tutorials covering php, xhtml, css, xml, rss, javascript, and ruby on rails, along with tutorials on being a webmaster. These will help you make a better and more attractive web site.


    Web Development Tutorials from the Shadow Fox Network


    Making a Two Column Fluid Layout With Rounded Corners
    Taking apart the two column blue layout of the Shadow Fox Network. Learn how to build a full two column layout with rounded corners.

    3 Column All CSS Layout With Fluid Center and Two Columns
    A response to the amount of 3 column css fluid width layout tutorials. This will make a 3 column layout with a fluid center and two fixed width sidebars. Uses only 3 divs for the columns and shows how to accurately use the float technique.

    Building a Tab Navigation
    Shows how to build a cool tool for navigation, a tabbed system using cascading style sheets.

    How to Center a Layout in CSS
    A tutorial which provides insight to a common problem: centering a layout through cascading style sheets.

    Basics of Cascading Style Sheets
    An introductory tutorial into the world of Cascading Style Sheets, or CSS.

    Generating RSS Feeds on the Fly With PHP
    This article serves to augment the previous article. Instead of writing to a file to make an RSS feed, php code is included that makes the output of RSS without writing to a separate file.

    Building an RSS Feed From a Database
    Learn how to take information in a MySQL database table and export it to RSS using the file writing capabilities of PHP.

    Building a BBCode Function
    How to build the useful little bbcode used in forums into your applications, like [b][/b], [i][/i], etc.

    Introduction to Functions
    How to make simple functions in PHP.

    Building Yet Another PHP Navigation
    How to build another PHP navigation using the switch() statements. Includes an explanation of GET variables.

    Caching PHP Operations
    How to use output buffers to cache code in PHP.

    Building a MySQL Class Using OOP
    How to apply Object Oriented Programming to build a class to interact with MySQL.

    An Introduction to Object Oriented Programming
    How to use PHP's object oriented capabilities and build better, more sophisticated applications.

    Editing Rows in MySQL
    A tutorial that shows you the ups and downs of editing rows in MySQL

    Hit Counter
    A great way to make a hit counter that's seen on a lot of websites that counts both regular and unique hits.

    Your First MySQL Database
    A tutorial to start you on your way of creating mysql driven applications.

    PHP Includes
    A very basic tutorial on how to use include() in your PHP applications.

    XSLT: An Introduction to Styling XML
    How to format and style XML documents using XSL Transformations, or eXtensible Stylesheet Language Transformations.

    XML: The Definitive Introduction
    An introduction to the W3C recommended XML (eXtensible Markup Language).

    Introduction to RSS Feeds
    An introduction to the new trend sweeping the web, RSS feeds.

    Beginning DOM Manipulation Part 3
    The third and final part to starting to manipulate the Document Object Model with Javascript. This covers using the innerHTML property, creating nodes, and deleting nodes.

    Beginning DOM Manipulation Part 2
    Part two of how to begin manipulating elements on a page on-the-fly using the Document Object Model with Javascript. Covers getting and setting attributes and values.

    Javascript Degradation
    A few points on gracefully degrading in javascript if a client doesn't have capabilities that your application uses.

    Beginning DOM Manipulation
    A beginning perspective into how to use the Document Object Model using Javascript to manipulate page elements on the fly. Covers getElementById, getElementsByTagName, childNodes, firstChild, lastChild, and nodeValue.



    Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:19 pm


    Free Books and Ebooks from the Free Book Zone

    FreeBookZone hosts and links to many free online books, ebooks, manuals, and coursewares covering the following: Web Programming, Web Technologies, Operating Systems (Linux, Windows), Java Programming, Enterprise Java, Programming Languages (C, C++ , Assembly, Perl, Scripting, Ruby), Hardware (Microprocessors, Device Drivers, Peripherals), Microsoft Technologies (Certifications, .Net, Visual Basic, VC++, C#, Windows, Web Technology), Computer Science, Database (Oracle, SQL, SQL Server, Postgre SQL, DB/2), Networking, Software Engineering, XML and XSL, and the Internet.. All of these books are freely available over the internet.


    Free  Book Zone


    Book Categories:


    Web Programming

    Web Technologies

    Operating Systems
    Linux
    Unix
    Solaris
    Windows
    Embedded & RT
    Theory Books

    Java
    Java Language
    Java Micro Edition
    Java Enterprise
    Advanced Java
    Java GUI
    Java Networking
    Java Tools

    Programming Languages
    C
    C++
    Assembly
    Java
    Perl
    COBOL
    Scripting
    Ruby
    Others

    Hardware
    Computer H/W
    Microprocessors
    Device Drivers
    Logic & HW Design
    Peripherals

    Microsoft Technologies
    Certifications
    .Net
    Visual Basic
    Server Tech.
    VC++
    COM/DCOM/ATL
    C#
    MS Office
    Windows
    Web Technology

    Computer Science
    Theory Computing
    Compilers
    Database
    Hardware
    DS & Algorithms
    OS
    Network

    Database
    Oracle
    SQL
    SQL Server
    Postgre SQL
    DB/2
    Datawarehousing
    Others

    Network

    Software Engineering

    XML and XSL

    Internet



    Filed under: Free Computer and I.T. Books — computer_teacher @ 1:01 am


    June 15, 2006

    Free Online Computer, Web Development, and Programming Books

    2020ok.com is a gateway site to many free online books. Here is their section covering free technical computer and application developments books. The categories are listed and linked below for your convenience. When you find a book you like, the link will open a new browser window and take you to the free book described.


    Free Online Computer, Web Development, and Programming Books


    Browse Categories:



    Filed under: Free Computer and I.T. Books — computer_teacher @ 10:48 pm


    Top 20 Training and Tutorials Sites on Diggs Programming for last month

    Here are what I am judging to be the best free training and tutorial sites in digg.com's programming category for the last month or so. I have compiled these here so you can see the type of content that we esteem to be valuable here at intelligentedu.com. These cover a variety of subjects and areas, including web development, Ajax, Javascript, CSS, PHP, Firefox extensions, C#, MySQL, Rails, Ruby on  Rails, and free programming books.


    Top 20 Training and Tutorials Sites on Digg's Programming for last month


    15 Exercises for Learning a new Programming Language

    1321 diggs digg it submitted by sickaltima 4 days ago
    Prashant N Mhatre has a working knowledge of several programming languages but job demands to learn a new language frequently in a short time. Prashant shares 15 exercises to master languages quickly.
    72 comments blog this email this


    AJAX Feedback Mechanism

    754 diggs digg it Munzir 7 days ago
    Nifty little mechanism that lets you get user feedback on a page without harassing them. Should be on your site.
    62 comments blog thisemail this category: programming


    PHP - Top Ten Security Vulnerabilities

    734 diggs digg it submitted by Bitruder 2 days ago
    These vulnerabilities can, of course, exist in PHP applications. Here are some tips on how to avoid them. I've included related links and references where relevant.
    24 comments blog this email this


    Converting Windows executables to Mac OS X or Linux binaries

    1348 diggs  digg it submitted by binaryloop 1 day 14 hours ago
    Cody Brocious (PyMusique) is working on a new project to convert Windows executables to native Mac OS X or Linux binaries. He is focusing on high-end gaming at the moment, though he plans to support other apps in the future. On his blog, he said: "My goal for the next 5 years is simple: Any piece of software, any platform you choose."
    109 comments blog this email this


    How to Write FireFox Extensions

    1667 diggs digg it submitted by cdoggydog6621 10 days ago
    Everyone has a good idea at one time or another to implement a new feature in a web browser. Well, with the goodness that is Mozilla Firefox, now you can do just that!
    27 comments blog this email this


    Compilr - Compile C, C#, VB, and Fortran programs online

    746 diggs digg it submitted by dirtyfratboy 10 days ago
    Away from home? No compiler? Type your source code in and have it compiled online. Just choose a language and enter your code in the box. Choose a language by clicking on the language below. You can either use C#, VB.NET, C or Fortran currently.
    51 comments blog this email this


    5 Worthy CSS Tips

    1365 diggs digg it submitted by thedove 21 days ago
    "After reading "5 Steps To CSS Heaven" and disagreeing with some of what was said I thought that writing this would be appropriate...so here are 5 quick tips that help me out in my day to day work. I wouldn't call them best practices because everybody has a style that works for them, but these are what work best for me."
    22 comments blog thisemail this category: programming


    Learn How to Create a Keygen

    1858 diggs digg it submitted by Serendipity 20 days ago
    After reading this, you hopefully will have a better understanding of how programs generate and check serials.
    56 comments blog this email this


    Configuring Rails Environments: The Cheat Sheet

    488 diggs digg it submitted by kevinclark 24 days ago
    A fairly exhaustive list of the options allowed when configuring a Rails application.
    8 comments blog this email this


    Password hashing using PHP and MySQL

    844 diggs digg it submitted by vagabond0101 18 days ago
    This article will explain what a hash is, why you want to use them instead of storing real passwords in your applications, and give you some examples of how to implement password hashing in PHP and MySQL.
    47 comments blog this email this


    The Windows XP Command Line, Batch Files, and Scripting

    1630 diggs digg it submitted by veza 28 days ago
    "The Windows command line is a mainstay for systems administrators and power users but is relatively unknown to many PC users." - Very nice introduction for Batch Files and Scripting.
    102 comments blog this email this


    100+ powerpoint presentations on improving your PHP skills

    1225 diggs digg it submitted by jiminoc 30 days ago
    Nice page on php.net that has a ton of PHP powerpoint presentations from some of the top PHP developers out there. Topics range from Database, Internal Workings, Internationalization, Debugging, Performance and more. Good stuff.
    34 comments blog this email this 


    What's The Secret Sauce in Ruby on Rails?

    582 diggs digg it submitted by BloodJunkie 32 days ago
    Rails isn't a better hammer; it's a different kind of tool. This article explores the compromises and design decisions that went into making Rails so productive within its niche.
    47 comments blog this email this 


    Build RSS reader using AJAX and PHP

    726 diggs digg it submitted by bigdig 34 days ago
    Learn how to build an Asynchronous JavaScript and XML (Ajax) Really Simple Syndication (RSS) reader, as well as a Web component that you can place on any Web site to look at the articles in the RSS feeds.
    18 comments blog this email this


    Learn CSS

    1135 diggs digg it submitted by AndreasA 34 days ago
    This CSS Tutorial will get you started with CSS in just a few minutes. It is easy to understand and will teach you all the sophisticated techniques.
    26 comments blog this email this


    Simple JavaScript Debugging

    527 diggs digg it submitted by wayjer 36 days ago
    Writers edit, architects redraw, and programmers debug. Development environments are usually nice enough to give programmers a bunch of tools to help determine where their program's going wrong. But with JavaScript, your development environment is a web browser, and things aren't quite so hospitable.
    25 comments blog email this


    Cut through AJAX hype

    773 diggs digg it submitted by bigdig 37 days ago
    If you're considering building an Ajax application of your own, you will inevitably need to consider the discussion points in this series. You'll learn about both the potential and the pitfalls inherent to this new technology.
    34 comments blog this email this


    C# FAQ for C++ programmers

    713 diggs digg it submitted by crexor 41 days ago
    Answers many of the questions that C++ developers have when they first encounter C#. Wanna work at NASA, you better read this.
    61 comments blog this email this


    Collection of AJAX Tutorials

    1278 diggs submitted by nks533 40 days ago
    100’s of AJAX Tutorials, Articles & More are linked to here.
    29 comments blog this email this


    195 Free Online Programming Books

    2200 diggs digg it submitted by teenwolf 52 days ago
    Categorized by Language, A Very Nice List
    35 comments blog thisemail this   digg it





    Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 8:48 pm


    June 14, 2006

    58 Developers Cheatsheets

    This post is inspired from Cheet Sheet Roundup. It compiles all of the best cheat sheets linked there, including those in the comments and some of mine own, and puts them all here at your fingertips. Use these Quick References and Cheat Sheets to print, post on your wall, or bookmark for quick reference.


    58 Developer's Cheatsheets


    Web Development Cheat Sheets


    Databases / SQL Cheat Sheets

    Language Cheat Sheets

    Version Control Cheat Sheets

    Other Cheat Sheets

    More cheat sheets

    Techtarget's favorite cheat sheets



    Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:50 pm


    June 13, 2006

    Free PHP and Oracle Manual is Available

    The free Underground PHP and Oracle Manual is hot off the press and now freely available for download.. The OTN team describes it: "Just starting out with PHP database development, or unsure how to install PHP and Oracle? This full-length guide includes everything you need to know (and more)." This PHP / Oracle guide is 124 pages and in pdf format.


    The Underground PHP and Oracle Manual


    Here is the Table of Contents:

    Chapter 1
    • Introduction
    • Who Should Read This Book?
    • Introduction to Oracle
    • Oracle Database Terminology
    • Introduction to PHP
    • Choosing a PHP Oracle Extension
    Chapter 2
    • PHP Oracle Extensions
    •    Oracle Extension
    •    OCI8 Extension
    •    PDO Extension
    • PHP Database Abstraction Libraries
    •    ADOdb
    •    PEAR DB
    •    PEAR MDB2
    • Getting the OCI8 Extension
    • PHP and Oracle Installation Options
    • Zend Core for Oracle
    • PHP Version Numbering
    • OCI8 Function Names in PHP 5
    Chapter 3
    • Installing Oracle Database 10g Express Edition
    • Oracle Database Editions
    • Oracle Database XE
    • Installing Oracle Database XE on Linux
    • Installing Oracle Database XE on Debian, Ubuntu, and Kubuntu
    • Installing Oracle Database XE on Windows
    • Testing the Oracle Database XE Installation
    • Configuring Oracle Database XE
    • Setting the Oracle Database XE Environment Variables on Linux
    • Enabling Database Startup and Shutdown from Menus on Linux
    • Starting and Stopping the Oracle Listener
    • Starting and Stopping the Database
    • Enabling Remote Client Connection
    Chapter 4
    • Using Oracle Database 10g Express Edition
    • Oracle Application Express
    • Logging In To Oracle Application Express
    • Creating Database Object
    • Working with SQL Scripts
    • Creating a PL/SQL Procedure
    • Creating a Database User
    • Monitoring Database Sessions
    • Database Backup and Recovery
    • Backing Up The Database
    • Restoring The Database
    • Oracle Security
    • Security Mechanisms
    Chapter 5
    • Installing Apache HTTP Server
    • Installing Apache HTTP Server on Linux.
    • Starting and Stopping Apache HTTP Server
    • Installing Apache HTTP Server on Windows
    • Starting and Stopping Apache HTTP Server
    Chapter 6
    • Installing Zend Core for Oracle
    • Zend Core for Oracle
    • Installing Zend Core for Oracle
    • Configuring Zend Core for Oracle
    • Testing the Zend Core for Oracle Installation
    Chapter 7
    • Installing PHP
    • Installing PHP on Linux
    • Restart the Apache HTTP Server
    • Installing PHP on Windows
    • Restart the Apache HTTP Server
    Chapter 8
    • Installing PHP With Oracle Instant Client 
    • Installing Oracle Instant Client on Linux
    • Installing Oracle Instant Client on Windows
    Chapter 9
    • Connecting to Oracle Using OCI8
    • Oracle Connection Types
    • Standard Connections
    • Unique Connections
    • Persistent Connections
    • Oracle Database Name Connection Strings
    • Easy Connect String.
    • Full Database Connection String
    • Database Alias
    • Oracle Environment Variables for Connections
    • Closing Oracle Connections
    • Connection Cleanliness with Persistent Connections
    • Optional Connection Parameters
    • Connection Character Set 
    • Connection Privilege Level
    • The Transactional Behavior of Connections
    • Tuning Oracle Connections in PHP
    • Tuning Oracle Net
    • Other Oracle Net Optimizations
    • Tracing Oracle Net.
    • Tuning Persistent Connections
    • Connection Management in Scalable Systems
    Chapter 10
    • Executing SQL Statements With OCI8
    • SQL Statement Execution Steps
    • Query Example
    • Oracle Datatypes
    • Fetch Functions
    • Insert, Update, Delete, Create and Drop
    • Transactions
    • Autonomous Transactions
    • Handling Errors
    • Limiting Rows and Creating Paged Datasets
    • Auto-Increment Columns
    • Tuning SQL Statements in PHP Applications
    • Default Prefetch Size
    • Default Statement Cache Size
    • Using Bind Variables
    • Exploring SQL
    • Regular Expressions in SQL
    • Analytic Functions in SQL
    Chapter 11
    • Using PL/SQL
    • PL/SQL Overview
    • Blocks, Procedures, Packages and Triggers
    • Anonymous Block
    • Stored or Standalone Procedure and Function
    • Package
    • Trigger
    • Calling PL/SQL Procedures and Functions
    • Getting output from PL/SQL with DBMS_OUTPUT
    • Oracle Collections in PHP
    • Using PL/SQL Types in PHP
    • New Array Binding Function in PHP 5.1.2
    • Using REF CURSORS for Result Sets
    Chapter 12
    • Using Large Objects in OCI8
    • Working with LOBs
    • Other LOB Methods
    • Working with BFILEs
    Chapter 13
    • Using XML with Oracle and PHP
    • Fetching Relational Rows as XML
    • Using DBMS_XMLGEN
    • Accessing Data from Oracle over HTTP
    • XQuery XML Query Language
    Chapter 14
    • Globalization
    • Establishing the Environment Between Oracle and PHP
    • Manipulating Strings
    • Determining the Locale of the User
    • Developing Locale Awareness
    • Encoding HTML Pages
    • Specifying the Page Encoding for HTML Pages
    • Specifying the Encoding in the HTTP Header
    • Specifying the Encoding in the HTML Page Header
    • Specifying the Page Encoding in PHP
    • Organizing the Content of HTML Pages for Translation
    • Strings in PHP
    • Static Files
    • Data from the Database
    • Presenting Data Using Conventions Expected by the User
    • Oracle Date Formats
    • Oracle Number Formats
    • Oracle Linguistic Sorts
    • Oracle Error Messages
    Chapter 15
    • Resources
    • General Information and Forums
    • Documentation
    • Articles and Other References
    • Source and Binaries
    • PHP Bugs
    • Utilities
    Glossary



    Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:59 pm


    Freely Available eBooks for Many Technical Subjects

    Chmpdf.com offers free computer ebooks in chm and pdf formats for many technical topics and subjects. You will need to register for free. Here is the full collection achive.


    Subjects covered include the following: Linux, Windows, Ajax, Java, J2EE, .Net (dotNet) Framework, C#, Visual Basic .Net, ASP.Net, UML, Security, Networking, Algorithms, Web Development, PHP, Extreme Programming, Oracle, SQL Server, MySQL, Flash, Wireless Applications, and Cisco (CCNA, CCNP, CCIE).

    Chmpdf.com




    Tags for this post>>

    Filed under: Free Computer and I.T. Books — computer_teacher @ 6:45 pm


    June 12, 2006

    Great Google Searches for Free Certification Study Guides

    Here is an excellent google search for freely available Certification Study Guides (in pdf format).


    Here are some sub-searches to this search, adding a subject keyword:




    Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 12:50 pm


    Next Page »

    Powered by WordPress