Oracle – Fundamentals Of SQL

( Duration 2 Months )

Online Training

Rs. 27,500 *100 days access

Classroom Training

Rs. 27,500 *100 days access

Get Certification
Expert Educators
Flexible Schedule
24×7 Tech Support

Introduction to RDBMS and Oracle

Relation Database Concepts, Data model,
Entity Relational Model,
Normalization and De-normalization

Writing Basic SQL Select Statements

Selecting all and Specific columns
Arithmetic expressions,
operator precedence

Courses details

Pre-requisite For The Course: Knowledge of any Operating System

Restricting and Sorting Data

Limiting rows using a selection
Using where clause
Sorting rows using Order by Clause

Single Row Function

Character and case manipulation functions
Number, Date, Conversion functions
General functions

Displaying Data from multiple table

Obtaining data from multiple tables
Using inner join,
Right, left and full outer join
Working with Self join

Aggregating Data Using Group Functions

Group function sum, avg, max, min, count
Using Group by clause and grouping columns
Restricting groups using Having clause

Sub Queries

Using different types of sub queries
Single row and multiple row sub queries
Single and multiple row sub queries operators

Producing readable output

Define and use Substitution variable
Setting system variables and column headings

Manipulating Data

Using DML statements
Insert, update, delete and merge
Controlling transaction
using commit and rollback

Creating and Managing Tables

Using DDL statements
Using Create, Alter, Drop, Truncate

Including Constraints

Defining Column and table level constraints
Not Null, Unique, Primary Key
Foreign key and Check Constraints

Creating Views

Creating Simple and Complex views
Querying and modifying views

Other Database Objects

Creating and Using Sequences,
Synonyms and Indexes

Controlling User Access

Creating and Managing Users and Privileges
Granting and revoking privileges

Using Set Operators

Using Set operators Union,
Union All, Intersect

Oracle Date Time Functions

Using Date and Time Functions

Enhancement to Group by Clause

Using Rollup, Cube, group sets

Advance Sub Queries

Using pair wise sub queries.
Using non-pair wise sub queries

Hierarchical Retrieval

Using Hierarchical retrieval and Tree structure

Oracle Extension DML and DDL Statements

Using Multi table Insert and Update Statements

Related Courses

Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit.