Oracle Certified Professional (OCP) 1Z0-053 Complete Video Training 2 DVDs 500/-

11g Database Administration II and 1Z0-053

This series covers all objectives of the 1Z0-053 Oracle Database 11g Administration II exam. As you probably know, passing this exam is a requirement to earn the Oracle Certified Professional (OCP) credential in Oracle Database 11g Database Administration. This CBT Nuggets training series with Tim Warner focuses on Oracle backup and recovery, database performance tuning, optimization, and automation. 

Total Course Duration: 12:06:03

Videos in course:

DVD 1

Course Introduction 00:18:48 

In this Nugget we set the stage for the entire series by describing the "hows and whys" of Oracle Database 11g certification. We then discuss best-practice approaches for studying this material for maximum retention, real-world application, and, of course, exam success! We conclude by reviewing the basics of computer-based testing, 1Z0-053 exam registration, and "need to know" metadata concerning the DBA II test itself.

Oracle 11g Database Architecture and ASM 01:00:48 

In this training Nugget we assume that you understand all of the material presented in our Oracle SQL Fundamentals and DBA I training courses. Nevertheless, we spend some time in this Nugget reviewing the distinction between logical and physical database/instance components in Oracle Database 11g Release 2. We then learn the basics of Automatic Storage Management (ASM), the logical volume manager which is just one of so many Oracle features that set it apart from its competition.

Configuring Oracle 11g for Recoverability 00:45:35 

We begin this training Nugget by learning how to configure multiple archived redo log files to increase the recoverability window of our Oracle 11g database. We then examine the Fast Recovery Area (previously known as the Flash Recovery Area), which is a "no brainer" file system or ASM disk group that Oracle uses as a default save location for backups. Finally, we introduce the Oracle Recovery Manager (RMAN), specifically focusing on establishing a backup retention policy.

Configuring RMAN Backup Specifications 00:45:44 

In this Nugget we begin to develop a more intimate familiarity with the Oracle Recovery Manager (RMAN) command-line tool. Specifically, we practice setting persistent backup and recovery options by using the CONFIGURE statement. We then learn how Oracle uses channels to orchestrate data flow during backup and recovery operations. Finally, we learn the hows and whys of RMAN backup optimization.

Using the RMAN Recovery Catalog 00:34:22 

At this point we know that the RMAN metadata repository is always contained in the database control file. In this Nugget we discover an additional, more robust place to store RMAN-related information: the recovery catalog. By the conclusion of this Nugget you will know how to create a recovery catalog schema and use it to store RMAN scripts. By the time we conclude this Nugget you'll also know how to create a virtual private catalog, which enables us to granularly control access to the recovery catalog metadata store.

Using RMAN to Create Backups 00:38:01 

This Nugget serves as a "capstone" to the skills we've been developing and the concepts we've been learning over the previous five Nuggets. Here we use RMAN to perform backups of several different types: image file backups, whole database backups (with and without compression), incremental backups, duplex backups, multiplexed backups, and archival backups. We also become familiar with multisection backups and the all-important LIST and REPORT RMAN reporting commands.

Performing User-Managed Backup and Recovery 00:49:53 

By this point we have a pretty good grasp of creating Oracle database backups by using RMAN. In this Nugget we learn how to back up and restore the complete database or individual database elements by using so-called "user-managed" recovery techniques. Here you will pick up quite a bit of important Oracle-specific terminology that you'll need to be familiar with to pass your OCP exam. You'll also learn some excellent hands-on procedures for recovering from various critical and non-critical data losses.

Performing Server-Based Recovery with RMAN 00:51:26 

In this Nugget we use RMAN to perform complete and incomplete (point-in-time) restoration and recovery of the Oracle 11g R2 database. We also learn how to take tablespace and datafile backups as well. Finally, we discover how easy it is to use incrementally updated image copy backups for fast file switching and recovery.

Duplicating a Database with RMAN 00:41:13 

We begin this Nugget by describing the many common business use cases that require duplicating an Oracle 11g database. By the end of this Nugget you will know how to clone a database by using the backup-based and active database duplication techniques.

Performing Tablespace Point-in-Time Recovery 00:29:33 

By now we know how to perform point-in-time incomplete recoveries of the entire Oracle 11g database. However, you may find yourself needing to restore data from a particular tablespace without perturbing the rest of the database. In this Nugget we learn how to perform tablespace point-in-time recovery (TSPITR). This technology carries with it many "gotchas," and by the conclusion of this Nugget you'll be aware of them and know how to circumvent potential problems.

Monitoring and Tuning RMAN 00:26:48 

