Learn Oracle Database: Become An Oracle Database Admin-Dba

This course walks you through easy to follow guides to learn the basics of Oracle Databases.

What you'll learn
The goal of this course is to walk you through the basics of an Oracle database.
Requirements
The requirements are Oracle 11g express and Toad for Oracle.
Description
This course will walk you through the basics of an Oracle Database. The course material is all videos with a duration of just over two hours long. The course is structured in a very easy to follow way and also logical. This course is a fast and easy way to know about the basics of an oracle database. This course walks you through some database concepts and includes the following ·Data Types and Constraints ·View and Dual Tables ·ERD (Entity Relationship Diagram) ·SQL ·Operators ·SQL SUB Languages ·Sample Oracle Database Installation ·Viewing ,limiting and sorting data from an oracle database

Overview

Section 1: Oracle Database Setup and Concepts

Lecture 1 Introduction

Lecture 2 Entity Relationship Diagram (ERD)

Lecture 3 Oracle Download and Installation

Lecture 4 Creating an account on oracle

Lecture 5 How to Unlock Oracle Sample HR Schema Account

Lecture 6 How to assemble HR Schema Tables

Lecture 7 How to Run Sample Oracle Database Application

Lecture 8 Toad For Oracle Download and Installation

Lecture 9 Oracle Database Connection with Toad

Lecture 10 Oracle Data Types And Constraints

Lecture 11 View and Dual Table

Lecture 12 Operators

Section 2: SQL ( Structured Query Language) For Oracle

Lecture 13 SQL

Lecture 14 SQL SUB LANGUAGES

Lecture 15 DDL CREATE PART 1

Lecture 16 DDL CREATE PART 2

Lecture 17 DDL ALTER TRUNCATE DROP

Lecture 18 DML SELECT

Lecture 19 DML INSERT

Lecture 20 DML UPDATE And Delete

Lecture 21 How to View ,Limit and Sort Data From Oracle Database

Section 3: Conclusion

Lecture 22 Conclusion

Lecture 23 Thank You

This course is for anyone that wants to know about Oracle. Also ideal for IT Professionals who want to gain more knowledge.It is a beginners guide.