Setup Menus in Admin Panel

Course Curriculum

Chapter 1: Introduction to Oracle SQL
What is a database? FREE 00:00:00
What is DBMS? 00:00:00
What is RDBMS? 00:00:00
What is SQL? 00:00:00
RDBMS Products In The Market 00:00:00
Chapter 2: Basics of Oracle SQL
Users and Schemas 00:00:00
Introduction to Data Modeling 00:00:00
Introduction to Data Dictionary 00:00:00
Oracle SQL Data Types 00:00:00
Chapter 3: Data Defination Language(DDL) Commands
Create Table 00:00:00
Alter Table 00:00:00
Truncate Table 00:00:00
Drop Table 00:00:00
Rename Table 00:00:00
Chapter 4: Data Manipulation Language(DML) Commands
Insert Command 00:00:00
Update Command 00:00:00
Delete Command 00:00:00
Merge Command 00:00:00
Chapter 5: Constraints
What are Constraints? 00:00:00
Not Null Constraint 00:00:00
Check Constraint 00:00:00
Unique Constraint 00:00:00
Primary Key Constraint 00:00:00
Foreign Key Constraint 00:00:00
ON Delete Cascade 00:00:00
Composite Keys 00:00:00
Chapter 6: Transaction Control Language(TCL) Commands
Oracle SQL Commit 00:00:00
Rollback 00:00:00
Savepoint 00:00:00
Chapter 7: Data Control Language(DCL) Commands
Grant 00:00:00
Revoke 00:00:00
Chapter 8: Data Retrieval Language(DRL) & Clauses
SELECT 00:00:00
Where Clause 00:00:00
ORDER BY 00:00:00
GROUP BY 00:00:00
Having Clause 00:00:00
Chapter 9: SQL Operators
Introduction to SQL Operators 00:00:00
Types of Operators 00:00:00
Chapter 10: Relational Operators
Equals to (=) Operator 00:00:00
Less than ( 00:00:00
Greater Than (>) Operator 00:00:00
Less than or Equals to ( 00:00:00
Greater than or Equals to (>=) Operator 00:00:00
Not Equals to ( != / ^= / ) Operator 00:00:00
SQL IN Operator 00:00:00
SQL BETWEEN Operator 00:00:00
SQL LIKE Operator 00:00:00
SQL IS NULL Operator 00:00:00
SQL Concatenation ( || ) Operator 00:00:00
Chapter 11: Relational Negation Operators
SQL NOT LIKE Operator 00:00:00
SQL Not Equals to ( != / ^= / ) Operator 00:00:00
SQL NOT IN Operator 00:00:00
SQL NOT BETWEEN Operator 00:00:00
SQL IS NOT NULL Operator 00:00:00
Chapter 12: Logical Operators
Logical AND Operator 00:00:00
Logical OR Operator 00:00:00
Logical NOT Operator 00:00:00
Chapter 13: Arithmetic Operators
Addition (+) Operator 00:00:00
Subtraction (-) Operator 00:00:00
Multiplication (*) Operator 00:00:00
Division ( / ) Operator 00:00:00
Chapter 14: Functions
String Functions 00:00:00
Numeric Functions 00:00:00
Date Functions 00:00:00
Conversion Functions 00:00:00
Group Functions 00:00:00
Chapter 15: Joins
What Is a Join? 00:00:00
Inner Join (or) Simple Join (or) Equi Join 00:00:00
Left Outer Join 00:00:00
Right Outer Join 00:00:00
Full Outer Join 00:00:00
Cross Join 00:00:00
Non-Equi Join 00:00:00
Chapter 16: Subqueries
Sub Query 00:00:00
Sub Query In From Clause 00:00:00
Sub Query In Select Clause 00:00:00
Sub Query In Where Clause 00:00:00
Nested Sub Queries 00:00:00
Chapter 17: Set Operators
UNION 00:00:00
UNION ALL 00:00:00
INTERSECT 00:00:00
MINUS 00:00:00
Chapter 18: Indexes
Index 00:00:00
Unique Index 00:00:00
Non Unique Indexes 00:00:00
Composite Index 00:00:00
Function Based Index 00:00:00
Chapter 19: Synonym
Synonym 00:00:00
Private Synonym 00:00:00
Public Synonym 00:00:00
Chapter 20: Sequence
What Is Sequence? 00:00:00
Using A Sequence 00:00:00
Altering And Dropping The Sequence 00:00:00
Chapter 21: Views
View 00:00:00
Simple View 00:00:00
Complex Views 00:00:00
DML Operations on Views 00:00:00
MATERIALIZED VIEW 00:00:00
Difference Between Normal and Materialized View 00:00:00
Force View 00:00:00
Chapter22: SQL Articles
What are Abstract Datatypes in Oracle SQL? 00:00:00
Performance tuning tips for SQL statements 00:00:00
Oracle SQL Metadata or System Tables 00:00:00
Emp and Dept Table Creation Script 00:00:00
LOB (Large Object) Data Types in Oracle SQL 00:00:00
Oracle 11g New Feature – LISTAGG function in Oracle 00:00:00
Oracle Database 11g New Feature – Pivot & UnPivot functions 00:00:00
XML Functions in SQL 00:00:00
‘XMLTYPE’ Data type in Oracle SQL 00:00:00
Hierarchical Queries 00:00:00
What is the difference between 'YYYY' and 'RRRR' in date format? 00:00:00
Difference between WHERE Clause and HAVING Clause 00:00:00
Difference between Truncate command and Delete command 00:00:00
What is the difference between to_date and to_char functions for date fields? 00:00:00
What is the difference between CHAR, VARCHAR and VARCHAR2 data types? 00:00:00
Database Object Locks 00:00:00
Automatic Performance Tuning using SQL Tuning Advisor 00:00:00
Analytic Functions 00:00:00
Chapter23: Interview Questions
TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS

Advanced Course Search Widget

Recent Posts

  • Starting a Startup

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis vestibulum turpis...

X