Oracle 12c Foundations: SQL & SQL*PLUS

5 Day | Instructor Led

You will receive a hands-on introduction to SQL Basics and SQL*Plus and learn about relational databases and how to access them through SQL and SQL*Plus.

Inquire About
Oracle 12c Foundations: SQL & SQL*PLUS

Ideal Candidates for Oracle 12c Foundations: SQL & SQL*PLUS Class

Application designers, developers, and database administrators

Oracle 12c Foundations: SQL & SQL*PLUS Prerequisites

There Are No PreRequisites Defined for this Course

What You'll Get in Oracle 12c Foundations: SQL & SQL*PLUS

What You'll Learn in Oracle 12c Foundations: SQL & SQL*PLUS

Relational database terminology
Structured Query Language (SQL) basics
Format reports using SQL*Plus commands
Extract and organize information from the database
Insert, update, and delete information in database tables
Create and drop tables, views, synonyms, and indexes

No Certification Test Available For This Course

No Certification Test Available For This Course

Oracle 12c Foundations: SQL & SQL*PLUS Outline

1. Introduction to the Oracle Database

  • Why Use an Entity Relationship Model?
  • Physical Data Storage
  • Relationships between Tables
  • Domains and Data Integrity Constraints
  • Data Model Review

2. 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 SQL Buffer, SQL*Plus Default Output
  • LOGIN.SQL / GLOGIN.SQL
  • The SELECT Command and Mandatory Clauses

3. Using SQL Developer

  • Understanding SQL Developer
  • SQL Developer Setup
  • Advanced Functionality

4. The WHERE and ORDER BY Clauses

  • WHERE, ORDER BY Clauses
  • Using the Data Dictionary
  • Hierarchical Queries
  • Pattern Matching

5. Single Row Functions

  • Arithmetic Operators
  • Operator Precedence
  • Single Row vs. Group Functions
  • Date and Numeric Format Models
  • Data Conversion / Date Manipulation / Time Zones
  • Control Statements
  • IF THEN ELSE Logic
  • Regular Expressions

6. Joining Data from Multiple Tables in Queries

  • ANSI SQL 92 and SQL99 Joins
  • The JOIN Condition / The Cartesian Product
  • Outer JOINs

7. Group Functions and the GROUP BY Clause

  • Group Functions
  • Distinct Operator in Group Functions
  • GROUP BY, WITH Clause, ROLLUP, CUBE
  • Grouping Sets

8. Using Subqueries

  • Single-Row, Multi-Row, Multi-Column Subqueries
  • Subqueries in a WHERE / FROM / HAVING Clauses
  • Subqueries In the SELECT Clause - Scalar Subqueries
  • Correlated Subqueries / Hierarchical Queries
  • EXISTS / NOT EXISTS / WITH / Recursive WITH

9. SQL Set Queries

  • Multiple Select Statement Rules
  • Union vs. Union All of Select Statements
  • INTERSECTion of Two Select Statements
  • MINUS one select from another

10. Multi-Table Inserts

  • Unconditional All Insert
  • Conditional Insert with ELSE
  • Conditional ALL
  • Conditional FIRST
  • Pivoting Insert

11. Analytical Functions

  • Single Row Analytic Functions
  • Aggregating Analytic Functions
  • PIVOT / UNPIVOT
  • The MODEL Clause

12. 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
  • Using SET Variables in SQL*Plus, SQL to Generate SQL

13. Data Manipulation Language (DML) Commands

  • INSERT, UPDATE, DELETE, and MERGE Commands
  • Use of Subqueries
  • Transaction Control Commands / Read Consistency / Locking
  • The MERGE Command
  • Flashback Queries

14. Data Definition Language (DDL) Commands

  • DDL Commands, Object Naming, Dropping Objects
  • TRUNCATE, COMMENT, RENAME Commands
  • Creating Tables / Integrity Constraints
  • CREATE TABLE, ALTER TABLE Commands
  • Datatypes, Types of Declarative Constraints
  • Default Values
  • Creating, Deferrable, Dropping, Disabling/Enabling Constraints / Displaying Constraint Information
  • Handling Exceptions
  • Views, Synonyms, Sequences, Indexes, Virtual Columns
  • Temporary Tables, External Tables

Testimonials

A. Erlich

RITSC, N6C

I just wanted to say your presentation on Social Media Technology and Security was the finest I have ever attended.

Wilder Guerra

US Navy Reserve

This course is definitely an eye opener. With how much social media has taken over, it is important to be fully aware of the capabilities along with all the risks it brings. It is important to get this course because social media is the new norm.

Rebekah Coughlin

MicroTech

The Social Media and Security Training course offered by UKI is a great and beneficial course combining technical training to fully understand TCP IP networking, DNS, and the harms of malware and cross-site scripting; as well as practical training that allowed attendees to play with open source social intelligence gathering solutions. This is the perfect class for those involved in IT security and interested in social media and identity theft.


Top Related Courses

In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle's implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle's implementation of SQL.



In this course, you will learn about the Oracle Server architecture, expand the size of the database, implement security, and how to perform specific database administration tasks.



In this course, you will learn a wide variety of advanced concepts to let you fully master administration of an Oracle database. This course includes a thorough discussion of new Oracle 12c automation features including flashback technologies, automated storage management, automated tuning tools, and automated management tools (such as the new scheduler).



© 2017 Ultimate Knowledge Insitute | All Rights Reserved | GSA# GS-35F-0469W