Learn ORACLE SQL in 2 days hands on Practical Training

Sunday 18th November 2018
9:30 AM

Event Type: Workshop

Duration: 6:30:00


2 DAYS ORACLE SQL WORKSHOP *********************************** DAY 1 ****** • Introduction to Oracle, RDBMS • Working with SQL Languages (DRL, DML, TCL, DCL, DDL) • Getting started with Select Query to retrieve data from 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) • Sub queries: 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)



Organiser: Mouzzam Ali

About Organiser: 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).
Email: [email protected]
Phone no: 8712172191