All items that have the "Cash on Delivery Available" icon are valid for order by Cash on Delivery.
Add the item(s) to your cart and proceed to checkout. When prompted to choose a payment option, select "Pay By Cash on Delivery". Enter the CAPTCHA text as shown, for validation.
Once verified and confirmed, your order will be processed for shipment in the time specified, from the date of confirmation. You will be required to make a cash-only payment to our courier partner at the time of delivery of your order to complete the payment.
Terms & Conditions:
|30 days from delivery||Damaged, Defective, Item not as described||Replacement|
|30 days from delivery||Exchange for colors and size, Does not fit||Exchange|
|10 days from delivery||Damaged, Item not as described||Replacement|
This book was written to try and provide an excellent grounding to those who wish to learn SQL and PL/SQL (a superset of SQL) using Oracle. A thorough grounding in both is absolutely necessary to become a competent Oracle application programmer or DBA. The examples and hands on exercises help build your skills until a strong programming foundation using the natural language of Oracle has been established.
Section 1 takes you step by step through installing and setting up Oracle 9i on a Windows computer, as well as setting up, configuring and using Oracle's Interactive SQL*Plus Tool
Section 2: Broadly explains Retail Banking and its project planning.
Section 3: Starts developing interactive SQL syntax. You will learn through hands on exercises most of the SQL syntax you will use throughout your professional application development life. Here a completely new and updated section covering Dynamic SQL has been included.
Section 4: A new section describing indexes, especially cluster indexes has been added. Cluster indexes are very commonly used in a host of commercial applications. SQL performance tuning and simple security management has also been addressed.
Section 5: Cursors have been expanded quite a some useful examples of DBMS_SQL added is covered in some depth and made simple bit. Cursor syntax is often a slightly neglected area. There are as well. Locking, a subject that is often ignored completely to understand.
Appendix: This has applications. knowledge. fit in the been expanded to cover several Oracle terms that you will encounter when creating Oracle These terms are especially useful when searching Google for information to expand your Each topic is very liberally sprinkled with examples that are mapped to applications, which real world.
Contents Of The CD-ROM
The Complementary CD-ROM accompanying this book provides the book codes as wellas the solutions to the hands-on exercises covered.
About The Author
The author Ivan Bayross is an M. Tech in DBMS from Manchester University UK. He has spent more than 30 years in the software industry rising from the ranks in the IT industry. He started as a programmer, moVed up to CIO, and is now the Chairman and Technology lead, in a software development house at Mumbai, India. He specializes in multi-tier, client/server, application development.
Table 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 Database Objects
|Edition||4th Revised Edition|
|Number of Pages||443 Pages|
The book contains all the necessities you need to know to learn PL/SQL. Great book for beginners in PL/SQL.
The print is good and it generates interest to learn PL/SQL in you,make sure you have one copy of this book if you are interested in learning the language.
I was looking for a comprehensive, from-the-scratch reference material when I found this book. And to be honest, I am not at all disappointed. The book includes every single step, from setting up Oracle on your system to its detailed and in-depth functionality tour. If you are looking for a book to freshen up your basics or you just want to start from scratch then look no further, this is the book for you!
This book by Ivan Bayross is pivotal if you are knowing your way through SQL. Its great for quickly checking the syntax of various commands. I've been using it as a reference for three years now. Many of my friends have also bought. Prices are good. Its great value for money. Its very helpful for students as well as developers.
Flipkart packing & delivery were good.
This book is good.But the approach is not practical.Being a software professional,I can tell u that the tables upon which the examples are written,are really a burden for grasping sql quickly and effectively.This book is not so interactive.Very boring and traditional approach is used while writing this book.
Go for Head First Sql.Really a great one for learning.
This book support old version of oracle ,and written for oracle 9.
If you are looking for 11g or something dont buy this book.
If you are looking only for concepts then a must book to read.
Thing are explained in very basic way and is good for the learners who are new to SQL
Customers Who Bought This Book Also Bought