ORACLE DATA BASE. Advanced Administration with SQL (ePub)

In successive versions of Oracle Database, Oracle has been simplifying the work of customers in standardising, consolidating and automating database services, including the cloud. Oracle allows data scientists, analysts and developers to accelerate machine learning and data science projects. It is possible to eliminate data preparation and duplication, process large data sets faster, and take full advantage of the Oracle Cloud Infrastructure platform by moving algorithms into the database. This book delves into the creation, configuration and advanced administration of databases through the relational language ORACLE SQL. The tasks are illustrated with practical exercises to make database work more comprehensible. The content deals with the design of relational databases and the use of the data definition language, the data manipulation language and the transaction control language. It also deals with database retrieval, security administration, authentication and user administration, administration of privileges, roles and profiles. It focuses on oracle data protection mechanisms, enabling media recovery, database backup (BACKUP) with Recovery Manager (RMAN), database recovery with RMAN and other advanced ORACLE administration media.