Book Online Tickets for Learn ORACLE SQL in 2 days hands on Trai, Hyderabad. 2 DAYS ORACLE SQL WORKSHOP
 
When: Saturday, November 17th,  & Sunday, November 18th, 2018.
 
Time: 10:30 AM – 4:30 PM IST
 
Address: TSIIC Park Opposite to HSBC TSIIC Park, Phase 2, HITEC City, Hyderabad, Telangana

Learn ORACLE SQL in 2 days hands on Training-Workshop on 17th and 18th Nov @ Phoenix Arena, Hi Tech City,Hyderabad.

 

  • Early Bird

    Sale Date Ended

    INR 599
    Sold Out
  • Regular

    Sale Date Ended

    INR 699
    Sold Out

Invite friends

Contact Us

Page Views : 264

About The Event

2 DAYS ORACLE SQL WORKSHOP

 

When: Saturday, November 17th,  & Sunday, November 18th, 2018.

 

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

 

AddressTSIIC Park Opposite to HSBC TSIIC Park, Phase 2, HITEC City, Hyderabad, Telangana 500081

 

What will you learn?
After attending this 2 days workshop, the participants will be able to write SQL Queries easily and understand the logic behind any Queries written by others.

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)

 

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

More Events From Same Organizer

Similar Category Events

    Venue Map