It's one thing to understand how to use Oracle Recovery Manager. It's quite another to know how to make the tool run efficiently. In this Nugget we learn techniques to monitor RMAN sessions and jobs. We also pick up some real-world tips on tuning RMAN for maximum performance and reliability.


DVD 2

Using Flashback Technology Part 1 of 2 00:31:19 

Flashback technology gives us Oracle DBAs much more flexibility in performing fast data recoveries, undo operations, and historical analysis. We start this Nugget by first differentiating among all the different Flashback options. We then learn how to "rewind" entire databases to previous points in time by using Flashback Database. We conclude the nugget by examining Oracle Total Recall, which gives companies the ability to comply with industry/governmental regulations regarding data archival and auditing.

Using Flashback Technology Part 2 of 2 00:24:56 

In this Nugget we continue the discussion we started in the previous Nugget concerning Oracle Flashback technologies. Here we consider how to undrop tables by using Flashback Table. We then learn how to view past data states by using Flashback Query and Flashback Version Query. Finally, we discuss how to research and undo individual transactions by using Flashback Transaction.

Diagnosing the Database 00:33:08 

Let's face it: Oracle Database 11g is a huge beast of an RDBMS. Determining what went wrong when we observe an error or bottleneck condition can sometimes prove challenging. In this Nugget we learn about the Automatic Diagnostic Repository and discover how to use the Data Recovery Advisor and Support Workbench to troubleshoot issues and submit support tickets to Oracle. We also cover how to perform block media recovery.

Managing Memory 00:26:20 

As you know, Oracle Database 11g includes a multitude of advisors to help us DBAs to manage the manifold moving parts in the product. In this Nugget we learn how to maximize Oracle's use of memory (both physical and virtual). We understand Automatic Memory Management (AMM), Automatic Shared Memory Management (ASMM), and then move to consider how to manually configure SGA and PGA parameters at both the instance and the session level.

Managing Database Performance 00:38:21 

How can we manage the performance of Oracle 11g over time? By the conclusion of this Nugget, you'll know how! Here we learn to use the SQL Tuning Advisor and the SQL Access Advisor, both of which help us to revise our SQL for maximum performance and the least possibility of error. We also study Database Replay, which enables us to point Oracle 11g at real-world stored workloads and offer you performance tuning suggestions.

Managing Space 00:36:48 

In this Nugget we learn how to minimize the possibility of Oracle 11g stopping an operation due to a lack of storage space. Here we learn how to manage resumable space allocation. We also learn how transportable tablespaces work. Finally, we discover how to reclaim wasted space from tables and indexes by using Segment Shrink.

Managing Resources 00:38:32 

The host operating system, by default, has no way of differentiating between high-priority and low-priority Oracle processes. In this Nugget we learn how to use the Oracle Database Resource Manager, which allows us to prioritize sessions on Oracle's end. Thus, we can grant specific user groups more relative CPU and other hardware resources depending upon needs and workload.

Administering the Scheduler 00:29:55 

The ability to schedule tasks in Oracle reduces the possibility of human error and lightens the DBA's workload. In this Nugget we learn all about the Oracle Scheduler. We differentiate among the relevant vocabulary, for instance, the job, the program, and the schedule. We also learn some advanced Scheduler topics, in particular how to integrate the Scheduler with the Database Resource Manager that we learned about earlier in this course.

Additional Learning Resources 00:24:33 

Here we wrap up the course by presenting you with a bucketload of relevant web resources for you to take with you and continue to build your Oracle DBA skills. We share Oracle OCP exam prep resources, Oracle tech resources, Oracle community resources, and job search resources. There is a lot of useful info in this Nugget!

Oracle Database 11g Oracle Exam 1Z0-052 And 1Z0-051 Video Traning DVD Rs 300/-

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs

MySQL 5 Development Video Tutorial DVD Rs 300/-

MySQL 5 Development - Part 1


Information

Course:MySQL 5 Development (Part 1)
Author:David Swain
Release Date:2011-05-27
Duration:11 hrs / 129 tutorials
Subject: Databases 

MySQL 5 Development - Part 2 


Information

Author:David Swain
Release Date:2011-11-22
Duration:17.5 hrs / 184 tutorials

Description

As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and "why" those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!


Table of Contents

Introduction
* Welcome (04:34)
* What This Course Will Cover (05:09)
* System Requirements (02:56)
* A Brief History of MySQL (06:07)
* Help on the MySQL Web Site (03:27)
* Online Manual Demonstration pt. 1 (05:56)
* Online Manual Demonstration pt. 2 (01:54)

