Learn Practical ORACLE-SQL in 2 weeks , Trainer is an OCP(Oracle Certified Professional)-Online Classes

Batch1: 6:00 AM to 7:00 AM IST

Batch2: 4:00 PM to 5:00 PM IST

Learn Practical ORACLE-SQL in 2 weeks from an OCP (Oracle Certified Professional)

 Who Can Attend?

 *********************

Freshers/IT Professionals/Business Analyst/SQL Developers/Others who want to Learn SQL Practically with real-time scenarios.

  Note:

• Login details will be shared 1 day prior to the Online Class.
• All Concepts/Queries learned will be shared daily after the Session.
• All Participants will be provided with Learning Material.

2 WEEKS ORACLE SQL - ONLINE CLASSES

*************************************************

WEEK 1

*********

• Introduction to Oracle Database, RDBMS Concepts
• Overview of what we will be covering in 2 weeks -- (DRL, DML, TCL, DCL, DDL)
• Getting started with Select Query to retrieve data from database.
• Enhancing the Select Query by including other features..

Working with Operators and writing effective Queries:

1. Arithmetic Operators ( +,-,*,/)
2. Comparison Operators ( =,<,>,<=,>=,!=)
3. Logical Operators ( AND,OR,NOT,LIKE,IN,BETWEEN..AND ,etc.)

Working with Functions to enhance query results:

1. Single Row Functions (Character/Number/Date Functions)
2. Multiple Rows or Group Functions ( Sum/Count/Min/Max/Avg)

Using joins, retrieving data from Multiple Tables by using the following Concepts:

1. Cartesian Product
2. Equi Join
3. Non-Equi
4. Self-Join
5. Outer Join ( Left/Right)

Writing Subqueries: Writing Query inside a query

1. Single Row Subquery
2. Multiple Rows Subquery
3. Multiple Columns Subquery

WEEK 2

*********

Working with Multiple Tables using Various Set Operators in a Query

SET Operators:

1. Union All
2. Union
3. Minus
4. Intersect

Understanding and working with Integrity Constraints (Rules):

1. Not Null Constraint
2. Unique  Constraint
3. Primary Key Constraint
4. Foreign Key Constraint
5. Check Constraint

Working with DML: Data Manipulation Language (INSERT/UPDATE/DELETE Commands)

1. Inserting New Rows in the Database
2. Updating existing Rows in the Database
3. Deleting existing Rows in the Database

• Implementing TCL: Transaction Control Language (Savepoint/Commit/Rollback Commands)

• Implementing DDL: Data Definition Language (Create/Rename/Alter/Truncate/Drop)

• Working with Other Database Objects (Views/Synonym/Sequences)

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 Classroom/Online training on Oracle SQL, PL/SQL, and MS-Excel (Basic/Intermediate/Advanced).

 For Enquiries/Alternate Time-Slot or details call or WhatsApp @ 8712172191 or leave an E-mail on mouzzam@info2excel.com