2 DAYS ORACLE SQL PRACTICAL WORKSHOP @ SUN CITY

2 DAYS ORACLE SQL PRACTICAL WORKSHOP

When: Saturday, April 6th,  & Sunday, April 7th, 2019.

 Time: 10:30 AM – 4:30 PM IST

Address: Knowledge Hub, Suncity Main Road, Near langer Hauz, Hyderabad 500086

What will you learn?

After attending this 2 days  SQL workshop, the participants will get a clear idea of Database, write SQL Queries easily, extract data from the database and understand the logic behind any Queries.

Trainer: Mouzzam Ali

Agenda :

Daywise Schedule:

DAY 1:-

• Introduction to Oracle, RDBMS
• Working with SQL Languages (DRL, DML, TCL, DCL, DDL)
• 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
• 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

DAY 2:-

• 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
• DML: 1. Insert 2. Update 3. Delete
• TCL (Savepoint, Commit, Rollback)
• DDL (Create, Rename, Alter, Truncate, Drop)
• Constraints: Add/Drop/Disable/Enable/Cascade, Data Dictionary
• Schema Objects (Tables, Views, Synonym, Sequences)

 Note: Lunch and Training Documents will be provided.

Reach out for more details at info@info2excel.com or Call at 8712172191

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