Oracle Database SQL and PLSQL Basics

Oracle Database SQL and PLSQL Basics

4.45 (39 reviews)
Udemy
platform
English
language
Other
category
instructor
155
students
10.5 hours
content
Jan 2021
last update
$49.99
regular price

What you will learn

SQL - Structured Query Language

PLSQL- Procedural Language for SQL

Crash Course On SQL & PLSQL

Description

The course is for the Oracle Database Developers - which is designed for beginner level.

Starting with SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER by For Data Extraction Purpose

INSERT, UPDATE, DELETE for DML Operations

CREATE, ALTER , DROP For DDL Operations

In Procedural Language For SQL - Starting with Variable Declaration, Loops, CURSORS, API's etc are covered

Content

SQL - Structured Query Language - DML

SELECT and FROM Clause
WHERE and ORDER BY Clause
Single Row Function
Group Functions- GROUP BY , HAVING Clause
Joins
Subqueries
Manipulating Data INSERT, UPDATE and DELETE

DDL

CREATE, ALTER, DROP, GRANT and REVOKE

PLSQL - Procedureal Language For SQL

Declaring Variables
IF ELse, CASE, Loops
Cursor - Implicit and Explicit
Procedure
Functions
Exception Handling
Packages
Triggers
Types in PLSQL
PLSQL Record Types - Associate Array, Nested Table and VARRAY

SQL Miscellaneous

PIVOT
WITH Clause

SQL Loader

Intro and Sample For Variable Length and Fixed Length Data Files
Loading Multiple Files, Loading Data Into Multiple Tables Using When Clause
Invoking SQLLoader From Unix

Screenshots

Oracle Database SQL and PLSQL Basics - Screenshot_01Oracle Database SQL and PLSQL Basics - Screenshot_02Oracle Database SQL and PLSQL Basics - Screenshot_03Oracle Database SQL and PLSQL Basics - Screenshot_04

Reviews

ARYAN
April 19, 2023
superbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb sir....................................

Charts

Price

Oracle Database SQL and PLSQL Basics - Price chart

Rating

Oracle Database SQL and PLSQL Basics - Ratings chart

Enrollment distribution

Oracle Database SQL and PLSQL Basics - Distribution chart

Related Topics

2758574
udemy ID
1/14/2020
course created date
1/21/2021
course indexed date
Bot
course submited by