OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062
Lýsing:
Oracle is the leading developer of database software, and the Oracle certifications have long been the standard for professional Database Administrators. Oracle 11g OCAs need to have an understanding of the following: Restricting and Sorting Data Using Conversion Functions and Conditional Expressions Displaying Data from Multiple Tables Manipulating Data Exploring the Oracle Database Architecture Preparing the Database Environment Creating an Oracle Database Managing the Oracle Instance Managing Database Storage Structures Administering and Implementing User Security Database Maintenance Performance Management Performing Database Backups and Recovery Moving Data OCA: Oracle Database 12c Administrator Certified Associate Study Guide is designed for those who feel they are ready to attempt these challenging exams.
Annað
- Höfundur: Biju Thomas
- Útgáfa:1
- Útgáfudagur: 2014-04-08
- Hægt að prenta út 2 bls.
- Hægt að afrita 10 bls.
- Format:Page Fidelity
- ISBN 13: 9781118763254
- Print ISBN: 9781118643952
- ISBN 10: 1118763254
Efnisyfirlit
- Contents
- Introduction
- Assessment Test
- Answers to Assessment Test
- 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
- Exam Essentials
- Review Questions
- 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
- 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
- Appendix A: Answers to 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
- Appendix B: About the Additional Study 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