Bøger udgivet af Rampant TechPress
-
623,95 kr. This book is the first of its kind, a book dedicated to tuning the Oracle high availability RAC architecture. Oracle RAC databases are flexible and robust, and along with this flexibility comes complexity, making RAC tuning one of the most challenging areas of Oracle tuning. Packed with incisive insights and examples from one of America's leading RAC experts, guru Brian Peasland delivers an indispensible book for all RAC administrators who need to guarantee that their RAC systems run at optimal performance. It's not enough for the DBA to maintain and control RAC database, the RAC DBA must also have an arsenal of tools and scripts that will help them ensure that their RAC database run at optimal levels. This book will be valuable to all Oracle professionals who must tune their Oracle RAC systems for peak performance. Similar to tuning Oracle database systems in general, Oracle RAC performance tuning covers a wide variety of focus areas. Topics will include Oracle wait events specific to RAC deployments, using Oracle Enterprise Manager Grid Control and AWR in diagnosing RAC problems, and RAC utilities such as OS Watcher and ORAchk (formerly RACcheck). This book will also discuss architecture issues related RAC performance, delving into the cluster interconnect, physical disk layout and Oracle 12c new Flex Clusters. Oracle RAC also allows the workload the spread among several low cost servers (scale-out) rather than a large single server (scale-up), and this book examines these approaches from a tuning perspective. Many companies are working towards private cloud implementations using RAC, and this book is perfect for the DBA's charged with . Oracle 12c RAC raises the bar with its new multi-tenant database implementation. Think of multi-tenant as virtualization at the database level. As more companies start leveraging Oracle 12c RAC for their enterprise database architecture, it is important that the system be designed and tuned properly to ensure the application has a well-performing user experience. This unique book provides a one-stop location for any RAC DBA who must become a RAC performance tuning specialist. Most Oracle RAC books on the market devote only one chapter to performance tuning. The information in this book provides a solid foundation for one's first RAC deployment, and provide you with the tools and methods needed to keep your complex RAC systems running optimally. While this book is not for beginners, the reader is given sufficient background throughout the chapters so that most Oracle DBAs, even those will little Oracle RAC experience, will be able to understand its contents. Oracle RAC is inherently complex. This explains the concepts before delving into highly technical areas. Many in-depth areas of RAC tuning are explored that help the DBA reveal hidden performance trends within even the most complex RAC database.
- Bog
- 623,95 kr.
-
- Using WLDF through Practical Examples and Profiles
453,95 kr. WebLogic is a complex, professional application server environment with a complex and powerful security environment. WebLogic server at its core implements the J2EE specification stack and its main purpose is to offer a hosting environment for J2EE applications. But WebLogic is much more than that. Like most professional J2EE server WebLogic also offers a large number of extended features like comprehensive management, clustering and failover functionality on different levels, plus a number of extended enterprise features not required by J2EE but very useful in the enterprise world, enterprise features that are required by many companies.
- Bog
- 453,95 kr.
-
- Includes HIPAA Regulatory Compliance
678,95 kr. Oracle is the world's most complex database and it offers a bewildering plethora of tools and techniques for managing privacy, security and auditing. This is an indispensible book that addresses these issues in Oracle privacy security auditing, a book that uncovers all of the hidden aspects aspects of Oracle security and auditing, and privacy management. The Health/Insurance Portability and Accountability Act of 1996 (HIPAA) was created to ensure privacy for medical patient data. HIPAA requires complete auditing to show everyone who has viewed confidential medical patient information. This permeates from Hospitals, insurance companies, and dozens of healthcare related industries. HIPAA is a framework that provides complete security access and auditing for Oracle database information.
- Bog
- 678,95 kr.
-
- Performance Optimization Secrets
318,95 kr. If you're a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning, then this book is for you. Written by a widely read DBA and SQL Server internals expert, Robin Schumacher offers real-world advice, an easy to follow performance strategy, and lots of SQL diagnostics scripts in a superb book that shows how to quickly diagnose and optimize SQL Server performance problems. Robin Schumacher has written the internals for some of the world's most powerful SQL Server performance software, and now he shows you how to make your database servers run as fast as possible.
- Bog
- 318,95 kr.
-
- The Definitive Reference
678,95 kr. This is the definitive guide to all Oracle utilities, and it is targeted at experienced Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases. The authors approach Oracle Utilities from a functional perspective, adding value by explaining the "why" and "how" for the use of all Oracle Utilities. This comprehensive book includes details on all of the Oracle utilities, including experts-only sections on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. This indispensable book covers all areas of Oracle database administration and includes secrets for database migration (with Data Pump and SQL*Loader) and detailed tips for using The Oracle OS utilities (e.g. BBED, dbv, orastack, orakill). The book also covers Oracle tuning utilities, including ADDM and the SQL tuning advisors as well as the traditional command-line tuning utilities such as dbms_alert and dbms_xplan, tkprof and dbms_debug. This book is special because noted Oracle experts supplement the operational considerations of Oracle utilities with expert insights and working scripts. The time savings from a single utility script is easily worth the price of this definitive book. This book is not for beginners. These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.
- Bog
- 678,95 kr.
-
- With 100+ High Performance SQL Scripts
318,95 kr. Written by the world's most widely-read Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault, Don Burleson and Harry Conway shares their personal arsenal of Oracle data dictionary scripts in this comprehensive book. With over 50 years of combined experience using Oracle monitoring scripts and Oracle tuning scripts, this is the most comprehensive Oracle script collection ever assembled. Packed with over 100 ready-to-use Oracle scripts, this is the definitive collection for every Oracle professional DBA. It would take man-years to develop these scripts from scratch, making this book the best value in the Oracle industry. Caution - These are extremely powerful undocumented Oracle data dictionary scripts. They should only be used by a certified Oracle DBA, and after a careful review of the Oracle data dictionary script functionality. These Oracle scripts are not for beginners and knowledge of the Oracle data dictionary is required to fully utilize these scripts. USE AT YOUR OWN RISK.
- Bog
- 318,95 kr.
-
- Mining Gold from Your Warehouse
453,95 kr. Oracle experts know that data mining is one of the most complex and challenging areas of any data warehouse. In this concise book, Dr. Carolyn Hamm shares the secrets for success in data mining. Using proven techniques and approaches, Dr. Hamm explains how to perform complex predictive analysis without having a PhD in multivariate statistics. This indispensable book show how to glean hidden trends and correlations from terabytes of Oracle data, using proven tools such as SAS and ODM. Targeted at the data warehouse professional, Dr. Hamm explains the complex concepts in plain English and give you a framework to help you get started fast. Your time savings from a single tip is worth the price of this great book.
- Bog
- 453,95 kr.
-
- Oracle Grid Computing with RAC
318,95 kr. This text presents a complete guide to the installation, configuration and design of Oracle Grid and RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. The text also demonstrates the use of Oracle Grid using the Enterprise Manager Grid control utility.
- Bog
- 318,95 kr.
-
- Administration and Monitoring with WLST and JMX
563,95 kr. All production environments need automated, auditable, and reproducible processes. This book discusses how to automate all aspects of WebLogic, an essential prerequisite for all production environments. The WebLogic Server platform is recognized as one of the leading J2EE application servers and is the foundation of the Fusion Middleware platform. It is well suited for a variety of different application architectures including modern grid and cloud infrastructures. A large number of WebLogic installations from a single server to thousands of servers exist all over the world. Complex environments may consist of hundreds of domains and thousands of managed-servers. It is impossible for an administrator group to maintain all those servers with manual tasks or the web console. This book is written based on 15+ years of experience with many real architecture and consultancy assignments, and includes tips based on lessons learned from real project experience. Its main focus is to teach readers who are already familiar with WebLogic how to use the powerful automation APIs to operate WebLogic in small to very complex environments. This book includes many practical examples that can be easily adapted to the reader's needs. This book does not use the WebLogic GUI nor talk about J2EE programming; it focuses on automation only. A comprehensive code download of powerful WLST and JMX scripts is also provided.
- Bog
- 563,95 kr.
-
- The Definitive Reference
678,95 kr. It's impossible to tune an Oracle database without understanding SQL tuning. Oracle is a SQL processing engine and the execution speed of any SQL query is influenced by many factors, both internal and external. As a declarative data access method, SQL relies on the Oracle cost-based optimizer to always choose the "best" execution plan for every SQL query. However, Oracle's SQL is among the most flexible and robust in the world, and along with this great power comes complexity. Tuning Oracle SQL is the single most important skill of any Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time. "Advanced Oracle SQL Tuning" is a pragmatic treatment of Oracle SQL tuning, short on theory and big on real-world techniques and tips. This book is the culmination of the author's 25 years of full-time DBA experience and he shares expert tips and secrets for hyper charging SQL execution speed. This book covers advanced topics and it is not appropriate for beginners, dilettantes or neophytes.
- Bog
- 678,95 kr.
-
- Expert secrets for using RMAN and Data Pump
453,95 kr. Backup and recovery are mission-critical DBA tasks, and it is critical that every Oracle professional develop a RMAN strategy that guarantees recoverability while minimizing unplanned downtime. RMAN is one of the world's most sophisticated backup and recovery tools. It is robust and complex with thousands of options. This landmark book demonstrates, by example, how to create a successful backup and recovery infrastructure using RMAN. This book also contains links to RMAN video tutorials and a download of working RMAN scripts to guide users through full automation of a backup strategy. Together, backup and recovery are the single most important combined DBA activity, and it is crucial that you master the RMAN and Data Pump Import utilities to protect against catastrophic data loss. Written by practicing Oracle DBAs with years of RMAN experience, this is a pragmatic approach to RMAN, focusing less on theory and more on real-world, practical RMAN tools, tips and techniques. This Oracle backup and recovery book is unique because it provides real-world examples on how to use RMAN and other tools to protect your mission critical data. Even with reliable mirrored disks, your important Oracle database is still at-risk from from software corruption, user error and hardware failures. This book details Oracle RMAN best practices and shows the best ways to minimize backup and recovery time, which is critical for maximizing system availability This is the definitive RMAN reference that guides you, step-by-step, through all of the techniques for Oracle backup and recovery, from simple cold backups to complex incremental backups. Experienced RMAN experts guide you through the installation, setup and configuration for a complete RMAN backup and recovery infrastructure using proven techniques and Oracle best practices. Best of all, you be given the opportunity to learn from supplemental video tutorials and working examples how to recover from every possible data scenario. This book has step-by-step checklists that you can follow to guide you through a complex recovery with minimal unplanned system outages. This is an indispensible RMAN reference for every professional DBA who needs to ensure that they understand every possible backup and recovery strategy. It also contains a download of working RMAN scripts to help you easily automate and monitor your RMAN backups.
- Bog
- 453,95 kr.
-
- The Definitive Reference
343,95 kr. Oracle continues to implement amazing programs to aid the Oracle DBA. This book shows how powerful Oracle utilities are encapsulated into special DBMS packages. Properly used, these DBMS packages can aid the DBA in every aspect of their job. Specifically, DBMS packages provide the underlying foundation for many of the Oracle Enterprise Manager (OEM) screens; therefore, a skilled DBA with in-depth knowledge of DBMS packages can learn to write and apply sophisticated scripts to replicate the online functionality in a batch mode. Knowing when and how to use DBMS packages is key to a DBA's success in administering and monitoring their database. This book contains insider information on how to determine which Oracle packages are best to use in real world situations. The examples supplied in this book will be a powerful tool for any experienced DBA or developer interested in escaping from a reliance on queries or a GUI interface. The detail given in this book is unlike any others on the market today. This book is not for beginners. These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.
- Bog
- 343,95 kr.
-
- OCE Exam: 1Z0-046: Managing Oracle on Linux Certified Expert
453,95 kr. Written by a top Oracle Linux specialist with over a decade of experience in Oracle, this is the most detailed OCE Exam Guide Available in the Oracle community. Prepare to pass the OCE Oracle Database 10g under Linux certification exam with this 1Z0-046 exam preparation guide. This book will help you prepare for all topics of exams 1Z0-046 with real world examples, exercises and practical tests. For use in preparations for Exam 1Z0-046 Certifications required for Exam: Oracle Database 10g: Managing Oracle on Linux Certified Expert
- Bog
- 453,95 kr.
-
- Advanced OEM Techniques for the Real World
318,95 kr. Oracle's Enterprise Manager Grid Control is recognized as the IT Industry's leading Oracle database administration and management tool. It is unrivalled in its ability to monitor, manage, maintain and report on entire enterprise grids that comprise hundreds (if not thousands) of Oracle databases and servers following an approach that is consistent and repeatable. However, Enterprise Manager Grid Control may seem daunting even to the most advanced Oracle Administrator. The problem is you know about the power of Enterprise Manager but how do you unleash that power amongst what initially appears to be a maze of GUI-based screens that feature a myriad of links to reports and management tasks that in turn lead you to even more reports and management tasks? This book shows you how to unleash that power. Based on the Author's considerable and practical Oracle database and Enterprise Manager Grid Control experience you will learn through illustrated examples how to create and schedule RMAN backups, generate Data Guard Standbys, clone databases and Oracle Homes and patch databases across hundreds and thousands of databases. You will learn how you can unlock the power of the Enterprise Manager Grid Control Packs, PlugIns and Connectors to simplify your database administration across your company's database network, as also the management and monitoring of important Service Level Agreements (SLAs), and the nuances of all important real-time change control using Enterprise Manager. There are other books on the market that describe how to install and configure Enterprise Manager but until now they haven't explained using a simple and illustrated approach how to get the most out of your Enterprise Manager. This book does just that.
- Bog
- 318,95 kr.
-
- Expert Secrets for High Performance Programming
318,95 kr. Oracle experts know that PL/SQL tuning makes a huge difference in execution speed. As one of the world's most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PL/SQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL./SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PL/SQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book.
- Bog
- 318,95 kr.
-
- Create Dynamic Web Pages with Oracle Data
318,95 kr. This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page. This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.
- Bog
- 318,95 kr.
-
- The Definitive Reference
563,95 kr. This book will cover all major aspects of Linux system management critical to running Oracle on Linux. Unlike general system administration books, this book will focus on those tasks most important to Oracle administrators. The author has broken down the complex subject of Linux administration into easy to digest chapters organized by task. This makes the subject matter easier to learn and makes it a compelling reference which the reader will go back to for specific information.
- Bog
- 563,95 kr.
-
- With Dictionary Internals SQL & Tuning Scripts
398,95 kr. This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.
- Bog
- 398,95 kr.
-
173,95 kr. Experienced database professionals who work on Oracle database systems often have to solve difficult issues for Oracle performance and hang analysis. Due to the need to perform these critical tasks and lack of support from existing Oracle documentation, Oracle professionals will benefit from learning how to leverage the power of the hidden and undocumented tools within Oracle such as the oradebug utility. Using these poorly or little known tools within Oracle, readers will be able to quickly diagnose problems and perform root cause analysis of such issues as ORA-0600 database errors and database hang issues. It will furthermore provide coverage of these features that allow the Oracle DBA to dig into the core of the Oracle database internal structures to resolve the most challenging issues for database management. As such, this timely book will provide the latest features for Oracle 11g and 10g environments in terms of how to quickly diagnose and fix the toughest database problems.
- Bog
- 173,95 kr.
-
- The Definitive Reference
788,95 kr. Oracle has become the world's most flexible and robust database and along with great power comes great complexity. This complexity requires that the DBA have expert knowledge of Oracle internals. This book provides a thorough step-by-step approach for holistic Oracle tuning in this challenging information technology era. It represents the knowledge accumulated from tuning thousands of Oracle databases. Oracle tuning has always been a complex task; however, it has become even more complex as Oracle evolves and yields new techniques for achieving optimal performance in the stressed production environment of today's high-tech world. Oracle STATSPACK and AWR has introduced a revolution in database tuning. By understanding these time-series tables, we can develop time-series tuning models to predict upcoming outages and dynamically change the instance to accommodate the impending resource changes. Database tuning efforts must become as sophisticated as the databases themselves.This book strives to show you how to leverage upon the wealth of Oracle performance information so that you can create a robust Oracle database engine, one that maximizes computing resources while minimizing overhead. If you are seeking theory, this is not the book for you. This book encapsulates the combined knowledge of over a century of hands-on DBA tuning experience, a pragmatic, practical approach for the professional Oracle DBA. This is not a book for beginners. Targeted at the senior Oracle DBA, this comprehensive book gives you all of the knowledge you need to be successful in tuning even the most complex Oracle database. The code download for this book is packed with ready-to-run scripts to monitor and identify even the most challenging performance issues.
- Bog
- 788,95 kr.
-
343,95 kr. This text explains hot issues for resolving the most difficult performance and recovery issues for Oracle 11g databases. It will allow the experienced Oracle professional to become an expert on how the Oracle database engine really works and provide the Oracle beginner with the solid core knowledge of the theory and practice behind the Oracle database. Most experienced Oracle DBAs are familiar with the standard utilities found within the Oracle database server environment such as RMAN, export and import and Grid Control. However, when it comes down to how the actual database engine works under the hood, the internal workings of Oracle are poorly documented or hidden from plain view of the working DBA. Are you a senior level Oracle professional who wants to learn the secret workings of the Oracle 11g database engine to be able to solve tricky database issues? This timely and expert guide will cover many of the little known and undocumented features within the newest release of Oracle database for Oracle 11g. It will be a perfect capstone to mastering the keys to the kingdom of the Oracle 11g engine. Move from the average Oracle DBA to become an expert level DBA with the help of this exciting new guide from an Oracle guru! Topics will include a detailed discussion of the latest Oracle 11g database internals which previously have been undocumented and internal to only the Oracle server development team. In addition, tools and utilities that have been previously neglected such as how to use internal tools for database issues such as oradebug and tkprof will be explored for tuning difficult issues with the Oracle 11g database. This book distills the very complex nature of Oracle 11g database internals using undocumented tools and features that have not been covered so that database professionals can gain mastery over solving the most difficult and challenging issues for Oracle 11g.
- Bog
- 343,95 kr.
-
- Get Started Fast with Working PL/SQL Code Examples
318,95 kr. 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.
- Bog
- 318,95 kr.
-
- Get Started Fast writing SQL Reports with SQL*Plus
318,95 kr. 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.
- Bog
- 318,95 kr.
-
- Expert Secrets for Migrating from MySQL and SQL Server
398,95 kr. One of the biggest challenges that IT departments currently face is how to migrate their non-Oracle databases to Oracle platform with limited budget, staff, and time constraints. In order to meet these needs, Oracle originally developed an excellent tool called the Oracle Migration Workbench (OMWB). As the latest and greatest enhancement to migration software, Oracle has provided the new version of migration tools along with a full development environment with the SQL Developer software with Oracle 10g and 11g database releases as the method of choice to accomplish these daunting tasks. This comprehensive guide to these new Oracle migration tools will be valuable to all database professionals who are challenged with the task of migrating their non-Oracle databases to the Oracle 10g and 11g platforms. This text will provide the blueprint and implementation details as well as expert hands-on tips and techniques on how to use this new migration tool to quickly migrate non-Oracle databases to the Oracle 10g database environment. Topics will include a detailed discussion of these tools including coverage of both SQL Developer and the Oracle Migration Workbench installation and configuration process, techniques on how to best use the editors for parsing non-Oracle SQL and stored procedures to map to the Oracle SQL and PL/SQL code, problem resolution and troubleshooting during the migration process, and testing procedures after the initial migration has been completed. This book distills the very complex and technical challenges of how to best migrate your non-Oracle database into an easily digested format with clear step by step techniques that all database professionals can implement right away.
- Bog
- 398,95 kr.
-
- Oracle Database Management Concepts and Administration
318,95 kr. This book introduces you to the Oracle Database in plain English with a focus on providing you with an in-depth knowledge of Oracle's basic features and management techniques. By explaining how Oracle works, this book will provide you with the information and tools you need to manage and administer an Oracle database. We include important Oracle tasks such as database creation, startup, shutdown and management and we also cover Oracle's capability to protect the data stored in the database, as well as critical daily maintenance scripts. This book is a valuable resource for both the new DBA and a manager wanting to understand the management and operation of an Oracle Database.
- Bog
- 318,95 kr.
-
- Working Examples of Linux Command Syntax
318,95 kr. Linux is one of the most robust and complex operating systems ever created, and the Linux professional must master complex commands, arguments and scripting syntax. For beginners and experts alike, this condensed book is an indispensable guide for using Linux commands. Filled with working examples, this reference will get you started fast in maintaining any Linux server. Written by a working Linux administrator, this quick reference has working examples of all of the Linux commands that you need to manage your Linux environment. Best of all, this great book contains all of the common Linux shell commands to allow you to quickly locate errors and monitor your filesystem environment.
- Bog
- 318,95 kr.
-
- The Expert Guide to Writing Complex Queries
453,95 kr. Oracle SQL is one of the world's most powerful dialects, packed with advanced functions and features that give Oracle SQL procedural language capabilities. Using these powerful features it is no longer necessary to embed Oracle SQL inside a procedural language, and native Oracle SQL can now be used to solve complex query problems. This is an indispensable book for all Oracle DBA's and developers who need to understand how to apply Oracle SQL features for complex queries. Written by a certified Oracle Master and Oracle ACE, this advanced book shows working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language. This book shows important techniques on how to leverage Oracle's powerful XML interface to quickly format Oracle data with XML for instant publication. This is not a book for beginners or dilettantes and it is designed for the professional Oracle developer, covering many advanced Oracle SQL techniques including XML queries, Oracle SQL analytics, SQL for aggregation, and traversing Hierarchies. Best of all, the author reveals secrets for retrieving Oracle data faster and more elegantly than the traditional approaches to writing SQL.
- Bog
- 453,95 kr.
-
- The Expert Guide to SQL Programming
563,95 kr. This indispensable SQL reference book is the first-of- its-kind to leverage the benefits of design patterns to relational database SQL queries. Leveraging on the success of programming design patterns books, SQL guru Vadim Tropashko categorizes and describes all common SQL structures and design patterns. This is an important book for programmers and managers alike. Because SQL is a declarative language there are many ways to write any SQL query and convoluted and clumsy SQL syntax has become a maintenance nightmare. Professional database programmers must understand the correct way to write SQL for complicated database queries, and managers must institute formal SQL coding standards to improve productivity and maintainability. As relational databases structures become more complex, so do their SQL queries. Complex SQL becomes difficult to understand and maintain, especially with novices who pile-on nested subqueries, and all SQL programmer must learn rudimentary SQL theory, which classifies known SQL solutions into common patterns. SQL design patterns greatly improve the quality and productivity of systems development projects because SQL design patterns form a "best practices" foundation for all relational database queries. The SQL programmers benefit from using SQL design patterns since all query structures are standardized with common approaches, and management benefits by having standardized and maintainable SQL syntax. This book is both pragmatic and academic, a worthy academic book that emphasizes theoretical foundation for almost every type of SQL query problem. Most of the material has accompanying figures that help visualizing the problem. This is not a book for casual programmers or dilettantes. It is specifically created for professional SQL developers who need to solve complex problems using common SQL idioms.
- Bog
- 563,95 kr.
-
- Oracle Security Best Practices
788,95 kr. Today's Oracle professionals are challenged to protect their mission-critical data from many types of threats. Electronic data is being stolen is record amounts, and criminals are constantly devising sophisticated tools to breech your Oracle firewall. With advanced Oracle Forensics we can now proactively ensure the safety and security of our Oracle data, and all Oracle Forensics techniques are part of the due diligence that is required for all production databases. A failure to apply Forensics techniques to identify unseen threats can lead to a disaster, and this book is required reading for every Oracle DBA. This indispensable book is authored by Paul Wright, the world's top Oracle forensics expert, and the father of the field of Oracle Forensics. Packed with insights and expert tips, this is the definitive reference for all Oracle professional who are charged with protecting their valuable corporate information.
- Bog
- 788,95 kr.
-
- The Definitive Reference
453,95 kr. This book will cover all major aspects of Windows system management critical to running Oracle on Windows. Unlike general system administration books, this book will focus on those tasks most important to Oracle administrators. The author has broken down the complex subject of Windows administration into easy to digest chapters organized by task. This makes the subject matter easier to learn and makes it a compelling reference that the reader will go back to for specific information. - See how professionals manage Oracle on a Windows server. - Learn how to automate Oracle tasks with Windows scripts. - Understand how to build powerful server-side alert mechanisms. - See how to manage data files on a Windows server.
- Bog
- 453,95 kr.