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

Paramwebinfo Academy Logo

SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It's a robust and widely used database platform that helps in storing, retrieving, and managing data for various applications and systems.

by Paramwebinfo Academy [Claim Listing ]
  • Price
  • Start Date
  • Duration
AIIT Computer Education Logo

SQL Server

SQL Server course is offered by AIIT Computer Education for all skill level.

by AIIT Computer Education [Claim Listing ]
Mohali Career Point Logo

Web Development Industrial Training (PHP /My-SQL)

We offers practical as well as theoretical Training in PHP using CMS (WordPress) with My-SQL database, C, C++, JAVA, DATABASE(SQL/PL/SQL), Automation Testing (Selenium) , SEO (Search Engine Optimization) students so that they will get hands-on experience exposure environment.

by Mohali Career Point [Claim Listing ]
Thasor Infotech Logo

SQL Server (2008)

SQL Server course is offered by Thasor Infotech. We offer a wide range of online and offline services for low to high-level education across the globe.

by Thasor Infotech [Claim Listing ]
ACTE Logo

SQL Server DBA Training

SQL Server is one of the biggest database platforms in the world.we extensively use SQL Server to do a lot of our development efforts.

by ACTE [Claim Listing ]

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