Oracle Database 10g: A Beginner's Guide


Book Description

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.




Oracle Database 10g DBA Handbook


Book Description

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.




Beginning Oracle Database 11G Administration:From Novice To Professional


Book Description

Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.Part 1: Database ConceptsChapter 1: Relational Database Management SystemsChapter 2: SQL and PL/SQLChapter 3: Oracle ArchitecturePart II: Database ImplementationChapter 4: PlanningChapter 5: Software InstallationChapter 6: Database CreationChapter 7: Physical Database DesignChapter 8: User Management and Data LoadingPart III: Database SupportChapter 9: Taking ControlChapter 10: MonitoringChapter 11: Fixing ProblemsChapter 12: BackUpsChapter 13: RecoveryChapter 14: Database MaintenanceChapter 15: The Big Picture and the Ten DeliverablesPart IV: Database TuningChapter 16: Instance TuningChapter 17: SQL Tuning




Oracle Data Guard 11gR2 Administration Beginner's Guide


Book Description

Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.




OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)


Book Description

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration







Oracle 11g DBA for Beginners


Book Description

Learn the RDBMS concepts, database installation, and oracle database administration using different tools and utilities that will help you to administer, monitor any production database.Build strong foundation in database administration with this tutorial for absolute beginnersOracle database installationUser connectivity and SQL executionOracle database architectureManual database creationTablespace and user administrationOracle networking and utilitiesOracle DBA is one of the highly stable jobs!Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA!




Oracle Database Administration for Microsoft SQL Server DBAs


Book Description

Apply Your SQL Server DBA Skills to Oracle Database Administration Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard




Oracle Database 11g A Beginner's Guide


Book Description

Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge




Beginning Oracle Database 12c Administration


Book Description

Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: • Install and configure an Oracle database, and ensure that it’s properly licensed; • Execute common management tasks in a Linux environment; • Defend against data loss by implementing sound backup and recovery practices; and • Improve database and query performance.