Professional >> Engineering and Computer Science >> Computer Science >> Computer Science


Oracle PL/SQL by Example

Oracle PL/SQL by Example

Author(s):
  • Benjamin Rosenzweig
    • Author: Benjamin Rosenzweig
    • ISBN:9789332552005
    • 10 Digit ISBN:9332552002
    • Price:Rs. 1080.00
    • Pages:528
    • Imprint:Pearson Education
    • Binding:Paperback
    • Status:Available


    Be the first to rate the book !!

    9789332552005This tutorial is an integrated learning solution that teaches all the Oracle PL/SQL skills students will need, hands-on, through real-world labs, extensive examples, exercises, and projects. Completely updated for Oracle 12c, it covers all the fundamentals, from PL/SQL syntax and program control through packages and optimization. Concepts are thoroughly explained, then illustrated via examples and interactive labs. At the end of each chapter there is a "Test Your Thinking" section made up of a series of projects designed to solidify all of the skills learned in the chapter.

    Table of Content

    Chapter 1: PL/SQL Concepts  
    Chapter 2: PL/SQL Language Fundamentals 
    Chapter 3: SQL in PL/SQL  
    Chapter 4: Conditional Control: IF Statements  
    Chapter 5: Conditional Control: CASE Statements    
    Chapter 6: Iterative Control: Part I    
    Chapter 7: Iterative Control: Part II     
    Chapter 8: Error Handling and Built-in Exceptions    
    Chapter 9: Exceptions     
    Chapter 10: Exceptions: Advanced Concepts    
    Chapter 11: Introduction to Cursors    
    Chapter 12: Advanced Cursors     
    Chapter 13: Triggers     
    Chapter 14: Mutating Tables and Compound Triggers     
    Chapter 15: Collections     
    Chapter 16: Records      
    Chapter 17: Native Dynamic SQL   
    Chapter 18: Bulk SQL       
    Chapter 19: Procedures     
    Chapter 20: Functions    
    Chapter 21: Packages     
    Chapter 22: Stored Code    
    Chapter 23: Object Types in Oracle
    Chapter 24: Oracle-Supplied Packages      
    Chapter 25: Optimizing PL/SQL     
    Appendix A: PL/SQL Formatting Guide    
    Appendix B: Student Database Schema  
     

    Salient Features

    • Teaches all the Oracle PL/SQL skills needed to start developing PL/SQL fast
    • Includes hundreds of extensive exercises, examples, and projects
    • Covers the new features in Oracle 12c, which was recently released
    • Written by authors with extensive experience in training and teaching students and employees in the use of PL/SQL