Free Training : Learn SQL From Home in 10 days--1st April to 14th April

Training on: Oracle  SQL

Duration: 10 Days (Sessions will be from Monday to Friday only)

Date: Starting From Wednesday,1st April to 14th April 2020

Who can attend?

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

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 Software.
• Overview of various 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
• 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
• Creating Tables and Views and enforcing Integrity Constraints using DDL Commands (Create, Rename, Alter, Truncate, Drop)
• Inserting New Records, Updating Existing Records and Deleting existing records using DML Commands ( 1. Insert 2. Update 3. Delete )
• Saving Data permanently the Database using TCL Commands (Savepoint, Commit, Rollback).
• Viewing/Managing data from other users/Schema using DCL Commands (Grant, Revoke)
• 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.
• Assessment

Note: Training material will be provided. 

For any queries related to this Training, please write an email to mouzzam.ocp@gmail.com and keep the subject as "Oracle SQL 10 daysTraining"

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