Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students learn the basic functionality of how to debug functions and procedures using the SQL Developer Debugger. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. Oracle Database 11g: PL/SQL Fundamentals and Oracle Database 11g: Develop PL/SQL Program Units courses.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools. This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
Learn to:
Global I.T. is an authorized Oracle University WDP institution and provide the same curriculum and materials used by Oracle University. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Introduction
Introduction to PL/SQL
Declaring PL/SQL Identifiers
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Handling Exceptions
Creating Stored Procedures
Creating Stored Functions and Debugging Subprograms
Creating Packages
Working With Packages
Using Oracle-Supplied Packages in Application Development
Using Dynamic SQL
Design Considerations for PL/SQL Code
Creating Triggers
Creating Compound, DDL, and Event Database Triggers
Using the PL/SQL Compiler
Managing PL/SQL Code
Managing Dependencies
Real testimonials from our Students!
May 28,2020. My experience with Global Information Technology has proven to be exceedingly beneficial. Through the VA VET TEC program and my attendance at Global IT, I was able to complete the IT Professional 4 courses. Along with the valuable training and resources that GIT has provided, I not only have a better understanding of [...] Read more
Rachel Smith
Manish – I am writing to say thank you. I thank God for Global Information Technology. I thank God for you, because you genuinely care about the direction of the student. I thank God for believing in me, for coaching me, and for helping me. I thank God for everyone at Global Information Technology for [...] Read more
Samar Gorial
At college graduation, I thought that a major part of my life was behind me. I would finally get the opportunity to live out life the way I was advised as a child: go to school, get a degree, get a safe and secure job. Unfortunately, I didn’t dare anticipate what was actually ahead of [...] Read more
Steve Johnson
I was a veteran who wanted to start a second career in IT. I had a bad experience with another computer training company, which actually had me about ready to quit, I was introduced to Global Information Technology by my VA counselor and the rest is ALL GOOD!  Global IT has been proactive on my [...] Read more
Brian Gibson
In mid-2012, I was at a cross-road in my life after being informed that the position I held for over 11 years was being eliminated. I realized then that my skills needed to be updated to take me into a new line of work. That’s when I met one of your career advisors at Detroit [...] Read more
Deb Lasko