Lecture 61. SQL – Sub Query (Single Row Sub Query explained by solving different problems)

Lecture 62. SQL – In Operator

Lecture 63. SQL – Using In Operator with Multi Row Sub Query

Lecture 64. SQL – Using Any Operator in Multi Row Sub Query

Lecture 65. SQL – Using All Operator in Multi Row Sub Query

Lecture 66. SQL – Exists Operator

Lecture 67. SQL – Using Sub Queries for retrieving the records from multiple tables

Lecture 68. SQL – Using Multiple Sub Queries in a single SQL statement

Lecture 69. SQL – Integrity Constraints

Lecture 70. SQL – Not Null Integrity Constraint

Lecture 71. SQL – Unique Integrity Constraint

Lecture 72. SQL – Part 71- Primary Key Integrity Constraint

Lecture 74. SQL – Check Integrity Constraint

Lecture 75. SQL – Default Integrity Constraint

Lecture 76. SQL – auto_increment

Lecture 77. SQL – Insert Into

Lecture 78. SQL – AS Keyword

Lecture 79. SQL – IfNull() function

Lecture 80. SQL – Case, When, Then and End Keywords