Oracle SQL and PL/SQL: (3rd Edition) - Softcover

Joel Murach

Softcover

ISBN 10: 1943873194 ISBN 13: 9781943873197

Publisher: Mike Murach & Associates, 2024

Synopsis

If you’re developing applications that access Oracle databases, you can save time and effort by having the database do more work for you. That’s where this book comes in. This book teaches you how to write SQL statements to efficiently retrieve and update the data in an Oracle database. It teaches you how to design and create a database because that provides insight into performance and security issues. It teaches you how to use Oracle’s procedural language (PL/SQL) to take advantage of powerful features like transactions, stored procedures, functions, and triggers. And it teaches you how to host an Oracle database in the cloud and use SQL Developer to run SQL statements against that database. The result? You’ll learn how to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer or analyst. Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive “paired-pages” format is ideal for learning and reference.

Edition details

• Publisher: Mike Murach & Associates
• Publication date: 2024
• Language: English
• ISBN 10: 1943873194
• ISBN 13: 9781943873197
• Binding: Paperback
• Edition number: 3
• Number of pages: 586