Duration : 20 days | 2hrs theory & Practical/day

Timings : daily 1 to 9 pm (Monday to friday)
Weekend classes (Saturday 3-4hrs / 6 weekend)

Sql course syllabus

Introduction to SQL

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,
#641/1, 8th B main road, 27th cross, 3rd block, Sapna book house road,
Opp to Nandini hotel, Jayanagar, Bangalore - 56001

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