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

Global Institute of Cyber Security and Ethical Hacking Logo

MySQL

MySQL course is offered by Global Institute of Cyber Security and Ethical Hacking for all skill level. GICSEH offers strategic training paths for the certification skills required to support today’s technologies.

by Global Institute of Cyber Security and Ethical Hacking [Claim Listing ]
LearnoVita Logo

Oracle Admin Training

Oracle admin was one of the most in-demand technologies and it is ranked as the world’s most popular programming language among professional software developers as well as the first most wanted programming language. Learn Oracle admin in real-time with LearnoVita experts practically with live tra...

by LearnoVita [Claim Listing ]
NobleProg (India) Logo

HBase For Developers Training Course

This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.

by NobleProg (India) [Claim Listing ]
CC Computer Education Logo

Certificate in MYSQL

Certificate in MYSQL course is offered by CC Computer Education. CC Computer Education is one of the best Computer Training Institute to receive best computer education and support services.

by CC Computer Education [Claim Listing ]
ECEC Skill School Logo

Oracle Training

ECEC Skill School is a best Oracle training institute in Madurai working since 1997. We have experienced and industry experts Oracle trainers who provide Oracle coaching classes to our students, Non-IT peoples, and freshers etc.

by ECEC Skill School [Claim Listing ]

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