Database systems using Oracle : a simplified guide to SQL and PL/SQL

By:

Shah, Nilesh

Material type: Text

TextPublication details: Noida Pearson 2015Edition: 2nd EdDescription: xxiv,432 p. PbkISBN:

978-9332549722

Subject(s):

Relational databases Oracle - Computer file

DDC classification:

001.642 SHA

Online resources:

Click here to access online

Contents:

I. RELATIONAL DATABASE CONCEPTS. 1. Database Concepts: A Relational Approach. 2. Database Design: Data Modeling and Normalization. II. ORACLE SQL. 3. Oracle 9i: An Overview. 4. Oracle Tables: Data Definition Language (DDL). 5. Working with Tables: Data Manipulation and Retrieval. 6. Working with Tables: Functions and Grouping. 7. Multiple Tables: Joins and Set Operators. 8. Subqueries: Nested Queries. 9. Advanced Features: Objects, Transactions, and Data Control. SQL Review: Review of SQL Statements Covered in Chapters 3-9 with a Sample Database. III. PL/SQL. 10. PL/SQL: A Programming Language. 11. More on PL/SQL: Control Structures and Embedded SQL. 12. Cursors and Exceptions. 13. PL/SQL Composite Data Types: Records, Tables, and Varrays. 14. PL/SQL Named Blocks: Procedure, Function, Package, and Trigger. IV. ADVANCED TOPICS. 15. Connecting to Oracle Database: JDBC, SQLJ. 16. Oracle 9i Architecture and Administration. Appendix

Summary: Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a valuable future reference. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.

Tags from this library: No tags from this library for this title. Log in to add tags.

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
Books	H.T. Parekh Library	GSB Collection	001.642 SHA (Browse shelf(Opens below))	Available		B2363

Browsing H.T. Parekh Library shelves, Collection: GSB Collection Close shelf browser (Hides shelf browser)

Previous	No cover image available		No cover image available			No cover image available	No cover image available	Next
Previous	001.642 SAM Basic programming	001.642 SCH Programming C for UNIX	001.642 SCH Visual references basics microsoft excel 97	001.642 SHA Database systems using Oracle : a simplified guide to SQL and PL/SQL	001.642 TRE Excel vba for managers	001.642 WAL Excel 2007 Bible	001.642 WAL Microsoft office excel 2003 power programming with VBA	Next

Gratis Rs.419/-

I. RELATIONAL DATABASE CONCEPTS.
1. Database Concepts: A Relational Approach.
2. Database Design: Data Modeling and Normalization.
II. ORACLE SQL.
3. Oracle 9i: An Overview.
4. Oracle Tables: Data Definition Language (DDL).
5. Working with Tables: Data Manipulation and Retrieval.
6. Working with Tables: Functions and Grouping.
7. Multiple Tables: Joins and Set Operators.
8. Subqueries: Nested Queries.
9. Advanced Features: Objects, Transactions, and Data Control.
SQL Review: Review of SQL Statements Covered in Chapters 3-9 with a Sample Database.
III. PL/SQL.
10. PL/SQL: A Programming Language.
11. More on PL/SQL: Control Structures and Embedded SQL.
12. Cursors and Exceptions.
13. PL/SQL Composite Data Types: Records, Tables, and Varrays.
14. PL/SQL Named Blocks: Procedure, Function, Package, and Trigger.
IV. ADVANCED TOPICS.
15. Connecting to Oracle Database: JDBC, SQLJ.
16. Oracle 9i Architecture and Administration.
Appendix

Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a valuable future reference. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.

There are no comments on this title.

to post a comment.