Oracle DBA Forum  

Вернуться   Oracle DBA Forum > Документация, книги и обучающие материалы > Документация, книги и обучающие материалы > Видеоматериалы

Опции темы Опции просмотра
Старый 20.08.2011, 14:30
Marley Marley вне форума
Senior Member
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию [] Oracle Database 11g [eng]

Oracle Database 11g: Administration I
Oracle Exam 1Z0-052

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.

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.

2 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

3 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)

4 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)

5 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

6 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

7 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

8 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

9 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

10 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

11 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

12 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

13 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

14 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

15 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.

16 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

17 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

18 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

19 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)

20 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

Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 27.12.2011 в 23:28.
Ответить с цитированием
Старый 06.12.2011, 17:05
Marley Marley вне форума
Senior Member
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию

Oracle Database 11g: Administration 2
Oracle Exam 1Z0-053

Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 24.09.2012 в 18:21.
Ответить с цитированием
Старый 27.12.2011, 23:21
Marley Marley вне форума
Senior Member
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию

Cbt Nuggets Oracle Database 11g SQL Fundamentals 1 1Z0-051

Course Introduction
In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss.

About SQL
In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer.

Retrieving Data By Using the SELECT Statement
The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database.

Restricting and Sorting Data
In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables.

Using Single-Row Functions to Customize Output
In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam.

Reporting Aggregated Data Using the Group Functions
In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause.

PL/SQL Basics
In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties.

Displaying Data from Multiple Tables
In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model.

Using Subqueries
In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats.

Using the Set Operators
SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set.

Using DDL Statements to Create and Manage Tables
In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views.

Creating Other Schema Objects Part 1
In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views.

Creating Other Schema Objects Part 2
Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature.

Manipulating Data Part 1
Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements.

Manipulating Data Part 2
In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g.

Basic Oracle Database Security
Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective.

Accessing the Data Dictionary
The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA.

Referencing the Oracle Documentation
While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out.

Using Oracle Flashback Query
In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin.

Query Optimization Basics
In this concluding nugget of the series we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans.

Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 24.09.2012 в 18:20.
Ответить с цитированием
Старый 24.09.2012, 18:20
Marley Marley вне форума
Senior Member
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию

[CBT Nuggets] Oracle 9i/10g OCA Series

The Oracle 9i/10g OCA Series contains these videos:

- Series Intro
- SQL*Plus and iSQL*Plus
- Installing Oracle Software and Creating a Database
- Oracle Database and Instance Architecture
- Startup, Shutdown, and the Initialization File
- Managing Tables, Views, Constraints and Sequences
- Data Moving Utilities
- PL/SQL Basics
- Triggers, procedures, functions
- Packages
- Managing undo
- Tablespaces
- Managing users
- Oracle net services
- Oracle's shared server option
- Oracle security
- Locks, latches, and waits (free video!)
- Performance
- Backup and Recovery Techniques
- Backups using RMAN
- Database recovery
- Enterprise Manager

Чат форума (требуется аккаунт на github или twitter)
Ответить с цитированием

Опции темы
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.

Быстрый переход

Текущее время: 22:09. Часовой пояс GMT +3.

Powered by vBulletin®