Oracle Database SQL and PLSQL Basics
Oracle Database SQL and PLSQL Basics
4.45 (39 reviews)
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
Reviews
ARYAN
April 19, 2023
superbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb sir....................................
Charts
Price
Rating
Enrollment distribution
Related Topics
2758574
udemy ID
1/14/2020
course created date
1/21/2021
course indexed date
Bot
course submited by