Intelligentedu
Best New Free Computer IT Training Tutorial Resources
Translate to EnglishÜbersetzen Sie zum Deutsch/GermanΜεταφράστε στα ελληνικά/GreekПереведите к русскому/RussianOversetter til Norsk/NorwegianÖversätta till Svensk/Swedishहिन्दी अनुवाद करने के लिए/Hindi
Tradueix al català/CatalanTulkot uz latviešu/LatvianPreložiť do slovenčiny/SlovakVertaal aan het Nederlands/Dutchترجمة الى العربية/ArabicTraduzca al Español/SpanishTraduisez au Français/French
Traduca ad Italiano/ItalianTraduza ao Português/Portuguese日本語に翻訳しなさい /Japanese한국어에게 번역하십시오/Korean中文翻译/Chinese Simplified中文翻译/Chinese TraditionalПереклад на українську/Ukrainian


 



     Blog Roll:


     Top Links:

June 20, 2006

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
  • Popularity: 5% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Free Java Guide for Java, SQL and PLSQL Tutorials
  • Learning Guides for XML, XML Security, and Web Services Security
  • Free Books for MySQL, Oracle 10g Database, PL/SQL and SQL
  • Free Training for Oracle 10g and 9i
  • Free SCJP Practice Exams and Java Tutorials


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


    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.

    Popularity: 4% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Learning Guides for XML, XML Security, and Web Services Security
  • 23 Free Cisco Study Guides
  • 40 Programming Ebooks
  • 49 Computer and I.T. Books Freely Available
  • Many Computer Ebooks and Online Books


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


    June 22, 2006

    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


    Popularity: 6% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • 222 Open Source Online Books and Tutorials
  • Technical, Programming, and Web Development Books and Ebooks
  • Freely Available Technical Computer Books
  • Linux in Plain English
  • Free Linux Quick Command Reference Book


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


    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

    Popularity: 5% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Free J2EE Programming Instructor-led Online Course
  • Free Training for J2EE Programming
  • Core and Enterprise Java Tutorials by Srikanth
  • The Java Series - Free Online Books
  • Free Java Training Videos, Books and Tutorials!


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


    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

    Popularity: 6% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • 15 Linux eBooks
  • 8 Free Programming Books: C++, C Sharp, Java, Linux
  • Learning Guides for XML, XML Security, and Web Services Security
  • 49 Computer and I.T. Books Freely Available
  • Many Computer Ebooks and Online Books


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


    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

    Popularity: 5% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Learning Guides for XML, XML Security, and Web Services Security
  • 23 Free Cisco Study Guides
  • 40 Programming Ebooks
  • 49 Computer and I.T. Books Freely Available
  • Many Computer Ebooks and Online Books


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


    June 26, 2006

    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

    Popularity: 8% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Books on C++, C#, Linux, Perl, Web Programming, Oracle SQL
  • 13 Web Services Tutorials
  • Free Security Training by Microsoft and Learning How to Program in C++
  • 40 Programming Ebooks
  • 11 EJB and J2EE Tutorials


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


    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

    Popularity: 5% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Cookbooks for PHP, Python, Text Scripting, Tcl, and XSLT
  • Linux Client Migration Cookbook for Migrating to Desktop Linux
  • Linux Client Migration Cookbook - Version 2
  • 139 Freely Available Computer Books
  • Computer, Programming, Web, OS, and IT Books


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


    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

    Popularity: 5% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Certification Exam Study Guides: A+ i-Net, Security+, CCNA, 70-270
  • Windows Server Reference Guide
  • Free Certification Prep for CIW, CompTIA, Cisco, and Microsoft MCSE
  • .NET Reference Guide
  • Free Cisco Books, Guides, and Manuals


  • Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 1:09 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.



    Popularity: 8% [?]

    Share and Enjoy:
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg

    Related Posts:
  • Learn How to Write Regular Expressions
  • PHP Regular Expressions Tutorial
  • Free Shell Scripting Course
  • 16 Programming eBooks for Python, Bash, Regex
  • 10 Ebooks on Linux and Solaris


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


    « Previous PageNext Page »

    Powered by WordPress