Until now, almost all books on logical database design focused exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It then examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into some physical design, as determined by how the features of modern databases are implemented. Because this is a logical-design book, the authors attempt to make the examples database-neutral. Because various vendors implement features in different ways, this volume sometimes offers examples from a specific database management system. When necessary, it highlights a specific application, clearly demonstrating the concept being discussed.

Logical Database Design Principles (Foundations of Database Design)

Computers & Technology

WALKER, JEFF

Garmany, John

Clark, Terry

Computer Science

Auerbach Publications

With the advent of inexpensive and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data; however, Oracle multi-master replication is extremely complex and time-consuming to implement. This book addresses the complexity of Oracle replication by providing working code examples and illustrations of working systems. Demonstrated is every aspect of Oracle snapshot replication, including syntax for refresh intervals, managing snapshot logs, monitoring oracle replication, and refresh timings. Also detailed are techniques for implementing conflict resolution in multi-master replication.

Oracle Replication: Expert Methods for Robust Data Sharing (Oracle In-Focus series)

Freeman, Robert G.

Software

Rampant TechPress

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Easy Oracle SQL: Get Started with Fast Writing SQL Reports With SQL*Plus

Easy Oracle Pl/sql Programming: Get Started Fast With Working Pl/sql Code Examples

Wade, Teri

Burleson, Don

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs and Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.

Oracle 11g New Features (Oracle In-focus)

Carr, Brian

Hartmann, Lutz

Jain, V. J.

Karam, Steve

Databases & Big Data

In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for SQL and SQL*Plus beginners. This book is intended for anyone who needs to extract Oracle data and format reports. John reveals even more secrets for quickly and easily producing stunning reports from Oracle. Unknown to most Oracle professionals, special SQL extraction techniques and SQL*Plus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, John Garmany's exciting second edition shares more working samples in his online code depot than before. Your time savings from a single script is worth the price of this great book. Easy Oracle SQL is your introduction to using SQL and SQL*Plus with an Oracle database. Whether you are just learning SQL or just need a handy reference, this book will provide you with proven methods to building queries and reports using SQL. Each concept is explained in detail with multiple examples and exercises at the end of each section. Also included is a section detailing how to effectively use SQL*Plus to not only create and run queries but also to create quality reports and scripts. This book will have you up and using SQL quickly and efficiently.

Easy Oracle SQL: Get Started Fast writing SQL Reports with SQL*Plus (Easy Oracle Series)

Programming Languages

This second edition, authored by distinguished Oracle veteran, John Garmany, is an indispensable guide for any Oracle professional who must quickly implement Oracle reporting. John's decades of SQL*Plus experience come to bear in this indispensible book. New tips and tricks have been included in this cutting edge edition. In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for PL/SQL beginners. This book is intended for anyone who needs to extract Oracle data and format reports. John reveals even more secrets for quickly and easily producing stunning reports from Oracle. This second edition of Easy Oracle PL/SQL provides the reader with the tools needed to create, debug and execute PL/SQL code. The example driven methodology will have users coding basic PL/SQL blocks by the end of the first chapter. Each chapter builds on previous concepts, introducing increasingly more complex PL/SQL coding, while always focusing on readability and manageability. Each concept is introduced using multiple examples and each chapter has exercises to test knowledge. With Easy Oracle PL/SQL, the incredible power to use the Oracle Database in harmony with your application will be at your fingertips.

Easy Oracle PLSQL Programming: Get Started Fast with Working PL/SQL Code Examples (Easy Oracle Series)

Programming

See the best price to sell, buy, or rent books by Garmany, John. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Garmany, John