Availability: Out of Stock
0.0 / 5
Publisher | BPB Publications |
Publication Year | 2017 |
ISBN-13 | 9789386551177 |
ISBN-10 | 9789386551177 |
Binding | Paperback |
Number of Pages | 592 Pages |
Language | (English) |
Weight (grms) | 1080 |
This textbook aims at familiarizing the students and professional developers with SQL and pathologies/SQL. This textbook provides a detailed explanation of the basic as well as advanced features of SQL and pathologies/SQL such as data manipulation and transaction, schema objects (sequences, views, materialized views and Synonyms) built-in functions, exception handling, cursors and triggers, subprograms and so on. The systematic explanation of source code with suitable examples, a unique feature of the text book, enables students to gain a thorough and practical understanding of Oracle. Moreover, the chapters in the textbook are structured in a pedagogical sequence that makes it very effective in learning the key features and capabilities of Oracle database. Table of Contents: br>Chapter 1: Introduction to Oracle database br>Chapter 2: Introduction to SQL plus br>Chapter 3: retrieving data in SQL br>Chapter 4: Data manipulation and transaction br>Chapter 5: creating & managing schema objects br>Chapter 6: built-in functions in Oracle br>Chapter 7: Introduction to pathologies/SQL br>Chapter 8: exception handling in pathologies/SQL br>Chapter 9: cursors and triggers br>Chapter 10: pathologies/SQL subprograms br>Chapter 11: pathologies/SQL packages br>Chapter 12: Oracle database security index.
Prof. Sham Tickoo
,TIET
BPB Publications