Alex Nuijten – författare

Visar alla böcker från författaren Alex Nuijten. Handla med fri frakt och snabb leverans.

6 produkter

Kategorier

6 produkter

Real World SQL and PL/SQL: Advice from the Experts
AvArup Nanda,Brendan Tierneym. fl.
Häftad, Engelska, 2016
641 kr
Skickas inom 3-6 vardagar
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
Real World SQL and PL/SQL: Advice from the Experts
AvAlex Nuijten,Martin Widlakem. fl.
E-bok
Engelska, 2016
911 kr
Läs direkt efter köp
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
Modern Oracle Database Programming
Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
AvAlex Nuijten,Patrick Barel
Häftad, Engelska, 2023
622 kr
Skickas inom 10-15 vardagar
Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You’ll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You’ll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality–that their company has paid for–on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever.Part I looks at features in SQL and PL/SQL that are underused and not well known. You’ll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand.Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You'll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems.Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. These features are just a taste of what the book provides. Soon you’ll be improving your skillsand wondering why you ever worked so hard to solve problems that Oracle Database already solves for you.What You Will LearnWrite more powerful code by incorporating underused features in SQL and PL/SQLOptimize your integration between SQL and PL/SQL for best performanceTake advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQLMake your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancementsIntegrate with web services and external data sources directly from the databaseCreate and parse JSON documents for easy data exchange and flexible schema designWho This Book Is ForAny developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledgeand skills to the latest features that Oracle Database provides, and developers who don’t want to write their own solutions only to find out later that they’ve wasted their time by building something that Oracle Database provides out of the box
Modern Oracle Database Programming
Level Up Your Skill Set to Oracle''s Latest and Most Powerful Features in SQL, PL/SQL, and JSON
AvPatrick Barel,Alex Nuijten
E-bok
Engelska, 2023
894 kr
Läs direkt efter köp
Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You’ll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You’ll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality–that their company has paid for–on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever.Part I looks at features in SQL and PL/SQL that are underused and not well known. You’ll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand.Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You''ll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems.Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. These features are just a taste of what the book provides. Soon you’ll be improving your skillsand wondering why you ever worked so hard to solve problems that Oracle Database already solves for you.What You Will LearnWrite more powerful code by incorporating underused features in SQL and PL/SQLOptimize your integration between SQL and PL/SQL for best performanceTake advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQLMake your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancementsIntegrate with web services and external data sources directly from the databaseCreate and parse JSON documents for easy data exchange and flexible schema designWho This Book Is ForAny developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledgeand skills to the latest features that Oracle Database provides, and developers who don’t want to write their own solutions only to find out later that they’ve wasted their time by building something that Oracle Database provides out of the box
Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
AvAlex Nuijten,Patrick Barel
Engelska, 2023
585 kr
Skickas inom 5-8 vardagar
Oracle Apex Best Practices
AvA. Nuijten,Alex Nuijten
Häftad, Engelska, 2012
730 kr
Skickas inom 5-8 vardagar

Företag, bibliotek eller offentlig verksamhet?

Alex Nuijten – författare

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

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

Modern Oracle Database Programming

Modern Oracle Database Programming

Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Oracle Apex Best Practices

Mina sidor

Mina sidor

Hjälp

Hjälp

Om Bokus

Om Bokus

Populärt

Populärt

Inspiration

Inspiration