OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062

Lýsing:
An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.
Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.
Annað
- Höfundur: Biju Thomas
- Útgáfa:1
- Útgáfudagur: 2014-05-02
- Hægt að prenta út 2 bls.
- Hægt að afrita 10 bls.
- Format:ePub
- ISBN 13: 9781118931332
- Print ISBN: 9781118643952
- ISBN 10: 1118931335
Efnisyfirlit
- Titlepage
- Dedication
- Acknowledgments
- About the Author
- About the Contributor
- About the Technical Reviewers
- Introduction
- Exam Objectives
- Assessment Test
- Exam 1Z0-061: SQL Fundamentals
- Exam 1Z0-062: Installation and Administration
- Answers to Assessment Test
- Exam 1Z0-061: SQL Fundamentals
- Exam 1Z0-062: Installation and Administration
- Part I: Oracle Database 12c: SQL Fundamentals
- Chapter 1: Introducing Oracle Database 12c RDBMS
- Relational Database Management Systems
- The Oracle Database 12c
- Becoming Familiar with SQL*Plus
- Summary
- Chapter 2: Introducing SQL
- SQL Fundamentals
- Writing Simple Queries
- Accepting Values at Runtime
- Summary
- Exam Essentials
- Review Questions
- Chapter 3: Using Single-Row Functions
- Single-Row Function Fundamentals
- Using Single-Row Character Functions
- Using Single-Row Numeric Functions
- Using Single-Row Date Functions
- Using Single-Row Conversion Functions
- Using Other Single-Row Functions
- Summary
- Exam Essentials
- Review Questions
- Chapter 4: Using Group Functions
- Group Function Fundamentals
- Utilizing Aggregate Functions
- Summary
- Exam Essentials
- Review Questions
- Chapter 5: Using Joins and Subqueries
- Writing Multiple-Table Queries
- Using Set Operators
- Using Subqueries
- Summary
- Exam Essentials
- Review Questions
- Chapter 6: Manipulating Data
- Using DML Statements
- Understanding Transaction Control
- Summary
- Exam Essentials
- Review Questions
- Chapter 7: Creating Tables and Constraints
- Database Objects Overview
- Built-in Datatypes
- Creating Tables
- Modifying Tables
- Managing Constraints
- Summary
- Exam Essentials
- Review Questions
- Chapter 1: Introducing Oracle Database 12c RDBMS
- Chapter 8: Introducing Oracle Database 12c Components and Architecture
- Oracle Database Fundamentals
- Oracle Database 12c Architecture
- Summary
- Exam Essentials
- Review Questions
- Chapter 9: Creating and Operating Oracle Database 12c
- Oracle Database 12c Software Installation
- Using DBCA to Create an Oracle 12c Database
- Working with Oracle Database Metadata
- Managing Initialization-Parameter Files
- Starting Up and Shutting Down an Oracle Instance
- Monitoring the Database Alert Log
- Summary
- Exam Essentials
- Review Questions
- Chapter 10: Understanding Storage and Space Management
- Understanding the Physical and Logical Storage
- Managing Tablespaces
- Managing Data Files
- Managing Space
- Summary
- Exam Essentials
- Review Questions
- Chapter 11: Managing Data Concurrency and Undo
- Managing Data Changes Using DML
- Managing Data Concurrency
- Summary
- Exam Essentials
- Review Questions
- Chapter 12: Understanding Oracle Network Architecture
- Introducing Network Configurations
- An Overview of Oracle Net Features
- Configuring Oracle Net on the Server
- Configuring Oracle Net for the Client
- An Overview of Oracle Shared Server
- Understanding Database Resident Connection Pooling
- Communicating Between Databases
- Summary
- Exam Essentials
- Review Questions
- Chapter 13: Implementing Security and Auditing
- Creating and Managing User Accounts
- Granting and Revoking Privileges
- Controlling Resource Usage by Users
- Auditing Database Activity
- Summary
- Exam Essentials
- Review Questions
- Chapter 14: Maintaining the Database and Managing Performance
- Proactive Database Maintenance
- Managing Performance
- Summary
- Exam Essentials
- Review Questions
- Chapter 15: Using Backup and Recovery
- Understanding and Configuring Recovery Components
- Performing Backups
- Understanding Types of Database Failures
- Performing Recovery Operations
- Summary
- Exam Essentials
- Review Questions
- Chapter 16: Controlling Resources and Jobs
- Resource Management with the Resource Manager
- Task Automation with Oracle Scheduler
- Summary
- Exam Essentials
- Review Questions
- Chapter 17: Upgrading to Oracle Database 12c
- Determining the Database Upgrade Method
- Preparing for a Database Upgrade
- Upgrading the Database
- Summary
- Exam Essentials
- Review Questions
- Chapter 18: Using Grid Infrastructure and Data Movement Tools
- Tools for Moving Data
- Migrating Data Using Data Pump
- Loading Data with SQL*Loader
- Populating External Tables
- Introducing Grid Infrastructure
- Summary
- Exam Essentials
- Review Questions
- Chapter 1: Introducing Oracle Database 12c RDBMS
- Chapter 2: Introducing SQL
- Chapter 3: Using Single-Row Functions
- Chapter 4: Using Group Functions
- Chapter 5: Using Joins and Subqueries
- Chapter 6: Manipulating Data
- Chapter 7: Creating Tables and Constraints
- Chapter 8: Introducing Oracle Database 12c Components and Architecture
- Chapter 9: Creating and Operating Oracle Database 12c
- Chapter 10: Understanding Storage and Space Management
- Chapter 11: Managing Data Concurrency and Undo
- Chapter 12: Understanding Oracle Network Architecture
- Chapter 13: Implementing Security and Auditing
- Chapter 14: Maintaining the Database and Managing Performance
- Chapter 15: Using Backup and Recovery
- Chapter 16: Controlling Resources and Jobs
- Chapter 17: Upgrading to Oracle Database 12c
- Chapter 18: Using Grid Infrastructure and Data Movement Tools
- Additional Study Tools
- System Requirements
- Using the Study Tools
- Troubleshooting
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 12401
- Útgáfuár : 2014
- Leyfi : 379