ORACLE DATABASE

Teacher

Techehost

Category:

ORACLE

ORACLE DATABASE Course Content

File size: 122 kb

Overview:

Oracle Database Administration training will help you master Oracle DBA. In this Oracle online training, you will master the Oracle Database architecture, database processes, memory structures, schema objects, security, data recovery, and backup, all through hands-on projects and case studies.

Core database concepts
Role of a Database Administrator
SQL and PL/SQL concepts
Physical and logical structure of a database
Introduction to table space
Configuring and managing Oracle Network
Database configuration and programming
Installation and harnessing cloud and storage management
Database best practices and scripts

About Techehost :
Techehost is designed to provide high-quality, flexible and accessible learning opportunities to help you develop the skills you need to advance your career or pursue your personal interests. We offer a range of courses, taught by industry experts, that cover a wide variety of topics and are designed to fit your schedule and learning style. Our online learning environment is user-friendly and allows you to interact with instructors and other learners in real-time, enabling you to get the support you need to succeed. Whether you’re looking to learn a new skill, enhance your knowledge or take your career to the next level, our online training website is the perfect place to start.

1) Oracle Introduction

2) Installation Process

3) Introduction Database

4) DDL & DML Statements

Introduction to DDL & DML

5) Retrieving data using Select statement

Capabilities of SQL SELECT Statements

Arithmetic expressions and NULL values

Column Alias, Concatenation , Distinct and DESCRIBE

6) Restricting and sorting data

The WHERE Clause & Comparison Operators

Using Between and / IN / Like Operators

Using IS NULL / NOT / Not equal Operators

Logical Operators (AND/ OR/ NOT)

Order by Clause

The FETCH Clause

7) Variables

Substitution Variables

DEFINE / UNDEFINE

ACCEPT / PROMPT

Double-Ampersand / SET VERIFY / SET DEFINE

8) Single-row Functions

Single Row Function Introduction

Character functions (Upper, Lower, Initcap )

Character functions (concat, substr, length )

Character functions ( instr )

Number functions ( Round, Trunc, MOD )

Date Functions ( Sysdate)

Date Functions ( months_between, add_months, next_day, last_day)

Date Functions ( round , trunc )

Nesting Functions

9) Conversion Functions and Conditional Expressions

Implicit Data Conversion VS Explicit

TO_CHAR with dates

TO_CHAR with numbers

TO_NUMBER , TO_DATE Functions

The CASE Function

NUllif & Coalesce Function

The DECODE Function

10) Group Functions

Group functions (sum, count, max, min, avg)

Group by Clause, Having Clause

11) Joins Concept

Natural Join

Left/Right/full Outer Join

Cross Join

Self Join

12) Subqueries

Single row & Multiple rows Subqueries

NULL values

Exists and not Exists

Scalar Subquery / Correlated Subquery

13) Set Operators

Union

Union all

Intersect

14) Introduction to View

Creating Simple Views

Creating Complex Views

READ ONLY / With check option

15) Sequences

Synonyms and Indexes

Creating Sequences

Creating Synonyms

Creating Indexes

16) Controlling User Access

Database Security / System Privileges & Roles

Database Security / Object Privileges

Creating ROLE Practice

With Grant Option

Drop user Statement

Be the first to add a review.

Please, login to leave a review

Add to Wishlist

Get course

₹15,000 ₹20,000

Enrolled: 0 students

Duration: 20 hr

Lectures: 54

Video: 22

Level: Advanced

Keep learning your way forward | Get courses from ₹5000 now