Oracle 11g/12c Express Introduction to SQL, SQL*Plus, and PL/SQL
Duration: 3 Days
You will receive an introduction to Oracle's relational database, and a hands-on introduction in how to add, update, extract and organize information from the database. You will cover how to format reports and export data. You will work with Oracle's Structured Query Language (SQL), SQL*Plus, and (Procedural Language for SQL) PL/SQL. You will cover debugging and error reporting procedures and how to define, execute and store procedures for reuse in the future.
This course is a reduced version of our five-day Oracle 11g/12c Essentials course.
This course can also be presented with content specific to Oracle 10g.
Topics Covered In This Course
The WHERE and ORDER BY Clause
Single Row Functions
Joining Data from Multiple Tables in Queries
Group Functions and the GROUP BY Clause
Using Subqueries and CASE Clauses
Working With Database Data
Stored PL/SQL Objects
What You Can Expect
On successfully completing this course, participants can expect to be able to:
Who Should Take This Course
Anyone who needs to extract and organize information from an Oracle database, including formatting reports, adding, updating, and deleting data, and exporting data to ODBC files. i.e. Application designers, developers, database administrators, and end users and those seeking the OCA certification.
An understanding of relational database design concepts.
Short lecture sessions (60%) along with hands-on lab sessions (40%).
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]