Front | Back |
Primary KeyForeign Key Unique KeySurrogate key
|
Primary key uniquely identify a row. Unique key uniquely identify a record in the table and there can be multiple unique key.Foreign key creates a relationship between the parent and child table. Surrogate key is used in dimension modelling to create relationship between dimension & fact tables.
|
Referential Integrity
|
Referential integrity
|
Constraints
|
Primary KeyForeign keyDefaultCheckNot NullUnique Key
|
Joins
|
Left JoinRight JoinFull JoinInner JoinSelf Join
|
Union vs Union All
|
Combines Distinct row values vs combines all rows
|
IndexClustered Index vs Non Clustered Index
|
Index are used to retrieve the data faster. Clustered index creates a logical and physical order of the table. Non Clustered Index creates a logical order and a pointer to the table.
|
Stored Procedure
|
Asdf
|
User Defined Function (UDF)
|
Abcc
|
View vs Materialized View
|
Asdf
|
Triggers
|
Asdf
|
Window Functions
|
Asdf
|
Name 10 System Functions
|
Asdf
|
What is subquery? Types of subquery?
|
Sfsdfsd
|
CTE
|
CTE
|
Temp Table
|
Aasdfd
|