Developing Queries with SQL

Responsible	ScholarsDNA Admin
Last Update	12/07/2025
Completion Time	5 hours 39 minutes
Members	60

Course
Reviews (2)

Module 0

3Lessons · 15 min
- Introduction
  
  Preview
- Installation Guide
  
  Preview
- Course Materials
  
  Preview
Module 1

9Lessons · 29 min
- Introduction and Module Overview
  
  Preview
- History and Definition of SQL and T-SQL
  
  Preview
- What is Relational Database and Types of Relational Database
  
  Preview
- Database table Structure
  
  Preview
- Schema and Object name
  
  Preview
- Understanding Database Dictionary
  
  Preview
- SQL Statement types
  
  Preview
- Module Summary
  
  Preview
- Quiz
  
  Preview 10 xp
Module 2

3Lessons · 1 hr 5 min
- Reading Course
  
  Preview
- Practice Exercise
  
  Preview
- Quiz
  
  Preview 10 xp
Module 3

13Lessons · 1 hr 58 min
- Introduction to SELECT Statement
  
  Preview
- Explaining how to write SELECT Statement
  
  Preview
- ORDER BY
  
  Preview
- Limiting the Appearance of Records (TOP N)
  
  Preview
- Removing Duplicate - Distinct
  
  Preview
- Inbuilt Function
  
  Preview
- Inbuilt Functions- Date and Time
  
  Preview
- Inbuilt Functions-String Function
  
  Preview
- Inbuilt Functions- Aggregate Function
  
  Preview
- Inbuilt Function- Mathematical Functions
  
  Preview
- Module Summary
  
  Preview
- Practice Exercise
  
  Preview
- Quiz
  
  Preview 10 xp
Module 4

10Lessons · 1 hr 18 min
- Introduction and Module Overview
  
  Preview
- Understanding the Where Clause
  
  Preview
- Filtering Using WHERE Clause - Comparison Operator
  
  Preview
- WHERE Conjugative Operators - AND, OR NOT CLAUSE
  
  Preview
- WHERE Using Logical Functions - IN and Between
  
  Preview
- WHERE Using Logical Functions - Like and WildCard
  
  Preview
- Handling Null Values
  
  Preview
- 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