• Software Training and Placement Center

Oracle PL/SQL program

  • Overview
  • Course Highlights
  • Pre-requisites and Eligibility
  • Syllabus
  • Audience for this course
  • Batches
  • Mode of Training
  • Know About Our Trainer
  • Key Features

Oracle Training in Chennai

Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment and it use SQL and PL/SQL to interact with their Database Systems.
SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.
Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL and you will learn how to use PL/SQL statements to implement business logic with the use of Cursors, Procedures, Functions and Triggers.

Course Highlights

  • Understand the basics of Oracle RDBMS Architecture.
  • Understand the fundamentals of SQL (Structured Query Language).
  • Develop codes using Oracle SQL.
  • Can gain considerable SQL knowledge to apply for a beginner level, SQL Developer or Database Developer Job.
  • Learn PL/SQL Object Oriented Programming.
  • Learn PL/SQL Architecture Very Well.
  • Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level.
  • Improve Performance of SQL& PL/SQL Codes.
  • Learn PL/SQL Tuning for Performance.
  • Learn UNIX.

Pre-requisites and Eligibility

There are no pre-requisites for Oracle PLSQL training. However, a basic understanding of computer science technicalities and databases will be helpful but is not mandatory. Don't worry , we will cover fundamentals in detail in our course.

Syllabus

  • Topic 01: Database Concept
    • What is a Database
    • What is RDBMS
    • Why Oracle
    • What is SQL
    • What is Table
  • Topic 02: Basics of SQL
    • Creating Tables
    • SQL SELECT Statement/Data Retrieve
    • Filter & Sorting (Using WHERE condition to filter the result and usage of DISTINCT, ORDER BY)
    • Operators used in SQL (LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT)
  • Topic 03: Functions and Joins
    • Single row Functions (Character, Number, Date, Conversion, General functions, Group functions, Decode & Case)
    • Analytic Functions (ROW_NUMBER, RANK, DENSE RANK, LEAD and LAG)
    • SET Operators (Union, Union ALL, Minus and INTERSECT)
  • Topic 04: SQL Statements
    • DDL Statements (Create, Alter, Drop, Replace and Truncate)
    • SQL Constraints (Primary Key, Foreign Key, NOT NULL, Unique and ON DELETE CASCADE & ON DELETE SET NULL)
    • DML Statements (Insert, update and Delete)
    • DCL (Grant & Revoke) and TCL (COMMIT, ROLLBACK, SAVEPOINT)
  • Topic 05: Other Schema Objects
    • View (Simple & Compound view and WITH CHECK OPTION)
    • Index and types of indexes
    • Creating, Using and Managing Sequences
    • Creating, Using and Analyzing Synonyms
    • Materialized Views (Creating and Refreshing M-View)
  • Topic 06: Basic of PL/SQL
    • PL/SQL Variable
    • Using SQL in PL/SQL
    • Control Structures (IF Statement and Loops- WHILE and FOR LOOP)
    • Composite Data Types (%Rowtype, Record Type, VARRAY, Nested Table and Associative Arrays)
  • Topic 07: Advanced PL/SQL Concepts
    • PL/SQL Cursor (Implicit & Explicit Cursor, Parameterized Cursor, Cursor Attributes and Where Current of Clause)
    • Handling Exceptions (Predefined & Non Predefined exception and User Defined exceptions)
    • Creating and Using Functions
    • Creating and Using Procedures
    • Bulk Binds (Bulk Collect and FORALL)
    • Creating Packages and Related concepts like Overloading, Forward Declarations and One time only procedure
    • Oracle Supplied Packages like DBMS_OUTPUT, UTL_FILE
    • Creating Database Triggers (DML Triggers, Instead of Triggers, Compound Triggers)
  • Topic 08: DB Architecture & Performance Tunning
    • Oracle DB Architecture
    • Performance Tunning Tips
  • Topic 09: Unix Basic Commands
    • Introduction to Unix
    • Create files and directory, Change directory, Absolute path
    • Listing Directory contents, Copying files and Directories etc
    • Remove files and directories
    • Cat Command, Pipe Command, Grep Command, WC & Sort Command
    • Command Operators (Save Result to files, Get Data from file, Passing Result of one commands to another"|")
    • Processing File Data Using CUT Command
    • SED & AWK Command
    • Scheduling task using Crontab
  • Topic 10: Shell Scripting
    • Introduction to Shell Scripting
    • Writing Shell Scripting (How to create shell, Steps to Execute and Passing inputs to shell)
    • Condition Handling (IF Condition, Case Statements, Logical Operators) and Loops
    • How to write functions and their uses
    • Calling a Shell Script from another
    • How to connect Oralce DB from shell
  • Topic 11: Real Time Project classes
    • Real Time Projects on Oracle which are diverse in nature covering various data sets from multiple domains.
  • Topic 12: Interview Questions
  • Topic 13: Mock Interview and Mock Interview Answers
  • Topic 14: Resume Preparation session and sample resumes