Database Basics
* Definitions (04:28)
* Client/Server Systems (06:04)
* Tables/Columns/Rows (03:21)
* Database Design in a Nutshell (06:21)
* Indexes (03:45)
* Databases in MySQL (05:43)

Installation
* Installation Basics (07:19)
* Windows (07:16)
* Mac OS X (02:58)
* Linux (02:00)
* What We Installed (05:27)
* Starting and Stopping MySQL (02:19)

Configuration
* MySQL Server Configuration (02:18)
* Server Startup Options (05:53)
* MySQL Configuration File (05:25)
* Important Configuration Options (06:00)

Client Programs
* Command Line Operations (05:48)
* Using a Command Line Client (04:05)
* Command Line Client Help File (06:06)
* MySQL Client Batch Mode (06:27)
* MySQL Client Interactive Mode pt. 1 (06:01)
* MySQL Client Interactive Mode pt. 2 (04:32)
* MySQL Client Interactive Mode pt. 3 (06:02)
* Executing Scripts (06:49)
* Exploring Databases and ables (07:11)

SELECT Statement Basics
* SELECT Arithmetic (06:18)
* Selecting More Than One Column (04:42)
* Operators and Functions (05:03)
* Column Aliases (05:50)
* NULL (05:01)
* Data Type Basics (05:24)

Variables
* What is a Variable? (03:55)
* User Variables (01:42)
* Assignment Operator (02:50)
* SET Statement (05:53)
* System Variables (04:36)
* Variable Scope (07:12)

Calculations and Expressions
* New Values From Old (02:35)
* Operators and Operands (03:45)
* Arithmetic Operators (03:39)
* String Operators (05:12)
* Comparison Operators (05:28)
* Logical Operators (06:22)
* Order of Precedence (02:59)
* Functions and Parameters (03:28)
* Useful Numeric Functions (06:31)
* Useful Character String Functions (07:10)
* Temporal Operations (05:33)
* Useful Temporal Functions (05:09)
* Decision-Making Functions (07:27)
* NULL-Related Functions (04:52)
* Useful System Functions (02:41)

Querying SQL Data
* Using a Database (05:02)
* Selecting FROM a able (04:59)
* Targeting Rows Using WHERE (05:08)
* Complex WHERE Criteria (06:59)
* Sorting Results Using ORDER BY (05:56)
* Going to Extremes Using LIMIT (03:38)
* Avoiding Duplicates Using DISTINCT (03:54)
* Aggregation Queries (04:52)
* Subtotals Using GROUP BY (06:10)
* Filter Derived Columns with HAVING (02:43)
* Multilevel Sums Using WITH ROLLUP (05:17)
* Summarizing SELECT Clauses (06:44)
* Some Clauses Cannot Coexist (03:07)

Databases and Tables
* Databases in MySQL (04:42)
* Creating a Database (06:57)
* Aspects of a Table (02:47)
* Creating a Table (05:12)
* Table Options (05:08)
* Column Options (06:35)
* Auto-Incrementation (05:29)
* Altering a Table (04:54)
* Adding and Dropping Columns (03:43)
* Altering a Column (06:09)
* Dropping a Table (04:27)
* Dropping a Database (04:26)

Data Type Details
* Dataype Categories (02:23)
* Integer Numbers (07:00)
* Floating Point Numbers (07:36)
* Fixed Decimal Numbers (04:49)
* BIT Data Type (07:24)
* Strings (03:13)
* Basic Character Strings (05:45)
* ENUM Character Strings (06:35)
* SET Character Strings (06:08)
* Character Sets (06:54)
* Collations (06:51)
* Fonts and Keystroke Mapping (07:00)
* Binary Strings (05:21)
* Temporal Data (05:43)
* Timestamp and Time Types (06:16)

Storage Engines
* Storage Engine Basics (06:29)
* Discovering Storage Engines (04:34)
* MyISAM (06:20)
* InnoDB (06:36)
* Memory (05:31)
* Example (01:54)
* CSV (03:53)
* Archive (02:38)
* Federated (04:41)
* Blackhole (02:27)
* Third Party Engines (02:27)

Exporting Data
* Basic Export Concepts (02:57)
* Exporting Using SQL Commands pt. 1 (04:44)
* Exporting Using SQL Commands pt. 2 (05:06)
* Exporting on the Shell Command Line (05:03)
* Using MySQLDUMP for Scripts (07:02)
* Using MySQLDUMP for Exporting (07:21)

Prepared Statements
* Prepared Statement Basics (07:53)
* Prepared Statement Demonstration (07:00)
* Commands That Can Be Prepared (03:32)
* When to Use Them (03:26)

