Buy Books Online > Information technology: general issues > Oracle for Professionals: 1 (X-Team)
Oracle for Professionals: 1 (X-Team): Book by Sharanam Shah

Oracle for Professionals: 1 (X-Team)

Product Details:    Share this by email:

ISBN: 9788184045260    Publisher: Shroff Publishers and Distributors Pvt. Ltd; 1 edition Year of publishing: 2014     Language: English
Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same...Read more
Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly used business database models. It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle's flagship database management system along with existing features found in Oracle Database 9i and 10g. TOPICS COVERED IN THE BOOK Overview Of Oracle DatabaseIntroduction, Architecture, Installation, Tablespace/User Management, SQL Plus, SQL Developer Basics Of SQLEntity Relationship Diagram, Data Types, Working with Database Tables, Multi-Table Insert Statements, Merging Rows, Altering Table Structures, Synonyms, External Tables, Data Constraints Working with DataOperators, Character/String Functions, Number Function, Date Functions, Grouping Data, Subqueries, Joins, Union, Intersect and Minus, Analytic Functions, Modeling Data, Hierarchical SQL Queries, If, then and Else, Pivot/Unpivot Operators, Regular Expressions, RowlD and RowNum SQL Performance TuningIndexes, Views, Clusters, Sequences Beyond The BasicsFlashback, Objects and Collections, Oracle Text, XML PL/SQLIntroduction To PL/SQL, Transactions, Cursors, Procedures and Functions, Packages, Triggers, Automatically Generating and Assigning Primary Key Values, Dynamic SQL, DML Error Logging Backup, Restore and Data LoadingIMP and EXP, Data Pump - IMPDB and EXPDB, SQL*Loader Application DevelopmentJava, PHP, Pro C/C++ Scripting In OracleSQL Scripts, PL/SQL Scripts Data WarehouseOracle Warehouse Builder AppendixSample Data, Installing Oracle Database 10g XE, Interview Questions CONTENTS OF THE CD-ROMSetup files for Oracle database 10g eXpress Edition.
Read less
About the author: Sharanam Shah
The author Sharanam Shah has 7+ years of IT experience as a Developer, Database Designer, Technical Writer, Systems Analyst and a Lead Architect. He currently... Read more
The author Sharanam Shah has 7+ years of IT experience as a Developer, Database Designer, Technical Writer, Systems Analyst and a Lead Architect. He currently consults with several software houses in Mumbai, India, to help them design and manage database applications.Vaishali Shah, his wife, co-author and a Technical Writer by profession, has a rich experience of designing, developing and managing database systems. Their desire to share the knowledge they we acquired over all these years working together and perhaps partially to keep it available and alive made them co-author and publish several books, most of them tightly focused on commercial application development using software tools.
Read less

Other books by Sharanam Shah

Recommended Books for you - See all

Price: Rs. 1170   Rs.1158
You save: Rs.12
Vendor : Sunidhi Ventures Inc., Mumbai
BUY NOW

FREE SHIPPING | Delivered in 5 working days

(Cash on delivery available)

Be assured. 7 days Return & Refund Policy.
Click here

Rs.200 OFF

on purchase of Rs.500 & above

1.Click on Add to Cart & Proceed to Checkout
2.Under payment options, choose
"Redeem Coupon Code/Gift Certificate"
3.Enter Promo Code "SHOP200"
4.Get Rs.200 off, Pay Balance Amount

Valid upto 21st July,13

Rs.200 OFF

on purchase of Rs.500 & above

Terms & Conditions