Online Training--Oracle SQL and PL/SQL in 1 Month

Online Training -- Learn Oracle SQL and PL/SQL in 1 Month

Date: 16th March -- 15th April 2020

Timings 6:00 Am to 7:30 Am IST

Who can attend?

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

Trainer: Mouzzam Ali 

SQL Course Contents :  

• Introduction to Oracle, RDBMS
• Various Tools to interact with Oracle Database.
• Downloading Database from Oracle Corporation for Learning Purpose and Installing Database and SQL Developer Softwares.
• Working with SQL Languages (DRL, DML, TCL, DCL, DDL)
• Schema Objects: Tables, Views.
• Getting started with Select Query to retrieve data from the database.
• Operators: 1. Arithmetic 2. Comparison 3. Logical
• Functions: 1. Single Row 2. Multiple Rows or Group Functions
• Assessment -1
• Joins (Retrieving data from Multiple Tables) 1. Cartesian Product 2. Equi Join 3. Non-Equi 4. Self-Join 5. Outer Join ( Left/Right)
• Subqueries: Query inside a query 1. Single Row 2. Multiple Rows 3. Multiple Columns.
• SET Operators: 1. Union All 2. Union 3. Minus 4. Intersect
• Integrity Constraints: 1. Not Null 2. Unique 3. Primary Key 4. Foreign Key 5. Check
• DCL  (Grant, Revoke)
• DDL (Create, Rename, Alter, Truncate, Drop)
• DML: 1. Insert 2. Update 3. Delete
• TCL (Savepoint, Commit, Rollback)
• Assessment -2

PL/SQL Course Contents :

• 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
• Using Attributes ( %TYPE, %ROWTYPE),
• Control Structures ( Conditional Contol, Iterative Control )
• Exceptions (Predefined, Non-Predefined, User Defined)
• Assessment -1
• Cursors ( Implicit, Explicit Cursors, Cursor For Loop)
• Introduction to Sub Programs and Data Dictionaries ( User_Source / User_Objects)
• Procedures
• Functions
• Packages (Package Specification, Package Body)
• Triggers
• Assessment -2
• Course Review, Q&A

Note: Training material will be provided. 

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).