|
|
1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.mp4
|
MP4
|
19.8 MB
|
|
|
1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.srt
|
SRT
|
2.7 KB
|
|
|
1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.mp4
|
MP4
|
34.7 MB
|
|
|
1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.srt
|
SRT
|
4.8 KB
|
|
|
1. CASE Returns a Value on a Specified Condition just like if and else..mp4
|
MP4
|
42.3 MB
|
|
|
1. CASE Returns a Value on a Specified Condition just like if and else..srt
|
SRT
|
5.1 KB
|
|
|
1. Comparison Operators to Compare a given Value.mp4
|
MP4
|
19 MB
|
|
|
1. Comparison Operators to Compare a given Value.srt
|
SRT
|
2.6 KB
|
|
|
1. Concatenate Two Different String Columns and Returns a Single Column.mp4
|
MP4
|
26.4 MB
|
|
|
1. Concatenate Two Different String Columns and Returns a Single Column.srt
|
SRT
|
2.6 KB
|
|
|
1. Convert a value of any type into a specified datatype.mp4
|
MP4
|
36 MB
|
|
|
1. Convert a value of any type into a specified datatype.srt
|
SRT
|
4.7 KB
|
|
|
1. Count Function Used to Tally Number of Non-Null Values of an Column..mp4
|
MP4
|
61.1 MB
|
|
|
1. Count Function Used to Tally Number of Non-Null Values of an Column..srt
|
SRT
|
8.1 KB
|
|
|
1. Creating Database in SQL SERVER.mp4
|
MP4
|
36.9 MB
|
|
|
1. Creating Database in SQL SERVER.srt
|
SRT
|
5.4 KB
|
|
|
1. Database SQL Introduction and Motivation.mp4
|
MP4
|
23.4 MB
|
|
|
1. Database SQL Introduction and Motivation.srt
|
SRT
|
4.2 KB
|
|
|
1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.mp4
|
MP4
|
75.2 MB
|
|
|
1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.srt
|
SRT
|
17.1 KB
|
|
|
1. Installing SQL SERVER with Management Studio (Free Version).mp4
|
MP4
|
23.1 MB
|
|
|
1. Installing SQL SERVER with Management Studio (Free Version).srt
|
SRT
|
4.4 KB
|
|
|
1. Introduction to JOINS and their Types.mp4
|
MP4
|
4.1 MB
|
|
|
1. Introduction to JOINS and their Types.srt
|
SRT
|
1.7 KB
|
|
|
1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.mp4
|
MP4
|
92.1 MB
|
|
|
1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.srt
|
SRT
|
10.3 KB
|
|
|
1. Manipulate Year part of the Date.mp4
|
MP4
|
17.9 MB
|
|
|
1. Manipulate Year part of the Date.srt
|
SRT
|
2.7 KB
|
|
|
1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.mp4
|
MP4
|
61.1 MB
|
|
|
1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.srt
|
SRT
|
7.4 KB
|
|
|
1. Perform Numeric Operation using SQL Built-in Functions.mp4
|
MP4
|
38.2 MB
|
|
|
1. Perform Numeric Operation using SQL Built-in Functions.srt
|
SRT
|
4.8 KB
|
|
|
1. SELECT Statement to Retrieve Data from Database Tables.mp4
|
MP4
|
20.5 MB
|
|
|
1. SELECT Statement to Retrieve Data from Database Tables.srt
|
SRT
|
4.2 KB
|
|
|
1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.mp4
|
MP4
|
52.9 MB
|
|
|
1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.srt
|
SRT
|
6 KB
|
|
|
1. WHERE Clause to Filter out ROWS of a Table.mp4
|
MP4
|
35 MB
|
|
|
1. WHERE Clause to Filter out ROWS of a Table.srt
|
SRT
|
3.9 KB
|
|
|
2. Calculate Minimum and Maximum Values of a Column..mp4
|
MP4
|
20.6 MB
|
|
|
2. Calculate Minimum and Maximum Values of a Column..srt
|
SRT
|
2.9 KB
|
|
|
2. Computed Column to Perform Arithmetic’s Operations on Columns.mp4
|
MP4
|
20.3 MB
|
|
|
2. Computed Column to Perform Arithmetic’s Operations on Columns.srt
|
SRT
|
2.2 KB
|
|
|
2. Concept of Relationships using Foreign Key.mp4
|
MP4
|
27.5 MB
|
|
|
2. Concept of Relationships using Foreign Key.srt
|
SRT
|
6.3 KB
|
|
|
2. Convert Strings to UPPER and LOWER CASE.mp4
|
MP4
|
19.7 MB
|
|
|
2. Convert Strings to UPPER and LOWER CASE.srt
|
SRT
|
2.1 KB
|
|
|
2. Creating Tables in SQL SERVER.mp4
|
MP4
|
51.4 MB
|
|
|
2. Creating Tables in SQL SERVER.srt
|
SRT
|
6.7 KB
|
|
|
2. HAVING to Filters Result based on the Output of the Grouped Items.mp4
|
MP4
|
21.2 MB
|
|
|
2. HAVING to Filters Result based on the Output of the Grouped Items.srt
|
SRT
|
4.1 KB
|
|
|
2. IN Special Operators used for Matching any Value within a Value List.mp4
|
MP4
|
26.1 MB
|
|
|
2. IN Special Operators used for Matching any Value within a Value List.srt
|
SRT
|
3.2 KB
|
|
|
2. Manipulate Month part of the Date.mp4
|
MP4
|
16.2 MB
|
|
|
2. Manipulate Month part of the Date.srt
|
SRT
|
2.1 KB
|
|
|
2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.mp4
|
MP4
|
20.1 MB
|
|
|
2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.srt
|
SRT
|
3.6 KB
|
|
|
2. Understanding SQL SERVER Structure.mp4
|
MP4
|
10.5 MB
|
|
|
2. Understanding SQL SERVER Structure.srt
|
SRT
|
2.6 KB
|
|
|
3. Calculate Sum, Average and Standard Deviation of a Column..mp4
|
MP4
|
40.2 MB
|
|
|
3. Calculate Sum, Average and Standard Deviation of a Column..srt
|
SRT
|
5.5 KB
|
|
|
3. Get a Substring or Part of a String.mp4
|
MP4
|
23.4 MB
|
|
|
3. Get a Substring or Part of a String.srt
|
SRT
|
2.8 KB
|
|
|
3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.mp4
|
MP4
|
31.9 MB
|
|
|
3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.srt
|
SRT
|
4.2 KB
|
|
|
3. Manipulate Day part of the Date.mp4
|
MP4
|
25.3 MB
|
|
|
3. Manipulate Day part of the Date.srt
|
SRT
|
3 KB
|
|
|
3. Tables for JOINS.mp4
|
MP4
|
32.6 MB
|
|
|
3. Tables for JOINS.srt
|
SRT
|
7.4 KB
|
|
|
4. Calculate Difference between Two Dates.mp4
|
MP4
|
30.6 MB
|
|
|
4. Calculate Difference between Two Dates.srt
|
SRT
|
4.7 KB
|
|
|
4. INNER JOIN.mp4
|
MP4
|
43.8 MB
|
|
|
4. INNER JOIN.srt
|
SRT
|
9.8 KB
|
|
|
4. LIKE Special Operators used for Matches a Given String Pattern.mp4
|
MP4
|
70.1 MB
|
|
|
4. LIKE Special Operators used for Matches a Given String Pattern.srt
|
SRT
|
8.3 KB
|
|
|
4. Retrieve the Length of Strings.mp4
|
MP4
|
14.6 MB
|
|
|
4. Retrieve the Length of Strings.srt
|
SRT
|
1.5 KB
|
|
|
5. Adds a TimeDate Interval to a Date.mp4
|
MP4
|
24.6 MB
|
|
|
5. Adds a TimeDate Interval to a Date.srt
|
SRT
|
4.2 KB
|
|
|
5. OUTER JOINS.mp4
|
MP4
|
43.3 MB
|
|
|
5. OUTER JOINS.srt
|
SRT
|
8.3 KB
|
|
|
5. Replace a NULL with a value.mp4
|
MP4
|
16.1 MB
|
|
|
5. Replace a NULL with a value.srt
|
SRT
|
2.1 KB
|
|
|
6. CROSS JOIN.mp4
|
MP4
|
12.2 MB
|
|
|
6. CROSS JOIN.srt
|
SRT
|
2.8 KB
|
|
|
6. Replace, Replicate, and Reverse Strings Built-in Functions.mp4
|
MP4
|
22.8 MB
|
|
|
6. Replace, Replicate, and Reverse Strings Built-in Functions.srt
|
SRT
|
3 KB
|
|
|
7. SELF JOIN.mp4
|
MP4
|
28.3 MB
|
|
|
7. SELF JOIN.srt
|
SRT
|
5.7 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
