Kishan Mashru
What is database normalisation? | Insert, update and delete anomaly explained | Data Warehousing
5:49
Kishan Mashru
Star Schema and Snowflake Schema | Data Warehousing
10:25
Kishan Mashru
Medallion Architecture - Bronze layer vs Silver layer vs Gold layer
10:39
Kishan Mashru
Fact table and Dimension table | Data Warehousing
7:56
Kishan Mashru
How to get the exact error line number in Oracle PL/SQL?
12:07
Kishan Mashru
Centralized Version Control System (CVCs) and Distributed Version Control System (DVCs)
4:34
Kishan Mashru
What is Version Control System?
3:48
Kishan Mashru
Oracle SQL Loader - How to load data from file(.csv, .dat, .txt) into table - Tutorial - 3
16:44
Kishan Mashru
Oracle SQL Loader - Control File Example - Tutorial -2
15:36
Kishan Mashru
Oracle SQL Loader - Introduction - Tutorial -1
7:47
Kishan Mashru
Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool
15:04
Kishan Mashru
ORA-01940: cannot drop a user that is currently connected | Oracle Database Error Solved
6:12
Kishan Mashru
How to solve ORA-28002: the password will expire warning
5:10
Kishan Mashru
REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE
25:07
Kishan Mashru
On Delete cascade, On delete set null, on delete no action in sql | Interview question
15:31
Kishan Mashru
Foreign Key in SQL | Interview Question
16:01
Kishan Mashru
DIFFERENCE BETWEEN PRIMARY KEY AND UNIQUE KEY CONSTRAINT IN ORACLE SQL
6:47
Kishan Mashru
PRIMARY KEY of a database table explained!!
12:43
Kishan Mashru
UNIQUE KEY IN SQL | Interview question
14:37
Kishan Mashru
NOT NULL AND CHECK CONSTRAINT IN ORACLE SQL WITH EXAMPLE
11:09
Kishan Mashru
DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE
6:33
Kishan Mashru
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE
21:53
Kishan Mashru
How to copy a table with and without data in Oracle SQL | Create Duplicate table |Interview Question
6:24
Kishan Mashru
ADVANCE CREATE TABLE STATEMENT IN SQL
14:24
Kishan Mashru
TYPES OF SQL STATEMENTS | DDL, DML, TCS, control statements | Interview question
8:27
Kishan Mashru
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
13:46
Kishan Mashru
Views in database | Oracle, SQL Server |
15:24
Kishan Mashru
SEQUENCES IN ORACLE SQL WITH EXAMPLES (asc, desc, cycle, nocycle, cache, nocache)
24:39
Kishan Mashru
LNNVL FUNCTION IN ORACLE SQL | Check NULL value in SQL statement
9:11
Kishan Mashru
COALESCE IN ORACLE SQL
6:50
Kishan Mashru
NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE | Return null if expressions are equal
3:24
Kishan Mashru
NVL2 FUNCTION IN ORACLE SQL WITH EXAMPLE
5:40
Kishan Mashru
HOW TO REPLACE NULL VALUE IN ORACLE SQL | NVL function explained
6:25
Kishan Mashru
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
14:19
Kishan Mashru
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
4:46
Kishan Mashru
Difference between Case and Decode
10:14
Kishan Mashru
DECODE FUNCTION IN ORACLE SQL
9:36
Kishan Mashru
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
6:28
Kishan Mashru
ORDER multiple columns in SQL | Interview Question
13:54
Kishan Mashru
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
19:50
Kishan Mashru
DIFFERENT WAYS TO CALL / EXECUTE A PROCEDURE IN ORACLE PL/SQL? (Position, Named and Mixed Notations)
6:53
Kishan Mashru
Procedures in Oracle PL/SQL
23:50
Kishan Mashru
User defined Exception in Oracle PL/SQL
21:35
Kishan Mashru
Exception handling in Oracle PL/SQL | too_many_rows, no_data_found, Oracle PL/SQL concepts
14:01
Kishan Mashru
SQLCODE AND SQLERRM IN ORACLE PL/SQL
6:48
Kishan Mashru
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL
19:41
Kishan Mashru
Materialized Views in Oracle (Part - 2 Practical Implementation with Examples)
13:10
Kishan Mashru
Materialized Views in Oracle ( Part - 1 Introduction)
12:04
Kishan Mashru
type and rowtype PL/SQL | difference between type and rowtype in pl sql | Interview Question
11:37
Kishan Mashru
Wrapping Oracle PL/SQL code
8:27
Kishan Mashru
DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL
4:38
Kishan Mashru
Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)
15:04
Kishan Mashru
How to use Pivot and Unpivot? (how to change rows to column and column to rows)
10:47
Kishan Mashru
OUTER JOIN IN ORACLE SQL EXPLAINED (LEFT / RIGHT/ FULL OUTER JOIN) | Interview Question
10:33
Kishan Mashru
Cross join in SQL | Interview question
3:56
Kishan Mashru
INNER JOIN IN ORACLE SQL WITH EXAMPLE | SQL INTERVIEW QUESTION
12:58
Kishan Mashru
Row Number, Rank and Dense Rank in sql | Analytical functions explained
7:04
Kishan Mashru
Replace and Translate in sql
3:46
Kishan Mashru
HOW TO IDENTIFY AND DELETE DUPLICATE ROWS USING ROWID AND GROUPBY IN ORACLE SQL
7:53
Kishan Mashru
Difference between Procedure and Function
6:33
Kishan Mashru
How to commit in a trigger | Oracle PL SQL
10:54
Kishan Mashru
What is PRAGMA AUTONOMOUS_TRANSACTION in oracle?
12:17
Kishan Mashru
What is High Water Mark(HVM) in oracle and how it effects the performance of queries?
5:41
Kishan Mashru
How to recover a dropped table in oracle? (without backup)
16:52
Kishan Mashru
Difference between Delete and Truncate and Drop in sql | Interview question
14:06
Kishan Mashru
Cursors in Oracle PL/SQL | Oracle PLSQL concepts
21:53
Kishan Mashru
UPDATE STATEMENT WITH JOIN IN ORACLE SQL
7:18
Kishan Mashru
how to unlock oracle user account? ORA-28000: the account is locked
2:34
Kishan Mashru
Find the nth highest salary in sql (1st, 2nd, 3rd, ...nth ) | SQL Interview Question freshers
12:07
Kishan Mashru
IN v/s EXISTS v/s JOIN, performance tuning | Interview question
4:56
Kishan Mashru
How to solve ORA-28000: the account is locked
2:48
Kishan Mashru
How to Join two tables in a update statement
7:18
Kishan Mashru
Interview Question | How to find 2nd max salary in a table using analytical functions in oracle
12:10
Kishan Mashru
IN VS EXISTS VS JOIN, performance
5:04