Open Contact Form
Please Contact Us

Your Name (required)

Your Email (required)

Subject

Your Message

img

Oracle

ABOUT THE COURSE

  • Learn Oracle SQL from a certified Oracle instructor with more than 14 years of IT experience in Oracle.
  • Basics of Database
  • CRUD operations of Database.
  • How to write queries & functions.

Quality Notes along with code will be provided to the students.

TOPICS COVERED

  • SQL – Overview
  • RDBMS Concepts
  • Databases Architecture
  • CRUD operations
  • Data Types
  • Operators
  • Expressions
  • Create Database
  • Drop Database
  • Select Database
  • Create Table
  • Drop Table
  • Update Tables
  • Insert Data into Tables
  • Select Query
  • Where Clause
  • AND & OR Clauses
  • Update Query
  • Delete Query
  • Like Clause
  • Order By
  • Group By
  • Distinct Keyword
  • Sorting Results
  • Constraints
  • Using Joins
  • Unions Clause
  • NULL Values
  • Indexes
  • Alter Command
  • Using Views and Advance Views
  • Having By Clause
  • String and Date Functions
  • Sub Queries
  • Aggregate Functions
  • Character Functions
  • Numeric Functions
  • All Types of Joins

WHO SHOULD ATTEND/PRE-REQUISITES

Who wants to get into IT without any prior knowledge of programming

WHAT YOU NEED TO BRING

Student should bring their laptops otherwise machines will be provided.