Easy Oracle Sql

Written by a distinguished graduate of West Point, Col. Garmany leverages his 20+ years of experience into an indispensable guide for any Oracle professional who must quickly implement Oracle reporting. A noted instructor, author and lecturer, Col. John Garmany leverages his ability to explain complex issues in Plain English into a one-of-a-kind book. John Garmany targets his decades of SQLPlus experience into this must-have book. Intended for anyone who needs to extract Oracle data and format reports, John reveals the secrets of quickly and easily producing stunning reports from Oracle.

Unknown to most Oracle professionals, special SQL extraction techniques and SQLPlus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, Colonel Garmany shares dozens of working samples in his online code depot. Your time savings from a single script is worth the price of this great book.

Easy Oracle SQL is your introduction to using SQL and SQLPlus with an Oracle database. Whether you are just learning SQL or just need a handy reference, this book will provide you with proven methods to building queries and reports using SQL. Each concept is explained in detail with multiple examples and exercises at the end of each section. Also included is a section detailing how to effectively use SQLPlus to not only create and run queries but also to create quality reports and scripts. This book will have you up and using SQL quickly and efficiently.

• Get detailed explanations of using Oracle’s SQLPlus and SQL Worksheet.
  
• Comes with an online code depot with working examples of Oracle reports.
  
• Understand the Oracle database including tables, rows and columns.
  Learn all basic SQL Clauses, SELECTs, JOINs, WHEREs, and Grouping.
  
• Learn to modify data using INSERTs, UPDATEs and DELETEs.
  Create and manage Tables, Views and Materialized Views.
  
• Use Oracle’s Data Dictionary to find information.
  
• Learn to increase SQL performance using Indexes.
  
• Use SQLPlus to create detailed reports.
  
• Learn by example as each section contains exercises to test your understanding.
  
• Shows how to incorporate Oracle8i analytic functions in Oracle reports.
  
• Contains working SQLPlus scripts to get you started fast.
  
• Presents tricks for writing complex SQL in incremental stages.

About the Author
Colonel John Garmany is a Senior Oracle DBA with Burleson Consulting. A graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point. A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and SearchOracle and SELECT Magazine. John is also the author of four bestselling Oracle books by Rampant TechPress, Oracle Press and CRC Press and hosts a popular Oracle Application Server Newsletter.