Oracle Mega AIO Video Trainings | 7.6GB
Description:
Oracle9i Database provides efficient, reliable, secure data management for high-end applications such as high-volume on-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Oracle also offers several additional optional database products that enhance the capabilities of Oracle9i Database for specific application requirements.
This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.
Oracle Database 10g: Administration Workshop I
Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you’ll learn how to install and maintain an Oracle database.
Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
This course is designed to prepare you for the correspondingOracle Database 10g Administrator Certified Associate.
Certification Exam: #1Z0-042 Oracle Database 10g: Administration I
Duration: 33 hours
Oracle Database 10g: Administration Workshop I Release 2
Learn To:
* Install the Database
* Back up and Recover Data
* Administer Users
* Transport Data between Databases
* Manage Data
* Configure the Network
Topics include:
Quote:
Video 1: Series Intro|07:03
Video 2: SQL Plus andiSQL Plus|40:14
Video 3: Installing Oracle Software and Creatinga Database|28:01
Video 4: Oracle Database and Instance Architecture|33:08
Video 5: Startup, Shutdown, and the Initialization File|28:58
Video 6: Managing Tables, Views, Constraints and Sequences|34:14
Video 7: Data Moving Utilities|32:55
Video 8: PL/SQL Basics|43:23
Video 9: Triggers, procedures, functions|47:49
Video 10: Packages|22:49
Video 11: Managing undo|23:47
Video 12: Tablespaces|28:57
Video 13: Managing users|25:52
Video 14: Oracle net services|29:43
Video 15: Oracle's shared server option|30:39
Video 16: Oracle security|24:39
Video 17: Locks, latches, and waits|37:21
Video 18: Performance|42:39
Video 19: Backup and Recovery Techniques|27:45
Video 20: Backups using RMAN|30:31
Video 21: Database recovery|42:59
Video 22: Enterprise Manager|26:41
Welcome
Introduction (00:55)
Evolution of Oracle Database (01:02)
Introducing Oracle 10g (00:59)
What the Course is About (00:42)
Overview
Features of Oracle 10g (01:26)
Performance & Scalability (01:26)
Availability (00:31)
Security (00:37)
Grid Computing (02:45)
Automatic Storage Management (00:41)
Data Warehousing (01:58)
Management of Records (00:55)
Oracle Application Builder (00:27)
Choice of Development Tools (00:52)
Different Versions of 10g (00:40)
Getting Started
Preinstallation Checks (03:23)
Installation (05:36)
Post Installation Tasks (01:41)
Upgrading an Existing Oracle Database (01:46)
Creating a New Administration Account (02:19)
Creating a New Database User Account Pt.1 (04:11)
Creating a New Database User Account Pt.2 (03:46)
Loading Data (06:21)
Creating Database Objects
Overview (00:41)
Tables Creation (04:29)
Tables Modification (03:32)
Dealing with Constraints Pt.1 (04:37)
Dealing with Constraints Pt.2 (06:19)
Removing Tables (04:02)
Retrieving & Manipulating Data
Overview (00:46)
Basic Query Construction (03:51)
Joining Tables (05:06)
Report Customization (04:22)
Handling Groups of Data (03:06)
Data Addition/Modification & Removal (04:40)
Saving & Discarding Data (04:44)
Administering & Monitoring Database
Managing Database Settings (02:43)
Managing Memory (01:27)
Oracle Shutdown & Start Up (03:33)
Managing Tablespaces (03:01)
Freeing Space (02:06)
Managing Database User Accounts (01:26)
Schemas/Roles & Privileges (03:37)
Altering a Password for a User (01:31)
Dropping a User (01:05)
Monitoring the Database (03:25)
Monitoring Performance Issues (02:11)
Viewing Top SQL (02:40)
Monitoring Sessions (02:02)
Viewing System Statistic (01:44)
Service Availability in 10g EE
Transparent Application Failover in RAC (01:07)
Recovery from Error Using Flashback (04:26)
Using Oracle Secure Backup (03:29)
Database Backups & Recovery (02:25)
Rebuilding Database Objects Online (02:38)
Security in 10g EE
Transparent Data Encryption Feature (04:14)
Using Secure Application Roles (02:15)
Using Oracle Label Security (01:33)
Use of Virtual Private Database (03:11)
Using Fine Grained Auditing (02:00)
Data Manageability
Management of Large Database (00:55)
Exploring Cluster Database (03:06)
Automatic Memory Management Feature (03:36)
Automatically Managing Undo (04:26)
Managing ASM Disk Groups (02:40)
Using the Segment Advisor (04:09)
Resolving Performance Issues Using ADDM (02:55)
SQL Tuning & Access Advisor (03:10)
Using Oracle Data Pump (05:18)
Advanced Scheduling (05:13)
Information Lifecycle Management (01:32)
Managing Enterprise Manager Policies (02:41)
Data Warehousing
Oracle Warehouse Builder (01:32)
Working with Flat File Data (01:53)
Designing Relational Target Warehouse (02:20)
Designing ETL Data Flow Mappings (01:01)
Deploying Objects in Target Warehouse (01:17)
Inter-Row Calculations (01:02)
Filling Gaps in Sparse Data (00:51)
High Speed Data Loading (01:03)
ETL Infrastructure (01:35)
Using Basic Warehousing Functionality (01:08)
Using Materialized Views (00:45)
Application Development
Using Oracle Application Express (04:30)
Adding PL/SQL Functionality (03:05)
Creating a .NET Application (01:54)
Creating an Application Using PHP (00:56)
CHAPTER-1
***********
Fundamentals of Oracle
1.1 History of oracle. What is oracle?
1.2 Why we need oracle10g
1.3 What is grid computing
CHAPTER-2
***********
Setting up Environment
2.1 Steps to open SQL*plus for the First time
2.2 Steps to open iSQL*plus
CHAPTER-3
***********
Introduction to Database
3.1 What is Database?
3.2 Types of Database
3.3 What is Normalization?
3.4 What is Object Relational Database
3.5 Management System (RDBMS & ORDBMS)?
CHAPTER-4
***********
Structured Query Language (SQL) Essentials
4.1 Introduction to SQL
4.2 Simple “SELECT” statement
4.3 SQL Data types
4.4 Oracle 10g new Data types
4.5 SQL operators and their precedence
4.6 Alias Concatenation and Distinct Keyword
CHAPTER-5
***********
Data definition language
5.1 Simple “TABLE” Creation,
5.2 Table creation with “DEFAULT” option
5.3 Altering a Table
5.4 Table creation with “Sub query” &
5.5 “NOT NULL”, “UNIQUE”,”PRIMARY KEY”-I
5.6 “NOT NULL”, “UNIQUE”,”PRIMARY KEY”-II
5.7 Referential FOREIGN KEY & Check constraints
5.8 Altering and Removing Constraints
5.9 Dropping And Truncating Tables
CHAPTER-6
***********
Data manipulation language
6.1 Inserting Data
6.2 Copying Data
6.3 Deleting Data
6.4 Select statement with “WHERE” clause
6.5 Logical operators in “WHERE” clause
6.6 Working with “ORDER BY” clause
6.7 Updating a table
6.8 Merge statement
6.9 Transaction Control Statements
CHAPTER-7
***********
SQL functions
7.1 Aggregate Functions
7.2 Character Functions & Date Functions – I
7.3 Character Functions & Date Functions – II
7.4 “GROUP BY” and “HAVING” clause
7.5 Set Operators,
7.6 Case and Decode Function
7.7 Rollup and Cube Function
7.8 NVL functions
CHAPTER-8
***********
Working with Joins Subqueries & User Access
8.1 Joins: CROSS JOIN or Cartesian product
8.2 Equi Join and NonEqui join
8.3 Join with “USING” and “ON” clause
8.4 Outer Joins (LEFT, RIGHT and FULL)
8.5 Controlling and Managing User Access
8.6 Creating a Report in SQL Plus
CHAPTER-9
***********
Procedural / Structured Query Language (PL/SQL)
9.1 Introduction to PL/SQL
9.2 Fundamentals of PL/SQL
9.3 Datatypes in PL/SQL
9.4 PL/SQL LOB Datatypes and Special Datatypes
9.5 PL/SQL Declaration and executable block
9.6 PL/SQL Conditional logics
9.7 Loops
CHAPTER-10
***********
Cursor, trigger and handling exceptions
10.1 PL/SQL Cursor, cursor types
10.2 Implicit Cursor
10.3 Explicit Cursor
10.4 Triggers in PL/SQL
10.5 Exception Handling in PL/SQL
CHAPTER-11
***********
Procedures, Functions and package
11.1 Procedure Creation in PL/SQL
11.2 Working with Function
11.3 Package in PL/SQL
extabit:
- Code: Select all
http://extabit.com/file/2b4vox5lrml2k/Oracle_All.part09.rar
http://extabit.com/file/2b4vox5lrml24/Oracle_All.part08.rar
http://extabit.com/file/2b4vox5lrml1o/Oracle_All.part07.rar
http://extabit.com/file/2b4vox5lrml4s/Oracle_All.part06.rar
http://extabit.com/file/2b4vox5lrml4c/Oracle_All.part05.rar
http://extabit.com/file/2b4vox5lrml3w/Oracle_All.part04.rar
http://extabit.com/file/2b4vox5lrml3g/Oracle_All.part03.rar
http://extabit.com/file/2b4vox5lrmi0s/Oracle_All.part02.rar
http://extabit.com/file/2b4vox5lrmi0c/Oracle_All.part01.rar
turbobit:
- Code: Select all
http://turbobit.net/wed0gziqscq9/Oracle_All.part01.rar.html
http://turbobit.net/uey37f25r6yi/Oracle_All.part02.rar.html
http://turbobit.net/7zxl1b581qs1/Oracle_All.part03.rar.html
http://turbobit.net/lar4aknbz8ia/Oracle_All.part04.rar.html
http://turbobit.net/8ccwczuwe9bc/Oracle_All.part05.rar.html
http://turbobit.net/r6sx74mlbq9x/Oracle_All.part06.rar.html
http://turbobit.net/oa3ghld3p0nz/Oracle_All.part07.rar.html
http://turbobit.net/r00ujj8wgeus/Oracle_All.part08.rar.html
http://turbobit.net/i82k6w2w2317/Oracle_All.part09.rar.html
shareflare:
- Code: Select all
http://shareflare.net/download/08054.0e188d751d2187877be59b00e6e5/Oracle_All.part01.rar.html
http://shareflare.net/download/28820.27cbc5e85a8c16d5dccd02b43043/Oracle_All.part02.rar.html
http://shareflare.net/download/56771.5a408aa19f32e293ebc67f8821dc/Oracle_All.part03.rar.html
http://shareflare.net/download/53539.52f3136223411b670d3d98063d64/Oracle_All.part04.rar.html
http://shareflare.net/download/62478.60b390a7be94114309f9d5a2c1f5/Oracle_All.part05.rar.html
http://shareflare.net/download/80362.83b9e4c09129383079148c5d1ce4/Oracle_All.part06.rar.html
http://shareflare.net/download/26812.26de098c3679c5fe5c44f9b8cfc2/Oracle_All.part07.rar.html
http://shareflare.net/download/67952.6bbd82d8cc8f10981487ae1eebc0/Oracle_All.part08.rar.html
http://shareflare.net/download/34476.3574f913933ceff21132d161932f/Oracle_All.part09.rar.html
uploaded.to:
- Code: Select all
http://ul.to/0sqrdrn4/Oracle_All.part01.rar
http://ul.to/o4eou2mx/Oracle_All.part02.rar
http://ul.to/3jvkg8e6/Oracle_All.part03.rar
http://ul.to/808urakc/Oracle_All.part04.rar
http://ul.to/n5uo2h44/Oracle_All.part05.rar
http://ul.to/5ax5p793/Oracle_All.part06.rar
http://ul.to/n60all7m/Oracle_All.part07.rar
http://ul.to/59ozrvbo/Oracle_All.part08.rar
http://ul.to/33ld80ig/Oracle_All.part09.rar
Took Hours / Days To make new thread and to Upload.
Takes Only 5 sec. To Say Thanks.
So Please Say Thanks To Keep This Topic Alive.
Feel Free To Ask if You Have Any Difficulty.
**** For high speed and parallel downloads, you can buy premium account !
