Oracle Database 12C Hands-on SQL and PL/SQL

0 avg rating
( 0 ratings by Goodreads )
 
9788120351516: Oracle Database 12C Hands-on SQL and PL/SQL

This book teaches the basics of the Oracle database, from a beginner's perspective to advanced concepts, using a hands-on approach. Each concept is explained with practical examples and code for clear and precise understanding of the topic. Using a practical approach, this new edition covers the detailed introspection of pluggable databases and explains practically the various new features incorporated in the new 12c version. It also explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. The book is suitable for undergraduate engineering students of computer science and information technology, and students of computer applications. It can also be used as a reference by professionals pursuing short-term courses covering the Oracle database and students of Oracle certified courses.

"synopsis" may belong to another edition of this title.

About the Author:

Satish Asnani is currently Senior Manager, Informatics Division, Bharat Heavy Electricals Limited, Bhopal, India. He is a Red Hat Certified Engineer (RHCE) for administration of Linux-based servers and also a Certified Internal Information Security Auditor (CIISA) from STQC, India. Mr. Asnani has more than 15 years of experience in database design, application development and implementation of several 2-tier and 3-tier projects using Oracle Database and Oracle Developer 2000. He has worked on wide range of web technologies also like ASP, ASP.NET and JSP and has been a speaker on various topics in renowned institutions.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

ASNANI
Published by PHI Learning Pvt. Ltd.
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Quantity Available: 10
International Edition
Seller:
BookVistas
(New Delhi, DELHI, India)
Rating
[?]

Book Description PHI Learning Pvt. Ltd. Book Condition: New. International Edition. Bookseller Inventory # PHI-9788120351516

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 9.24
Convert Currency

Add to Basket

Shipping: US$ 4.71
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

ASNANI
Published by PHI Learning Pvt. Ltd.
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Quantity Available: 10
International Edition
Seller:
A - Z Books
(New Delhi, DELHI, India)
Rating
[?]

Book Description PHI Learning Pvt. Ltd. Book Condition: New. International Edition. Bookseller Inventory # PHI-9788120351516

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 9.24
Convert Currency

Add to Basket

Shipping: US$ 5.89
From India to U.S.A.
Destination, Rates & Speeds

3.

Satish Asnani
Published by PHI Learning (2015)
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Softcover Quantity Available: > 20
Seller:
BookVistas
(New Delhi, DELHI, India)
Rating
[?]

Book Description PHI Learning, 2015. Softcover. Book Condition: New. 2nd edition. Description: The book teaches the basics of the Oracle database from a beginner?s perspective to the advanced concepts using a hands-on approach. Each and every concept has been elaborated with suitable practical examples along with code for clear and precise understanding of the topic. Using a practical approach, this new edition of the book covers the detailed introspection of pluggable databases and explains practically the various new features incorporated in the new 12c version. It also explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. Contents: Preface Acknowledgements 1. Introduction to DBMS and RDBMS 2. Installation of Oracle 10g XE (Express Edition) 3. Introduction to Oracle 4. Oracle Data Types 5. Oracle Operators 6. Integrity Constraints 7. Oracle Built-in Functions 8. Adding, Deleting and Modifying Records 9. Sorting 10. Table Operations?Altering Structure 11. Joins 12. Advanced Queries Using Special Operators 13. Indexing 14. Oracle Security?Privileges 15. Oracle Security?Roles 16. Sequences and Synonyms 17. Views and Materialized Views 18. SQL*Plus Reporting 19. PL/SQL 20. Stored Functions 21. Stored Procedures 22. Oracle Packages 23. Exception Handling in PL/SQL 24. Cursors 25. Database Triggers 26. Oracle Flashback Technology 27. Normalization 28. Entity Relationship Diagram (ERD) 29. Oracle FAQ 30. Oracle 11g New Features 31. Installation of Oracle Database 12c 32. New Features in Oracle 12c 33. Working More with CDB and PDBs 34. Plugging and Unplugging PDBs 35. Transaction Handling Index Printed Pages: 544. Bookseller Inventory # 104387

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 10.63
Convert Currency

Add to Basket

Shipping: US$ 4.70
From India to U.S.A.
Destination, Rates & Speeds

4.

Satish Asnani
Published by PHI Learning (2015)
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Softcover Quantity Available: > 20
Seller:
A - Z Books
(New Delhi, DELHI, India)
Rating
[?]

