~Get Your Files Here !

  1. Introduction and Motivation

   1. Database SQL Introduction and Motivation.srt

  10. Logical Operators (OR, AND, NOT) in SQL

   1. Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition.srt

  12. Special Operators in SQL

   1. BETWEEN Special Operators to Check whether an Attribute Value is within a Range.srt

   2. IN Special Operators used for Matching any Value within a Value List.srt

   3. IS NULL Special Operators to Check whether an Attribute Value is Null or Not.srt

   4. LIKE Special Operators used for Matches a Given String Pattern.srt

  14. Comparison Operators in SQL

   1. Comparison Operators to Compare a given Value.srt

  15. ALIAS and Computed Column in SQL

   1. ALIAS to Give a Table or a Column in a Table, a Temporary Name.srt

   2. Computed Column to Perform Arithmetic’s Operations on Columns.srt

  17. CASE Statement in SQL

   1. CASE Returns a Value on a Specified Condition just like if and else..srt

  18. SQL STRING Built-in Functions

   1. Concatenate Two Different String Columns and Returns a Single Column.srt

   2. Convert Strings to UPPER and LOWER CASE.srt

   3. Get a Substring or Part of a String.srt

   4. Retrieve the Length of Strings.srt

   5. Replace a NULL with a value.srt

   6. Replace, Replicate, and Reverse Strings Built-in Functions.srt

  2. Installing SQL SERVER and its Structure Understanding

   1. Installing SQL SERVER with Management Studio (Free Version).srt

   2. Understanding SQL SERVER Structure.srt

  20. SQL Datatypes Conversion Built-in Functions

   1. Convert a value of any type into a specified datatype.srt

  21. SQL Date and Time Built-in Functions

   1. Manipulate Year part of the Date.srt

   2. Manipulate Month part of the Date.srt

   3. Manipulate Day part of the Date.srt

   4. Calculate Difference between Two Dates.srt

   5. Adds a TimeDate Interval to a Date.srt

  23. SQL MathNumeric Built-in Functions

   1. Perform Numeric Operation using SQL Built-in Functions.srt

  24. Aggregate Functions in SQL

   1. Count Function Used to Tally Number of Non-Null Values of an Column..srt

   2. Calculate Minimum and Maximum Values of a Column..srt

   3. Calculate Sum, Average and Standard Deviation of a Column..srt

  26. GROUP BY and HAVING CLAUSE

   1. GROUP BY to Summarize Result across Small Grouped Items in the Database Table.srt

   2. HAVING to Filters Result based on the Output of the Grouped Items.srt

  28. JOINS in SQL - Write Advance & Complex Queries

   1. Introduction to JOINS and their Types.srt

   2. Concept of Relationships using Foreign Key.srt

   3. Tables for JOINS.srt

   4. INNER JOIN.srt

   5. OUTER JOINS.srt

   6. CROSS JOIN.srt

   7. SELF JOIN.srt

  3. Creating Database and Tables in SQL

   1. Creating Database in SQL SERVER.srt

   2. Creating Tables in SQL SERVER.srt

  4. Select Statement in SQL

   1. SELECT Statement to Retrieve Data from Database Tables.srt

   2. SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set.srt

  6. WHERE Clause in SQL

   1. WHERE Clause to Filter out ROWS of a Table.srt

  7. ORDER BY Keyword in SQL

   1. ORDER BY Keyword to Sort the Result in Ascending or Descending Order.srt

  9. TOP Clause in SQL

   1. TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result.srt

  Bonus Resources.txt