Real World SQL and PL/SQL: Advice from the Experts

Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake

買這商品的人也買了...

商品描述

Master the Underutilized Advanced Features of SQL and PL/SQL

This hands-on guide from Oracle Press shows how to fully exploit lesser known but extremely useful SQL and PL/SQL features―and how to effectively use both languages together. Written by a team of Oracle ACE Directors, Real-World SQL and PL/SQL: Advice from the Experts features best practices, detailed examples, and insider tips that clearly demonstrate how to write, troubleshoot, and implement code for a wide variety of practical applications. The book thoroughly explains underutilized SQL and PL/SQL functions and lays out essential development strategies. Data modeling, advanced analytics, database security, secure coding, and administration are covered in complete detail.

Learn how to:

• Apply advanced SQL and PL/SQL tools and techniques
• Understand SQL and PL/SQL functionality and determine when to use which language
• Develop accurate data models and implement business logic
• Run PL/SQL in SQL and integrate complex datasets
• Handle PL/SQL instrumenting and profiling
• Use Oracle Advanced Analytics and Oracle R Enterprise
• Build and execute predictive queries
• Secure your data using encryption, hashing, redaction, and masking
• Defend against SQL injection and other code-based attacks
• Work with Oracle Virtual Private Database

Code examples in the book are available for download at www.MHProfessional.com.

TAG: For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

 

商品描述(中文翻譯)

精通SQL和PL/SQL的未充分利用的高級功能

這本由Oracle Press出版的實用指南展示了如何充分利用較少人知但非常有用的SQL和PL/SQL功能,以及如何有效地結合這兩種語言。《Real-World SQL and PL/SQL: Advice from the Experts》是由一群Oracle ACE Directors撰寫的,其中包含最佳實踐、詳細示例和內部技巧,清楚地展示了如何為各種實際應用編寫、排除故障和實施代碼。本書詳細解釋了未充分利用的SQL和PL/SQL函數,並提供了必要的開發策略。內容涵蓋了數據建模、高級分析、數據庫安全、安全編碼和管理等方面的完整細節。

學習如何:
- 應用高級的SQL和PL/SQL工具和技術
- 理解SQL和PL/SQL的功能,並確定何時使用哪種語言
- 開發準確的數據模型並實施業務邏輯
- 在SQL中運行PL/SQL並整合複雜的數據集
- 處理PL/SQL的儀器化和分析
- 使用Oracle Advanced Analytics和Oracle R Enterprise
- 構建並執行預測性查詢
- 使用加密、哈希、遮蔽和遮罩來保護數據
- 防範SQL注入和其他基於代碼的攻擊
- 使用Oracle Virtual Private Database進行工作

本書中的代碼示例可在www.MHProfessional.com上下載。

標籤:有關Oracle Press的完整書目清單,請訪問www.OraclePressBooks.com。