ISBN 9788176569644,SQL, PL/SQL - The Prog. Language of Oracle

SQL, PL/SQL - The Prog. Language of Oracle

Author:

Ivan Bayross

Publisher:

BPB Publications

Rs288 Rs360 20% OFF

Availability: Available

Usually ships in: 2-3 business days

(+Rs. 49 Delivery Charges)
Free Shipping if total order amount is Rs . 300 or more.
We Accept
ISBN 9788176569644
Check delivery information
 
ISBN 9788176569644
Publisher

BPB Publications

Publication Year 2009
ISBN-13

ISBN 9788176569644

ISBN-10 817656964X
Binding

Paperback

Edition 4th
Number of Pages 443 Pages
Language (English)
Subject

Programming

An excellent guide for those looking to learn the fundamentals of SQL and PL/SQL using the Oracle software, SQL, PL/SQL: The Programming Language Of Oracle (With CD-ROM) was published in 2010 by BPB Publications.
 
Summary Of The Book
 
Oracle’s Workgroup is the world’s largest selling relational database management system (RDBMS). Delving into both, the basics as well as the advanced details of the SQL and PL/SQL programming language, this informative text can help one become a competent and efficient Oracle application programmer or developer (DBA). This book was written keeping in mind the requirements of programmers, and the need to have a handy reference book.
 
Containing extensive examples and practise exercises, SQL, PL/SQL: The Programming Language Of Oracle (With CD-ROM) has been divided into five sections. The first section is dedicated to the setting up of Oracle 9.1 and offers a step-wise guide to installing and implementing it on a Windows platform. The next section discusses how to set up a business model and delves into Retail Banking and project planning. The third section, Structured Query Language (SQL) provides helpful exercises to learn the SQL syntax. The next section is dedicated to Advance SQL, providing information on cluster indexes, security management and simple SQL performance tuning. The last section is devoted to an introduction to PL/ SQL, security and database objects. The appendix provided before the culmination of the book provides the meanings of different Oracle terms.
 
The complimentary CD-ROM that accompanies this text contains codes as well as answers to the various exercises provided in the book. A source of comprehension and grounding for budding programmers and developers, SQL, PL/SQL: The Programming Language Of Oracle (With CD-ROM) is a must-have to understand the languages used in Oracle.
 
About Ivan Bayross
 
Ivan Bayross is an Indian author, programmer and software developer.
 
He has authored Mastering Database Technology, Using MySQL on Linux, Java Server Programming For Professionals, Database Concepts And Systems For Students, Web Enabled Commercial Application Development Using Java 2.0 and Commercial Application Development Using Oracle Developer 2000.
 
Bayross procured his Master’s degree in Technology from Manchester University in the UK. He has over thirty years of experience in the software industry, and is currently the Chairman of a leading software development house in Mumbai.
 
 
 
TABLR OF CONTENTS : -
 
Section – I: Setting Up Oracle 9.1
1. Database Concepts
 



Installation Of Oracle 9.1


Post Installation Steps


Setting Up Interaction Sql *Plus Tool



 
Section – Ii: Setting Up The Business Model
 



A Business Model For Retail Banking


Project Planning For The Retail Banking Model



 
Section – Iii: Structured Query Langauge (SQL)
 



Interactive SQL Part – I


Interactive SQL Part – Ii


Interactive SQL Part – Iii


Interactive SQL Part -  Iv



 
Section – Iv: Advance SQL
 



Sql Performance Tuning


Security Management Using SQL


Oops In Oracle


Advance Features In Sql *Plus



 
Section – V: Pl / SQL
 



Introduction To Pl/SQL


PL / SQL Transaction


PL/SQL Security


PL/SQL Database Objects


Scroll