Audience for this course:

IT professionals , Software testers , System administrators , Solution architects , Security engineers , Application developers ,Integration specialists , windows Administrators, Java Developers, Data analysts and database administrators, Database Administrator, System architects, IT managers, IT administrators and operators, IT systems engineers, data engineers and database administrators, data analytics administrators, cloud, web engineers, Project Managers, Software Architects, ETL and Data Warehousing Professionals, Data Engineers, Data Analysts & Business Intelligence Professionals, DBAs and DB professionals, Senior IT Professionals, Testing professionals, Mainframe professionals, Graduates looking to build a career in IT Field and Aspirants looking to work as oracle pl-sql developer can apply for this course.

Mode of Training

  • Classroom Training
  • Online Instructor-Led Live Training
  • Online Video Recorded Sessions Training

Week days batch

  • Class Room Training @ Anna nagar & OMR & Medavakkam
  • Online Instructor LED Training for Other Locations
  • Online Video Recorded Training sessions for Other Locations

Week end batch

  • Class Room Training @ Anna nagar & OMR & Medavakkam
  • Online Instructor LED Training for Other Locations
  • Online Video Recorded Training sessions for Other Locations

Fast track Batch

  • Class Room Training @ Anna nagar & OMR & Medavakkam
  • Online Instructor LED Training for Other Locations
  • Online Video Recorded Training sessions

KNOW ABOUT OUR TRAINER

  • Trendnologies's SQL PL/SQL training in Chennai is led by experts with over a decade of experience in the Oracle platform. Additionally, our trainers assist and guide you for Oracle certification examinations.
  • Administrated and mastered by highly skilled industry experts with 15+ years of strong IT experience in leading MNC companies as Architect and Senior Technical consultant.
  • Having 12+ years of work experience in Oracle Applications in different areas like design, development and implementation of business requirements through direct interaction with customers. 
  • Our Trainers are Oracle certified professionals with 10+ years of experience in their respective domain as well as they is currently working with Top MNCs.
  • 8+ years of delivering exceptional service to candidates in Oracle Training and placements.
  • Completed 100+ classroom and 100+ Online batches successfully
  • Providing training for clients around the globe from USA, UK, Canada, Australia India, Singapore and Malaysia.
  • Experience professional and Placement oriented instructional technical trainers.
  • Proven ability to plan and execute programs on time.
  • Knowledge of "current best practices" and the latest research in the use of technology to enhance teaching and learning
  • Our Trainers have worked on a variety of on-going projects in their respective industries.
  • Trainers also assist candidates in being placed in their particular companies through the Employee Referral / Internal Hiring procedure.

Key features

  • 100% Placement guarantee
  • Career Oriented Training
  • Hands-on with Case Studies
  • Industry Expert Faculties
  • Fast track placement mode
  • Managed and mastered by highly skilled Industry Experts
  • Both Classroom Training and Online Training
  • Complete Career Guidance
  • Mock Tests and Interviews
  • Resume Preparation and Interview preparation support
  • Multiple revision classes through training library
  • Placement in Top MNC Company
  • Online Professional Certification assistance
  • Technical Job Support after course completion and Placement
  • Hands-On Oracle Training with Certification
  • Job Assistance | Access to official content aligned to exam
  • Practice Labs & Projects with integrated Cloud labs
Call us
Call us