Oracle Dba Tutorial


What is oracle DBA tutorial?

Oracle includes different software mechanisms to achieve data optimization, maximized data concurrency, high performance for maximum productivity for multi users in database environment. This tutorial provides mentioned information is to get the basic understanding of the database.

Audience

This tutorial is designed for the beginners who wish to seek database concepts.

Prerequisites

One must have basic understating of database concepts and terms used in Oracle.

Next Topics »
The Relational Model
Object-relational Database System
Terms To Know
Relational Database Concepts The Relational Model Object-relational Database System Terms To Know Sql*plus And Isql*plus Basics Tools For Running Sql The Ubiquitous Select Statement Dml For Making Changes Ddl For Handling Database Objects Dcl For Handling Privileges Terms To Know In Dba Oracle Database Functions Built-in Single-row Functions User-defined Functions 0oracle Server Software Restricting, Sorting, And Grouping Data The Order By,select Clause Group Functions And The Group By Clause Using Multiple Tables Equijoins Outer Joins Self-joins Cartesian Products: The Black Sheep Of The Family Advanced Sql Queries Set Operators In Oracle Rollup And Cube Logical Consistency Transaction Processing Installing Oracle And Creating A Database Oracle Components Overview Installing Oracle Software Creating An Oracle Database Reporting Techniques Isql*plus Configuration Report Formatting Substitution Variables Saving And Running Scripts Creating And Maintaining Database Objects Creating Tables In Oracle Dba How To Create An Index How To Create And Use Views Creating Sequences And Synonyms Users And Security Granting And Revoking Privileges Auditing In The Oracle Database Making Things Run Fast (enough) Indexes Data Design Tuning Sql Application Tuning Memory Tuning Saving Your Stuff (backups) Database Failures User Backup And Recovery Methods Dba Backup And Recovery Methods Troubleshooting The Alert Log File Event Notification System Trace Files User Trace File Oracle Dba Interview Questions Oracle Dba Practice Tests