Oracle 11g/12c: Express Introduction to SQL and SQL*Plus
Course: OR11E1
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/OR11E1.html
Course Summary
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
- What is a Database?
- Types of DBMSs
Introduction to Entity Relationship Modeling
- What is a Data Model?
- Why Use an Entity Relationship Model?
Fundamentals of Relational Database Management Systems
- What is an RDBMS?
- Physical Data Storage
- Relationships between Tables
- Domains - Data Integrity
SQL Basics and SQL*Plus
- Understanding the Difference Between SQL, SQL*Plus and PL/SQL
- Invoking and Leaving SQL*Plus
- Entering and Executing Commands
- The SELECT Command & Mandatory Clauses
Using SQL Developer
- Understanding SQL Developer Environment and Commands
The WHERE and ORDER BY Clause
- WHERE and ORDER BY Clauses
- Using the Data Dictionary
Single Row Functions
- Functions, Date and Numeric Format Models/Data Conversion
- Control Statements
Joining Data from Multiple Tables in Queries
- The JOIN Condition / The Cartesian Product
- Outer JOINs
- ANSI99 Joins
Group Functions and the GROUP BY Clause
- Group Functions
- Distinct Operator in Group Functions
Using Subqueries and CASE Clauses
- Single-Row, Multi-Row, Multi-Column Subqueries
- Subqueries ? SELECT, FROM, WHERE, HAVING, ORDER BY, Correlated Subqueries
- CASE expressions
Analytic Functions (Optional)
- Single Row and Aggregating Analytic Functions
SQL*Plus Reporting
- SQL*Plus Report Writing Commands
- COLUMN Command / Titles, System Variables
- Master-Detail Report with TITLE and COLUMN Commands
- Control Breaks, Computing Aggregate Amounts
Data Manipulation Language (DML) Commands
- INSERT, UPDATE, DELETE, MERGE Command
- Use of Subqueries
- Transaction Control / Read Consistency / Locking
Getting Data In And Out Of Oracle
- SQL*Loader Basics
- Importing Into Excel
- Direct Database Queries Using ODBC
What You Can Expect
On successfully completing this course, participants can expect to be able to:
- Format reports using SQL*Plus commands
- Extract and organize information from the database
- Insert, update & delete information in database tables
- Understand Structured Query Language basics:
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.
Recommended Prerequisites
An understanding of relational database design concepts.
Training Style
Short lecture sessions (60%) along with hands-on lab sessions (40%).
Related Courses
Code |
Course Title |
Duration |
Level |
|
OR18SQL |
Oracle18c SQL |
5 Days |
I |
Details |
OR11E2 |
Oracle 11g/12c Express Introduction to SQL, SQL*Plus, and PL/SQL |
3 Days |
I |
Details |
OR11F |
Oracle 11g and 12c Foundations: SQL and SQL*Plus |
5 Days |
I |
Details |
ORAPEX |
Oracle APEX Version 5.0.4 |
5 Days |
II |
Details |
OR11SQL2 |
Transitioning to Oracle 11g/12c SQL |
3 Days |
II |
Details |
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.