Scribd
Upload
15 views

Key Point of SQL

Uploaded by

naveen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views

Key Point of SQL

Uploaded by

naveen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

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/

You might also like