database types
Relational Database =
-Tables are structured related to each other
-Each specific type of domain data is strored
it's own table
Non-Relational Database =
-There is no relation at all between tables
-Mostly key+value pair : like jSondatabase types
Relational Database =
-Tables are structured related to each other
-Each specific type of domain data is strored
it's own table
Non-Relational Database =
-There is no relation at all between tables
-Mostly key+value pair : like jSonsql types
1- Data Manipulation Language(DML)-(SELECT, INSTERT, UPDATE...)
DML statements affect records in table. These are
basic operations we perform on data such as selecting
few records from a table, inserting new records,
deleting unnecessary records, updating existing records.
2-Data Definition Language (CREATE , ALTER , DROP)...
DDL statements are used to modify database or
table schema. These statements handle the design
and storage of database objects.
3-Data Control Language (GRANT , REVOKE)...
DCL statements control the level of access that
users have on database objects
4- Transaction Control Language (BEGIN TRAN, COMMIT TRAN, ROLLBACK)...
TCL statements allows us to control and manage
transactions to maintain the integrity of data
withing SQL statements.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
