Training
Oracle
Oracle Database
Oracle Database 12c R2: SQL Workshop I Ed 3

7619 Reviews star_rate star_rate star_rate star_rate star_half

Oracle Database 12c R2: SQL Workshop I Ed 3

This course is an introduction to SQL. It teaches students how to query or update data in a relational database management system (RDBMS). In this class, students learn the concepts of relational...

By Request

$3,600 USD GSA $1,983.48

Course Code D80192GC30

Duration 3 days

Available Formats Classroom

Enter your Email to Download Full Course Details

This course is an introduction to SQL. It teaches students how to query or update data in a relational database management system (RDBMS). 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. A student can use SQL Developer to access an Oracle database or MySQL Workbench to access a MySQL database. They can also experience using SQL*Plus to access an Oracle database or MySQL command-line client to access a MySQL database.

Students can see SQL statements that are identical in both Oracle database and MySQL database, and also see the variations in output or syntax between the databases in some statements.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

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

Prerequisites

Familiarity with programming languages
Familiarity with data processing concepts and techniques

Course Details

Introduction

Oracle Database 12c: Focus Areas
Introduction to Oracle Cloud
MySQL Enterprise Edition
High Scalability with MySQL
Relational Database Concept
Entity Relationship Model
How SQL Works

Retrieving Data using the SQL SELECT Statement

Concatenation Operator in Oracle
Concatenation Function in MySQL
Using Literal Character Strings in Oracle
Using Literal Character Strings in MySQL
Displaying Table Structure by Using Oracle SQL Developer
Displaying Table Structure by Using MySQL Workbench
Duplicate Rows

Restricting and Sorting Data

Using the WHERE Clause
Character Strings and Dates
Comparison Operators
Using the BETWEEN, IN and LIKE Operators
Using the AND, OR and NOT Operators
Using the ORDER BY Clause
SQL Row Limiting Clause

Using Single-Row Functions to Customize Output

Character Functions
Nesting Functions
Numeric Functions
Working with Dates

Using Conversion Functions and Conditional Expressions

Implicit Data Type Conversion
Using the TO_CHAR,TO_NUMBER and TO_DATE Functions
Using the CAST() function in Oracle
Explicit Data Type Conversion in MySQL
NVL Function (Oracle) and IFNULL() Function (MySQL
Using the NVL and NVL2 Function in Oracle
Using the IFNULL Function in MySQL
Conditional Expressions

Reporting Aggregated Data Using the Group Functions

Types of Group Functions
Group Functions and Null Values in Oracle
Group Functions and Null Values in MySQL
Using the DISTINCT Keyword
Creating Groups of Data
Restricting Group Results
Nesting Group Functions in Oracle

Displaying Data From Multiple Tables Using Joins

Creating Natural Joins
Using Table Aliases with the USING Clause in Oracle
Creating Joins with the ON Clause
Creating Three-Way Joins
Self-Joins Using the ON Clause
Retrieving Records with Nonequijoins
Cartesian Products

Using Subqueries to Solve Queries

Rules and Guidelines for Using Subqueries
Single-Row Subqueries
Using Group Functions in a Subquery
HAVING Clause with Subqueries
Multiple-Row Subqueries
Using the ANY Operator in Multiple-Row Subqueries
Using the ALL Operator in Multiple-Row Subqueries
Null Values in a Subquery

Using the SET Operators

Set Operator Rules
Using the UNION and UNION ALL Operators
Using the INTERSECT Operator
Using the MINUS Operator
Matching SELECT Statements in Oracle
Matching SELECT Statements in MySQL
Using the ORDER BY Clause in Set Operations in Oracle
Using the ORDER BY Clause with UNION in MySQL

Managing Tables using DML statements in Oracle and MySQL

Adding a New Row to a Table
Updating Rows in a Table
Removing a Row from a Table
Explicit Transaction Control Statements
Implicit Transaction Processing
Implementing Read Consistency
FOR UPDATE Clause in a SELECT Statement

Introduction to Data Definition Language in Oracle and MySQL

Database Objects
Creating Tables (Database)
Data Types
Including Constraints
Creating a Table Using a Subquery
Adding, Modifying and Dropping a Column

Read Less

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.

Request Other Date Request On-site Course

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.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

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

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

Great company -- easy to sign up and very organized. Loved my teacher and class overall.

ExitCertified Student

ExitCertified

Great class I learned a great deal from the material. There would seem to a large amount that I need to learn about.

William Driver

ExitCertified

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

ExitCertified Student

ExitCertified

I was very satisfied about how the course was organized. Sean Did a very good work

Maximilien Belinga Belinga

ExitCertified

ExitCertified provided a very organized way to learn and provided materials to follow along.

ExitCertified Student

ExitCertified

Oracle Database 12c R2: SQL Workshop I Ed 3

Overview

Schedule

FAQ

Reviews