A collection of SQL Server scripts inspired by C programs and common interview questions.
Designed for beginners, SQL Developers, and Junior DBAs preparing for interviews.
- Addition, Subtraction, Multiplication, Division
- Factorial Number
- Palindrome (String/Number)
- Power Calculation (
x^y) - Armstrong Number
- Perfect Number
- Vowels and Consonants Count
- Prime Number
- Fibonacci Series
- Reverse a Number
- Sum of Digits
- Count Digits
- Even/Odd Number
- Swap Two Numbers (with/without third variable)
- Strong Number
- Right Half Pyramid Pattern
- Left Half Pyramid Pattern
- Full Pyramid Pattern
- Rhombus Pattern
- Diamond Pattern
- Hourglass Pattern
- Hollow Square Pattern
- Hollow Full Pyramid Pattern
- Hollow Diamond Pattern
- Hollow Hourglass Pattern
- Floyd's Triangle
- Pascal's Triangle
- Clone the repository:
git clone https://github.com/ChiFrontEnd/Beginner-Friendly-SQL-Server.git
Pull requests are welcome! If you’d like to add more beginner-friendly SQL programs or DBA notes, please contribute.
Author Name: Trupti Y. Sabale
Created: 28-Jun-2026
Updated: 28-Jun-2026