Working with Transaction Control Language (TCL)TCL Commands: Commit, Savepoint and RollbackJul 31, 2024Jul 31, 2024
Hands-on session on Data Manipulation Language (DML)DML Commands: Insert, Update, Delete, Truncate and MergeJul 31, 2024Jul 31, 2024
Working with Data Definition Language (DDL)If we want to execute any SQL command, we need a user/schema and appropriate privileges from the Database Administrator(DBA) to connect to…Sep 26, 2020Sep 26, 2020
Data Types in SQLI would like tell history of SQL before discussing about Datatypes in SQLSep 26, 2020Sep 26, 2020
Different types of Keys in DBMSBefore discussing about different keys, i would like to explain what is a Key in DBMS?Sep 17, 2020Sep 17, 2020
What is Normalization?Before discussing about Normalization, why Normalization is required?Sep 11, 2020Sep 11, 2020
ACID PropertiesBefore discussing about ACID properties, I would like to explain about transactionSep 7, 2020Sep 7, 2020
What is Oracle Database?Oracle is an Object Relational Database Management System (ORDBMS)Sep 7, 2020Sep 7, 2020
What is Database?Before discussing about what is Database? I would like to explain What is Data?Sep 7, 2020Sep 7, 2020