Oracle Database 12c : Hands-On SQL And PL / SQL

Oracle Database 12c : Hands-On SQL And PL / SQL by Satish Asnani

---

Book Summary:

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.

The book is suitable for undergraduate engineering students of Computer Science and Information Technology, B.Sc. (Computer Science/IT), M.Sc. (Computer Science/IT) and students of Computer Applications (BCA, MCA, PGDCA, and DCA). Besides, the book can be used as a reference by professionals pursuing short-term courses on Oracle Database and students of Oracle Certified Courses.

Audience of the Book :

This book Useful for BCA, MCA, PGDCA, and DCA Student.

Table of Contents:

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