Oracle Database 12c: SQL and PL/SQL Fundamentals Training & Certification Courses
 800 Ratings

Enquire Now


 
Loading...  

Processing data, please wait...

Live Chat
Oracle #1 Training Partner
Oracle #1 Training Partner
Official Training
Official Training
Get Trained by Industry Expert
Get Trained by Industry Expert
Hello Koenig

Overview

In this Oracle Database 12c: SQL and PL/SQL Fundamentals training course, you will learn the fundamentals of relational databases, SQL & PL/SQL programming language. You will also learn how to write queries against single and multiple tables, manipulate data in tables & create database objects.

Course Objective

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL Variables.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from tables.

Target Audience

  • Developer
  • Implementer
Download course contents.
Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Schedule & Prices

Delivery Mode Location Course Duration Fees Schedule
Instructor-Led Online Training (1-on-1) Client's Home/Office5 Days $ 3,200 As per mutual convenience (4-Hours Evenings & Weekends Possible
Classroom Training * Dubai 5 Days $ 3,470
7-11 Jul 2019,
21-25 Jul 2019,
4 Aug -8 Aug 2019
Delhi, Bangalore, Dehradun (Rishikesh), Goa, Shimla, Chennai 5 Days $ 1,292
1 Jul -5 Jul 2019,
8 Jul -12 Jul 2019,
15 Jul -19 Jul 2019,
29 Jul -2 Aug 2019,
5 Aug -9 Aug 2019,
12 Aug -16 Aug 2019,
2 Sep -6 Sep 2019,
9 Sep -13 Sep 2019
Fly-Me-a-Trainer Client's Location5 Days On Request As per mutual convenience

Oracle Database 12c: SQL and PL/SQL Fundamentals Benefits

  • Introduction
  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Conversion Functions and Conditional Expressions
  • Aggregated Data Using the Group Functions
  • Display Data from Multiple Tables
  • Usage of Subqueries to Solve Queries
  • SET Operators
  • Data Manipulation
  • DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Usage of Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions
Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Student Feedback

Student Name Country Month Feedback
Baziro Alphani Burundi Mar-2019 Unique in term of High Quality of the Trainer and good Lab
Abdullah Hilal Salem Al Araimi Oman Nov-2018 very knowledgeable trainer. he made the training very intersting. his way of training is easy to follow and understand.
Delhi
Bangalore (Bengaluru)
Goa
Shimla (Himalayas)
Chennai
Dehradun
Dubai
USA Singapore
All rights reserved. ©1997 - 2019, Koenig Solutions Pvt. Ltd.
PMP® is a registered trademark of the Project Management Institute.
Koenig Solutions Pvt. Ltd. is rated 4.4 stars by www.facebook.com/KoenigSolutions based on 107 reviews

Please Input Captcha Below

Submit