Synopsis
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.
Search results for Oracle Database 12c Hands-On SQL and PL/SQL
Stock Image
Oracle Database 12c : hands on SQL and PL/SQL
Seller: Vedams eBooks (P) Ltd, New Delhi, India
Seller rating 4 out of 5 stars
Soft cover. Condition: New. 2nd Edition. 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 OperationsAltering Structure 11. Joins 12. Advanced Queries Using Special Operators 13. Indexing 14. Oracle SecurityPrivileges 15. Oracle SecurityRoles 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. Seller Inventory # ABE-1629717130321
Stock Image
Oracle Database 12C Hands-On Sql And Pl/Sql
Published by
Prentice-Hall Of India Pvt.Ltd, 2016
ISBN 10: 8120351517
ISBN 13: 9788120351516
New
Paperback
Seller: Revaluation Books, Exeter, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Brand New. 2nd revised ed edition. 544 pages. 9.13x6.85x1.02 inches. In Stock. Seller Inventory # __8120351517
Buy New
US$ 26.13
US$ 16.73 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available