Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
0-9823061-0-5 
ISBN 13
978-0-9823061-0-9 
Library of Congress Number:xxxx
260 pages:
Perfect bind - 9x7
PD 911
Shelving: Databases/Oracle Easy Oracle Series
# 9

  Easy Oracle SQL
Get Started Fast writing SQL Reports with SQL*Plus
Second Edition

John Garmany      

Retail Price $27.95 USD /  £18.95 / $30.95 Canadian

Order now at 30% off and get access to the code depot! Only $19.95
(30% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     

This second edition, authored by distinguished Oracle veteran, John Garmany, is an indispensable guide for any Oracle professional who must quickly implement Oracle reporting.   John's decades of SQL*Plus experience come to bear in this indispensible book.  New tips and tricks have been included in this cutting edge edition.

In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for SQL and SQL*Plus beginners.  This book is intended for anyone who needs to extract Oracle data and format reports.  John reveals even more secrets for quickly and easily producing stunning reports from Oracle.

Unknown to most Oracle professionals, special SQL extraction techniques and SQL*Plus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, John Garmany's exciting second edition shares more working samples in his online code depot than before. 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 SQL*Plus 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 SQL*Plus 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.


 

 

 
Key Features

* Get detailed explanations of using Oracle’s SQL*Plus and SQL Worksheet.

* Comes with an expanded 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 SQL*Plus to create detailed reports.

* Learn by example as each section contains exercises to test your understanding.

* Contains even more working SQL*Plus scripts to get you started fast.

* Presents tricks for writing complex SQL in incremental stages.

About the Author:

John Garmany

 

John Garmany has been working as an Oracle DBA since 2002.

Table of Contents:


 

 

Index Topics:
     

Reader Comments
 


Errata:
 
 


 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks