All about programming with PL/SQL With PL/SQL, the procedural extension of SQL, you have a fascinating technology to extract Oracle's database powerful features. Whether you are already dealing with databases and now want to expand the capabilities with PL/SQL, want to work as an administrator in programming triggers, or as an application developer, need to take a closer look at database internals, this comprehensive guide provides everything you need to find the maximum value for your use case with PL/SQL. This is ensured by the thorough introduction to the structure and syntax of PL/SQL, helpful suggestions for the use and improvement of your code as well as detailed workshops with practical relevance. At the forefront of the book are the strategies you need to develop performant, secure and scalable applications. In addition to the comprehensive introduction to PL/SQL, it is therefore about questions such as: In what ways can you efficiently process large amounts of data? What are the advantages and disadvantages of database triggers, when are they right, when not? When should you use PL/SQL, when should you use SQL? How do you protect the database from unauthorized access? The combination of strategic thinking for database programming and workshops as well as code examples helps you with correct and high-quality database programming. Current on Oracle 19c and 21c!
From the contents:
- For programmers and admins
- Oracle Database Basics
- Tools & Resources
- Database Objects and SQL
- Data security, consistency, transactions
- Extend database functionalities
- Syntax of PL/SQL
- Data Types and Control Structures
- Dynamic SQL
- Pluggable Databases
- Debugging, monitoring and performance tuning.
- PL/Scope
- LargeObjects, XML, OOP
- Workshops from practice
- and much more.