Introduction to Oracle 11g Programming Training in Longmont
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. The Oracle 11g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. 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.
Audience: Database application developers
Course Length: 5 Days
Course Tuition: $2090 (US) |
Prerequisites |
|
Familiarity with relational database concepts as well as a solid understanding of 3GL programming are required. |
Course Outline |
Relational Database and SQL Overview
Using Oracle SQL*Plus
SQL Queries – The SELECT Statement
Scalar Functions
SQL Queries - Joins
Aggregate Functions and Advanced Techniques
Data Manipulation and Transactions
Data Definition and Control Statements
Other Database Objects
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 - The Data Dictionary
Appendix B: Dynamic SQL Appendix C: PL/SQL Versions, Datatypes, and Language Limits Appendix D: Oracle 11g Supplied Packages |
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