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

個数：

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

Nanda, Arup/ Tierney, Brendan/ Helskyaho, Heli

ウェブストア価格 ¥12,950（本体¥11,773）
McGraw-Hill Education（2016/09発売）
外貨定価 US$ 73.00
ポイント 117pt

提携先の海外書籍取次会社に在庫がございます。通常3週間で発送いたします。
【重要ご説明事項】
1. 納期遅延や、ご入手不能となる場合が若干ございます。
2. 複数冊ご注文の場合、分割発送となる場合がございます。
3. 美品のご指定は承りかねます。

●3Dセキュア導入とクレジットカードによるお支払いについて

【入荷遅延について】
世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。

◆画像の表紙や帯等は実物とは異なる場合があります。

◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
また、洋書販売価格は、ご注文確定時点での日本円価格となります。
ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。

製本 Paperback:紙装版/ペーパーバック版／ページ数 736 p.
言語 ENG
商品コード 9781259640971
DDC分類 005.7585

Full Description

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Part 1: The Importance of SQL, PL/SQL and a Good Data Model
Chapter 1: SQL, PL/SQL and When to Use Which
Chapter 2: Expert Data Modeling and Implementing Business Logic

Part 2: Underutilized Advanced SQL Functionality
Chapter 3: Handling Advanced and Complex Datasets
Chapter 4: Regular Expressions
Chapter 5: Edition Based Redefinition

Part 3: Essential Everyday Advanced PL/SQL
Chapter 6: Running PL/SQL in SQL
Chapter 7: Instrumenting, Profiling and Debugging PL/SQL
Chapter 8: Dynamic SQL
Chapter 9: PL/SQL for Database Management

Part 4: Advanced Analytics
Chapter 10: In-Database Data Mining Using Oracle Data Mining
Chapter 11: Oracle R Enterprise
Chapter 12: Predictive Queries

Part 5: Database Security
Chapter 13: Redaction and masking
Chapter 14: Encryption and hashing
Chapter 15: SQL Injection & Code Security
Chapter 16: Virtual Private Databases (VPD)