Oracle SQL and Plsql Training
Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.
Learners : 1080
Duration : 30 Days
About Course
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user’s request. This chapter provides background information on SQL as used by most database systems. Enroll now and get certified in it.
Oracle SQL and Plsql Training Course Syllabus
Oracle SQL and Plsql
✔ DBMS Concepts
✔ Role of Oracle 11g in Information management.
✔ Concepts of RDBMS
✔ RDBMS Rules (Codd’s Rules)
✔ What is Object Model?
✔ Features of Oracle 9i/10g/11i/12c
✔ E-R Modeling
✔ What is SQL?
✔ Roles of SQL in RDBMS
✔ What is SQL * Plus
✔ Types of Plus Commands
✔ Data Definition Language (DDL)
✔ Naming Conversion in Oracle
✔ Data Types of Oracle
✔ Implementation of Data Integrity & Integrity Constraints
✔ Normalization
✔ System Tables & Data Dictionary
✔ Insert
✔ Select
✔ Update
✔ Delete
✔ Single Row Functions (Oracle SQL and Plsql)
✔ Group functions
✔ Arithmetic Functions
✔ String Manipulation Functions
✔ Date Manipulation Functions
✔ Data conversion Functions
✔ List of Functions /Misc.Functions
✔ What is joining?
✔ Types of joins
✔ Cartesian joins
✔ Equi join/Non-Equi/Outer/Self join
✔ Simple /complex subqueries
✔ Co-related subquery
✔ Filters/Set operator usage
✔ Arithmetic Operators
✔ Relational Operators
✔ Relational Negation Operators
✔ Logical Operators
✔ Set Operators
✔ Index
✔ Types of Indexes
✔ Unique Index
✔ Non-Unique Index
✔ Function Bases Index
✔ Types of views (Oracle SQL and Plsql)
✔ Forced views
✔ Rules for DML on Views
✔ In-Line Views
✔ Materialized Views
✔ Types of synonyms
✔ Private synonym
✔ Public synonym
✔ Security aspect
✔ Usage mechanism of clusters
✔ Usage of various clauses
✔ Pseudo columns
✔ Simple Deletion
✔ Critical Data Deletion
✔ Using joining concept
✔ Using Sub query concept
✔ Using correlate Sub queries
✔ Table Update
✔ Multi-column updates
✔ Table Updation Using Decode Statement
✔ COMMIT
✔ ROLLBACK
✔ SAVE POINT
✔ Data Consistency
✔ GRANT
✔ REVOKE
✔ Create New User
✔ Assign Privileges For User
✔ What are privileges?
✔ What is a role?
✔ Grant privileges
✔ Cascading privileges
✔ Password Change
✔ Oracle Table Partitions
✔ Range Partitions
✔ List Partitions
✔ Composite Partitions
✔ Introduction to PL/SQL
✔ Key benefits of PL/SQL over SQL
✔ The architecture of PL/SQL
✔ PL/SQL Block Structure
✔ Constructs of PL/SQL
✔ Data type support in PL/SQL
✔ Variables /Constants of PL/SQL
✔ Flow control Statement Types
✔ If /Nested if .. / Exit/Go to/Raise
✔ Instructive statement types
✔ Simple loop (infinite loop)
✔ While loop
✔ For loop
✔ Reverse For loop
✔ What is Embedded SQL
✔ Need of Embedded SQL
✔ Constructs of Embedded SQL
✔ Transactions through Embedded SQL
✔ Valid statements of SQL
✔ Dynamic SQL
✔ What is an Exception?
✔ Type of Exceptions
✔ User Defined Exceptions
✔ Use of raise and its Scope
✔ Raise – Application-Error ( )
✔ PRAGMA EXCEPTION_INIT ( )
✔ Description
✔ Advantages
✔ Types of variables of PL/SQL
✔ Record type of PL/SQL
✔ Instruction to Cursor Management
✔ Pictorial view of cursor Diagram
✔ Implicit curser
✔ Explicit curser
✔ Cursor 1st Model
✔ Cursor 2nd Model
✔ Cursor 3rd Model
✔ Cursor 4th Model
✔ Cursor 5th Model
✔ Cursor Attributes
✔ Cursors using a simple loop
✔ Cursor for loops
✔ Cursor Exceptions
✔ Cursor Parameters
✔ Static Ref cursor
✔ Dynamic Ref cursor
✔ Dynamic behaviors of cursor mnt
✔ User-defined types (RECORDS)
✔ PL/SQL tables (2D ARRAYS)
✔ Dynamic behaviors of PL/SQL tables
✔ PL/SQL table Attributes
✔ Bulk Collect
✔ Bulk Bind
✔ Types of PL/SQL blocks
✔ Anonymous PL/SQL block
✔ Named PL/SQL block
✔ Stored PL/SQL
✔ Procedures
✔ Type of parameters
✔ Procedures Using In Parameter
✔ Procedures Using Out Parameter
✔ Procedures Using InOut Parameters
✔ Functions
✔ Description
✔ Advantages over Standalone Schema objects
✔ Encapsulation
✔ Package overloading
✔ Packages Create Using Global Variables
✔ Packages Create Using Record Types
✔ Packages Create Using Cursors
✔ Packages Create Using Ref Cursors
✔ Packages Create Using plsql Table Types
✔ Packages Create Using Procedures
✔ Packages Create Using Functions
✔ 12 Types of Triggers
✔ Triggering events
✔ Usage of Old & New reference
✔ View Trigger instead of Trigger Cascading /firing
✔ Table mutation error
✔ Bind variable support
✔ Special clauses of Triggers
✔ Statement Level Triggers
✔ Row Level Triggers
✔ Object Types
✔ Create Object Tables
✔ Create Nested Tables
✔ Index By Tables / Associative Array
✔ Varray
✔ New enhancements in oracle 10g,11g, And 12c
✔ New clauses in joining of tables
✔ Inner join/left outer join /right outer join
✔ Full outer join/natural full outer join
✔ Using clause/cross join
✔ Multi-table inserts
✔ Insert all command
✔ Merge command (UpSert)
✔ NVL ( ) enhancements
✔ Case statement of select command
✔ Searched CASE expression
✔ Heap tables
✔ Index Organized Tables (IOT)
✔ Temporary tables/global tables
✔ Multi-column updates
✔ Multiple Row subqueries
✔ New function EXTRACT( )
✔ Usage of subquery in the select list
✔ Autonomous Transaction
✔ Flashback Concepts
✔ Purge Concepts
Live Instructor Based Training With Software |
Lifetime access and 24×7 support |
Certification Oriented content |
Hands-On complete Real-time training |
Get a certificate on course completion |
Flexible Schedules |
Live Recorded Videos Access |
Study Material Provided |
Oracle SQL and Plsql Training - Upcoming Batches
7th NOV 2022
8 AM IST
Coming Soon
AM IST
5th NOV 2022
8 AM IST
Coming Soon
AM IST
Don't find suitable time ?
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
-
Schedule your sessions at your comfortable timings.
-
Instructor-led training, Real-time projects
-
Certification Guidance.
Self-Paced Learning
-
Complete set of live-online training sessions recorded videos.
-
Learn technology at your own pace.
-
Get access for lifetime.
Corporate Training
-
Learn As A Full Day Schedule With Discussions, Exercises,
-
Practical Use Cases
-
Design Your Own Syllabus Based
Oracle SQL and Plsql Online Training FAQ'S
- PL/SQL provides the feature of decision-making, looping, and branching by making use of its procedural nature.
- Multiple queries can be processed in one block by making use of a single command using PL/SQL.
- The PL/SQL code can be reused by applications as they can be grouped and stored in databases as PL/SQL units like functions, procedures, packages, triggers, and types.
- PL/SQL tables are nothing but objects of type tables that are modeled as database tables. They are a way to provide arrays that are nothing but temporary tables in memory for faster processing.
- These tables are useful for moving bulk data thereby simplifying the process.
SQL stands for the Structured Query Language. It is the standard language used to maintain the relational database and perform many different data manipulation operations on the data. SQL was initially invented in 1970. It is a database language used for database creation, deletion, fetching and modifying rows, etc. sometimes, it is pronounced as 'sequel.' We can also use it to handle organized data comprised of entities (variables) and relations between different entities of the data.
- Data definition language (DDL): It defines the data structure that consists of commands like CREATE, ALTER, DROP, etc.
- Data manipulation language (DML): It is used to manipulate existing data in the database. The commands in this category are SELECT, UPDATE, INSERT, etc.
- Data control language (DCL): It controls access to the data stored in the database. The commands in this category include GRANT and REVOKE.
- Transaction Control Language (TCL): It is used to deal with the transaction operations in the database. The commands in this category are COMMIT, ROLLBACK, SET TRANSACTION, SAVEPOINT, etc.
Get ahead in your career by learning Oracle SQL and Plsql through VISWA Online Trainings
A database is an organized collection of data that is structured into tables, rows, columns, and indexes. It helps the user to find the relevant information frequently. It is an electronic system that makes data access, data manipulation, data retrieval, data storing, and data management very easy. Almost every organization uses the database for storing the data due to its easily accessible and high operational ease. The database provides perfect access to data and lets us perform required tasks.