Session 20 Core Java 13 Dec

DBMS[DataBase Managements System] or SQL based Databases
----------------------------------------------------------
1. Hierarchical DBMS
2. Networked DBMS
3. Distributed DBMS
4. Relational DBMS [R-DBMS]
5. Object Oriented DBMS
6. ----


NoSQL Databases
----------------
a. MongoDB
b. Cassandra
c. AWS DynamoDB
d. BigTable
e. Elastic Search


RDBMS: It will store the data in the tabular format.
-----------------------------------------------------
a. Oracle
b. MySql
c. MariaDB
d. MS SqlServer
e. PostGresSql
d. D2
e. H2
f. AWS RDS
--
--


https://www.heidisql.com/download.php


HomeWork: Oracle|Mysql VS MongoDB


SQL:
-----
-| It is used to communicate with R-DBMS to perform operations.
-| It is only for RDBMS.


DDL[Data Defination Language]
|- Create Table
|- Drop Table
|- Alter Table

mysql =show databases;
mysql = create database nepal_db;
mysql = use nepal_db;
mysql = show tables;
mysql = CREATE TABLE employee (id INTEGER, name VARCHAR(255), salary float(4));
mysql = desc employee;
------------------------------------------------------------------------------------------


DML[Data Manipulation Language]
|- Select
|- Insert
|- Update
|- Delete

mysql = SELECT * FROM employee;
mysql = INSERT INTO employee VALUES(101, 'Musa', 1234.50);
mysql = UPDATE employee SET salary=3000 WHERE id = 101;
mysql = DELETE FROM employee WHERE id = 101;


DTL[Data Transaction Language]
|- Commit
|- Rollback


DCL[Data Control Language]
|- Grant Permission