Oracle SQL Training in Bangalore
Learn Oracle SQL Course from Expert Oracle Trainers who are Real-time Working Professionals.
Expert Trainers | Practical Training | Mock Interviews | Placement Assistance | Job Support
Best Oracle SQL Training in Bangalore
Enroll Today
Why Choose Softgen Infotech
Softgen Infotech is a leading Training Institute in Bangalore providing Quality Training for Multiple IT Courses with Placement Assistance.
Live & Interactive Sessions
Real Time Training
Practical Classes
Interview & Placement Assistance
Need Advice?
Worried or Confused whether this is the right course for you? Feel free to reach our Expert Consultant for all your Queries !

Course Material & Syllabus
Get all Course Content and Syllabus. Get Trained like a Professional. We Provide Course Material, Prepare for Interviews, Arrange Mock Interviews and 100 % Placement Assistance
Chapter 1 – Retrieving Data Using the SQL SELECT Statement
- The SELECT Statement
- The SELECT and FROM Clauses
- Conditions and the WHERE Clause
- Other Conditional Operators
- Logical Operators
Chapter 2 – Restricting and Sorting Data
- The ORDER BY Clause
- Column Aliases
- Arithmetic Expressions
- Precedence of Operators
Chapter 3 – Using Single-Row Functions to Customize Output
- Function Types
- Using Table dual to try out Functions
- Numeric Functions
- Character Functions
- String Concatenation
- Date Arithmetic and Date Functions
Chapter 4 – Using Conversion Functions and Conditional Expressions
- Conversion Functions
- NVL and NVL2
- DECODE
- CASE Expressions
- COALESCE and NULLIF
Chapter 5 – Reporting Aggregated Data Using the Group Functions
- SUM()
- COUNT()
- MIN()
- MAX()
- AVG()
Chapter 6 – Displaying Data from Multiple Tables
- Overview of Table Joins
- Inner Joins
- Table Aliases
- Outer Joins
- Self Joins
- ANSI Standard Joins
Chapter 7 – Using Sub queries to Solve Queries
- Overview of Subqueries
- Simple Subqueries
- Complex Subqueries
- Subquery Rules
- Using the ANY, ALL and IN Operators
Chapter 8 – Using the Set Operators
- UNION ,UNION ALL,INTERSECT and MINUS
Chapter 9 – Manipulating Data
- Inserting Rows
- Updating Rows
- Deleting Rows
- Verifying Updates
- Transaction Control
- Commit and Rollback
- Save points
- Commits and Constraints
- Amending Data in SQL Developer
Chapter 10 – Using DDL Statements to Create and Manage Tables
- Creating Tables
- Specifying Constraints
- Altering Tables, Columns and Constraints
- Dropping Tables, Columns and Constraints
- Copying Tables
- Data dictionary
Chapter 11 – Creating Other Schema Objects
- Creating Indexes
- Dropping Indexes
- Listing Indexes
- Creating and Using Views
- Dropping Views
- Listing Views
- Create a Sequence
- View Sequence Details
- Create a Synonym
- List Synonyms
Oracle 11g PL/SQL Course Content:
Introduction to PL/SQL
What is PL/SQL
PL/SQL Environment
Benefits of PL/SQL
Overview of the Types of PL/SQL blocks
Create and Execute a Simple Anonymous Block
Oracle SQL Training Course Duration & Batch Timings
Duration : 30 Hours | Version : latest Version |
---|---|
Regular : 1 Hour per day | Fast Track : 2 - 3 Hours per day: 10 days |
Weekdays : Monday - Friday | Weekend : Saturday and Sunday |
Online Training : Available | Class Room Training : Available |
Course Fee : Talk to our Customer Support | Mode of Payment : Talk to our Customer Support |
Frequently Asked Questions for Oracle SQL Training Course
Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.