eBook
View in EDS

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

Bibliographic Details
Title: Real World SQL and PL/SQL: Advice From the Experts
Description: 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
Authors: Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake, Alex Nuijten
Resource Type: eBook.
Subjects: Oracle (Computer file), PL/SQL (Computer program language), Relational databases, COMPUTERS / Database Management / General
Categories: COMPUTERS / Database Administration & Management, COMPUTERS / Languages / SQL
Database: eBook Index
FullText Text:
  Availability: 0
Header DbId: edsebk
DbLabel: eBook Index
An: 2686796
RelevancyScore: 925
AccessLevel: 6
PubType: eBook
PubTypeId: ebook
PreciseRelevancyScore: 924.640747070313
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Real World SQL and PL/SQL: Advice From the Experts
– Name: Abstract
  Label: Description
  Group: Ab
  Data: 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
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Arup+Nanda%22">Arup Nanda</searchLink><br /><searchLink fieldCode="AR" term="%22Brendan+Tierney%22">Brendan Tierney</searchLink><br /><searchLink fieldCode="AR" term="%22Heli+Helskyaho%22">Heli Helskyaho</searchLink><br /><searchLink fieldCode="AR" term="%22Martin+Widlake%22">Martin Widlake</searchLink><br /><searchLink fieldCode="AR" term="%22Alex+Nuijten%22">Alex Nuijten</searchLink>
– Name: TypePub
  Label: Resource Type
  Group: TypPub
  Data: eBook.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Oracle+%28Computer+file%29%22">Oracle (Computer file)</searchLink><br /><searchLink fieldCode="DE" term="%22PL%2FSQL+%28Computer+program+language%29%22">PL/SQL (Computer program language)</searchLink><br /><searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink><br /><searchLink fieldCode="DE" term="%22COMPUTERS+%2F+Database+Management+%2F+General%22">COMPUTERS / Database Management / General</searchLink>
– Name: SubjectBISAC
  Label: Categories
  Group: Su
  Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Database+Administration+%26+Management%22">COMPUTERS / Database Administration & Management</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Languages+%2F+SQL%22">COMPUTERS / Languages / SQL</searchLink>
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=2686796
RecordInfo BibRecord:
  BibEntity:
    Classifications:
      – Code: 005.75
        Scheme: ddc
        Type: prePub
    Languages:
      – Code: eng
        Text: English
    Subjects:
      – SubjectFull: Oracle (Computer file)
        Type: general
      – SubjectFull: PL/SQL (Computer program language)
        Type: general
      – SubjectFull: Relational databases
        Type: general
      – SubjectFull: COMPUTERS / Database Management / General
        Type: general
    Titles:
      – TitleFull: Real World SQL and PL/SQL: Advice From the Experts
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Arup Nanda
      – PersonEntity:
          Name:
            NameFull: Brendan Tierney
      – PersonEntity:
          Name:
            NameFull: Heli Helskyaho
      – PersonEntity:
          Name:
            NameFull: Martin Widlake
      – PersonEntity:
          Name:
            NameFull: Alex Nuijten
      – PersonEntity:
          Name:
            NameFull: Arup Nanda
      – PersonEntity:
          Name:
            NameFull: Brendan Tierney
      – PersonEntity:
          Name:
            NameFull: Heli Helskyaho
      – PersonEntity:
          Name:
            NameFull: Martin Widlake
      – PersonEntity:
          Name:
            NameFull: Alex Nuijten
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Type: published
              Y: 2016
            – D: 15
              M: 10
              Type: profile
              Y: 2024
          Identifiers:
            – Type: isbn-print
              Value: 9781259640971
            – Type: isbn-electronic
              Value: 9781259640988
          Titles:
            – TitleFull: Real World SQL and PL/SQL: Advice From the Experts
              Type: main
ResultId 1