Introduction and Motivation
  • Database SQL Introduction and Motivation
Installing SQL SERVER and its Structure Understanding
  • Installing SQL SERVER with Management Studio (Free Version)
  • Understanding SQL SERVER Structure
Creating Database and Tables in SQL
  • Creating Database in SQL SERVER
  • CREATE, USE and DROP DATABASE (SQL CODE)
  • Creating Tables in SQL SERVER
  • EMPLOYEES TABLE (SQL CODE)
Select Statement in SQL
  • SELECT Statement to Retrieve Data from Database Tables
  • SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set
Practice Session 1 ( SELECT, DISTINCT )
  • Practice Query (SELECT Statement)
  • Solution: Practice Query (SELECT Statement)
  • Practice Query (SELECT DISTINCT)
  • Solution: Practice Query (SELECT DISTINCT)
WHERE Clause in SQL
  • WHERE Clause to Filter out ROWS of a Table
ORDER BY Keyword in SQL
  • ORDER BY Keyword to Sort the Result in Ascending or Descending Order
Practice Session 2 ( WHERE, ORDER BY )
  • Practice Query (WHERE and OEDER BY)
  • Solution: Practice Query (WHERE and OEDER BY)
TOP Clause in SQL
  • TOP Clause to Select Number or Percentage of ROWS that are in the Top of Result
Logical Operators (OR, AND, NOT) in SQL
  • Logical Operators (OR, AND, NOT) to Filter ROWS based on more than One Condition
Practice Session 3 ( TOP, OR, AND, NOT )
  • Practice Query (Top, NOT)
  • Solution: Practice Query (Top, NOT)
  • Practice Query (OR, AND)
  • Solution: Practice Query (OR, AND)
Special Operators in SQL
  • BETWEEN Special Operators to Check whether an Attribute Value is within a Range
  • IN Special Operators used for Matching any Value within a Value List
  • IS NULL Special Operators to Check whether an Attribute Value is Null or Not
  • LIKE Special Operators used for Matches a Given String Pattern
Practice Session 4 ( BETWEEN, IS NULL, IN, LIKE )
  • Practice Query (BETWEEN)
  • Solution: Practice Query (BETWEEN)
  • Practice Query (IN)
  • Solution: Practice Query (IN)
  • Practice Query (IS NOT NULL)
  • Solution: Practice Query (IS NOT NULL)
  • Practice Query (LIKE , % )
  • Solution: Practice Query (LIKE , % )
  • Practice Query (LIKE , _ )
  • Solution: Practice Query (LIKE , _ )
Comparison Operators in SQL
  • Comparison Operators to Compare a given Value
ALIAS and Computed Column in SQL
  • ALIAS to Give a Table or a Column in a Table, a Temporary Name
  • Computed Column to Perform Arithmetic’s Operations on Columns
Practice Session 5 ( Comparison Operators, ALIAS, Computed Column )
  • Practice Query (Comparison Operator)
  • Solution: Practice Query (Comparison Operator)
  • Practice Query (ALIAS and Computed Column)
  • Solution: Practice Query (ALIAS and Computed Column)
CASE Statement in SQL
  • CASE Returns a Value on a Specified Condition just like if and else.
SQL STRING Built-in Functions
  • Concatenate Two Different String Columns and Returns a Single Column
  • Convert Strings to UPPER and LOWER CASE
  • Get a Substring or Part of a String
  • Retrieve the Length of Strings
  • Replace a NULL with a value
  • Replace, Replicate, and Reverse Strings Built-in Functions
Practice Session 6 ( STRING Functions )
  • Practice Query (STRING Functions)
  • Solution: Practice Query (STRING Functions)
SQL Datatypes Conversion Built-in Functions
  • Convert a value of any type into a specified datatype
SQL Date and Time Built-in Functions
  • Manipulate Year part of the Date
  • Manipulate Month part of the Date
  • Manipulate Day part of the Date
  • Calculate Difference between Two Dates
  • Adds a Time/Date Interval to a Date
Practice Session 7 ( DATA and TIME Functions )
  • Practice Query ( DAY, MONTH, YEAR)
  • Solution: Practice Query ( DAY, MONTH, YEAR)
SQL Math/Numeric Built-in Functions
  • Perform Numeric Operation using SQL Built-in Functions
Aggregate Functions in SQL
  • Count Function Used to Tally Number of Non-Null Values of an Column.
  • Calculate Minimum and Maximum Values of a Column.
  • Calculate Sum, Average and Standard Deviation of a Column.
Practice Session 8 ( COUNT, MAX, MIN, SUM, AVG, STEDEV )
  • Practice Query (COUNT, MAX, MIN)
  • Solution: Practice Query (COUNT, MAX, MIN)
  • Practice Query (SUM, AVG, STDEV)
  • Solution: Practice Query (SUM, AVG, STDEV)
GROUP BY and HAVING CLAUSE
  • GROUP BY to Summarize Result across Small Grouped Items in the Database Table
  • HAVING to Filters Result based on the Output of the Grouped Items
Practice Session 9 ( GROUP BY, HAVING )
  • Practice Query (GROUP BY)
  • Solution: Practice Query (GROUP BY)