Book Description PHI Learning, 2015. Softcover. Book Condition: New. 2nd edition. Description: The book teaches the basics of the Oracle database from a beginnerâs perspective to the advanced concepts using a hands-on approach. Each and every concept has been elaborated with suitable practical examples along with code for clear and precise understanding of the topic. Using a practical approach, this new edition of the book covers the detailed introspection of pluggable databases and explains practically the various new features incorporated in the new 12c version. It also explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. Contents: Preface Acknowledgements 1. Introduction to DBMS and RDBMS 2. Installation of Oracle 10g XE (Express Edition) 3. Introduction to Oracle 4. Oracle Data Types 5. Oracle Operators 6. Integrity Constraints 7. Oracle Built-in Functions 8. Adding, Deleting and Modifying Records 9. Sorting 10. Table Operationsâ"Altering Structure 11. Joins 12. Advanced Queries Using Special Operators 13. Indexing 14. Oracle Securityâ"Privileges 15. Oracle Securityâ"Roles 16. Sequences and Synonyms 17. Views and Materialized Views 18. SQL*Plus Reporting 19. PL/SQL 20. Stored Functions 21. Stored Procedures 22. Oracle Packages 23. Exception Handling in PL/SQL 24. Cursors 25. Database Triggers 26. Oracle Flashback Technology 27. Normalization 28. Entity Relationship Diagram (ERD) 29. Oracle FAQ 30. Oracle 11g New Features 31. Installation of Oracle Database 12c 32. New Features in Oracle 12c 33. Working More with CDB and PDBs 34. Plugging and Unplugging PDBs 35. Transaction Handling Index Printed Pages: 544. Bookseller Inventory # 104387

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 10.63
Convert Currency

Add to Basket

Shipping: US$ 5.88
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

5.

Satish Asnani
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Softcover Quantity Available: > 20
International Edition
Seller:
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Book Condition: New. 2nd edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS with tracking number. Choose expedited shipping for superfast delivery 2-4 business days by DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Bookseller Inventory # LPBDIN41561633

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 12.92
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds

6.

Asnani, Satish
Published by Prentice-Hall of India Pvt.Ltd (2016)
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Softcover Quantity Available: 1
Rating
[?]

Book Description Prentice-Hall of India Pvt.Ltd, 2016. Book Condition: New. Num Pages: 544 pages. BIC Classification: UY. Category: (U) Tertiary Education (US: College). Dimension: 181 x 234 x 26. Weight in Grams: 842. . 2016. 2nd Revised edition. Paperback. . . . . . Bookseller Inventory # V9788120351516

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 25.55
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

7.

Asnani, Satish
Published by Prentice-Hall of India Pvt.Ltd
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Softcover Quantity Available: 1
Seller:
Kennys Bookstore
(Olney, MD, U.S.A.)
Rating
[?]

Book Description Prentice-Hall of India Pvt.Ltd. Book Condition: New. Num Pages: 544 pages. BIC Classification: UY. Category: (U) Tertiary Education (US: College). Dimension: 181 x 234 x 26. Weight in Grams: 842. . 2016. 2nd Revised edition. Paperback. . . . . Books ship from the US and Ireland. Bookseller Inventory # V9788120351516

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 25.71
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

8.

Asnani, Satish
Published by Prentice-Hall of India Pvt.Ltd (2016)
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Quantity Available: 1
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Prentice-Hall of India Pvt.Ltd, 2016. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # GB-9788120351516

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 15.36
Convert Currency

Add to Basket

Shipping: US$ 11.88
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Satish Asnani
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Paperback Quantity Available: 1
Seller:
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Paperback. Book Condition: New. Not Signed; This book teaches the basics of the Oracle database, from a beginner's perspective to advanced concepts, using a hands-on approach. Each concept is explained with practical examples and code for clear and precise understanding of the topic. Using a practical approach, this new edition covers the det. book. Bookseller Inventory # ria9788120351516_rkm

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 22.97
Convert Currency

Add to Basket

Shipping: US$ 5.12
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Satish Asnani
ISBN 10: 8120351517 ISBN 13: 9788120351516
New Quantity Available: 1
Seller:
Speedy Hen LLC
(Sunrise, FL, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # ST8120351517. Bookseller Inventory # ST8120351517

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 29.50
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book