Oracle PL/SQL: Das umfassende Handbuch für Datenbankentwickler - Hardcover

Hardcover

ISBN 10: 3836260735 ISBN 13: 9783836260732

Synopsis

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 all about questions such as: How can you process large amounts of data efficiently? 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 to Oracle 12c!

From the contents:

• For programmers and administrators
• Oracle Database Basics
• Tools & Resources
• Data security, consistency, transactions
• Extend database functionalities
• Syntax of PL/SQL, data types, control structures,
• Dynamic SQL
• Trigger, file processing,
• Troubleshooting
• Pluggable Databases
• Debugging, monitoring and performance tuning
• PL/Scope
• Workshops from practice
• and much more.

Edition details

• Language: German
• ISBN 10: 3836260735
• ISBN 13: 9783836260732
• Binding: Hardcover