What you'll learn

Create simple and complex views

Retrieving Data from a View

Modifying and Removing a View

Manage Tables

Naming Rules

CREATE TABLE Statement

Data Types

Creating a Table by Using a Subquery

ALTER TABLE statement

Dropping a Table

Database Transactions

Database Transactions Types

COMMIT and ROLLBACK Statements

Controlling Transactions

Rolling Back Changes to a Marker

The Data Before COMMIT or ROLLBACK

The Data After COMMIT

The Data After ROLLBACK

Data Manipulation Language

Using a Subquery in an INSERT Statement

Changing Data in a Table

UPDATE Statement

Updating Rows in a Table

Updating Two Columns with a Subquery

Updating Rows Based on Another Table

Removing a Row from a Table

DELETE Statement

Deleting Rows from a Table

Adding a New Row to a Table

Inserting New Rows

Inserting Rows with Null Values

Inserting Specific Date Values

Set Operators

Using UNION, UNION ALL, INTERSECT, and MINUS

Using the UNION Operator

Using the UNION ALL Operator

Using the INTERSECT Operator

Using the MINUS Operator

Multiple-Row 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 Group Functions in a Subquery

The HAVING Clause with Subqueries

Using Subqueries to Solve Queries

Using a Subquery

Types of Subqueries

Single-Row Subqueries

Executing Single-Row Subqueries

Types of outer joins: LEFT OUTER, RIGHT OUTER, FULL OUTER

INNER Versus OUTER Joins

LEFT OUTER JOIN

RIGHT OUTER JOIN

FULL OUTER JOIN

Creating Cross Joins

Displaying Data from Multiple Tables

Creating Natural Joins

Retrieving Records with Natural Joins

Creating Joins with the USING Clause

Joining Column Names

Retrieving Records with the USING Clause

Using Table Aliases

Creating Joins with the ON Clause

Self-Joins Using the ON Clause

Self-Joins Using the ON Clause

Applying Additional Conditions to a Join

Creating Three-Way Joins with the ON Clause

Retrieving Records with Non-Equi joins

Restricting Group Results

Restricting Group Results with the HAVING Clause

Using the HAVING Clause

Nesting Group Functions

Grouping by More Than One Column

Grouping by More Than One Column

Using the GROUP BY Clause on Multiple Columns

Creating Groups of Data

Using the GROUP BY Clause

Group Functions

Types of Group Functions

Using the AVG and SUM Functions

Using the MIN and MAX Functions

Using the COUNT Function

Using the DISTINCT Keyword

Group Functions and Null Values

Conditional Expressions

CASE Expression

Using the CASE Expression

Using the DECODE Function

Nesting Functions

Using the NVL, NVL2, COALESCE, and NULLIF Function

Data Type Conversion

Elements of the Date Format Model

Using the TO_CHAR Function with Numbers

Using the TO_CHAR Function with Dates

Using the TO_CHAR Function with Numbers

Using the TO_NUMBER and TO_DATE Functions

Example of RR Date Format

Date Functions

Working with Dates

Arithmetic with Dates

SYSDATE Function

Working with Dates

Using Arithmetic Operators with Dates

Date Functions

Using Date Functions

Using ADD_MONTHS Function

Single-Row Functions

Types of SQL Functions

Single-Row Functions

Character Functions

Using Case-Manipulation Functions

Character-Manipulation Functions

Using the Character-Manipulation Functions

Using the Number, ROUND, TRUNC, and MOD Functions

Logical Conditions

Using the AND, OR. and NOT Operator

Rules of Precedence

Using the ORDER BY Clause

Sorting Data

Limiting Rows Using a Selection

Using the WHERE Clause

Character Strings and Dates

Comparison Conditions

Using Comparison Conditions

Using the BETWEEN, IN, LIKE, and NULL Condition

Arithmetic Expressions

Operator Precedence

Using Column Aliases

Concatenation Operator

Using Literal Character Strings

Alternative Quote (q) Operator

Displaying Table Structure

Structured Query Language (SQL)

Retrieving Data Using the SQL SELECT Statement

Basic SELECT Statement

Selecting All Columns

Selecting Specific Columns

Oracle OEHR schema

Overview of the Oracle Sample Schemas

Oracle Schema HR

Oracle Schema OE

HR Table Descriptions

Oracle OE Table Descriptions

Schema OEHR Diagram

Requirements

NO need to downloading the Oracle database.

No need for any prerequisite Oracle database skills.

No need for any programming experience is required to master the content in this course.

Description

I was very excited to create this course on teaching Oracle SQL to become an Oracle SQL developer and I think I will be an excellent trainer to demonstrate your Oracle SQL programming abilities. I can develop your programming skills with new programming ideas, strong analytical skills, new perspectives, and a great affinity for innovative programming techniques, a diversity of programming experience, and a dedication to Delivering software information in a professional manner that is simple to understand. There is nothing I cannot or will not do to ensure your success in achieving your goal of working as an Oracle SQL software developer.

On a personal level, I am passionate about software development technology and excited about the idea that your work as an Oracle SQL software developer will affect millions of end-users around the world, and I do not agree with the second-best solution but I strive to find the best ways to get the best results and I am constantly striving to improve your skills and programming knowledge. I am fully aware of the most recent ones.

As I have a software company in Germany and registered in the European Union, I am open to trying new technologies and have high experience in Oracle, Java, Spring Boot, Spring MVC, and Angular.

I would like to share this course with you my knowledge of software industries and feel that my strongest strength is firstly a passion for technology and software engineering. Second, the ability to understand and prioritize my work in a changing work environment, which helps me successfully achieve results.

This course does not need any prior qualifications and is training you on the basics of the Oracle SQL language in a practical and professional way up to the stage of professionalism in programming techniques for Oracle SQL.

After completing this course, you should be able to  do the following:

1. Use advanced SQL data retrieval techniques to  retrieve data from database tables 

2. Apply advanced techniques in a practice that  simulates real life

Who this course is for:

For everyone willing to get into and get a job as the Oracle SQL developer.

For everyone who is interested in passing and get the Oracle SQL 1Z0-071 Certification.