440: Parlez-Vous Klingon? Recursion SQL for Database Magicians
Alexander Kopac , Database-Brothers, Inc    Biography

Objectives: Learn how to create simple SQL recursive queries replacing hundreds of lines of SQL code
Learn how DBA's & application programmers can use SQL recursive queries for overall performance
Learn various data masking techniques & why data type selection in SQL is important for performance
Abstract: Recursive SQL now runs on most RDBMS versions. Often when the words 'recursive query' are spoken, application developers/DBA's may hear a 'klingon' or guttural groan. Here's a step-by-step explanation of SQL recursive queries to quickly spin thru data. See how recursive Stored Procedures & PL/SQL scripts gathers data without a need to compile a C/COBOL/Java pgms. Parts 1-3 explain recursive queries in simple terms and give lots of examples to take back to the office. In your near-future work life, you may hear 'Data Disguise Required' meaning that 'use of data derived from relationships for purposes of testing, research, training, or publication will be confined to content that is disguised to ensure the anonymity of the individuals involved'. Part 4 shows generating data techniques and helps you become a 'Master of Data Disguise'. Recursion between other relational databases will be discussed.

Audiernce Focus: Developers
Expertise: Intermediate
Track: Development
Date: Tuesday, April 15, 2008
Time: 4:45 PM - 5:45 PM