Server Information
* Metadata (07:07)
* SHOW Commands (06:39)
* DESCRIBE Command (03:07)
* MySQLSHOW Command Line Client (06:58)
* Information_Schema Database pt. 1 (04:55)
* Information_Schema Database pt. 2 (06:40)

Conclusion
* What We Covered (03:00)
* Where to Go from Here (03:08)

==========================================================

MySQL 5 Development - Part 2 of 2


Course:MySQL 5 Development (Part 2)

Author:David Swain
Release Date:2011-11-22
Duration:17.5 hrs / 184 tutorials

This MySQL 5 Development Part 2 course continues the introduction to MySQL we began with Part 1.

Table of Contents

Introduction
* Welcome (05:44)
* What the Course Will Cover (04:47)
* System Requirements (03:20)
* Brief Review of Part 1 (02:15)

Configuration
* Startup Options (06:02)
* Configuration File (05:30)
* Important Configuration Options (06:00)

Manipulating Data
* Data Manipulation Basics (03:16)
* Warnings and Errors (07:39)
* SQL Modes (06:40)
* Changing Syntax Interpretation (06:56)
* Elevating Warnings to Errors (07:02)
* Interpreting Error Messages (05:45)
* Note Warnings (04:23)
* System Error Warnings (05:24)

Inserting Data
* Inserting Data (06:19)
* Inserting Data Archaic Syntax (04:29)
* INSERT Demonstrations (07:39)
* Default Values on Insert (05:01)
* AUTO_INCREMENT on Insert (05:13)
* AUTO_INCREMENT Issues (06:06)
* LAST_INSERT_ID Function (07:04)
* Common INSERT Errors (04:47)

Deleting Data
* Deleting Data (06:08)
* DELETE with WHERE (06:25)
* DELETE with LIMIT (06:43)
* DELETE with ORDER BY (04:01)
* DELETE Result Messages (03:03)

Updating Data
* Updating Data (07:48)
* UPDATE with WHERE (05:02)
* UPDATE with LIMIT (07:09)
* UPDATE with ORDER BY (03:36)
* UPDATE Result Messages (05:25)

Other MySQL DML Commands
* REPLACE Command (05:02)
* REPLACE Demo (05:54)
* ON DUPLICATE KEY UPDATE Option (05:15)
* ON DUPLICATE KEY UPDATE Demo (05:22)
* TRUNCATE Command (03:48)
* TRUNCATE Demonstration (05:56)
* Safe Updates Mode (07:14)

Importing Data
* Importing Data (07:29)
* Basic Import Demonstrations (06:35)
* Importing Non-Tab Formats (06:58)
* Skipping Header Lines on Import (04:13)
* Changing Import Column Order (07:14)
* Converting Data on Import pt. 1 (04:35)
* Converting Data on Import pt. 2 (04:47)
* Importing on the Shell Command Line (06:33)

Deriving New Tables
* New Tables from Existing Tables (06:40)
* CREATE TABLE Using SELECT (06:09)
* Including Other Features (06:41)
* CREATE TABLE Using LIKE (04:12)
* Populating Derived Tables (03:24)
* Temporary Tables (06:48)
* Altering Derived Tables (05:54)

Multi-Table Queries
* Addressing Multiple Tables (08:04)
* Column Name Conflicts (04:35)
* Resolving Column Name Conflicts (04:13)
* Table Name Conflicts (05:03)
* Resolving Table Name Conflicts (06:31)

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

=======================================================================
Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs

Oracle Database 11g Oracle Exam 1Z0-052 And 1Z0-051 Video Traning DVD Rs 300/-

Oracle Database 11g SQL Fundamentals 1 1Z0-051

Total Course Duration: 10:29:23

Course Introduction 00:18:23
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 00:41:33
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 00:38:10
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 00:37:24
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 00:36:51
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 00:30:04
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 00:36:03
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 00:38:11
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 00:24:21
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 00:23:51
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.

========================================================================

Oracle Database 11g DBA 1 1Z0-052

Total Course Duration: 12:33:06

Course Introduction 00:19:22
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 00:57:16
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 00:40:29
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 00:50:04
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 00:49:25
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 00:31:32
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 00:47:20
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 00:39:54
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 00:47:49
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 00:40:26
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 00:29:31
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 00:34:00
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 00:42:01
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 00:26:20
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 00:34:50
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 00:31:41
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 00:37:23
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 00:31:32
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 00:29:45
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 00:32:26
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



Using DDL Statements to Create and Manage Tables 00:46:29
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 00:31:43
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 00:34:39
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 00:30:32
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 00:30:34
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 00:35:14
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 00:22:19
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 00:22:24
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 00:24:57
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 00:25:41
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.

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs