SQL BootCamp: Learn SQL DATABASE Queries with SQL SERVER

Course Curriculum

Chapter 1: Introduction and Motivation

Lecture 1: Database SQL Introduction and Motivation

Chapter 2: Installing SQL SERVER and its Structure Understanding

Lecture 1: Installing SQL SERVER with Management Studio (Free Version)

Lecture 2: Understanding SQL SERVER Structure

Chapter 3: Creating Database and Tables in SQL

Lecture 1: Creating Database in SQL SERVER

Lecture 2: CREATE, USE and DROP DATABASE (SQL CODE)

Lecture 3: Creating Tables in SQL SERVER

Lecture 4: EMPLOYEES TABLE (SQL CODE)

Chapter 4: Select Statement in SQL

Lecture 1: SELECT Statement to Retrieve Data from Database Tables

Lecture 2: SELECT DISTINCT Statement to Return only Unique ROWS in a Result-set

Chapter 5: Practice Session 1 ( SELECT, DISTINCT )

Lecture 1: Solution: Practice Query (SELECT Statement)

Lecture 2: Solution: Practice Query (SELECT DISTINCT)

Chapter 6: WHERE Clause in SQL

Lecture 1: WHERE Clause to Filter out ROWS of a Table

Chapter 7: ORDER BY Keyword in SQL

Lecture 1: ORDER BY Keyword to Sort the Result in Ascending or Descending Order

Chapter 8: Practice Session 2 ( WHERE, ORDER BY )

Lecture 1: Solution: Practice Query (WHERE and OEDER BY)

Chapter 9: TOP Clause in SQL

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

Chapter 10: Logical Operators (OR, AND, NOT) in SQL

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

Chapter 11: Practice Session 3 ( TOP, OR, AND, NOT )

Lecture 1: Solution: Practice Query (Top, NOT)

Lecture 2: Solution: Practice Query (OR, AND)

Chapter 12: Special Operators in SQL

Lecture 1: BETWEEN Special Operators to Check whether an Attribute Value is within a Range

Lecture 2: IN Special Operators used for Matching any Value within a Value List

Lecture 3: IS NULL Special Operators to Check whether an Attribute Value is Null or Not

Lecture 4: LIKE Special Operators used for Matches a Given String Pattern

Chapter 13: Practice Session 4 ( BETWEEN, IS NULL, IN, LIKE )

Lecture 1: Solution: Practice Query (BETWEEN)

Lecture 2: Solution: Practice Query (IN)

Lecture 3: Solution: Practice Query (IS NOT NULL)

Lecture 4: Solution: Practice Query (LIKE , % )

Lecture 5: Solution: Practice Query (LIKE , _ )

Chapter 14: Comparison Operators in SQL

Lecture 1: Comparison Operators to Compare a given Value

Chapter 15: ALIAS and Computed Column in SQL

Lecture 1: ALIAS to Give a Table or a Column in a Table, a Temporary Name

Lecture 2: Computed Column to Perform Arithmetic’s Operations on Columns

Chapter 16: Practice Session 5 ( Comparison Operators, ALIAS, Computed Column )

Lecture 1: Solution: Practice Query (Comparison Operator)

Lecture 2: Solution: Practice Query (ALIAS and Computed Column)

Chapter 17: CASE Statement in SQL

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

Chapter 18: SQL STRING Built-in Functions

Lecture 1: Concatenate Two Different String Columns and Returns a Single Column

Lecture 2: Convert Strings to UPPER and LOWER CASE

Lecture 3: Get a Substring or Part of a String

Lecture 4: Retrieve the Length of Strings

Lecture 5: Replace a NULL with a value

Lecture 6: Replace, Replicate, and Reverse Strings Built-in Functions

Chapter 19: Practice Session 6 ( STRING Functions )

Lecture 1: Solution: Practice Query (STRING Functions)

Chapter 20: SQL Datatypes Conversion Built-in Functions

Lecture 1: Convert a value of any type into a specified datatype

Chapter 21: SQL Date and Time Built-in Functions

Lecture 1: Manipulate Year part of the Date

Lecture 2: Manipulate Month part of the Date

Lecture 3: Manipulate Day part of the Date

Lecture 4: Calculate Difference between Two Dates

Lecture 5: Adds a Time/Date Interval to a Date

Chapter 22: Practice Session 7 ( DATA and TIME Functions )

Lecture 1: Solution: Practice Query ( DAY, MONTH, YEAR)

Chapter 23: SQL Math/Numeric Built-in Functions

Lecture 1: Perform Numeric Operation using SQL Built-in Functions

Chapter 24: Aggregate Functions in SQL

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

Lecture 2: Calculate Minimum and Maximum Values of a Column.

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

Chapter 25: Practice Session 8 ( COUNT, MAX, MIN, SUM, AVG, STEDEV )

Lecture 1: Solution: Practice Query (COUNT, MAX, MIN)

Lecture 2: Solution: Practice Query (SUM, AVG, STDEV)

Chapter 26: GROUP BY and HAVING CLAUSE

Lecture 1: GROUP BY to Summarize Result across Small Grouped Items in the Database Table

Lecture 2: HAVING to Filters Result based on the Output of the Grouped Items

Chapter 27: Practice Session 9 ( GROUP BY, HAVING )

Lecture 1: Solution: Practice Query (GROUP BY)