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


Start Learning Now!

Over 3,600+ students have completed this course and started working at their dream jobs, what’s stopping you?

Choose the Batch that Suits You.


Contact US

Call Now
9844885059 / 9620890035


facebookjustdialinstagram Iconyoutubeyoutube



Our Specialities

Batch Flexibility

Students can choose a batch of their choice, weekend batches are available for working professionals



Very Less Fee Structure

Comapred to other institute fee structure here is very less



Effective Training

Practical Courses provide effective training since it covers all the areas of the course.



Certificate

Course Completion certificates will be issued after 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



Individual Support

Teachers can focus on the query of all students individually.



Live Training

While studying you will be working on live projects for better understanding.



Practical Training

courses are more focused on practical knowledge and Live Training rather than theoretical knowledge.



 

Courses Offered
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

Creative DESIGNING Courses



Fashion Disigning Course

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

 

Related course

 

Related Links