Oracle’s Workgroup is the world’s largest selling relational database management system (RDBMS). Delving into both, the basics as well as the advanced details of the SQL and PL/SQL programming language, this informative text can help one become a competent and efficient Oracle application programmer or developer (DBA). This book was written keeping in mind the requirements of programmers, and the need to have a handy reference book. Containing extensive examples and practise exercises, SQL, PL/SQL: The Programming Language Of Oracle (With CD-ROM) has been divided into five sections. The first section is dedicated to the setting up of Oracle 9.1 and offers a step-wise guide to installing and implementing it on a Windows platform. The next section discusses how to set up a business model and delves into Retail Banking and project planning. The third section, Structured Query Language (SQL) provides helpful exercises to learn the SQL syntax. The next section is dedicated to Advance SQL, providing information on cluster indexes, security management and simple SQL performance tuning. The last section is devoted to an introduction to PL/ SQL, security and database objects. The appendix provided before the culmination of the book provides the meanings of different Oracle terms. The complimentary CD-ROM that accompanies this text contains codes as well as answers to the various exercises provided in the book. A source of comprehension and grounding for budding programmers and developers, SQL, PL/SQL: The Programming Language Of Oracle (With CD-ROM) is a must-have to understand the languages used in Oracle.
|Number Of Pages||443|