• Home
  • Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Virtualization
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CCSA – Check Point Certified Admin
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
      • CISSP – Certified Information Systems Security Professional
    • AWS
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • Microsoft Certified: Azure Administrator Associate
      • Microsoft 365 Certified: Enterprise Administrator Expert
      • Microsoft Certified: Data Analyst Associate
      • Microsoft Certified: Azure Developer Associate
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security Specialist
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate
    • Certified Blockchain Professional
    • Certified Digital Marketer (CDM)
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA – IT Training Center
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Virtualization
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CCSA – Check Point Certified Admin
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
        • CISSP – Certified Information Systems Security Professional
      • AWS
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • Microsoft Certified: Azure Administrator Associate
        • Microsoft 365 Certified: Enterprise Administrator Expert
        • Microsoft Certified: Data Analyst Associate
        • Microsoft Certified: Azure Developer Associate
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security Specialist
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate
      • Certified Blockchain Professional
      • Certified Digital Marketer (CDM)
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      Oracle

      • Home
      • All courses
      • Oracle
      • Oracle Database: Program with PL/SQL

      Oracle Database: Program with PL/SQL

      User Avatar
      aktina
      Oracle
      Free
      oracle
      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Introduction

      This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Through hands-on instruction from expert instructors, you’ll develop stored procedures, functions, packages and more.

      Audience
      • Forms Developer
      • Portal Developer
      • Database Administrators
      • Developer
      • Technical Consultant
      • System Analysts
      • Application Developers
      • PL/SQL Developer
      At Course Completion

      You will learn To:

      • Conditionally control code flow (loops, control structures).
      • Use PL/SQL packages to group and contain related constructs.
      • Generate triggers to solve business challenges.
      • Create anonymous PL/SQL blocks, as well as stored procedures and functions.
      • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
      • Create anonymous PL/SQL blocks, functions and procedures.
      • Declare PL/SQL variables.
      • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
      • Debug functions and procedures using the SQL Developer Debugger.
      • Use Dynamic SQL & understand design considerations when coding using PL/SQL.
      • Understand and influence the PL/SQL compiler and manage dependencies.
      • Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
      Prerequisites
      • Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
      • Oracle Database: SQL Fundamentals I
      • Oracle Database: SQL Fundamentals II
      Professional Exam(s)
      Exam 1Z0-144: Oracle Database – Program with PL/SQL
      Certification(s):
      OCA – Oracle Certified Associate: PL/SQL Developer
      CoursesOracleOracle Database: Program with PL/SQL
      • MODULES
        21
        • Lecture1.1
          Introduction 30 min
        • Lecture1.2
          Introduction to PL/SQL 30 min
        • Lecture1.3
          Declare PL/SQL Identifiers 30 min
        • Lecture1.4
          Write Executable Statements 30 min
        • Lecture1.5
          Interaction with the Oracle Server 30 min
        • Lecture1.6
          Control Structures 30 min
        • Lecture1.7
          Composite Data Types 30 min
        • Lecture1.8
          Explicit Cursors 30 min
        • Lecture1.9
          Exception Handling 30 min
        • Lecture1.10
          Stored Procedures 30 min
        • Lecture1.11
          Stored Functions and Debugging Subprograms 30 min
        • Lecture1.12
          Packages 30 min
        • Lecture1.13
          Deploying Packages 30 min
        • Lecture1.14
          Implement Oracle-Supplied Packages in Application Development 30 min
        • Lecture1.15
          Dynamic SQL 30 min
        • Lecture1.16
          Design Considerations for PL/SQL Code 30 min
        • Lecture1.17
          Triggers 30 min
        • Lecture1.18
          Creating Compound, DDL, and Event Database Triggers 30 min
        • Lecture1.19
          PL/SQL Compiler 30 min
        • Lecture1.20
          Manage PL/SQL Code 30 min
        • Lecture1.21
          Manage Dependencies 30 min
      City
      Nicosia
      Dates and Times
      Duration (Hours)
      40
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Duration (Hours)
      40
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      For participants eligible for subsidy by the Human Resource Development Authority:
      Participation * Course ManualExam
      CourseOracle Press1Z0-144
      Amount€550,00€70,00€212,00
      VAT * €233,70€13,30
      -
      * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.

      This course is also offered at a high discount as part of a bundle of 2 certification courses – click here 

      For participants not eligible for subsidy by the Human Resource Development Authority:
      Participation Course ManualExam
      CourseOracle Press1Z0-144
      Amount€875,00€70,00€212,00
      VAT €166,25€13,30-

      This course is also offered at a high discount as part of a bundle of 2 certification courses – click here


      Take advantage of our special offer by taking this course as part of a bundle of 2 courses leading to the OCA – Oracle Certified Associate: PL/SQL Developer certification:

      For participants eligible for subsidy by the Human Resource Development Authority:
      Participation * Course ManualsExams
      Courses PL/SQL & SQL Fund.Oracle Press - 2 books1Z0-144 & 1Z0-061
      Amount€950,00€130,00€321,00
      VAT * €438,90€24,70
      -
      * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.
      For participants not eligible for subsidy by the Human Resource Development Authority:
      ParticipationCourse ManualsExams
      Courses PL/SQL & SQL Fund.Oracle Press - 2 books1Z0-144 & 1Z0-061
      Amount€1,300,00€130,00€321,00
      VAT€247,90€24,70
      -

       

       

      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Free
      • Share:

      You May Like

      Oracle Database 12c: Performance Management and Tuning – Official Oracle Course Read More
      aktina

      Oracle Database 12c: Performance Management and Tuning – Official Oracle Course

      0
      Free
      Exadata Database Machine: 12c Administration Workshop – Official Oracle Course Read More
      aktina

      Exadata Database Machine: 12c Administration Workshop – Official Oracle Course

      0
      Free
      Oracle SQL Tuning for Developers Workshop – Official Oracle Course Read More
      aktina

      Oracle SQL Tuning for Developers Workshop – Official Oracle Course

      0
      Free
      Oracle Database: Backup and Recovery Workshop – Official Oracle Course Read More
      aktina

      Oracle Database: Backup and Recovery Workshop – Official Oracle Course

      0
      Free
      Oracle Database: Administration Workshop Read More
      aktina

      Oracle Database: Administration Workshop

      0
      Free

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Digital Marketing e-course

      Digital Marketing e-course

      Blockchain Professional e-course

      Blockchain Professional e-course

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      More Courses

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools) PO Box 25252, CY-1308 Lefkosia (Nicosia), Cyprus

      (+357) 22 81.81.01

       

      TOP COURSES

      • 20740: Windows Server 2016
      • 20461: Querying Microsoft SQL
      • 20483: Programming in C#
      • 20461: Microsoft SQL Server
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

      • Security
      • Microsoft
      • Oracle
      • Cisco
      • Linux
      • Adobe

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now
      Modal title

      Message modal