Skip to Content
Lessons
Share Exit Fullscreen Back to course
Developing Queries with SQL
    • Introduction and Module Overview
    • History and Definition of SQL and T-SQL
    • What is Relational Database and Types of Relational Database
    • Database table Structure
    • Schema and Object name
    • Understanding Database Dictionary
    • SQL Statement types
    • Module Summary
    • Quiz
      • Quiz
    • Introduction to SELECT Statement
    • Explaining how to write SELECT Statement
    • ORDER BY
    • Limiting the Appearance of Records (TOP N)
    • Removing Duplicate - Distinct
    • Inbuilt Function
    • Inbuilt Functions- Date and Time
    • Inbuilt Functions-String Function
    • Inbuilt Functions- Aggregate Function
    • Inbuilt Function- Mathematical Functions
    • Module Summary
    • Practice Exercise
    • Quiz
      • Quiz
    • Introduction and Module Overview
    • Understanding the Where Clause
    • Filtering Using WHERE Clause - Comparison Operator
    • WHERE Conjugative Operators - AND, OR NOT CLAUSE
    • WHERE Using Logical Functions - IN and Between
    • WHERE Using Logical Functions - Like and WildCard
    • Handling Null Values
    • Module Summary
    • Practice Exercise
    • Quiz
      • Quiz
    • Introduction and Module Overview
    • Understanding Group By and Having
    • Calculating Using Aggregate Functions
    • Group By
    • Having Clause
    • Module Summary
    • Practice Exercise
    • Quiz
      • Quiz