Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example–laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation’s flagship database product.
Learn what’s new in Oracle that really counts.
See actual examples and test run output.
Make sound decisions on new feature adoption.
Sift the gold from the silt and discover which new features of the latest release of Oracle’s flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step–by–step testing and a heart–felt emphasis on what matters in the real–world to help you get the most out of Oracle Database 11g .
What you’ll learn
Which new features really can make your day–to–day work easier
How to automate more of your DBA work than ever before
Who is this book for?
Oracle Database 11g : New Features for DBAs and Developers is for developers, DBAs, project managers, consultants, and other technically minded users of the Oracle database. The book will be of use to any professional in the field who wants to quickly review the new features offered by the Oracle Database 11g release.
About this product: Microsoft SQL Server 7 DBA Survival Guide is organized into several parts that compromise the various jobs and tasks the DBA performs. Learn client/server computing and the role of the database administrator, how to plan and install/upgrading SQL Server, database operation, performance and tuning, and maintaining the shop. This book provides the knowledge and know-how to administer a SQL Server database. Through real-world insight and experience, you'll learn the tips, tricks, and suggestions you need to succeed as a DBA. Checklists and examples for SQL Server DBA tasks are provided, as well as conventions and naming standards. Also included is a section that looks into the tasks that make up a DBA's job description.
About this product: -Your key to attaining certification in Oracle's revamped DBA track! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.
About this product: The book To Become an Oracle DBA in Eighty Days explains the concepts of oracle database using the stories from Jules Verne's novel Around the World in 80 Days: One Oracle Database Architecture Two Oracle Network Configuration 2.1. Client Request 2.2. Network Configuration Files 2.3. Listener Static and Dynamic Register 2.4. Listener Failover and Load Balance Three Database Grid Control 3.1. Grid Control Structure 3.2. Event and Notification 3.3. Scheduled Job Four Backup, Recovery and RMAN 4.1. System Change Number (SCN) 4.2. Online Backup 4.3. Recovery 4.4. Oracle Recovery Manager (RMAN) Five Oracle Real Application Cluster (RAC) 5.1. Physical Structure 5.2. Resource Coordination 5.3. Cache Fusion Six Performance Tuning
About this product: All database administrators need a set of trusty resources to look to for guidance in managing systems as complex as Oracle8i. Oracle8i DBA Handbook is just one of these essential tools with an emphasis on the big picture--what the authors call "effective and efficient" management. This isn't a guide to troubleshooting daily disasters but rather a strategic look at setting up and rearchitecting databases wisely to perform well over the long haul.
Authors Kevin Loney and Marlene Theriault, both seasoned DBAs themselves, address all the major aspects of wise Oracle architecture design. They begin with an Oracle overview and a look at hardware configurations and considerations. While previous knowledge of Oracle will enable readers to put this material most quickly to use, the presentation is straightforward and appropriate to those moving from other relational DBMS's such as SQL Server.
The text includes excellent coverage of logical and physical database layouts, as well as great chapters on performance tuning, security auditing, and backup/restore strategies. Oracle Application Server is introduced, but only briefly; the focus of this book is the administration of the core Oracle product.
A large chunk of the book is devoted to the reprinted SQL language reference from the product's official documentation. Of all the Oracle tutorials and guides out there, this one should be a mandatory part of any Oracle DBA's arsenal. --Stephen W. Plain
Topics covered: Oracle architecture, hardware configurations, logical and physical database layouts, database monitoring, rollback segment management, performance tuning, security, backup and recovery, large database management, networking environments, configuring for Web environments, and Oracle8i SQL language.
About this product: This book is the ultimate field guide for every SQL Server DBA’s laptop bag. Don’t go onsite without it! Covers the most commonly used SQL Server database versions. Handy, easy-to-find information includes security, database creation and management, restoration and recovery, automating SQL Server administration, monitoring performance, tuning, and much more.
Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9I coverage; and iAS--Internet Application Server.
About this product: The Ultimate Reference & Learning Guide for Oracle Database Administrators!
100 Certification Questions, Answers, and Explanations
Oracle has long been setting the standard in database technology, and to stay competitive administrators need to have a current understanding of Oracle's newest improvements. With Oracle Ultimate DBA Interview Questions even 10g issues are covered, so you will be current and competitive. Using this guide to prepare for a job interview or to brush up on the newest trends in Oracle will aid any DBA in acquiring new skills. This guide will explain many common Oracle errors, standard database maintenance, performance tuning, and new features. More than just Oracle documentation and sales pitches, this guide explains Oracle from the perspective of the DBA so that you can evaluate a DBA candidate or land that DBA position with ease.
Key certification and interview topics include:
- Oracle 10g and 9i Database Administration - Database interactions with Windows - Database design - Performance tuning - Audit and security - Database monitoring and maintenance - OEM and OMS troubleshooting
About this product: Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques. The book covers all the new features of Oracle9i. From the exclusive publisher of Oracle Press books.
About this product: Develop the skill you need in the real world.
Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including: * Installing and configuring SQL Server * High availability and disaster recovery * Maintenance and automation * Monitoring and troubleshooting
An Invaluable study tool
This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including: * Upgrading from a previous version of SQL Server * Configuring an operating mode * Restoring a database * Creating a Transact-SQL user-defined type * Using Windows(r) System Monitor to Monitor performance
THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.
BOOK
