Pragada S. Oracle Database 12c For Beginners

Srikanth Technologies, 2016. — 462 p. — ASIN: B01HAZC50UOracle Database has been the most widely used for nearly 4 decades. A lot of corporates use Oracle for their critical data.
In this book, I look at Oracle Database 12c from programmer’s point of view. This book is a must for all those who want to learn Oracle Database and use it as Database Management System for their applications.
I started working with Oracle 5.1 in the year 1993 and have been training people on Oracle Database. The popularity of Oracle has been constant all these years. However, Oracle has changed its direction from Internet (Oracle 8i, 9i) to Grid Computing (Oracle 10g, 11g) to Cloud Computing (Oracle 12c).
I have covered all important topics related to Oracle Database, from fundamental concepts to advanced concepts. I used a simple set of Tables so that any reader can easily understand them without any prior knowledge about databases.
Focus in this book has been on SQL and PL/SQL along with important concepts in Relational Databases like constraints, views, indexes, security and queries.
PL/SQL is the language used to create stored procedures, functions, packages and database triggers. So, understanding PL/SQL is very important for any Oracle Developer. Apart from control structures, cursors, exception handling and collections, I covered program units, dynamic SQL and LOBs.
Developers at times perform some administrative tasks related to their small set of tables. In this regard, I felt it is important to cover utilities related to backup, recovery and data loading.
This book is a single source of information for anyone who uses Oracle Database as backend for their applications.