Union

Section 1

1) Oracle Introduction

Section 2

2) Installation Process

Section 3

3) Introduction Database

Section 4

4) DDL & DML Statements

1

Introduction to DDL & DML

Section 5

5) Retrieving data using Select statement

1

Capabilities of SQL SELECT Statements

2

Arithmetic expressions and NULL values

3

Column Alias, Concatenation , Distinct and DESCRIBE

Section 6

6) Restricting and sorting data

1

The WHERE Clause & Comparison Operators

2

Using Between and / IN / Like Operators

3

Using IS NULL / NOT / Not equal Operators

4

Logical Operators (AND/ OR/ NOT)

Section 7

7) Variables

1

Substitution Variables

Double-Ampersand / SET VERIFY / SET DEFINE

Section 8

8) Single-row Functions

1

Single Row Function Introduction

2

Character functions (Upper, Lower, Initcap )

3

Character functions (concat, substr, length )

4

Character functions ( instr )

5

Number functions ( Round, Trunc, MOD )

6

Date Functions ( Sysdate)

7

Date Functions ( months_between, add_months, next_day, last_day)

8

Date Functions ( round , trunc )

9

Nesting Functions

Section 9

9) Conversion Functions and Conditional Expressions

1

Implicit Data Conversion VS Explicit

TO_NUMBER , TO_DATE Functions

5

The CASE Function

6

NUllif & Coalesce Function

7

The DECODE Function

Section 10

10) Group Functions

1

Group functions (sum, count, max, min, avg)

2

Group by Clause, Having Clause

Section 11

11) Joins Concept

1

Natural Join

2

Left/Right/full Outer Join

Section 12

12) Subqueries

1

Single row & Multiple rows Subqueries

2

NULL values

3

Exists and not Exists

4

Scalar Subquery / Correlated Subquery

Section 13

13) Set Operators

Section 14

14) Introduction to View

1

Creating Simple Views

2

Creating Complex Views

3

READ ONLY / With check option

Section 15

15) Sequences

Section 16

Synonyms and Indexes

Section 17

16) Controlling User Access

1

Database Security / System Privileges & Roles

2

Database Security / Object Privileges

3

Creating ROLE Practice

Section 18

ORACLE DATABASE

Hey there, great course, right? Do you like this course?

Course sections

1) Oracle Introduction

2) Installation Process

3) Introduction Database

4) DDL & DML Statements

5) Retrieving data using Select statement

6) Restricting and sorting data

7) Variables

8) Single-row Functions

9) Conversion Functions and Conditional Expressions

10) Group Functions

11) Joins Concept

12) Subqueries

13) Set Operators

14) Introduction to View

15) Sequences

Synonyms and Indexes

16) Controlling User Access

Questions

13) Set Operators

Union

Lesson is locked. Please Buy course to proceed.

Shopping Cart

Cart is empty!