Pro Oracle Database 23c administration manage and safeguard your organization's data

This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies. What You'll Learn Configure and manage...

Full description

Bibliographic Details
Main Authors: Malcher, Michelle, Kuhn, Darl (Author)
Format: eBook
Language:English
Published: [Berkeley] Apress 2024
Edition:Fourth edition
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 04895nmm a2200457 u 4500
001 EB002199856
003 EBX01000000000000001337059
005 00000000000000.0
007 cr|||||||||||||||||||||
008 240305 ||| eng
020 |a 9781484298992 
050 4 |a QA76.9.D3 
100 1 |a Malcher, Michelle 
245 0 0 |a Pro Oracle Database 23c administration  |b manage and safeguard your organization's data  |c Michelle Malcher, Darl Kuhn 
250 |a Fourth edition 
260 |a [Berkeley]  |b Apress  |c 2024 
300 |a xxviii, 588 pages  |b illustrations (chiefly color) 
505 0 |a 1. Installing the Oracle Binaries -- 2. Creating a Database -- 3. Configuring an Efficient Environment -- 4. Tablespaces and Data Files -- 5. Managing Control Files, Online Redo Logs and Archivelogs -- 6. Users and Basic Security -- 7. Tables and Constraints -- 8. Indexes -- 9. Views, Duality Views and Materialized Views -- 10. Data Dictionary Fundamentals -- 11. Large Objects -- 12. Containers and Pluggables -- 13. RMAN Backups and Reporting -- 14. RMAN Restore and Recovery -- 15. External Tables -- 16. Automation and Troubleshooting -- 17. Migration to Multitenant and Fleet Management -- 18. Data Management. 
653 |a Oracle (Computer file) / http://id.loc.gov/authorities/names/n91015760 
653 |a Bases de données / Gestion 
653 |a Bases de données relationnelles 
653 |a Database management / fast / (OCoLC)fst00888037 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768 
653 |a Relational databases / fast / (OCoLC)fst01093575 
653 |a Oracle (Computer file) / fast / (OCoLC)fst01363816 
700 1 |a Kuhn, Darl  |e author 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Includes index 
028 5 0 |a 10.1007/978-1-4842-9899-2 
776 |z 1484298993 
776 |z 1484298985 
776 |z 9781484298992 
776 |z 9781484298985 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484298992/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.7585 
082 0 |a 658 
520 |a This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies. What You'll Learn Configure and manage Oracle 23c databases both on-premises and in the cloud Meet your DBA responsibilities in the Oracle Cloud and with Database Cloud Services Perform administrative tasks for Autonomous Database dedicated environments Perform DBA tasks and effectively use data management tools Migrate from on-premises to the Oracle Cloud Infrastructure Troubleshoot issues with Oracle 23c databases and quickly solve performance problems Architect cloud, on-premises, hybrid, and multi-cloud database environments 
520 |a Master Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you'll need to perform to keep your databases stable, tuned, and running. The book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls.  
520 |a Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You'll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization's data for those type of activities. You'll know how to pull back information from a combination of relational tables and JSON structures. You'll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you'll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time.