You profile has been submitted for review.
Sandeep S Sr IT Developer
No reviews yet
A highly energetic, articulate and hands-on Principal Trainer with extensive experience in successfully training people at all levels and abilities on SQL & PLSQL . Able to devise and deliver practical courses that are tailored to meet the specific needs/abilities of participants and the business. Exceptionally patient and communicates complex technical concepts simply and clearly. Extremely strong technical skills gained through considerable experience as a developer and able to relate real world examples to the particular experience and needs of participants.
Training will be on web based and real time scenarios will be taught with examples.
Below is the high level Content.
SQL Contents:
Chapter 1. SQL and Data
What Is SQL?
Why Learn SQL?
An Introduction to Databases
Lab 1.1. The Relational Database
Lab 1.2. Data Normalization and Table Relationships
Lab 1.3. The STUDENT Schema Diagram
Chapter 2. SQL: The Basics
Lab 2.1. The SQL Execution Environment
Lab 2.2. The Anatomy of a SELECT Statement
Lab 2.3. An Introduction to SQL*Plus
Chapter 3. The WHERE and ORDER BY Clauses
Lab 3.1. The WHERE Clause
Lab 3.2. The ORDER BY Clause
Chapter 4. Character, Number, and Miscellaneous Functions
Chapter 4.Data Types
Lab 4.1. Character Functions
Lab 4.2. Number Functions
Lab 4.3. Miscellaneous Single-Row Functions
Chapter 5. Date and Conversion Functions
Lab 5.1. Applying Oracle’s Date Format Models
Lab 5.2. Performing Date and Time Math
Lab 5.3. Understanding the TIMESTAMP and TIME ZONE Data Types
Lab 5.4. Converting from One Data Type to Another
Chapter 6. Aggregate Functions, GROUP BY, and HAVING Clauses
Lab 6.1. Aggregate Functions
Lab 6.2. The GROUP BY and HAVING Clauses
Chapter 7. Equijoins
Lab 7.1. The Two-Table Join
Lab 7.2. Joining Three or More Tables
Chapter 8. Subqueries
Lab 8.1. Simple Subqueries
Lab 8.2. Correlated Subqueries
Lab 8.3. Inline Views and Scalar Subquery Expressions
Lab 8.4. ANY, SOME, and ALL Operators in Subqueries
Chapter 9. Set Operators
Lab 9.1. The Power of UNION and UNION ALL
Lab 9.2. The MINUS and INTERSECT Set Operators
Chapter 10. Complex Joins
Lab 10.1. Outer Joins
Lab 10.2. Self-Joins
Chapter 11. Insert, Update, and Delete
Lab 11.1. Creating Data and Transaction Control
Lab 11.2. Updating and Deleting Data
Chapter 12. Create, Alter, and Drop Tables
Lab 12.1. Creating and Dropping Tables
Lab 12.2. Altering Tables and Manipulating Constraints
Chapter 13. Indexes, Sequences, and Views
Lab 13.1. Indexes
Lab 13.2. Sequences
Lab 13.3. Views
Chapter 14. Security
Lab 14.1. Users, Privileges, Roles, and Synonyms
PLSQL Contents:
Intro
Pl/SQL Concepts:
• Client/Server Architecture
• PL/SQL Anonymous Blocks
• Understand How PL/SQL gets Executed
General Programming Language Fundamentals.
• PL/SQL Programming Fundamentals.
• Making Use of PL/SQL Language Components
• Making Use of PL/SQL Variables
• Handle PL/SQL Reserved Words
• Identifiers In PL/SQL
• Anchored Data Types
• Declare and initialize variables
SQL in PL/SQL
• DML in PLSQL.
• INTO Syntax
• Sequence in a PLSQL block.
• Save point
• Commit/rollback
Conditional Control: IF Statements
• IF Statements
• ELSIF Statements
• Nested IF Statements
Conditional Control: Case Statements
• Case
• Searched Case
• Case Expression
• NULLIF and COALESCE Functions
Iterative Control: Part I
• Simple Loops
• While Loops
• Numeric For Loops
Iterative Control: Part I
• The Continue Statements
• Continue When Conditions
• Nested Loops
Error Handling and Built-in Exceptions
• Handling Errors
• Built-in Exceptions
Exceptions
• Exception Scope
• User Defined Exceptions
• Exception Propagation.
Introduction to Cursors
Triggers
Collections
Records
Procedures
Functions
Packages
Object Types In oracle
Oracle Supplied Packages
Training will be on web based and real time scenarios will be taught with examples.
Below is the high level Content.
SQL Contents:
Chapter 1. SQL and Data
What Is SQL?
Why Learn SQL?
An Introduction to Databases
Lab 1.1. The Relational Database
Lab 1.2. Data Normalization and Table Relationships
Lab 1.3. The STUDENT Schema Diagram
Chapter 2. SQL: The Basics
Lab 2.1. The SQL Execution Environment
Lab 2.2. The Anatomy of a SELECT Statement
Lab 2.3. An Introduction to SQL*Plus
Chapter 3. The WHERE and ORDER BY Clauses
Lab 3.1. The WHERE Clause
Lab 3.2. The ORDER BY Clause
Chapter 4. Character, Number, and Miscellaneous Functions
Chapter 4.Data Types
Lab 4.1. Character Functions
Lab 4.2. Number Functions
Lab 4.3. Miscellaneous Single-Row Functions
Chapter 5. Date and Conversion Functions
Lab 5.1. Applying Oracle’s Date Format Models
Lab 5.2. Performing Date and Time Math
Lab 5.3. Understanding the TIMESTAMP and TIME ZONE Data Types
Lab 5.4. Converting from One Data Type to Another
Chapter 6. Aggregate Functions, GROUP BY, and HAVING Clauses
Lab 6.1. Aggregate Functions
Lab 6.2. The GROUP BY and HAVING Clauses
Chapter 7. Equijoins
Lab 7.1. The Two-Table Join
Lab 7.2. Joining Three or More Tables
Chapter 8. Subqueries
Lab 8.1. Simple Subqueries
Lab 8.2. Correlated Subqueries
Lab 8.3. Inline Views and Scalar Subquery Expressions
Lab 8.4. ANY, SOME, and ALL Operators in Subqueries
Chapter 9. Set Operators
Lab 9.1. The Power of UNION and UNION ALL
Lab 9.2. The MINUS and INTERSECT Set Operators
Chapter 10. Complex Joins
Lab 10.1. Outer Joins
Lab 10.2. Self-Joins
Chapter 11. Insert, Update, and Delete
Lab 11.1. Creating Data and Transaction Control
Lab 11.2. Updating and Deleting Data
Chapter 12. Create, Alter, and Drop Tables
Lab 12.1. Creating and Dropping Tables
Lab 12.2. Altering Tables and Manipulating Constraints
Chapter 13. Indexes, Sequences, and Views
Lab 13.1. Indexes
Lab 13.2. Sequences
Lab 13.3. Views
Chapter 14. Security
Lab 14.1. Users, Privileges, Roles, and Synonyms
PLSQL Contents:
Intro
Pl/SQL Concepts:
• Client/Server Architecture
• PL/SQL Anonymous Blocks
• Understand How PL/SQL gets Executed
General Programming Language Fundamentals.
• PL/SQL Programming Fundamentals.
• Making Use of PL/SQL Language Components
• Making Use of PL/SQL Variables
• Handle PL/SQL Reserved Words
• Identifiers In PL/SQL
• Anchored Data Types
• Declare and initialize variables
SQL in PL/SQL
• DML in PLSQL.
• INTO Syntax
• Sequence in a PLSQL block.
• Save point
• Commit/rollback
Conditional Control: IF Statements
• IF Statements
• ELSIF Statements
• Nested IF Statements
Conditional Control: Case Statements
• Case
• Searched Case
• Case Expression
• NULLIF and COALESCE Functions
Iterative Control: Part I
• Simple Loops
• While Loops
• Numeric For Loops
Iterative Control: Part I
• The Continue Statements
• Continue When Conditions
• Nested Loops
Error Handling and Built-in Exceptions
• Handling Errors
• Built-in Exceptions
Exceptions
• Exception Scope
• User Defined Exceptions
• Exception Propagation.
Introduction to Cursors
Triggers
Collections
Records
Procedures
Functions
Packages
Object Types In oracle
Oracle Supplied Packages
Subjects
-
SQL Beginner-Expert
-
PLSQL Beginner-Expert
-
Oracle Fusion Procurement Beginner-Expert
-
Oracle Fusion Financials Beginner-Expert
-
Oracle Integration Cloud (OIC) Beginner-Expert
Experience
-
SR IT Developer (Sep, 2011–Present) at Veritas Technologies India PVT LTD
Education
-
eee (Aug, 2006–Aug, 2010) from AURORAS RESEARCH AND TECHNOLOGICAL INSTITUTE
Fee details
₹1,000–2,000/hour (US$10.53–21.05/hour)
Total Classes will be of 30 days. I will cover Both SQL & PLSQL every day 1 hour .
-
-
Vishal Nagar, Pimpri-Chinchwad, Maharashtra, India
-
Can travel:
No
-
- Last login: Nov 21, 2025
- Registered: Aug 13, 2018
- Total Teaching exp: 5.0 yrs.
- Teaches online: Yes
- Online Teaching exp: 5.0 yrs.
- Teaches at student's home: No
- Homework Help: Yes
-
Gender: Male
- Works as: Individual teacher
- Speaks: English, Telugu
-
Fee:₹1,000–2,000/hour(USD 10.53–21.05/hour)
Reviews
No reviews yet. Be the first one to review this tutor.
