OCA/OCP Oracle database 12c all-in-one exam guide : (exams 1Z0-061, 1Z0-062, & 1Z0-063) /

Including examples; practice questions; chapter summaries; and a two-minute drill to reinforce essential knowledge in each chapter; this Oracle Press guide covers all of the exam objectives on the Installation and Administration; SQL Fundamentals; and Advanced Administration exams in detail. --

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Watson, John (Autor), Ramklass, Roopesh (Autor), Bryla, Bob (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : Oracle Press : McGraw-Hill Education, [2015]
Colección:All-In-One Ser.
Temas:
Oracle (Computer file)
SQL (Computer program language) > Examinations > Study guides.
Relational databases > Examinations > Study guides.
Electronic data processing personnel > Certification > Study guides.
SQL (Langage de programmation) > Examens > Guides de l'étudiant.
Bases de données relationnelles > Examens > Guides de l'étudiant.
Electronic data processing personnel > Certification
Relational databases > Examinations
Study guides
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Installing Oracle database software
  • Creating an Oracle database using DBCA
  • Installing Oracle grid infrastructure for a stand-alone server
  • Using Oracle restart
  • - DDL and schema objects
  • DML and concurrency
  • Retrieving, restricting, and sorting data using SQL
  • Single-row and conversion functions
  • Group functions
  • SQL joins
  • Subqueries and set operators
  • Architectural overview of Oracle database 12c
  • Instance management
  • Oracle networking
  • Oracle storage
  • Oracle security
  • Moving and re-organizing data
  • The AWR and the alert system
  • Performance tuning
  • The resource manager
  • The scheduler
  • Configuring the database for backup and recovery
  • Back up with RMAN
  • Restore and recover with RMAN
  • Diagnosing failures
  • Flashback
  • Duplicating a database
  • Encrypting, securing, monitoring and tuning RMAN
  • Upgrading Oracle database software and migrating data
  • Upgrading an Oracle database
  • Multitenant container and pluggable database architecture
  • Creating and managing multitenant container and pluggable databases
  • Managing storage, security, availability, and performance in a CDB and PDBS.

Ejemplares similares