SQL:
Types of Constraints:
NOT NULL - Ensures that a column cannot have a NULL value
UNIQUE - Ensures that all values in a column are unique and accept one
null values.
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Uniquely
identifies each row in a table
FOREIGN KEY - Prevents actions that would destroy links between
tables
CHECK - Ensures that the values in a column satisfies a specific
condition
DEFAULT - Sets a default value for a column if no value is specified
CREATE INDEX - Used to create and retrieve data from the database
very quickly
Difference between truncate and delete statement:
https://www.geeksforgeeks.org/difference-between-delete-and-truncate/
https://www.sqlshack.com/difference-between-sql-truncate-and-sql-delete-
statements-in-sql-server/
Syntax samples:
https://www.tutorialspoint.com/sql/sql-truncate-table.htm
DDL:
The DDL commands in SQL are used to create database schema and to define the type
and structure of the data that will be stored in a database.
Data definition language (DDL) refers to the set of SQL commands that can create and
manipulate the structures of a database. DDL statements are used to create, change, and
remove objects including indexes, triggers, tables, and views.
Acid properties:
https://www.essentialsql.com/sql-acid-database-properties-explained/
https://www.c-sharpcorner.com/blogs/sql-server-acid-properties1
For SQL injection:
https://www.w3schools.com/sql/sql_injection.asp
https://www.guru99.com/learn-sql-injection-with-practical-example.html
Savepoint in transaction
https://www.mssqltips.com/sqlservertip/5538/understanding-sql-server-transaction-savepoints/
