1. Does SQL support programming language features?
It is true that SQL is a language, but it does not support programming as it is not a programming language, it is a command language. We do not have some programming concepts in SQL like for loops or while loop, we only have commands which we can use to query, update, delete, etc. data in the database. SQL allows us to manipulate data in a database.

2. What is a trigger?
Trigger is a statement that a system executes automatically when there is any modification to the database. In a trigger, we first specify when the trigger is to be executed and then the action to be performed when the trigger executes. Triggers are used to specify certain integrity constraints and referential constraints that cannot be specified using the constraint mechanism of SQL.

3. What are aggregate and scalar functions?
For doing operations on data SQL has many built-in functions, they are categorized into two categories and further sub-categorized into seven different functions under each category. The categories are:
Aggregate functions:
These functions are used to do operations from the values of the column and a single value is returned.
Scalar functions:
These functions are based on user input, these too return a single value.

4. Define SQL Order by the statement?
The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns.
By default ORDER BY sorts the data in ascending order.
We can use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order.

5. What is the difference between primary key and unique constraints? 
The primary key cannot have NULL values, the unique constraints can have NULL values. There is only one primary key in a table, but there can be multiple unique constraints. The primary key creates the clustered index automatically but the unique key does not.

SQL Quick Guide
For more join -> t.me/sqlspecialist

*📊 Master Microsoft Excel :*

The Excel Tree 👇
|
|── *Basics*
| ├── Workbook / Worksheet
| ├── Rows & Columns
| └── Cells & Ranges
|
|── *Data Entry & Formatting*
| ├── Text / Numbers / Dates
| ├── Cell Formatting (bold, color, borders)
| ├── Conditional Formatting
| └── Cell Styles & Themes
|
|── *Formulas & Functions*
| ├── =SUM(), =AVERAGE()
| ├── =IF(), =AND(), =OR()
| ├── =VLOOKUP() / =HLOOKUP() / =XLOOKUP()
| ├── =INDEX() / =MATCH()
| └── =COUNT(), =COUNTA(), =COUNTIF()
|
|── *Charts & Graphs*
| ├── Bar / Line / Pie / Column
| ├── Combo Charts
| └── Sparklines
|
|── *Data Tools*
| ├── Data Validation
| ├── Remove Duplicates
| ├── Text to Columns
| └── Flash Fill
|
|── *Sorting & Filtering*
| ├── AutoFilter
| ├── Custom Sort
| └── Advanced Filter
|
|── *Pivot Tables & Pivot Charts*
| ├── Summarize large data
| ├── Drag & drop interface
| └── Slicers for filtering
|
|── *Tables & Named Ranges*
| ├── Excel Tables (Insert > Table)
| └── Named Ranges for easy reference
|
|── *Date & Time Functions*
| ├── =TODAY(), =NOW()
| ├── =DATEDIF(), =EDATE()
| └── =TEXT() for formatting
|
|── *Text Functions*
| ├── =LEFT(), =RIGHT(), =MID()
| ├── =LEN(), =FIND(), =SEARCH()
| └── =CONCAT() / =TEXTJOIN()
|
|── *Logical & Lookup Functions*
| ├── =IFERROR()
| ├── =CHOOSE()
| └── =SWITCH()
|
|── *Keyboard Shortcuts*
| ├── Ctrl + Arrow → Jump
| ├── Ctrl + Shift + L → Filter
| └── F2 → Edit Cell
|
|── *Macros & Automation*
| ├── Record Macros
| └── VBA (Visual Basic for Applications)
|
|── *Data Analysis Tools*
| ├── Goal Seek
| ├── Solver
| └── What-If Analysis
|
|── *Best Practices*
| ├── Use tables for dynamic data
| ├── Use comments & named ranges
| └── Avoid merged cells in data tables
|
|── END __

💬 *Double Tap ❤️ if this helped you!*

SQL Detailed Roadmap
|
| | |-- Fundamentals
| |-- Introduction to Databases
| | |-- What SQL does
| | |-- Relational model
| | |-- Tables, rows, columns
| |-- Keys and Constraints
| | |-- Primary keys
| | |-- Foreign keys
| | |-- Unique and check constraints
| |-- Normalization
| | |-- 1NF, 2NF, 3NF
| | |-- ER diagrams

