Oracle SQL Certification Course

Note : This is an Online Training Program.

Timings: 9 pm to 11 pm IST (Monday to Friday) for 10 days.

This 10 days Online Practical Training, with weekend (Saturday) online practice workshop, will help you to Master Oracle Database SQL Basics and prepare you for Oracle Certification which has a great value in industry. No prior DB Experience required for this Training.

This training will be a great help for both Job Seekers and People in Job to excel in their current role.

Note: You will also be explained how to Install Oracle Database 11g Express Server on your Windows Machine before starting the course.

Important Note: Course is designed as per Oracle Certification Exam, 1Z0-051 (Oracle Database 11g: SQL Fundamentals I).

Here are my Course Topics.

1. Database Basics

• Datatypes
• DDL – Create and Drop Table
• Naming Convention
• DML – Insert, Update, Delete
• TCL - Commit and Rollback
• SELECT Queries and WHERE Conditions
• Rename table and Columns
• Add, Drop, Modify Columns

2. SELECT Statement

• Column Alias
• Arithmetic Expressions
• Arithmetic Operators
• Operator Precedence
• Defining a Null Value
• NULL Values : Explanation
• NULL Value : Arithmetic with NULLs
• NULL Values : Empty String
• NULL Values : Handle using NVL In Built Function
• Concatenation Operator
• Character Strings
• Duplicate Rows
• DISTINCT for Duplicates

3. Restricting and Sorting Data

• WHERE clause conditions
  • Equal, Not Equal
  • Greater Than, Less Than
  • Greater than or equal to, Less than or equal to
  • BETWEEN, NOT BETWEEN
  • IN, NOT IN
  • LIKE, NOT LIKE
  • NULL, NOT NULL
  • AND, OR and NOT operators
• ORDER BY
  • Ascending and Descending
  • Sort by Column Name
  • Sort by Column Alias
  • Sort by Column Position
  • Multi Column Sort
  • Sort using Expression

4. Oracle in-Built Functions :– Single Row Functions

• a. Numeric Function
• b. Character Functions
• c. Date Functions
• d. NVL, NVL2, NULLIF, COALESCE
• e. GRETEST, LEAST
• f. CASE expression and DECODE

5. Aggregate Functions :- Multiple Rows Functions

• SUM, COUNT, AVG, MIN, MAX
• GROUP BY Clause
• Having Clause
• NULL and Aggregate Functions

6. Integrity Constraints

• NOT NULL
• CHECK
• UNIQUE
• PRIMARY KEY
• FOREIGN KEY
• Adding and Dropping Constraints
• Enabling and Disabling Constraints

7. JOINS Type

• CROSS
• EQUI or INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN

8. Sub Queries

• Scalar Sub Queries
• Co-related Sub Queries
• WITH Clause
• EXISTS, NOT EXISTS
• Correlated UPDATE
• Correlated DELETE

9. SET OPERATORS

• UNION, UNION ALL
• MINUS, INTERSECT

10. Views

• Single Table View
• Multi Table View
• DML on Views
• Read only Views
• DML Restriction on Views
• Difference between View and Table
• TOP n Analysis

11. Sequence and Synonyms

• Create Sequence
• Alter Sequence
• Drop Sequence
• Uses of Sequence
• Private and Public Synonyms

12. Indexes

• Unique Index, Normal Index, Functional Index
• Index Usage

13. Global Temporary Table

• How to Create Global Temporary Table
• Uses of Global Temporary Table
• ON COMMIT Preserve Rows, ON COMMIT Delete Rows

14. Data Dictionary Views

• DDV for Tables
• DDV for Columns
• DDV for Constraints
• DDV for Views
• DDV for Sequence
• DDV for Indexes

15. Analytical Functions

• RANK, ROW_NUMBER, DENSE_RANK
• SUM, COUNT

16. User Access and Privileges

• Creating a User
• System privileges
• Grant Access to and Revoke Access from User ( DDL)
• Create Role and Role Usage
• WITH GRANT OPTION and PUBLIC
• Object privileges

17. Usage of SQL Plus Interface

• Executing the Commands
• Accepting User Input
• Executing Scripts

About the Trainer:

Arun is “Oracle Certified” and having more than 14 years of hands on experience in IT industry.

He has worked for various organizations and has passion to learn something new every day.

Mission: To provide Quality Training which is convenient & affordable and help you to Excel in your career.

You can reach me at +91-8142-535-635 in case you have any queries or need more more details about this training program.

Who should attend?

• Job Seekers who want to start their career as Oracle Database Developer.
• Anyone who is employed but want to switch to Database Developer Profile.
• Anyone who is already in database and wants to enhance and excel in database skills.
• Students who want to Learn Oracle Database as part of their Academics.
• People who wants to appear in Oracle Certification (1Z0-051) Exam.

Prerequisites:

You should know basic usage of computers and Internet.

Takeaways:

• Set of 200+ Practice Questions to help in Oracle Certification Exam.
• Complete course materials
• In Person and Online Support for doubts through his website LearnwithArun[dot]com
• Personal Articles on my Website for further reading.
• You can ask queries on my website/email and get is answered.

Important Instructions:

This is an Online Training conducted via Internet hence you must have

• Computer / Laptop / Tab (with at least 2GB RAM) at home with good speed internet connection.
• Google Chrome, IE or Firefox Browser installed to attend online meeting.
• Headphone with microphone.
• Meeting request will be send a day before /same day by afternoon.

Others Details

For more details and updates please visit website.