Skip to Content
Home └Developing Queries with SQL
Developing Queries with SQL

Developing Queries with SQL

Join this Course
Responsible ScholarsDNA Admin
Last Update 07/09/2025
Completion Time 5 hours 39 minutes
Members 9
  • Module 0
    3Lessons · 15 min
  • Module 1
    9Lessons · 29 min
    • 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
      10 xp
  • Module 2
    3Lessons · 1 hr 5 min
  • Module 3
    13Lessons · 1 hr 58 min
    • 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
      Preview
    • Quiz
      10 xp
  • Module 4
    10Lessons · 1 hr 18 min
    • 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
      Preview
    • Quiz
      10 xp
  • Module 5
    8Lessons · 34 min
    • Introduction and Module Overview
    • Understanding Group By and Having
    • Calculating Using Aggregate Functions
    • Group By
    • Having Clause
    • Module Summary
    • Practice Exercise
      Preview
    • Quiz
      10 xp