(This list will be constantly updated...)
ACID acronym for Atomicity Consistency Isolation Durability, guarantees the consistency of the database.
https://en.wikipedia.org/wiki/ACID
Normalization is the process of reducing data redundancy and improve quality of the data, the way to achieve this is using keys (primary and foreign) and relationships between them. 1NF 2NF and 3NF (normalization Form) are used to achieve this
https://en.wikipedia.org/wiki/Database_normalization
RDBMS acronym for Relational Database Management System, it is a software that implement the management of an organized collection of data (or database) and also implements the relational model. SQL Server, Oracle, Sybase are examples of RDBMS.
https://en.wikipedia.org/wiki/Relational_database_management_system
SQL acronym for Structured Query Language is a standard language used in RDBMS based on set theory (database) and predicate logic (relational model)
https://en.wikipedia.org/wiki/SQL
T-SQL or Transact SQL is the Microsoft implementation of SQL used in SQL Server products.
https://en.wikipedia.org/wiki/Transact-SQL
Null is the RDBMS implementation for the lack of data, and meet the following requirements: is not data type dependant, and logically evaluates to undetermined, it is not equivalent to an empty string and is not equivalent to numeric 0.
https://en.wikipedia.org/wiki/Null_(SQL)
 |
| Mind Blown! |
https://en.wikipedia.org/wiki/ACID
Normalization is the process of reducing data redundancy and improve quality of the data, the way to achieve this is using keys (primary and foreign) and relationships between them. 1NF 2NF and 3NF (normalization Form) are used to achieve this
https://en.wikipedia.org/wiki/Database_normalization
RDBMS acronym for Relational Database Management System, it is a software that implement the management of an organized collection of data (or database) and also implements the relational model. SQL Server, Oracle, Sybase are examples of RDBMS.
https://en.wikipedia.org/wiki/Relational_database_management_system
SQL acronym for Structured Query Language is a standard language used in RDBMS based on set theory (database) and predicate logic (relational model)
https://en.wikipedia.org/wiki/SQL
T-SQL or Transact SQL is the Microsoft implementation of SQL used in SQL Server products.
https://en.wikipedia.org/wiki/Transact-SQL
Null is the RDBMS implementation for the lack of data, and meet the following requirements: is not data type dependant, and logically evaluates to undetermined, it is not equivalent to an empty string and is not equivalent to numeric 0.
https://en.wikipedia.org/wiki/Null_(SQL)
Comments
Post a Comment