Book Online Tickets for Learn ORACLE-SQL in 2 weeks @unbelievabl, Hyderabad. Batch1: 6:00 AM to 7:00 AM IST
Batch2: 3:00 PM to 4:00 PM IST
Learn ORACLE-SQL in 2 weeks from an OCP (Oracle Certified Professional) at a very discounted rate..
 Who Can Attend?
 *********************
Freshers/IT Professionals/Business Ana

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

 

  • Register Now

    Last Date: 30-09-2018

    INR 499

Invite friends

Contact Us

Page Views : 150

About The Event

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

Batch2: 3:00 PM to 4:00 PM IST

Learn ORACLE-SQL in 2 weeks from an OCP (Oracle Certified Professional) at a very discounted rate..

 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 from Basic level to Intermediate Level

 

Working with Operators and writing effective Queries:

  1. Arithmetic Operators
  2. Comparison Operators
  3. Logical Operators

 

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 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 to 9246564462 or leave an E-mail on mouzzam@info2excel.com