Oracle SQL Query Writing - Basic to Advance

Oracle SQL Query Writing - Basic to Advance

  • Course TitleOracle SQL Query Writing - Basic to Advance
  • Course IDTD206
  • Target AudienceEntry-level to Managerial level associates
  • Course Duration10 Hrs (2 Hrs / Day)
  • Delivery MethodInstructor-led training
  • PrerequisitesBasic SQL

Course Overview

The SQL language is used for querying and processing data stored in the databases. It is important for developers because it allows them to interact with databases easily and efficiently. The course will cover the internal execution of SQL queries, SQL commands classification, SQL Operators, Library functions, joins, Sub-queries and advance concepts.

Faculty Details

Course Instructors

Dharani Prakash Sudhakar

Name

Dharani Prakash Sudhakar

Email ID : dharani.sudhakar@intellectdesign.com

Learning Objectives

Learning Objectives

Associates undergoing this course will:

  • Create and manage database objects using DDL, DML, DQL and TCL.
  • Effectively write various forms of SQL using queries, sub-queries, correlation and joins.
  • Understand the internal working of various statement.
  • Learn to apply advance concepts in their work.

Course Coverage

1. Oracle SQL Introduction

(Duration: 20 minutes)

2. SQL Data Types

(Duration: 20 minutes)

3. SQL Operators

(Duration: 20 minutes)

4. SQL Command Classification

(Duration: 40 minutes)

5. ACID Properties In SQL

(Duration: 20 minutes)

6. SQL Library function classification

(Duration: 120 minutes)

7. Set operations

(Duration: 30 minutes)

8. All types of joins

(Duration: 90 minutes)

9. Sub-Query classification

(Duration: 120 minutes)

10. Window functions & GROUP BY extensions

(Duration: 120 minutes)

Faculties

About the Faculty

Enroll