Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years, this book provides: Clear and concise information on advanced database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Configuring Recovery Manager Understanding the Flashback Database Recovering from User Errors Working with Globalization Support Using the Scheduler to Automate Tasks Monitoring and Managing Storage Securing the Oracle Listener Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.

This book highlights tips, tricks, shortcuts, and best practices for Oracle Database 10g. It assumes the reader has a good working knowledge of the Oracle database and now wants to know the inside tricks to Oracle Database 10g. Written by a trio of Oracle experts with more than 30 years experience, this book is chock full of information and tips that suit the needs of today's DBAs, database architects, and developers who want to make use of the latest and greatest in Oracle Database 10g.

Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL. Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.

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. From the exclusive publisher of Oracle Press books, here is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. You’ll find coverage of installation, configuration, and tuning, using Java with Oracle Application Server 10g, and much more.

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle’s industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You’ll learn to troubleshoot performance and other problems. You’ll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation. RAC is a complex and powerful technology. It demands expertise in its deployment. You can’t just “wing it” in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. Rigorous and technically accurate content Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting Up-to-date with the very latest RAC features