Technology Mania

Downloading Oracle Software

Extracting Files

Installing Oracle 12c Database

Startup Instance on Windows

Make SQL Developer Run Faster

Oracle Live SQL

Download Virtualbox

Download Linux

Download Oracle Software

Install Virtualbox

Create Virtual Machine

Install Linux

Prerequests

Oracle Software Installation

Create Database

Connect Database From Client

Learn Data, Database and RDBMS Concepts

What is DDL?

Connect and Start to Create Objects

Create Tablespace

Create User

Create Table

Create Synonym

Alter Objects

Drop Objects

Section Practice

DML and TCL

Insert Data to Table

Update Table Data

Delete from Table

Basic Select Statement

"Like" Operator

Sorting Data

Limiting The Resultset

Using Ampersand (&) Subtition

Single Row Operators

Single Row Functions

Conversion Functions

Using Group Functions

Restricting Reported Data

Joining Tables

Using Subqueries

Exists And Not Exists

"With" Clause

Using The Set Operators

What We Have Learned?

Schema Objects With SQL Developer

Using Dictionary Views To Manage Schema

What We Have Learned In This Section?

Controlling User Access

Section Summary

Manipulating Large Data Sets

Section Summary

First Controls of Day

Monthly Controls

Useful Scripts Usage

Opatch-AWR-ASH

ORA Errors Solutions

Be Ready For The Homework

What should be the next step to become DBA?