ISBN 9788120340206,Oracle Database 11G : Hands-On Sql And Pl/Sql

Oracle Database 11G : Hands-On Sql And Pl/Sql





PHI learning Pvt Ltd

Publication Year 2010

ISBN 9788120340206

ISBN-10 8120340205


Number of Pages 448 Pages
Language (English)
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, the book 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. Key Features : Includes numerous practical examples with code. Discusses commands executed and tested on the Oracle database software. Provides a large number of review questions, true/false and multiple choice questions along with lab assignments, at the end of each chapter. Includes new features of Oracle Database 11g. Presents normalization and ER-diagrams. Discusses database triggers and Oracle flashback technology. Gives Oracle FAQs.