019. SQL Joins

Download Link:
https://drive.google.com/open?id=1mQVBaPp1C6rF2u6rOA-sRalTpKloDSfJ

full paylist link: https://www.youtube.com/playlist?list=PLTKdqDvypmKfmbTTz7xPs1Av_aL-asT8S

SQL SERVER – Complete Series includes following
1. Introduction to SQL Server
2. SQL Syntax
a. Database Tables
b. SQL Statements
c. Most Important SQL Commands
3. SQL SELECT Statement
a. SELECT Syntax & Examples
b. SELECT DISTINCT Syntax & Examples
4. SQL WHERE Clause
a. WHERE Syntax & Examples
b. Text Fields vs. Numeric Fields
c. Operators in The WHERE Clause
5. SQL AND, OR and NOT Operators
a. AND Syntax & Examples
b. OR Syntax & Examples
c. NOT Syntax & Examples
d. Combining AND, OR and NOT
6. SQL ORDER BY Keyword & Execution Order
a. ORDER BY Syntax & Examples
7. SQL INSERT INTO Statement
a. INSERT INTO Syntax & Examples
8. SQL NULL Values
a. What is a NULL Value?
b. NULL Syntax & Examples
9. SQL UPDATE Statement
a. UPDATE Syntax & Examples
10. SQL DELETE Statement
a. DELETE Syntax & Examples
11. SQL TOP, LIMIT or ROWNUM Clause
a. SQL TOP, LIMIT and ROWNUM Examples
12. SQL MIN() and MAX() Functions
a. Syntax & Examples
13. SQL COUNT(), AVG() and SUM() Functions
a. Syntax & Examples
14. SQL LIKE Operator with Wildcards
a. Syntax & Examples
15. SQL IN, EXISTS, ANY & ALL Operator
a. Syntax & Examples
16. SQL Moving AVG & Cumulative Total
a. Syntax & Examples
17. SQL BETWEEN Operator
a. Syntax & Examples
18. SQL Aliases
a. Column, Table Syntax & Examples
19. SQL Joins
a. Different Types of SQL JOINs
i. INNER JOIN Syntax & Examples
ii. LEFT JOIN Syntax & Examples
iii. RIGHT JOIN Syntax & Examples
iv. FULL JOIN Syntax & Examples
v. SELF JOIN Syntax & Examples
20. SQL UNION & UNION ALL Operator
a. Syntax & Examples
21. SQL GROUP BY Statement
a. Syntax & Examples
22. SQL HAVING Clause
a. Syntax & Examples
23. SQL SELECT INTO Statement
a. Syntax & Examples
24. SQL INSERT INTO SELECT Statement
a. Syntax & Examples
25. SQL CASE Statement
a. Syntax & Examples
26. SQL NULL Functions
a. SQL NULLIF(), ISNULL(), and COALESCE() Functions
27. SQL Stored Procedures
a. Syntax & Examples
28. SQL Comments
a. Single Line Comments
b. Multi-line Comments
29. DATA TYPES
a. CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, NTEXT
b. BINARY, VARBINARY, IMAGE
c. BIT
d. TINYINT, SMALLINT, INT, BIGINT, DECIMAL, NUMERIC, SMALLMONEY, MONEY, FLOAT, REAL
e. DATETIME, DATETIME2, SMALLDATETIME, DATE, TIME, DATETIMEOFFSET, TIMESTAMP
f. SQL_VARIANT
g. UNIQUEIDENTIFIER
h. XML
i. CURSOR
j. TABLE
30. SQL CREATE DATABASE Statement
a. Syntax & Examples
31. SQL DROP DATABASE Statement
a. Syntax & Examples
32. SQL BACKUP DATABASE
a. Syntax & Examples
33. SQL CREATE TABLE Statement
a. Syntax & Examples
34. SQL DROP & Truncate TABLE Statement
a. Syntax & Examples
35. SQL ALTER TABLE Statement
a. Syntax & Examples
36. SQL Constraints
a. NOT NULL Constraint
i. Syntax & Examples
b. UNIQUE Constraint
i. Syntax & Examples
c. PRIMARY KEY Constraint
i. Syntax & Examples
d. FOREIGN KEY Constraint
i. Syntax & Examples
e. CHECK Constraint
i. Syntax & Examples
f. DEFAULT Constraint
i. Syntax & Examples
g. INDEX Constraint
i. Syntax & Examples
37. SQL AUTO INCREMENT Field
a. Syntax & Examples
38. SQL Working With Dates
a. Syntax & Examples
39. SQL Views
a. Syntax & Examples
40. SQL Server Functions
a. String Functions
i. ASCII()
ii. CHAR() & NCHAR()
iii. CHARINDEX() & PATINDEX()
iv. CONCAT()
v. DATALENGTH()
vi. DIFFERENCE() & SOUNDEX()
vii. FORMAT()
viii. CAST()
ix. CONVERT()
x. LEFT(), RIGHT() & SPACE()
xi. LOWER() & UPPER()
xii. LTRIM() & RTRIM()
xiii. QUOTENAME()
xiv. SUBSTRING(), REPLACE() & STUFF()
xv. REPLICATE()
xvi. REVERSE()
xvii. STR()
xviii. UNICODE()
b. Numeric Functions
i. ABC()
ii. ACOS()
iii. SIN() & ASIN()
iv. TAN() & ATAN()
v. ATN2()
vi. AVG()
vii. CEILING(), FLOOR() & ROUND()
viii. COUNT()
ix. COS()
x. COT()
xi. DEGREES(), RADIANS() & PI()
xii. EXP(), LOG() & LOG10()
xiii. MIN() & MAX()
xiv. POWER()
xv. RAND()
xvi. SIGN()
xvii. SQRT()
xviii. SQUARE()
xix. SUM()
xx. ISNUMERIC()
c. Date Functions
i. CURRENT_TIMESTAMP, GETDATE(), GETUTCDATE() & SYSDATETIME()
ii. DATEADD()
iii. DATEDIFF()
iv. DATEFROMPARTS()
v. DATENAME()
vi. DATEPART()
vii. DAY(), MONTH() & YEAR()
viii. ISDATE()
d. Advanced Functions
i. CURRENT_USER
ii. IIF()
iii. SESSION_USER, SYSTEM_USER & USER_NAME
iv. SESSIONPROPERTY
1. ANSI_NULLS
2. ANSI_PADDING
3. ANSI_WARNINGS
4. ARITHABORT
5. COCAT_NULL_YIELDS_NULL
6. NUMERIC_ROUNDABOUT
7. QUOTED_IDENTIFIER
v. TRY_CAST(), TRY_PARSE() & TRY_CONVERT()

Learning .NET in Urdu Language please visit:
http://www.youtube.com/user/pkishar

For .NET samples please visit:
http://www.a1vbcode.com/author.asp?name=Ishtiaq+Ahmed

and On MSDN please Visit:
http://code.msdn.microsoft.com/site/search?f%5B0%5D.Type=User&f%5B0%5D.Value=IsharPK