Oracle SQL PLSQL live online Training |Impetus Consultrainers

Course	Start Date	Days	Timing
Python	11-MARCH-20	M-F	12.00 PM-02.00 PM
Python	14-MARCH-20	S-S	04.00 PM-06.00 PM
Python	26-MARCH-20	M-F	10.00 aM-12.00 PM
Software Testing	08-MARCH-20	S-S	11.00 AM-12.00 PM
Software Testing	16-MARCH-20	M-F	12.00 PM-02.00 PM
Software Testing	21-MARCH-20	S-S	10.00 AM-12.00 PM
Selenium	07-MARCH-20	S-S	10.00 AM-12.00 PM
Selenium	22-MARCH-20	S-S	12.00 PM-02.00 AM
QTP	15-MARCH-20	S-S	12.00 AM-02.00 PM
JMeter	22-MARCH-20	S-S	08.00 PM-10.00 PM
MVC	05-MARCH-20	M-F	08.00 AM-10.00 AM
MVC	21-MARCH-20	S-S	04.00 PM-06.00 PM
.Net	05-MARCH-20	M-F	06.00 AM-08.00 PM
.Net	14-MARCH-20	S-S	04.00 AM-06.00 PM
.Net	23-MARCH-20	M-F	12.00 PM-02.00 PM
.Net	07-MARCH-20	S-S	02.00 PM-04.00 PM
.Net	16-MARCH-20	M-F	08.00 AM-10.00 PM
.Net	16-MARCH-20	M-F	10.00 AM-12.00 PM
Java	03-MARCH-20	M-F	08.00 PM-10.00 PM
Java	08-MARCH-20	S-S	06.00 PM-08.00 PM
Java	23-MARCH-20	M-F	10.00 PM-12.00 PM
Advanced Java	07-MARCH-20	S-S	06.00 AM-08.00 AM
Advanced Java	16-MARCH-20	M-F	12.00 PM-02.00 PM
Advanced Java	24-MARCH-20	M-F	02.00 AM-04.00 AM
SQL	11-MARCH-20	M-F	12.00 PM-02.00 PM
SQL	14-MARCH-20	S-S	02.00 PM-04.00 PM
SQL	24-MARCH-20	M-F	10.00 AM-12.00 PM
Android	07-MARCH-20	S-S	10.00 AM-12.00 PM
Android	18-MARCH-20	M-F	10.00 PM-12.00 PM
MAT	21-MARCH-20	S-S	02.00 PM-04.00 PM

Description

In Combo courses the core technologies are covered in depth. The knowledge of programming fundamentals is a prerequisite for these courses.

Prerequisite

Knowledge of programming

Modules Covered - 75 Hours

Structured Query Language (SQL) - 40 Hours

Software application cannot be complete without this support of a good database management system. SQL is an inherent part of any program. Current RDBMS products have many rich functionality like core related subqueries, advance group function, hierarchical queries, storing media in the database and many more.

Contents
1. Simple Queries
2. Single Row Functions
3. Joins
4. Group Functions
5. Sub-queries
6. Set Operations
7. DDL, DML queries

Contents
8. Constraints
9. Creating users and Roles
10. Advanced Group Functions
11. Manipulating Large Data Sets
12. Managing Data From Different Time Zones
13. Hierarchical Queries
14. Regular Expressions

PL/SQL - 35 Hours

In this module we covered the use of store procedure as a middleware.

Contents
1. PL/SQL Introduction
2. Programming constructs
3. Control Structure
4. Exception Handling
5. Cursors
6. PL/SQL Subprograms Procedures Functions Packages

Contents
7. Oracle Supplied Packages
8. Dynamic SQL and Metadata
9. Design Considerations in PL/SQL
10. Managing Dependencies
11. Managing Large Objects
12. Triggers

Modules Covered - 35 Hours

Structured Query Language (SQL)

30 Hours

Contents
1. Simple Queries
2. Single Row Functions
3. Joins
4. Group Functions
5. Sub-queries
6. Set Operations
7. DDL, DML queries
8. Constraints
9. Creating users and Roles
10. Advanced Group Functions
11. Manipulating Large Data Sets
12. Managing Data From Different Time Zones
13. Hierarchical Queries
14. Regular Expressions

PL/SQL

35 Hours

in this module we covered the use of store procedure as a middleware.

Contents
1. Foundation Modules
2. PL/SQL Introduction
3. Programming constructs
4. Control Structure
5. Exception Handling
6. Cursors
7. PL/SQL Subprograms Procedures Functions Packages
8. Oracle Supplied Packages
9. Dynamic SQL and Metadata
10. Design Considerations in PL/SQL
11. Managing Dependencies
12. Managing Large Objects
13. Triggers

Oracle SQL/PLSQL Training