Duration : 20 days | 1hr theory /day 1hr Practical

 

Sql course outline

Introduction to Oracle

Database management system
Single row functions

Date functions

Numeric functions

Character functions

 

Group functions

Sum ,average,max,min,count

Group by clause

Having clause

Order by clause

Rollup

Cube

Grouping sets

 

Other functions

To-char

Nvl,nvl2,nullif,coalesce

Decode

Case expression

 

Conditions and operators

 

Like condition, null condition, in condition, not condition

 

Between condition, exists, not exists

Addition, subtraction, multiplication,

division

 

Relational database management system

set operators

 

Union
Union all
Minus


Intersect

 

joins

 

Equi-join
Non-equi-join
Self-join
Left-outer-join
Right-outer-join
Full-outer-join
Natural join
Using clause
On clause


Where clause

Constraints

 

primary key
unique key
reference key or foreign key
check constraint
not null

Sub quaries

 

Single row subquaries
Multiple row subquaries
Co-related sub quaries
In-line view

Hierarchical retrival

 

top down
bottom up
prunning

 

Object relational database management system

 views

Synonyms

Sequences

Indexes

 


Contact US

A : PHILLOS,
#257, (BIIT Building),9th A Main, Near Upahaara Darshini,

 3rd Block, Jayanagar, Bangalore - 560011

E : : nishu.phillos@gmail.com


Click to call : 9620890035 / 9844885059


Click on Whatsapp: +91-9844885059


Facebook | Linked in | Google + | JD Site





BUSINESS ANALYTICS COURSE



Advanced Excel & MIS Course

vba & macros course

SAS Base & Advanced Course

Clinical sas Course

Statistical Analysis SAS Course

MSBI SSIS SSRS SSAS Course

Tableau Course

Business Analytics




SAP ERP COURSES


 

SAP fico Course

SAP ABAP Course


SAP PP Course

SAP SD Course

SAP MM Course

SAP HANA Course

SAP HR Course




GRAPHIC DESIGNING COURSES



Adobe photoshop Course
Adobe illustrator Course

Corel draw Course

Graphic designing Course

Infographics Course

Web designing Course

Video editing Course

Audio editing Course

3D Animation Course


Our Specialities


Flexible Timings

As per Office Time Or collage Timings Slots Will Be provided



Very Less Fee Structure

Comapred to other institute fee structure here is very less



Daily Theory & Practicals

Theory & Practical will be provided Everyday



Certificate

Certificates will be issued afte the courses



Course materials

Softcopy of course material will be given to every student



Placement Assistance

Placement support will be done after the course completion



Experienced Trainers & In Depth Knowledge

Very Experienced trainers will take sessions



 

 

 

Related course

 

Related Links