Скачать Oracle Database 11g DBA I 1Z0-052 ( книгу / аудиокнигу ) бесплатно

Скачать Oracle Database 11g DBA I 1Z0-052 файл

Книга позволяет открыть нам огромное количество новых неизведанных миров. Чтение положительно влияет на человека. Это не просто вид досуга, это удовольствие доступеное каждому. Литература передает невообразимое богатство фантазии автора. Мы можем побывать в древности, в высшем обществе, в далеком будущем. Главное достоинство литературы состоит в том, что она раскрывает фантазию. Читая книгу, мы себе представляем образы, окружающую обстановку. Наша фантазия ничем не ограничена. Мы можем представить себе, читая произведение то, что даже автор не писал. Книги содержат много разнообразной информации. Можно прочитать обо всем: о дальних неизведанных странах, разнообразии живой и неживой природы, прославленных личностях и известнейших произведениях искусства. Специальная литература и обучающее видео поможет Вам вырасти в своей профессии, овладеть необходимыми навыками. Книги помогают каждому, кто к ним обращается и ценит. Медицина, психология, техника, кулинария – любые знания могут стать Вашими, независимо от возраста и рода занятий. Книга – терпеливый учитель, подробно объясняющий непонятные, иногда удивительные знания и умения.

Oracle Database 11g DBA I 1Z0-052
Год выпуска: 2011
Производитель: Cbt Nuggets
Сайт производителя: http://betelgeize.org
Автор: Timothy L. Warner

Продолжительность: 12 hrs
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: Become your company's database deity. Learn how to install and administer Oracle 11g databases from scratch and ensure the integrity and security of your organization's data. Tim Warner's series even shows you how to apply your existing SQL Server, MySQL, or DB2 skills directly to Oracle platforms! After watching, you'll be able to pass the Oracle 1Z0-052 exam, and you'll have the vocab, experience and confidence you need to impress hiring managers and clients. Содержание Oracle Database 11g DBA 1
Course Introduction
What is Oracle? About Oracle Certification. How This Course Works. Tackling the 1Z0-052 Exam. Summary: In this nugget we introduce the series. We describe Oracle Database 11g, learn how Oracle certification works, determine your best path through this training, and finally pick up important metadata concerning the 1Z0-052 test.
Exploring the Oracle Database Architecture
Database Basics. Memory Structures. Process Structures . Storage Structures. Summary: We begin our training my examining the architectural underpinnings of Oracle Database 11g. This theory is important not only for our exam success, but also to give us a framework for later lessons on performance tuning and troubleshooting. Related Exam Objectives: Explain the Memory Structures; Describe the Process Structures; Overview of Storage Structures
Preparing the Database Environment
Planning an Oracle Database Installation. Installing the Oracle software. Summary: In this nugget we learn how to install and configure Oracle Database 11g software. We'll learn that while installation on Windows is far easier than installation on NIX, the basic installation process is the same, thanks to the Oracle Universal Installer (OUI) Java application. Related Exam Objectives: Plan an Oracle Database installation; Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
Using the Database Configuration Assistant. Oracle Database Administration Tools. Summary: This nugget serves as a nice bookend to what we covered in the previous nugget. Whereas in the previous lesson we learned how to install the Oracle 11g instance (that is, background processes and memory structures), in this nugget we install an actual database by using the Database Configuration Assistant (DBCA) utility. Related Exam Objectives: Identify the tools for Administering an Oracle Database; Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance Part 1
Stages of Database Startup and Shutdown. Database Initialization Parameters. Summary: Now that we have Oracle Database 11g fully set up, we learn how to manage the startup and shutdown processes (these are actually more complex than you might initially think). We also introduce the critical subject of initialization parameters and how they are stored in the server parameter file (SPFILE). Related Exam Objectives: Setting database initialization parameters; Describe the stages of database startup and shutdown
Managing the Oracle Instance Part 2
Alert Log and Trace Files. The Data Dictionary. Dynamic Performance Views. Summary: As we delve deeper into Oracle DBA concepts, we examine the alert and trace logs, both rich sources of diagnostic and performance information. We also formally define the data dictionary and learn to query both data dictionary views and dynamic performance views to gather instance/database metadata. Related Exam Objectives: Using alert log and trace files; Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
Configuring and Managing the Oracle Network. Using the Oracle Shared Server Architecture. Summary: As you know, Oracle Database 11g is a client/server relational database management system (RDBMS). To that end, in this lesson we learn how to configure the Oracle network environment for maximum reliability, performance, and security. We also differentiate between the dedicated server and shared server process architectures, weighing the relative pros and cons of each approach. Related Exam Objectives: Configure and Manage the Oracle Network; Using the Oracle Shared Server architecture
Managing Database Storage Structures
Reviewing Oracle Data Storage. Understanding Tablespaces and Datafiles. Creating and Managing Tablespaces. Summary: As we know, the physical files are what comprises the Oracle 11g database, proper. To wit, in this nugget we review the relevant terminology: stuff like datafiles, control files, and the logical storage construct known as the tablespace. Related Exam Objectives: Overview of tablespace and datafiles; Create and manage tablespaces; Space management in tablespaces
Administering User Security
Creating and Managing Database User Accounts. Granting and Revoking Privileges. Creating and Managing Roles. Creating and Managing Profiles. Summary: Oracle databases often contain highly sensitive data. Therefore, keeping the database as secure as possible is a chief task of any Oracle DBA. In this lesson we learn how to create and manage user accounts. We then examine how best to grant and revoke permissions by using roles. Finally, we learn how to institute password complexity rules and resource utilization limits by rolling out profiles. Related Exam Objectives: Create and manage database user accounts; Grant and revoke privileges; Create and manage roles; Create and manage profiles
Managing Data and Concurrency
Understanding Transactions. Monitoring and Resolving Locking Conflicts. Summary: Any RDBMS worth its salt will support multiuser access. Oracle 11g is known particularly for its adherence to the ACID properties of database transactions. By concluding this nugget you will understand how to define and manage transactions in Oracle. You will also learn how to diagnose and resolve user process locking problems. Related Exam Objectives: Monitor and resolve locking conflicts; Transactions and undo data
Managing Undo Data
Multiplexing the Redo Log Files. Understanding Undo. Managing Undo. Summary: Undo data in Oracle enables us to restore previous data values if needed as well as provides us with multi-user access to database data. In this nugget we'll learn how to multiplex the redo log files and manage the undo tablespace and datafiles. Related Exam Objectives: Overview of Undo; Transactions and undo data; Managing undo
Implementing Oracle Database Security
Reviewing Database Security Tasks. Using Standard Database Auditing. Summary: Here we revisit the subject of database security (it's a really important concept if you haven't put that together yet). Specifically, here we concentrate on a "laundry list" of security-related DBA tasks. Then we transition into a consideration of standard database auditing. Related Exam Objectives: Database Security and Principle of Least Privilege; Work with Standard Database Auditing
Database Maintenance
Managing Optimizer Statistics. Managing Automatic Workload Repository. Using Advisory Framework. Setting Alerts. Summary: Like a vehicle or most other mechanical possessions, we need to perform regular maintenance to keep those items tuned up. The same thing goes for Oracle Database 11g. In this nugget we get a flying head start on the myriad self-tuning options supported by Oracle Database 11g. Sometimes we might think that Oracle does self-management so well that we can leave the DBA business! Related Exam Objectives: Use and manage optimizer statistics; Use and manage Automatic Workload Repository (AWR); Use advisory framework; Manage Alerts and Thresholds
Performance Management
Using Automatic Memory Management. Using Memory Advisors. Troubleshooting Invalid and Unusable Objects. Summary: While performance tuning is a major subject on the Oracle Certified Professional (OCP) exam, here we cover the basics. We learn to tune memory and then discover and correct invalid/unusable database objects. Related Exam Objectives: Use Automatic Memory Management; Use Memory Advisors; Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
Using the Enterprise Manager Support Workbench. Managing Patches. Summary: Oracle support is not free, but if you have it you'll doubtless find it very comprehensive and extremely helpful. In this nugget we learn the basic mechanics of how to file issues with Oracle Support. Related Exam Objectives: Use the Enterprise Manager Support Workbench; Managing Patches
Backup and Recovery Concepts
Identifying Oracle Database Types of Failure. Tuning Instance Recovery. Checkpoints, Redo Log Files, and Archived Log Files. Configuring ARCHIVELOG Mode. Summary: Like performance tuning, backup and recovery is the other "centerpiece" subject on the OCP exams. Here we, again, cover the basic principles of this vast subject. Specifically, here we focus on backup and recovery concepts and the notion of database recovery. Related Exam Objectives: Identify the types of failure that can occur in an Oracle database; Describe ways to tune instance recovery; Identify the importance of checkpoints, redo log files, and archived log files; Overview of flash recovery area; Configure ARCHIVELOG mode
Performing Database Backups Part 1
Creating Consistent Database Backups. Performing a Hot Backup. Creating Incremental Backups. Summary: This is part one of a three-part nugget miniseries on performing Oracle backups and restores. This particular nugget teaches you the "nuts" and bolts of performing backups by using both the RMAN utility as well as Oracle Enterprise Manager (OEM). Related Exam Objectives: Create consistent database backups; Back up your database without shutting it down; Create incremental backups
Performing Database Backups Part 2
Automating Database Backups. Managing Backups. Viewing Backup Reports. Summary: In this nugget we continue our discussion from the previous lesson. Here we examine how to script out/automate database backups and examine backup reports. Related Exam Objectives: Automate database backups; Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
Understanding Data Recovery Advisor. Performing Recovery (Control file, Redo Log File and Data File). Summary: In this nugget we look at the other side of the disaster recovery coin: that is, how to restore all or part of an Oracle 11g database by using RMAN and OEM. Related Exam Objectives: Overview of Data Recovery Advisor; Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
Moving Data (Directory Objects, SQL*Loader, External Tables). Understanding Oracle Data Pump. Using Data Pump Export and Import. Summary: We complete the training by learning to use the built-in Oracle tools for performing data import and export. This supports technologies and scenarios such as data warehousing and Extract-Transform-Load (ETL). Related Exam Objectives: Describe and use methods to move data (Directory objects, SQL*Loader, External Tables); Explain the general architecture of Oracle Data Pump; Use Data Pump Export and Import to move data between Oracle databases
00:32:26 Видео Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Bit rate : 80.0 Kbps
Nominal bit rate : 1 500 Kbps
Width : 800 pixels
Height : 600 pixels
Display aspect ratio : 4:3
Frame rate mode : Variable
Frame rate : 14.984 fps
Minimum frame rate : 0.612 fps
Maximum frame rate : 30.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.011
Stream size : 10.5 MiB (48%)
Writing library : x264 core 100 Аудио Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Bit rate mode : Variable
Bit rate : 82.7 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 10.9 MiB (49%) Скриншоты
Мои Раздачи Oracle Database 11g SQL Fundamentals 1 1Z0-051
Oracle Database 11g DBA II 1Z0-053

Размер файла: 904.4 MB
Скачать Аудиокнигу:

Похожие статьи


0 комментариев к Скачать Oracle Database 11g DBA I 1Z0-052 ( книгу / аудиокнигу ) бесплатно

Оставить отзыв

Введите код: *
Кликните на изображение чтобы обновить код, если он неразборчив
Рейтинг@Mail.ru Яндекс.Метрика