SQL Videos

SQL Videos Playlist

---

SQL Injection Attacks

---

Real Use Case of Dynamic SQL Query

---

Dynamic SQL Query and EXECUTE vs SP_EXECUTESQL

---

SQL NULL Value and Consequence of NULL values in SQL

---

SQL Three Valued Logic

---

SQL UNIQUE INDEX and UNIQUE INDEX vs. UNIQUE KEY

---

SQL NON-CLUSTERED INDEX

---

SQL CLUSTERED INDEX and CLUSTERED INDEX vs PRIMARY KEY:

---

Clustered vs. Non-Clustered Index and HEAP Table vs. Clustered Table

---

How SQL Stores Data Internally - SQL 8KB Page:

---

PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY: Part 3 - FOREIGN KEY CONSTRAINT

---

PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY: Part 2 - UNIQUE KEY

---

PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY: Part 1 - PRIMARY KEY

---

TABLE Valued Type or TABLE Valued Parameter in MS SQL

---

TABLE VARIABLE in MS SQL

---

TEMP Table or TEMPORARY Table in MS SQL

---

Common Table Expression - CTE in MS SQL

---

Derived Table - DT in MS SQL

---

What is the difference between GO and Semicolon(;) Terminator in SQL?

---

Set Statements - Part 2

---

Set Statements - Part 1

---

What is CROSS JOIN or CARTESIAN JOIN in SQL?

---

What is FULL OUTER JOIN in SQL?

---

What is RIGHT OUTER JOIN in SQL?

---

What is LEFT OUTER JOIN in SQL?

---

What is SELF JOIN in SQL?

---

What is EQUI-JOIN and NON-EQUI JOIN in SQL?

---

What is ANSI JOIN and NON-ANSI JOIN in SQL?

---

What is INNER JOIN or DEFAULT JOIN in SQL?

---