Event Type: Workshop
About The Event 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 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) For Details Contact : 8712172191 Email : [email protected] 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).