Beginning Oracle PL/SQL

Beginning Oracle PL/SQL

4.11 - 1251 ratings - Source



Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features that are free for the using, and PL/SQL is your ticket to learning about and using those features from your own code. With it, you can centralize business logic in the database, you can offload application logic, and you can automate database- and application-administration tasks. Author Don Bales provides in Beginning Oracle PL/SQL a fast-paced and example-filled tutorial. Learn from Dona€™s extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time on obscure and obsolete features. The author 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 what's most needed and used by PL/SQL professionals and avoid what's 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. Covers the key topics that matter, including variables and datatypes, executing statements, working with cursors, bulk operations, real-world objects, debugging, testing, and more. Teaches you to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well. Guides you in working through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory. What youa€™ll learn Write PL/SQL in both relational and object-relational settings Create maintainable, modular, and reusable programming units Build debugging and testing capabilities directly into your code Centralize business logic inside the database engine Speed performance through bulk operations and data movements Profile your code to isolate slow-running segments for improvement Who this book is for Beginning Oracle PL/SQL is for SQL programmers and database administrators wanting to write code that runs inside Oraclea€™s database engine. Whether ita€™s centralizing critical business logic that is your goal, or you just want to automate your administration work, or maybe just ita€™s just to enhance your applications by taking advantage of all the pre-built functionality Oracle Database has on offer, Beginning Oracle PL/SQL is the book to get you started on the road to PL/SQL mastery. Table of Contents Chapter 1. Relational SQL Chapter 2. Blocks, Functions and Procedures Chapter 3. Types, Variables and Scope Chapter 4. Single Row Processing Chapter 5. Multirow Processing Chapter 6. Object-relational SQL Chapter 7. Troubleshooting Chapter 8. Testing Chapter 9. Documenting Chapter 10. Examples Appendix A. How to Download, Install, and Use OracleI believe programmers are no better than their knowledge of the debugging and troubleshooting tools available for the programming language theya#39;re using. Why ? Well, first, all programmers make coding mistakes. I often remark that the day Ianbsp;...


Title:Beginning Oracle PL/SQL
Author: Donald Bales
Publisher:Apress - 2015-05-07
ISBN-13:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.


Click button below to register and download Ebook
Privacy Policy | Contact | DMCA