Oracle Database 12c: Introduction to SQL

Program Overview |Testimony |curriculum |admission |Who should do this course? |FAQ |Calendar

Program Overview

This Oracle Database: Introduction to SQL training helps you write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. You will learn this course more through hands-on exercises.

After completing this course, you will:

Understand Oracle database Architecture
Write and tune queries effectively to maximize performance
Write powerful SQL programs (procedures, packages, functions & triggers)
Perform code analysis

Testimony

You call them instructors, we call them your Mentors!

They are the catalysts under whose supervision and arm’s length support our students are empowered to accomplish expertise in advanced technology. We boast of enterprising and talented resources with proven track records who are working in tandem with our goal to provide inspiring and enduring technical learning experience to our students.

 

curriculum

  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Data Manipulation Statements
  • Use of DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Control User Access
  • Management of Schema Objects
  • Manage Objects with Data Dictionary Views
  • Manipulate Large Data Sets
  • Data Management in different Time Zones
  • Retrieve Data Using Sub-queries
  • Regular Expression Support

admission

Certificate of participation in ‘Oracle Database 12c: Introduction to SQL’ course.

Who should do this course?

Students and working professionals who wish to gain expertise in SQL programming.

FAQ

Calendar

  • Session one
    20 octobre 2016
    30 09 16
    Apply
  • Session two
    04 février 2017
    20 01 17
    Apply
  • Session three
    08 juillet 2017
    26 05 17
    Apply