Database Programming with PL/SQL

by ascent Infotech Claim Listing

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

ascent Infotech Logo

img Duration

2 Months

Course Details

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL.

They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.

 

Target Audiences:

  • Educators
  • College/university faculty who teach computer programming or a related subject
  • Secondary school teachers who teach computer programming

 

Prerequisites:

  • Required
  • Previous experience with at least one programming language
  • Suggested
  • Previous Experience with a database application
  • Oracle Academy Course – Database Design and Database Programming with SQL

 

Lesson-by-Lesson Topics:

  • Fundamentals
  • 3 section
  • Defining Variables and Datatypes
  • 7 section
  • Using SQL in PL/SQL
  • 4 section
  • Program Structures to Control Execution Flow
  • 5 section
  • Using Composite Datatypes
  • 2 section
  • Using Cursors and Parameters
  • 6 section
  • Exception Handling
  • 4 section
  • Using and Managing Procedures
  • 3 section
  • Using and Managing Functions
  • 6 section
  • Using and Managing Packages
  • 3 section
  • Getting the Best out of Packages
  • 2 section
  • Improving PL/SQL Performance
  • 2 section
  • Using and Managing Triggers
  • 5 section
  • Recognizing and Managing Dependencies
  • 2 section
  • Using the PL/SQL Compiler
  • 4 section
  • Kolkata Branch

    Prafullya Park, Kalibari, 10/A, near Bansdroni, opp. Bhawan, Bansdroni New Government Colony, Aurobindo Park, Kolkata

Check out more Oracle courses in India

A2Z Computex Logo

MS SQL Server

A2Z Computex offers MS SQL Course which is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security.

by A2Z Computex [Claim Listing ]
Excel Computer Education Logo

Oracle Course

Oracle course is offered by Excel Computer Education for all ages and skill level. Excel Institute of quality computer education is setting standard of career-oriented computer education of all software professionals courses to shape you for future.

by Excel Computer Education [Claim Listing ]
Glorex Infotech Logo

MySQL

MySQL course is offered by Glorex Infotech. We teach each student the subjects of their choice, in a very simple way that they can understand in the best possible way. We teach them real-world programs to practice every time.

by Glorex Infotech [Claim Listing ]
Innovative Techno Institute Logo

Cassandra

Cassandra is a distributed database from Apache that is highly scalable and designed to manage very large amounts of structured data. It provides high availability with no single point of failure.

by Innovative Techno Institute [Claim Listing ]
OAIT Logo

Oracle Course

Oracle course is offered by OAIT. At OAIT, we identify the country’s best potential talent and nurture them into high-performing & Certified Professionals. We allow their individuality to blossom and provide excellent motivation along with stimulation in a highly challenging environment.

by OAIT [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy