Oracle SQL/PLSQL Training in Bangalore
SQL/PLSQLCOURSE CONTENT
SQL * PLUS AND DATA DEFINITION COMMANDS
Definition of SQL and SQL* PLUS
The Create Object Commands
The alter, Drop Commands
Referential integrity and other constraints
DATA MANIPULATION COMMANDS
Insert, Select, Update and delete commands
Relating data through join concepts
Joining tables
Equi and non equi joins
Inner and outer joins
Sub queries and their usage
Multiple sub queries
Correlated sub queries
ARITHMATIC AND GROUP EXPRESSIONS
Usage of arithmetic operations in SQL*PLUS
Usage of arithmetic functions in SQL*PLUS
Usage of group functions in SQL*PLUS
Date Operations
Usage of NULL values
VIEWS AND SYNONYMS
Creation of Views
Querying of Views
Creation of Synonyms
TRANSCTIONAL CONTROL STATEMENTS
Commit, Rollback and Save points
SHARING, COLUMN FORMATS and INDEXES and SEQUENCES
Sharing and deadlocks
Formatting commands in SQL*PLUS
Definition of indexes and sequences
Oracle PL/SQL:
COMPONENTS OF PL/SQL
Relationship between SQL and PL/SQL
Advantages of PL/SQL
Attributes and Expressions in PL/SQL
LOOPs and Conditional statements in PL/SQL
ERROR HANDLING AND CURSORS IN PL/SQL
Definitions of Exceptions
Exception handling in PL/SQL
Cursor management in PL/SQL
PL/SQL Execution environments
Transaction handling
ADVANCED FEATURES
Subprograms and procedures
Stored procedures and functions
Triggers
Packages
Extra Topics:
Administering Database Users
Securing the Oracle Databases
Detecting and Recovering from Database Corruption
Normalization
Data Warehousing and Data Mining
Best Oracle SQL/PLSQL Training with Certification Providing in Akshaya Learning. Oracle courses in Bangalore with live projects training. Akshaya Learning is the best Oracle training institute in Bangalore with 100% placement Support Provided for Students.Oracle Fusion finance training institute in bangalore. We will provide oracle Course for beginners from Scratch to advanced Concepts in Real-time. Learn Oracle Goldengate,Oracle RAC,Oracle DBA training as a fresher and build your live project.
SQL/PLSQL Interview Questions