Beginning PL/SQL: From Novice to Professional (Paperback)

Description

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales?extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule ?cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

• Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
• Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
• Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.

• How important SQL is in PL/SQL
• How to use PL/SQL in both a relational and object-relational setting
• How to create maintainable, modular, and reusable PL/SQL program units
• The importance of testing as you go, and of building a permanent test plan for each module
• The importance of building debugging capabilities into your code and building a permanent debug facility for each module
• The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
• How to apply modular PL/SQL to solve real-world problems

描述

在《Beginning PL/SQL》這本節奏快且充滿實例的教學書中，從作者Don Bales的豐富經驗中學習PL/SQL這個每個Oracle開發人員和資料庫管理員都必須了解的內建語言。這本書著重於介紹PL/SQL中最常用的部分，避免浪費時間在冷門和過時的功能上。

作者Don Bales運用他20多年的經驗和他在這些年中收集到的PL/SQL使用統計數據，應用80/20法則，涵蓋了PL/SQL專業人員最需要和使用的內容，避免了不必要的部分。這本書涵蓋了PL/SQL的所有關鍵功能，讓你能夠學到真正重要的知識，讓你對PL/SQL有信心地開始工作。

重點內容包括變數和數據類型、執行語句、使用游標、實際應用、調試、測試等。你將學習如何撰寫生產級別的面向對象的PL/SQL，作者Don Bales強調了PL/SQL的面向對象特性，這與其他大多數關於PL/SQL的書籍不同。你將通過應用PL/SQL解決真實的商業問題來學習PL/SQL，而不是只停留在理論上。

此外，你還將學習以下內容：
- SQL在PL/SQL中的重要性
- 如何在關聯和物件關聯環境中使用PL/SQL
- 如何創建可維護、模塊化和可重用的PL/SQL程序單元
- 測試的重要性，以及為每個模塊建立永久測試計劃的重要性
- 在代碼中建立調試功能和為每個模塊建立永久調試設施的重要性
- 在進行文檔化時的重要性，並在此過程中為可重用模塊建立永久文檔集
- 如何應用模塊化的PL/SQL解決真實世界的問題