Udemy - Database SQL Queries Hands-on Training With Ms SQL Server

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

No comments yet.