|
Showing 1 - 16 of
16 matches in All Departments
Here is the expert-level, insider guidance you need on using Azure
SQL Database as your back-end data store. This book highlights best
practices in everything ranging from full-stack projects to mobile
applications to critical, back-end APIs. The book provides
instruction on accessing your data from any language and platform.
And you learn how to push processing-intensive work into the
database engine to be near the data and avoid undue networking
traffic. Azure SQL is explained from a developer's point of view,
helping you master its feature set and create applications that
perform well and delight users. Core to the book is showing you how
Azure SQL Database provides relational and post-relational support
so that any workload can be managed with easy accessibility from
any platform and any language. You will learn about features
ranging from lock-free tables to columnstore indexes, and about
support for data formats ranging from JSON and key-values to the
nodes and edges in the graph database paradigm. Reading this book
prepares you to deal with almost all data management challenges,
allowing you to create lean and specialized solutions having the
elasticity and scalability that are needed in the modern world.
What You Will Learn Master Azure SQL Database in your development
projects from design to the CI/CD pipeline Access your data from
any programming language and platform Combine key-value, JSON, and
relational data in the same database Push data-intensive compute
work into the database for improved efficiency Delight your
customers by detecting and improving poorly performing queries
Enhance performance through features such as columnstore indexes
and lock-free tables Build confidence in your mastery of Azure SQL
Database's feature set Who This Book Is For Developers of
applications and APIs that benefit from cloud database support,
developers who wish to master their tools (including Azure SQL
Database, and those who want their applications to be known for
speedy performance and the elegance of their code
The vast majority of Oracle SQL books discuss some syntax,
provide the barest rudiments of using Oracle SQL, and perhaps
include a few simple examples. It might be enough to pass a survey
course, or give you some buzz words to drop in conversation with
real Oracle DBAs. But if you use Oracle SQL on a regular basis, you
want much more. You want to access the full power of SQL to write
queries in an Oracle environment. You want a solid understanding of
what's possible with Oracle SQL, creative techniques for writing
effective and accurate queries, and the practical, hands-on
information that leads to true mastery of the language. Simply put,
you want useful, expert best practices that can be put to work
immediately, not just non-vendor specific overview or theory.
Updated to cover the latest version of Oracle, Oracle 10g, this
edition of the highly regarded "Mastering Oracle SQL" has a
stronger focus on technique and on Oracle's implementation of SQL
than any other book on the market. It covers Oracle s vast library
of built-in functions, the full range of Oracle SQL query-writing
features, regular expression support, new aggregate and analytic
functions, subqueries in the SELECT and WITH clauses, multiset
union operators, enhanced support for hierarchical queries: leaf
and loop detection, and the CONNECT_BY_ROOT operator, new
partitioning methods (some introduced in Oracle9i Release 2), and
the native XML datatype, XMLType.
"Mastering Oracle SQL," 2nd Edition fills the gap between the
sometimes spotty vendor documentation, and other books on SQL that
just don't explore the full depth of what is possible with
Oracle-specific SQL. For those who want to harness the untapped
(and often overlooked) power of Oracle SQL, this essential guide
for putting Oracle SQL to work will prove invaluable.
The "Oracle Utilities Pocket Reference" is a handy, quick-reference
guide to the multitude of Oracle utilities that database
administrators (DBAs) use every hour of every day.
As the undisputed leader among database products, Oracle is
grasped conceptually by most DBAs. However, they understandably may
not recall the specific utility to use for a given task, and, more
commonly, won't in many cases remember the syntax to use. And
that's exactly what the "Oracle Utilities Pocket Reference"
supplies--the syntax and options for whatever utility a DBA needs
to perform a given task.
Some of the utilities documented in this guide include:
SQL*Loader, for loading data
expdp and exp for exporting data to another database
oradebug for use in troubleshooting
loadjava and dropjava for loading and unloading Java
programs
Packed with information in an easy-to-read format, this valuable
resource is ideal for any experienced DBA. Even database
programmers who deal with Oracle will truly appreciate having the
"Oracle Utilities Pocket Reference" close at hand.
Authored by Sanjay Mishra, a foremost authority on Oracle
systems, this convenient and compact guide is focused and
to-the-point, eliminating any potential guesswork or difficult
memorization. The "Oracle Utilities Pocket Reference" is part of
the strong-selling collection of O'Reilly "pocket reference"
books.
|
You may like...
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
|