Flash Sale: Save 15% on IT Training

closeClose

Oracle Database 12c R2: SQL Workshop I

  • Tuition USD $2,316
  • Reviews star_rate star_rate star_rate star_rate star_half 1453 Ratings
  • Course Code D80192GC20
  • Duration 3 days
  • Available Formats Virtual

The Oracle Database: SQL Workshop I Ed 3 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Learn To:

  • Identify what a SQL statement is.
  • Understand the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL Statements.
  • Manipulate data in relational tables and save the data.

Benefits To You

Students use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the fundamental concepts. 

Skills Gained

  • Identify the major components of Oracle Database
  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Run complex queries to retrieve data from multiple tables
  • Run data manipulation language (DML) statements to update data in Oracle Database

Who Can Benefit

  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

Course Details

Topics

  • Introduction
    • Course Objectives, Course Agenda and Appendixes Used in this Course
    • Overview of Oracle Database 12c and Related Products
    • Overview of relational database management concepts and terminologies
    • Introduction to SQL and its development environments
    • What is Oracle SQL Developer?
    • Starting SQL*Plus from Oracle SQL Developer
    • The Human Resource(HR) Schema
    • Tables used in the Course
  • Retrieving Data using the SQL SELECT Statement
    • Capabilities of the SELECT statement
    • Arithmetic expressions and NULL values in the SELECT statement
    • Column aliases
    • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    • Use of the DESCRIBE command
  • Restricting and Sorting Data
    • Limiting the Rows
    • Rules of precedence for operators in an expression
    • Sorting rows using ORDER BY clause
    • SQL row limiting clause in a query
    • Substitution Variables
    • Using the DEFINE and VERIFY command
  • Using Single-Row Functions to Customize Output
    • Describe the differences between single row and multiple row functions
    • Manipulate strings with character function in the SELECT and WHERE clauses
    • Nesting Functions
    • Manipulate numbers with the ROUND, TRUNC and MOD functions
    • Perform arithmetic with date data
    • Manipulate dates with the date functions
  • Using Conversion Functions and Conditional Expressions
    • Describe implicit and explicit data type conversion
    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • Apply the NVL, NULLIF, and COALESCE functions to data
    • Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
    • Group Functions
    • Grouping Rows (GROUP BY and HAVING clause)
    • Nesting Group Functions
  • Displaying Data From Multiple Tables Using Joins
    • Introduction to JOINS
    • Types of Joins
    • Natural join
    • Self-join
    • Nonequijoins
    • OUTER join
    • Cartesian product
  • Using Subqueries to Solve Queries
    • Introduction to Subqueries
    • Single Row Subqueries
    • Multiple Row Subqueries
    • Null values in a subquery
  • Using the SET Operators
    • Set Operators
    • UNION and UNION ALL operator
    • INTERSECT operator
    • MINUS operator
    • Matching the SELECT statements
    • Using ORDER BY clause in set operations
  • Managing Tables using DML statements
    • Data Manipulation Language
    • Database Transactions
    • Manual Data Locking
  • Introduction to Data Definition Language
    • Database Objects
    • CREATE TABLE statement
    • Data types
    • Overview of constraint
    • Creating a table using subquery
    • Use the ALTER TABLE statement to add, modify, and drop a column
    • DROP TABLE statement
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource(HR) Schema
  • Tables used in the Course

Retrieving Data using the SQL SELECT Statement

  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command

Restricting and Sorting Data

  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Sorting rows using ORDER BY clause
  • SQL row limiting clause in a query
  • Substitution Variables
  • Using the DEFINE and VERIFY command

Using Single-Row Functions to Customize Output

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Nesting Functions
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions

Using Conversion Functions and Conditional Expressions

  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Conditional Expressions

Reporting Aggregated Data Using the Group Functions

  • Group Functions
  • Grouping Rows (GROUP BY and HAVING clause)
  • Nesting Group Functions

Displaying Data From Multiple Tables Using Joins

  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Nonequijoins
  • OUTER join
  • Cartesian product

Using Subqueries to Solve Queries

  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
  • Null values in a subquery

Using the SET Operators

  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations

Managing Tables using DML statements

  • Data Manipulation Language
  • Database Transactions
  • Manual Data Locking

Introduction to Data Definition Language

  • Database Objects
  • CREATE TABLE statement
  • Data types
  • Overview of constraint
  • Creating a table using subquery
  • Use the ALTER TABLE statement to add, modify, and drop a column
  • DROP TABLE statement

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

I've always enjoyed classes through ExitCertified. Great group of instructors and they have a great platform to teach on both in person and online (iMVP).

Very good course to get insights on spring framework. It would have been more helpful if reactive services were included in the course.

Great instructor and good class material. Labs were helpful and put together very well.

I thought the labs and content were helpful in understanding the services associated with devops

Great training provided. One suggestion is mail out printed copy of course material and exercises to participants.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward