Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
|
Your cart is empty |
|||
Showing 1 - 4 of 4 matches in All Departments
"This book should satisfy those who want a different perspective
than the official Oracle documentation. It will cover all important
aspects of a data warehouse while giving the necessary examples to
make the reading a lively experience."
Developers and DBAs use Oracle SQL coding on a daily basis, whether
for application development, finding problems, fine-tuning
solutions to those problems, or other critical DBA tasks. Oracle
SQL: Jumpstart with Examples is the fastest way to get started and
to quickly locate answers to common (and uncommon) questions. It
includes all the basic queries: filtering, sorting, operators,
conditionals, pseudocolumns, single row functions, joins, grouping
and summarizing, grouping functions, subqueries, composite queries,
hierarchies, flashback queries, parallel queries, expressions and
regular expressions, DML, datatypes (including collections), XML in
Oracle, DDL for basic database objects such as tales, views and
indexes, Oracle Partitioning, security, and finally PL/SQL.
Database professionals will find that this new edition aids in
mastering the latest version of Microsoft's SQL Server. Developers
and database administrators (DBAs) use SQL on a daily basis in
application development and the subsequent problem solving and fine
tuning. Answers to SQL issues can be quickly located helping the
DBA or developer optimize and tune a database to maximum
efficiency.
Tuning of SQL code is generally cheaper than changing the data
model. Physical and configuration tuning involves a search for
bottlenecks that often points to SQL code or data model issues.
Building an appropriate data model and writing properly performing
SQL code can give 100%+ performance improvement. Physical and
configuration tuning often gives at most a 25% performance
increase.
|
You may like...
Wits University At 100 - From Excavation…
Wits Communications
Paperback
1 Recce: Volume 3 - Onsigbaarheid Is Ons…
Alexander Strachan
Paperback
1 Recce: Volume 3 - Through Stealth Our…
Alexander Strachan
Paperback
|