Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: July 13th @ 7:00PM

Faculty: Mr. Suresh

Duration : 45 to 50 Sessions

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

ORACLE 19c

Chapter 1 - Demo

Introduction to prerequisites
File and File System
Disadvantages of file
Introduction to Database
Introduction to Database Management systems
Introduction to Database Models

Chapter 2

Database Models

Hierarichal Model
Network Model
Relational Model

Features of RDBMS
Client-Server Technology

Chapter 3

Oracle Versions
Oracle Corporation Products
About SQL & SQL*PLUS
Sub Languages in SQL

Chapter 4

Oracle Data Types
DDL Commands

Create
Alter-add, modify, drop column
Drop

Chapter 5

DML Commands
Insert Statement
Oracle Operators
Where Clause
Update, Delete Statements

Chapter 6

DQL – SELECT stmt
Examples on Select
Using Where clause
Special Operators

IN, BETWEE, LIKE, IS NULL

Chapter 7

DQL – SELECT stmt
Examples on Select
Using Where clause
Special Operators

IN, BETWEE, LIKE, IS NULL

Chapter 8

Select with Arthematic Expressions & Alias
Names, Distinct clause
Built in Functions
Arthematic Functions
Abs, sqrt, power, sign, round, trunc, ceil, floor, sin, cos, tan, exp, ln, log
Character Functions
Inticap, lower, upper, reverse, length, ascii, chr,
lpad, rpad, soundex

Chapter 9

Built in Functionss
Character Functions

Ltrim, rtrim,trim, concat, replace, translate, substr, instr

Date Functions

Sysdate, Add_months, months_between, last_Chapter, next_Chapter

Chapter 10

Date Conversions
To_char, to_date
Group Functions
Count, sum,min, max, avg, stddev, variance
General Functions
Least, greatest

Chapter 11

General Functions
NVL, Decode, to_number
Select Clauses
Group by Having, Order by clauses

Chapter 12

Joins

Equi Join, Non Equi Join, Outer Joins & Self Join

Chapter 13

Set Operators

Union all, Union, Intersect, Minus

Making a copy of Table
Data control Language (DCL)
Sharing Tables and Columns

Grant, Revoke

PUBLIC, WITH GRANT OPTION Keywords

Chapter 14

Creating New Users
Transaction control Language (TCL)

Commit, Rollback, Savepoint

Truncate, Rename commands
Rename Column & Constraints

Chapter 15

Sub Queries

Introduction & Examples

Sub Queries with Delete and Update

Chapter 16

Special operators in sub queries

Exists, Any, Some, All
Correlated sub queries

Locks – Row Level, Table Level Locks

Chapter 17

Integrity Constraints
Column level syntax
On delete cascade, Cascade constraints

Chapter 18

Integrity Constraints
Column, Table Constraint syntax

Chapter 19

Database Objects in Oracle
Views

Simple views, Read only views

Chapter 20

Join Views
Materialized views
Synonyms – Private & Public Synonyms
Sequence – Create and Alter

Chapter 21

Index – Normal, Composite, Unique, Function
Based Indexes
Pseudo Columns

Rownum, Rowid, Level with Examples
Top-N Analysis – Examples

PL/SQL

Chapter 22

PL/SQL
Introduction to Pl/Sql
Features, Block structure,
Data types, Executable Stmts
Simple Examples

Chapter 23

Conditional Statements
If, Case ,
Iteration control Statements
Simple Loop, While Loop, Numeric For loop

Chapter 24

Cursors

Introduction, Types of cursors
Explicit cursors – Declaring Cursor
Cursor Operations, Cursor Attributes
Examples using Cursors

Chapter 25

Cursors with Parameters
Where current of Clause
Implicit Cursors – Examples
Exceptions

Pre-defined & User defined Exceptions
Non predefined Exception

Examples

Chapter 26

Composite Data Types
PL/SQL Records
PL/SQL Tables
Nested Records
Using Record in Table
Examples

Chapter 27

Database Triggers
Introduction Types of Triggers
Row Triggers
Examples

Chapter 28

Database Triggers – contd
Statement Triggers
Instead of Triggers – Views
Examples

Chapter 29

Sub Programs – Features

Procedures, Functions

Examples

Chapter 30

Sub Programs… contd
Parameter Modes –IN, OUT, INOUT
Packages
Examples

Chapter 31

Packages – contd
Overloading of functions in Packages
Local subprograms in Packages
Examples

Chapter 32

Object Technology
Objects, Using in Tables, Nested Objects

Chapter 33

Objects with Methods
Collections

Nested Tables
Varrying Arrays

Diff between Nested tables and Varrays

Chapter 34

File Input & Output
UTL_FILE built in package
Oracle Utitlities
Export, Import

Chapter 35

Using LONG and raw datatypes
Using LOBS

LOB Types –CLOB, NCLOB BLOB, BFILE

Working with LOB Tables

Chapter 36

Returning into Clause
Bulk Collect construct

Using it in select, Update, Delete & Fetch

Temporary Tables
Group by with ROLLUP & CUBE Operators

Chapter 37

NORMALIZATION

Normal Forms with Example

Chapter 38

Partition Tables

Alter partitions – add, drop, merge
Partition Indexes

Chapter 39

New Date Fuctions

Systimestamp, Current_time Stamp,
Localtimestamp, DBTIMEZONE,
SESSIONTIMEZONE, EXTRACT
Timestamp Datatype

Chapter 40

New General Functions

Coalesce, Nullif, NVL2

Analytical functions
Rank, Dense_Rank,Lag,Lead,First,Last
Multiple Inserts
Conditional Insert
Merge Statement