| | |-- Core SQL
| |-- SQL Basics
| | |-- SELECT, WHERE, ORDER BY
| | |-- GROUP BY and HAVING
| | |-- JOINS: INNER, LEFT, RIGHT, FULL
| |-- Intermediate SQL
| | |-- Subqueries
| | |-- CTEs
| | |-- CASE statements
| | |-- Aggregations
| |-- Advanced SQL
| | |-- Window functions
| | |-- Analytical functions
| | |-- Ranking, moving averages, lag and lead
| | |-- UNION, INTERSECT, EXCEPT

| | |-- Data Management
| |-- Data Types
| | |-- Numeric, text, date, JSON
| |-- Indexes
| | |-- B tree and hash indexes
| | |-- When to create indexes
| |-- Transactions
| | |-- ACID properties
| |-- Views
| | |-- Standard views
| | |-- Materialized views

| | |-- Database Design
| |-- Schema Design
| | |-- Star schema
| | |-- Snowflake schema
| |-- Fact and Dimension Tables
| |-- Constraints for clean data

| | |-- Performance Tuning
| |-- Query Optimization
| | |-- Execution plans
| | |-- Index usage
| | |-- Reducing scans
| |-- Partitioning
| | |-- Horizontal partitioning
| | |-- Sharding basics

| | |-- SQL for Analytics
| |-- KPI calculations
| |-- Cohort analysis
| |-- Funnel analysis
| |-- Churn and retention tables
| |-- Time based aggregations
| |-- Window functions for metrics

| | |-- SQL for Data Engineering
| |-- ETL Workflows
| | |-- Staging tables
| | |-- Transformations
| | |-- Incremental loads
| |-- Data Warehousing
| | |-- Snowflake
| | |-- Redshift
| | |-- BigQuery
| |-- dbt Basics
| | |-- Models
| | |-- Tests
| | |-- Lineage

| | |-- Tools and Platforms
| |-- PostgreSQL
| |-- MySQL
| |-- SQL Server
| |-- Oracle
| |-- SQLite
| |-- Cloud SQL
| |-- BigQuery UI
| |-- Snowflake Worksheets

| | |-- Projects
| |-- Build a sales reporting system
| |-- Create a star schema from raw CSV files
| |-- Design a customer segmentation query
| |-- Build a churn dashboard dataset
| |-- Optimize slow queries in a sample DB
| |-- Create an analytics pipeline with dbt

| | |-- Soft Skills and Career Prep
| |-- SQL interview patterns
| |-- Joins practice
| |-- Window function drills
| |-- Query writing speed
| |-- Git and GitHub
| |-- Data storytelling

| | |-- Bonus Topics
| |-- NoSQL intro
| |-- Working with JSON fields
| |-- Spatial SQL
| |-- Time series tables
| |-- CDC concepts
| |-- Real time analytics

| | |-- Community and Growth
| |-- LeetCode SQL
| |-- Kaggle datasets with SQL
| |-- GitHub projects
| |-- LinkedIn posts
| |-- Open source contributions

Free Resources to learn SQL

• W3Schools SQL
https://www.w3schools.com/sql/

• SQL Programming
https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

• SQL Notes
https://whatsapp.com/channel/0029Vb6hJmM9hXFCWNtQX944

• Mode Analytics SQL tutorials
https://mode.com/sql-tutorial/

• Data Analytics Resources
https://t.me/sqlspecialist

• HackerRank SQL practice
https://www.hackerrank.com/domains/sql

• LeetCode SQL problems
https://leetcode.com/problemset/database/

• Data Engineering Resources
https://whatsapp.com/channel/0029Vaovs0ZKbYMKXvKRYi3C

• Khan Academy SQL basics
https://www.khanacademy.org/computing/computer-programming/sql

• PostgreSQL official docs
https://www.postgresql.org/docs/

• MySQL official docs
https://dev.mysql.com/doc/

• NoSQL Resources
https://whatsapp.com/channel/0029VaxA2hTHgZWe5FpFjm3p

Double Tap ❤️ For More

🚀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 📊🔥

Build a career in Data Analytics with Google FREE courses to help you learn industry-relevant analytics skills from scratch.

🎯 What's Included?

✅ Google Analytics Certification
✅ Google Analytics for Beginners
✅ Google Analytics for Power Users
✅ Advanced Google Analytics
✅ Learn at Your Own Pace
✅ 100% FREE Access

𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/3Tox1dK

🚀 Upskill with Google and strengthen your resume with one of the world's most recognized learning platforms!