Realistic Software Training
Contact RST
Author, Trainer, Consultant

Specializing in Oracle, Java, Data Warehouse Design and ETL

John Palinski is an accomplished writer. The courses he teaches are based upon his writing. You will find the writings and course topics very useful. John focuses on the topics you need to know to get the job done. His materials are part how-to and reference. Their intent is to get the student/reader up-and-running quickly and continue to be useful as the reader increases in ability. Review the publications and see that John has a very broad range. Much of this writing is included in his courses.

Books

"Oracle9i Developer: Developing Web Applications with Forms Builder", John Adolph Palinski, Course Technology, 2002

"Oracle SQL and PL/SQL Handbook", John Adolph Palinski, Addison Wesley Longman, 2002

"Oracle Database Construction Kit", John Adolph Palinski, QUE, 1997

Periodicals

"Building Your Own Tablespace Monitor Part 3 of 3", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Dec. 7, 2004

"Building Your Own Tablespace Monitor Part 2of 3", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Nov. 23, 2004

"Building Your Own Tablespace Monitor Part 1of 3", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Nov. 9, 2004

"A Simple Tool Free Method of Creating Large DBA Command Files", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Oct. 26, 2004

"Using the Insert All Statement to Easily Create Summary Tables", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Oct. 12, 2004

"Gee, I Wish I Hadn't Dropped That Table!!", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Sep. 20, 2004

"A Simple Technique for Sorting Pre-Oracle 10g Hierarchical Query Result Sets", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Sep. 6, 2004

"Oracle's Hierarchical Query and New 10g Enhancements", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Aug. 20, 2004

"Oracle's Merge Statement as an ETL Tool", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Aug. 13, 2004

"Oracle's Enhanced Group By Clause Part 2", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), July 22, 2004

"Oracle's Enhanced Group By Clause Part 1", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), July 15, 2004

"Using Oracle10g's New Regexp Instr() Function in Place of the Traditional Instr() Function", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), July 8, 2004

"Improving Performance Using the With Clause", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), June 17, 2004

"Using Oracle10g's Regexp_substr Function in Place of the Traditional Substr Function", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), May 28, 2004

"Using Oracle10g's Regexp_like operator in Place of the Traditional Like Function", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), May 3, 2004

"Controlling the "ORA-0491: table is mutating" Error With Autonomous Transactions", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Apr. 29, 2004

"Scalar Functions Can Make Tough Queries Easier", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Apr. 9, 2004

"The Ratio-to-Report Function - An Easy Way to Help Report Readers Evaluate Values", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Mar. 26, 2004

"Using the Ratio-to-Report Function - A Technique to Add Sub Totals to the Result Set", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Mar. 19, 2004

"Returning Reader Comments From an Oracle Reports Builder 9i Report", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Feb. 16, 2004

"A Tough Query: Filtering Records Based Upon Previous Result Set Records", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Feb. 12, 2004

"Spicing Your Reports With Future Predictions", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Jan. 29, 2004

"A New Way of Joining Oracle Tables? Why Would I Want to Change?", John Adolph Palinski, The SQL Server Worldwide User's Group (www.sswug.com), Jan. 16, 2004

"Using Cursor Variables and Procedures With an Oracle Form Builder Data Block", Oracle Professional, Nov. 2001

"Using Cursor Variables With Oracle's Report Builder", John Adolph Palinski, Oracle Internals, June, 2001

"Using Cursor Variables", John Adolph Palinski, Oracle Internals, May, 2001

"Using Oracle's Developer 6i to Create a Record Directory - A User's Favorite Application", John Adolph Palinski, Oracle Internals, Feb. 2001

"Populating Oracle Form Hierarchies Incrementally at Run Time", John Adolph Palinski, Oracle Internals, December, 2001

"Using Hierarchical Tree Items in Oracle's Developer 6i", John Adolph Palinski, Oracle Internals, November, 2000

402-636-3171
402-339-7493
Last updated: Nov. 20, 2004

 

Home

SQL and PL/SQL Handbook
Oracle 9i Developer
Database Construction Kit