Introduction to Oracle 11g PL/SQL Training in Hollywood
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle's Procedural Language for SQL. It is Oracle's database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs. The Oracle 11g release has greatly enhanced the features and functionality of PL/SQL. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.
Course Length: 3 Days
Course Tuition: $1190 (US) |
Prerequisites |
|
A good working knowledge of Oracle 11g SQL features is required. Programming experience in a high-level language, such as COBOL, Java, or Perl is also required. |
Course Outline |
Triggers
PL/SQL Variables and Datatypes
PL/SQL Syntax and Logic
Stored Procedures and Functions
Exception Handling
Records, Collections, and User-Defined Types
Cursors
Bulk Operations
Using Packages
Creating Packages
Working with LOBs
Maintaining PL/SQL Code
Appendix A: Dynamic SQL Appendix B: PL/SQL Versions, Datatypes, and Language Limits
|
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- DOCKER WITH KUBERNETES ADMINISTRATION
30 September, 2024 - 4 October, 2024 - RED HAT ENTERPRISE LINUX AUTOMATION WITH ANSIBLE
23 September, 2024 - 26 September, 2024 - VMware vSphere 8.0 with ESXi and vCenter
7 October, 2024 - 11 October, 2024 - RED HAT SATELLITE V6 (FOREMAN/KATELLO) ADMINISTRATION
21 October, 2024 - 24 October, 2024 - RHCSA EXAM PREP
9 September, 2024 - 13 September, 2024 - See our complete public course listing