Oracle Database (Hindi)

   Monday, May 13, 2024   

Starting a new Lecture Notes Series on Oracle Database

Youtube Lecture Playlist Credits 

Channel Name: Learn Coding

So Let Us Start to This Journey of Learning 

Oracle Database By Lecture Notes together!

Lecture 1: Introduction to Oracle Database | What is Oracle? full Explanation

Lecture 2: Oracle 11g installation on windows 10 64 bit | Learn Coding

Lecture 3: Oracle Database Objects | Learn Coding

Lecture 4: Introduction to Oracle Database | What is Oracle? full Explanation

Lecture 5: Oracle 11g installation on windows 10 64 bit | Learn Coding

Lecture 6: Oracle Database Objects | Learn Coding

Lecture 7: DDL Commands in SQL | Oracle Database

Lecture 8: Difference Between Truncate and Drop in SQL | SQL Commands

Lecture 9: DML Commands in SQL | Oracle Database

Lecture 10: DQL Commands in SQL | Oracle Database

Lecture 11: TCL Command in SQL | Oracle Database

Lecture 12: where clause in sql | oracle database

Lecture 13: SQL Operators | Oracle Database

Lecture 14: SQL: Arithmetic, Relational, Concatenation and Logical Operators | Oracle Database

Lecture 15: SQL: Distinct, ALL, IN, NOT IN, Between, LIKE and NOT LIKE Operators | Learn Coding

Lecture 16: SQL Set Operator | union, union all, intersect and minus operator | oracle database

Lecture 17: SQL Alias: column_alias and table_alias | Oracle Database

Lecture 18: Constraints in SQL | Oracle Database

Lecture 19: Domain Integrity Constraint in SQL | Default, Not Null and Check Constraints | Oracle Database

Lecture 20: Entity Integrity Constraint in SQL | unique and primary key constraints in oracle database

Lecture 21: Referential Integrity Constraint in SQL | create relationship between two tables using oracle

Lecture 22: Delete Records From Child/Parent Table in Oracle Database | referential integrity constraint

Lecture 23: SQL ALTER COMMAND | add, delete, modify and rename column/table in oracle

Lecture 24: SQL Function | single row and multi row functions in sql

Lecture 25: multi row function in sql | Oracle Database

Lecture 26: group by clause in sql | Oracle Database

Lecture 27: having clause in sql | Oracle Database

Lecture 28: ORDER BY Clause in SQL | Oracle Database

Lecture 29: single row function in sql | Oracle Database

Lecture 30: SQL Joining | types of joining in sql

Lecture 31: types of joins in sql | equi, non-equi, inner, outer, natural, cross and self join in sql

Lecture 32: view in sql | types of view in sql | Oracle Database

Lecture 33: types of view in sql | Oracle Database

Lecture 34: TNS: protocol adapter error in oracle database | Learn Coding

Lecture 35: DCL Commands in SQL | Privileges: Grant & Revoke With Example

Lecture 36: ROWNUM and ROWID in SQL | oracle database

Lecture 37: Top SQL Queries for Interview | Must Do SQL Interviews Queries

Lecture 38: important sql queries for interview | oracle database

Lecture 39: Part-1 SQL Interview MCQ's | SQL MCQs for Exam

Lecture 40: Part-2 SQL Interview MCQ's | SQL MCQs for College Placement