Skip to main content

Oracle 10g Administration Certification Training


VTC- Oracle 10g Administration Certification Training




VTC - Complete Oracle 10g Administration Certification Training | 163.3MB

Oracle 10g is a database that runs on Linux, Unix and Windows servers. Oracle Database 10g can be used to automate administrative tasks, providing security and regulatory compliance features, and enabling the highest availability with Real Application Clusters. In this VTC tutorial you will install and configure an Oracle 10g database, as well as review several programming choices to work with your database. To begin learning today simply click the links.


Course: Oracle 10g
Author: EI Design
Duration: 3.5 hrs / 87 tutorials
Size: 164MB


Description:

Quote:
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)


Code:
http://www.fileserve.com/file/MW4QwWX
http://www.fileserve.com/file/Gh9jV2C

Comments

Popular posts from this blog

Defacing Sites via HTML Injections (XSS)

Defacing Sites via HTML Injections Defacing Sites via HTML Injections What Is HTML Injection: "HTML Injection" is called as the Virtual Defacement Technique and also known as the "XSS" Cross Site Scripting. It is a very common vulnerability found when searched for most of the domains. This kind of a Vulnerability allows an "Attacker" to Inject some code into the applications affected in order to bypass access to the "Website" or to Infect any particular Page in that "Website". HTML injections = Cross Site Scripting, It is a Security Vulnerability in most of the sites, that allows an Attacker to Inject HTML Code into the Web Pages that are viewed by other users. XSS Attacks are essentially code injection attacks into the various interpreters in the browser. These attacks can be carried out using HTML, JavaScript, VBScript, ActiveX, Flash and other clinet side Languages. Well crafted Malicious Code can even hep the ...

EKS Cluster and Create CSI Driver to store credentials in AWS Secrets Manager via SecretProviderClass

EKS Cluster | CSI Driver | SecretProviderClass | AWS Secrets Manager Setup EKS Cluster and Manage Credentials at runtime using CSI driver using SecretProviderClass and Secrets Manager Assuming you have Configured/Installed AWS CLI, EKSCTL, KUBECTL, HELM. CSI Basic Information: CSI (Container Storage Interface) widely used as a Storage Technology. Created by Google | Mesosphere | Docker.  It has two two Plugins one runs on the Master Node (Centralized Controller Plugin) and another one on Worker Nodes (Decentralized headless Node Plugin).  CSI communication protocol is gRPC.   The communication between Container Orchestration to Controller Plugin (Master) and to Node Plugin (Worker Node) happens using gRPC .  CSI Drivers : vendor specific compiled into Kubernetes/openshift binaries. To use a CSI driver, a StorageClass needs to be assigned first.  The CSI driver is then set as the Provisioner for the Storage Class. CSI drivers provide three main service...

Linux Systems Performance/Observability (BPF (bpfcc-tools), BCC Tools

  Linux System Performance/Observability Tools Linux Systems Performance/Observability (BPF (bpfcc-tools), BCC Tools Assuming you have Linux Server in place and have the required BPF aka BCC related packages installed on the system(s) for the required Linux distribution. BPF(eBPF) aka BCC Tools (bpfcc-tools) : BPF, which originally stood for Berkley Packet Filter is the dynamic tracing tools for Linux Systems.  BPF initially used for the speeding up for the tcpdump expressions and since then it has been know as the extended Berkley packet Filter (eBPF).  Its new uses are Tracing Tools where it provides programmability for the BPF Compiler Collection (BCC) and bpftrace front ends .   Example: execsnoop, biosnoop etc is a BCC Tool. When facing production performance crisis these such list of tools comes handy to trace and fix the issue. However, it requires certain KERNEL level config options to be enabled such as CONFIG_FTRACE, CONFIG_BPF. Profiling tools typically re...