Image

Oracle(SQL and PL/SQL)

This course covers fundamentals of Database. The database training program facilitate participants to learn about database SQL commands, functions, Views and Joins. Database training helps in learning effective techniques of writing SQL queries and PL/SQL programs using Procedures, cursors, triggers, packages and exceptions.

Upon completion, students should be able to write basic to complex SQL queries using database software and tools.

Prerequisites

  • Knowledge on computers
  • Participants are not expected to have any database knowledge
  • Beginning level programmers, testers and analysts

Learning Objectives

  • Learn the different SQL commands and functions for interacting with database
  • Learn how to create SQL Constraints on Column and Table level
  • Selecting the data from various DB tables using operators, functions and clauses
  • Working with different views for testing the DB
  • Learn how to utilize the procedural language extension for SQL in the Oracle relational database
  • Learn the types of Joins, Procedures, Cursors and Triggers applications and to operate
  • Learn to declare and work with variables.
  • Learn to use conditionals and loops in PL/SQL.
  • Learn to handle and create user-defined exceptions.
  • Learn to use SQL within PL/SQL.
  • Learn to create Subprograms, Stored Procedures and Functions.
  • Learn to work with Packages, Triggers and Cursors.
  • Acquire the skills needed to work with SQL Editors
  • Develop efficient PL/SQL programs to access Oracle databases

 

Request a Demo and Course Brochure

If you would like to receive the full Course brochure by mail, please Contact Us

Clarus Infotech has a broad range of hands-on, practical software programming,testing training, as well as other software training courses.

CONTACT US

INDIA:

Phone : +91-9000044244

Phone : +91-7036043366

E-mail : info@clarusinfotech.com

USA & CANADA:

Phone : +1 617-237-9971

E-mail : info@clarusinfotech.com