Back to Courses

Oracle Sql / Plsql Online Training

Online Training by SV Soft Solutions

Inquire Now

Online / Training

Inquire to Request Schedule

View this Course

Inquire for Price

Inquire Book Now

RESPONSE RATE

Details
About the Provider

Book Now

Inquire

Details

Oracle 11g( SQL, Pl/Sql)

Introduction to Data Base Management
- Basic Data Base Concepts
- Introduction to DataBase Utilities
- Introduction to Oracle Tools
Interactive SQL
- Invoking Sql* Plus
- Data Manipulation in Data Base Management systems
- Oracle Data Types
- Creating a table
- Creating table from a table
- Insertion of data into tables
  - Inserting a single row of data into a table
  - Inserting data into a table from another table
  - Insertion of selected data into a table from another table
  - Updating the contents of a table
- Deletion operations
  - Deletion of all rows
  - Deletion of specified number of rows
- Data extraction
  - Global data extract
  - The retrieval of specific columns from a table
  - Elimination of duplicates from the select statement
  - Sorting of data in a table
  - Selecting a data set from table data
- Modifying the structure of tables
  - Adding new columns
  - Modifying existing columns
  - Restrictions on the Alter table
- Revoking/Deleting/Dropping Tables
  - Exercise
- investigate the EMP database
Using SQL*Plus
- Command prompt formatting keywords and their usage
- Creating basic reports using
- Exercise format a simple query in the emp database
sql Data constraints
- Column Level and Table Level Constraints
- Null Value concepts
- Primary Key Concepts
- Unqiue Key concepts
- Default value concepts
- The Foreign key/References constraint
- Check Integrity Constraints
- Defining different constraints on the table
- Defining Integrity constraints in the ALTER TABLE command
- Dropping Integrity constraints in the ALTER TABLE command
Computations in Expression lists used to select data
- Renaming Columns used with Expression Lists
- Arithmetic Operators
- Logical Operators
- Range Searching
- Pattern matching
  - The use of the LIKE predicate
  - The IN AND NOT IN predicates
- Advanced SQL operators
  - Between operator
  - EXISTS clause
  - Using wildcards in queries (LIKE operator)
  - Aggregation in SQLCount(*)
  - Concatination operator
Select statement class
Oracle Functions
Joins
- Equi joins
- Self joins
Subqueries
- Exercise write a subquery
- Correlated subquery
- Non-correlated subqueries
Indexes
- Creating an Index for a table
- Dropping Indexes
Views
- Creation of views
- Renaming the columns of a view
- Using views
- Selecting a data set from a view
- Updateable views
- Destroying views
Sequences
- Creation of Sequences
- Referencing a Sequence
- Altering a Sequence
- Dropping a Sequence
Privileges
- Granting permissions
- Revoking Permission
Tuning Basics
- Sql Query Optimization techniques
- Indexes
- Introduction to TKPROF,EXPLAIN PLAN

PL/SQL Section

Introduction of PL/SQL
- PL/SQL architecture
- Advantages of PL/SQL Over other programming languages
Overview of PL/Sql Elements
- Blocks
- Variables and constants
- Using Sql In PL/Sql
Introduction of PL/SQL structures
- Simple blocks
- Branching and Conditional Control
- Loop Statements
- Go To statement
- Declaring variables and constants
- Executing Simple block with various examples on constants and variables
Error checking
- exception handling
- Defining exceptions
- Using the when others clause
- Ensuring complete error checking
- Passing error messages to calling routine
Boolean logic in PL/SQL
- Identifying the Uses and Types of Control Structures
- Constructing an IF Statement
- If-then-else structure
- Testing for numbers characters and Booleans
Iteration in PL/SQL
- Constructing and Identifying Different Loop Statements
- For loop
- While loop
Cursors
- Introduction of cursor
- Cursor Attributes
- Implicit cursor & Explicit cursor
Procedure, Function and Packages
- Defining stored procedures & functions
- Passing arguments to functions and stored procedures
- Recompiling functions and stored procedures
- Package forward declaration
- Package dependency
- Listing package information
Records, Pl/Sql Tables
- Defining PL/SQL tables
- Reasons to use PL/SQL tables
- Populating a PL/SQL table
- Retrieving from a PL/SQL table
Object types and Collections.
Triggers
- Use of Data base triggers
- Defining a trigger
- Enabling and disabling a trigger

Reviews

Be the first to write a review about this course.

Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits