PL/SQL Live Training - Weekend Batch

 

Live and Interactive Training on: Oracle Developer (Covers PL/SQL).

Duration: 5 Weeks (Sessions will be on Saturday and Sunday)

 

Training Details will be shared with Registered Candidates, after successful registration.

 

Date: Starting From Saturday,20th June 2020

 

Who can attend?

• Anyone who would like to become a confident PL/SQL Developer/Business Analyst/Data Analyst/Fresh Graduates/Working-Professionals/Aspiring Database Developers.

 

Trainer: Mouzzam Ali , Oracle Certified Professional (OCP)

  

 

PL/SQL Course Contents:

 

Week-1:

• Overview of SQL
• DML Statements in SQL ( Insert/Update/Delete)
• TCL ( Commit/Rollback)
• PL/SQL Environment, Features, Advantages
• Writing Anonymous Blocks
• Incorporating SQL Statements in PL/SQL

 

Week-2:

• Using Attributes ( %TYPE, %ROWTYPE),
• Control Structures ( Conditional Control, Iterative Control )
• Exceptions (Predefined, Non-Predefined, User Defined)

 

Week-3:

• Cursors ( Implicit, Explicit Cursors, Cursor For Loop)
• Introduction to Sub Programs and Data Dictionaries ( User_Source / User_Objects)

 

Week-4:

• Procedures : Creating/Executing/Invoking/Calling.
• Functions : Creating/Using in Select Query and other Sub Programs.

 

Week-5:

• Packages (Package Specification, Package Body, Package Overloading) : Creating and Implementing
• Triggers : Creating and implementing
• Assessment -2
• Course Review

 

Note: Training material will be provided which includes Daily Queries along with Results and Notes with complete PPT Slides. 

 

About the Trainer:

Mouzzam Ali is an Oracle Certified Professional (OCP) in the SQL and PL/SQL development track. He has been working as a Business Data Analyst. His experience includes Design, Development, and Analysis of Database and Reporting. He has excellent Presentation and Communication Skills. He has been delivering Corporate/Classroom/Online training on Oracle SQL, PL/SQL, and MS-Excel (Basic/Intermediate/Advanced).

 If you would like to first learn SQL : https://www.meraevents.com/event/sql-live-training-weekend-batch