postgre SQL course for Intermediate trainees by Vertex IT Service

SQL Syllabus
Course Contents
Basic SQL
1. Introduction to SQL
2. Writing Basic SQL SELECT Statements
3. Restricting and Sorting Data
4. Single Row Functions
5. Displaying Data from Multiple Tables
Objectives
6. Aggregating Data Using Group Functions
7. Sub-Queries
8. Producing Readable Output with iSQL*Plus
9. Manipulating Data
10. Creating and Managing Tables
11. Including Constraints

Advanced SQL

12. Creating Views
13. Other Database Objects
14. Controlling User Access
15. Using SET Operators
16. Datetime Functions
17. Enhancements to the GROUP BY Clause
18. Advanced Sub queries
19. Hierarchical Retrieval
20. Extensions to DML and DDL Statements
Objectives
21. Advanced Functions in SQL

About Training Institute

VITS is Established in 2010, Vertex IT Services (VITS) is a leading IT training, placement and networking service provider company in Pune. VITS started off with a vision of imparting relevant and accurate knowledge to IT professionals and college students. The main objective of VITS is to create professionals who are skilled enough to work in the industry from day one.

We provide networking services with our sister company.

Our business model is based on needs of companies looking for well-trained resources tailored as per their business requirements.

Working Domains:

IT Training:
Corporate training
Classroom training
Online training
Software Development
Internship / Live Projects