SQL PLSQL Training Syllabus | Real Time Database Training

LearnoMate Technologies > SQL PLSQL Training Syllabus | Real Time Database Training

LearnoMate is the best oracle dba training . We provide real time training for SQL PLSQL Training. Please watch us on YouTube Channel before you trust us.

YouTube Channel[ANKUSH THAVALI]

Register here if you are interested for SQL PLSQL Training.

Register here.

Few key areas of training

  1. SQL and PLSQL 
  2. Limited students per batch
  3. All session get recorded
  4. 24*7 support
  5. Basic fees compare to market
  6. Online Batch
  7. Flexible timing
  8. Notification about job vacancies
  9. Real time scenario
  10. Daily Assignment
  11. Training Syllabus
  12. Resume preparation
  13. 100 % Job Assistant
syllabus

SQL Syllabus

  1. Introduction to SQL.

 

  1. Data Types in SQL.

 

  1. DDL Commands:
  • Create
  • Drop
  • Alter
  • Desc
  • Truncate
  • Commit
  • Rollback

 

  1. DML Commands:
  • Insert
  • Update
  • Delete
  • Select

 

  1. Constraints:
  • Primary key
  • Foreign Key

 

  1. Clauses
  • Where clause
  • Like clause
  • In clause
  • Order by clause
  • Having clause
  • Group by clause
  • Exists clause

 

  1. Operators:
  • AND
  • OR
  • BETWEEN
  • <>, <= >=, =, !=, <>

 

  1. SQL Aggregation Functions:
  • Count
  • Min, Max
  • Avg, Sum

 

  1. SQL Conditions
  • not in
  • is null not null
  • distinct
  • nvl, nvl2

 

  • Views in SQL.

 

  • INDEXES and Sequence in SQL

 

  • Sub-Queries in SQL.

 

  • String operations:
  • Concatenation
  • length
  • replace
  • Sub-string
  • In string.

 

  • UNION, UNION ALL in SQL.

 

  • Joins
  • Inner Join
  • Self Join
  • Cross Join/ Cartesian product
  • Left outer Join
  • Right outer Join
  • Full outer Join

PLSQL Syllabus

  1. Introduction to PL/SQL (Anonymous Block).

 

  1. Loops and Conditions in PLSQL
  • IF ELSE loop
  • Nested IF Else
  • For LOOP
  • While Loop
  • Simple Loop
  • Continue
  • Go To

 

  1. Record Types in PLSQL
  • %type
  • %rowtype
  • User Define Record type

 

  1. CASE and DECODE in PLSQL

 

  1. Cursors Attributes in PLSQL
  • %found
  • %notfound
  • %isopen
  • %rowtype

 

 

  1. Cursor in PLSQL
  • Explicit Cursor
  • For Loop Cursor
  • Parameterized Cursor

 

  1. Exception handling
  • Oracle define Exception
  • User define Exception

 

  1. Procedures
  • With IN, OUT, INOUT Parameter
  • Without Parameter

 

  1. Functions
  • With IN, OUT, INOUT Parameter
  • Without Parameter

 

  1. Triggers (Triggers on INSERT UPDATE DELETE).

 

  1. Packages
  • Using Cursor, Procedure, Function and Exceptions