 |
Oracle PL/SQL Interactive Workbook
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Appropriate for beginning to intermediate courses in Oracle PL/SQL.
Fully updated and expanded for Oracle 9i, this integrated book-and-Web learning
solution is designed to help students master Oracle PL/SQL as quickly as possible.
Its unique workbook-based pedagogy incorporates hands-on, real-world labs, exercises,
and projects, as well as an outstanding Web-based training site containing Test
Your Thinking project solutions and detailed explanations; additional self-review
exercises with instant feedback and explanations; and an exclusive Virtual Study
Lounge where students can interact with each other. The book's coverage includes
every fundamental PL/SQL concept, skill, and technique, including PL/SQL syntax,
iterative and conditional control, scoping, anchored datatypes, cursors, triggers,
security, tables, and packaging—plus powerful new techniques for working
with exceptions, cursors, collections, and records.
Features
- NEW—Fully updated and expanded to reflect Oracle 9i's version
of PL/SQL.
- Helps students rapidly master the most valuable features incorporated in
the latest version of Oracle PL/SQL.
- Uniquely effective hands-on workbook format—Gives students
hands-on practice through real-world exercises, labs, and projects.
- Helps students master Oracle PL/SQL more rapidly and retain more of what
they learn.
- Comprehensive coverage of Oracle PL/SQL fundamentals—Covers
syntax, program control, scoping, datatypes, cursors, triggers, security,
tables, packaging, exceptions, cursors, collections, records, and more.
- Gives students a single resource for learning all the Oracle PL/SQL skills
they are likely to need.
- Web-based training module—Supports the book with an extensive,
integrated set of online features.
- Gives students access to constant updates on even more learning resources.
- By two of the world's leading database educators—Authored
by Ben Rosenzweig and Elena Silvestrova, faculty members in the Database Application
Development and Design track at Columbia University's School of Continuing
Education.
- Lets students benefit from authoritative coverage by leading experts in
both database technology and database instruction.
- Virtual Study Lounge—Provides an online venue where students
can interact with each other.
- Helps students resolve their own questions and learn from each other.
Table of Contents
1. Programming Concepts.
2. PL/SQL Concepts.
3. General Programming Language Fundamentals.
4. SQL in PL/SQL.
5. Conditional Control.
6. Exception Handling and Built-In Exceptions.
7. Iterative Control.
8. Introduction to Cursors.
9. Exceptions.
10. Exceptions: Advanced Concepts.
11. Procedures.
12. Functions.
13. Packages.
14. Stored Code.
15. Triggers.
16. PL/SQL Tables.
Appendix A. Answers to Self-Review Questions.
Appendix B. PL/SQL Formatting Guide.
Appendix C. Student Database Scheme.
Index.
|
|
