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

Dream India Technologies Logo

Oracle

In Oracle Course we will train SQL and PL/SQL. SQL and PL/SQL both are completely different languages .SQL is a limited language that allows you to directly interact with the database.

by Dream India Technologies [Claim Listing ]
  • Price
  • Start Date
  • Duration
Urban Training Institute Logo

Certificate In SQL

Certificate in SQL course is offered by Urban Training Institute. UTI’s certificate course modules covering diverse subjects having employment scope in different industries. As all our courses are designed by experienced professionals, academic experts, and technicians.

by Urban Training Institute [Claim Listing ]
Shivani Infotech Computer Education Logo

Oracle 8i / SQL

Oracle 8i / SQL course is offered by Shivani Infotech Computer Education. Education Qualities of Shivani Computer Classes is first class where you can learn many computer courses and also get personal teaching or individual attention to every student with 100% practical guidance. 

by Shivani Infotech Computer Education [Claim Listing ]
Indian Institute Of Computer Technology Logo

SQL Server DBA Training

Our SQL Server DBA Training Course includes basic to advanced level and our SQL Server DBA course is designed to get the placement in good MNC companies in Chennai as quickly as once you complete the SQL Server DBA courses in Chennai with placement.

by Indian Institute Of Computer Technology [Claim Listing ]
JKSkillhub Institute Logo

SQL

SQL course is offered by JKSkillhub Institute. JKSkillhub Institute has been a pioneer in the field of Computer education since 2010. We have an expert team of trainers who have coached over 25k+ individuals.

by JKSkillhub Institute [Claim Listing ]

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