Oracle 11g/12c: Express Introduction to SQL and SQL*Plus
Duration: 3 Days
You will receive an introduction to Oracle's 11g and/or 12c 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 to ODBC files. You will work with Oracle's Structured Query Language (SQL), SQL*Plus.
This course is a slightly reduced version of our five-day Oracle Foundations course.
This course can also be presented with content specific to Oracle 10g.
Topics Covered In This Course
Database Management System Overview
Introduction to Entity Relationship Modeling
Fundamentals of Relational Database Management Systems
SQL Basics and SQL*Plus
Using SQL Developer
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
Analytic Functions (Optional)
Data Manipulation Language (DML) Commands
Getting Data In And Out Of Oracle
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]