Oracle SQL tutorial in TAMIL | INDEX - Introduction | SQL tutorial for beginners in Tamil @learncodetodaytamil.
Hello Guys welcome to Learn Code Today தமிழ் 👩💻
Give this video a Thumbs Up 👍
Share & Subscribe for More Videos😉
Click the bell icon to get notified for new videos 🔔
Feel free to drop your doubts in the comment section 📳
You can support me by buying a cup of coffee ☕ bit.ly/3wfnmrg
👍 Support: bit.ly/3Clr0E3
If u have any queries drop an email @ blog.learncode@gmail.com 📧
In this video we have covered, what is index with examples,
what are all thetypes of index.
what is syntactic check with examples
what is semantic check with examples
what is cpu cost with examples
How to find cpu cost with examples
Channel link: / @learncodetodaytamil
Oracle SQL Playlist:
• Oracle SQL in Tamil
Oracle PL/SQL Playlist:
• Oracle PL/SQL in Tamil
Oracle SQL & PLSQL Interview & Practical Questions Playlist:
• Oracle SQL & PLSQL Int...
➤ Index:
Introduction: • INDEX - Introduction w...
➤ Set Operator:
Introduction: • SET OPERATORS - Introd...
Union: • UNION - SET OPERATOR w...
Union All: • UNION ALL - SET OPERAT...
Intersect: • INTERSECT - SET OPERAT...
Minus: • MINUS - SET OPERATOR w...
➤ Materialized view
Complete Refresh: • COMPLETE REFRESH -MATE...
Fast Refresh: • FAST REFRESH - MATERIA...
Force Refresh: • Force Refresh - MATERI...
➤ Pseudo Column: • PSEUDO COLUMN with exa...
➤ Sub Query:
Single Row subquery: • SINGLE ROW SUB QUERY w...
Multi Row subquery: • MULTI ROW SUB QUERY wi...
Inline View: • INLINE VIEW with examp...
➤ Joins:
Cross join: • CROSS JOIN with exampl...
Equi join: • INNER JOIN with exampl...
Left outer join: • LEFT OUTER JOIN with e...
Right outer join: • RIGHT OUTER JOIN with ...
Full outer join: • FULL OUTER JOIN with e...
Self join: • SELF JOIN with example...
➤ Constraints:
Foreign Key: • FOREIGN KEY - CONSTRAI...
Check Constraint: • CHECK - CONSTRAINT wit...
Unique Key : • UNIQUE KEY - CONSTRAIN...
Primary Key: • PRIMARY KEY - CONSTRA...
➤ SQL Subsets - TCL: • TCL with examples | Or...
➤ SQL Subsets - DCL: • DCL with examples | Or...
➤ SQL Subsets - DML:
Delete: • DML - DELETE with ex...
Merge: • DML - MERGE with exa...
Update: • DML - UPDATE with ex...
Insert: • DML - INSERT with ex...
➤ SQL Subsets - DDL:
How to create table in oracle database
DDL part 1: • DDL - (Create, Renam...
DDL part 2: • DDL - (ALTER - Add, M...
➤ Relational operators: • Relational Operators w...
➤ Datatypes in Oracle: • DATATYPES in SQL | Ora...
#oracleintamil
#oraclesqlintamil
#oracledatabaseintamil
#oracletamiltutorials
#oracleindex
#oracleindextypes
#sqloracleindex
#oracleindexandtypes
#oracleindexadvantagesanddisadvantages
#alteroracleindex
#addoracleindex
#whatisindexandtypesofindexinoracle
#howtodeleteanindexinoracle
#whatissemanticcheck
#whatissyntacticcheck
#oracleindexcreation
#createoracleindex
#checkoracleindexstatus
#checkoracleindex
#oracleindexexample
#oracleindexenable
#oracleindexexplainplan
7 сен 2024