Find top SQL resources from global universities, cool projects, and learning materials for data analytics.
Admin: @coderfun
Useful links: heylink.me/DataAnalytics
Promotions: @love_data
Created
Between 1 October 2022 and 30 September 2023 — estimated from Telegram’s id allocation, not measured. How this range is calculated.
Education — a classification, not a measurement. An on-box language model (Qwen3.6-35B-A3B-UD-Q6_K_XL, prompt version 1) read this channel’s own recent posts on 20 August 2026 and assigned it the closest of 31 fixed categories, at 99% confidence. This is a model’s judgement about what the channel is likely to be about, not a fact this register measured the way a subscriber count or a view count is measured — it can be revised on a later pass, and it carries no weight anywhere else on this page. How this classification works, and why it has no browse page of its own yet.
Growth
36 measurements spanning 59 days, net +170. Dots are measurements; the straight line between them is drawn to join them, not to claim we know the path taken in between — snapshots are recorded only when a count changes, so gaps mean “no change observed”, never “interpolated”. The vertical axis spans 76,531–76,752 and does not start at zero.
Measurement log — every subscribers count we have recorded, most recent 20 of 36
Measured (UTC)
Subscribers
Change
5 Oct 2026, 00:42
76,726
+38
28 Sept 2026, 00:37
76,688
+13
17 Sept 2026, 16:40
76,675
+31
15 Sept 2026, 16:19
76,644
-4
14 Sept 2026, 03:37
76,648
+13
12 Sept 2026, 10:01
76,635
-1
10 Sept 2026, 05:59
76,636
-7
7 Sept 2026, 00:40
76,643
-17
4 Sept 2026, 10:19
76,660
+15
3 Sept 2026, 01:07
76,645
-9
1 Sept 2026, 22:18
76,654
-6
1 Sept 2026, 00:48
76,660
+13
30 Aug 2026, 20:55
76,647
+13
29 Aug 2026, 19:34
76,634
+34
28 Aug 2026, 17:53
76,600
-4
27 Aug 2026, 17:33
76,604
-5
26 Aug 2026, 14:35
76,609
+5
25 Aug 2026, 16:44
76,604
-11
24 Aug 2026, 18:39
76,615
-29
23 Aug 2026, 03:38
76,644
first reading
Engagement
193 posts held, back to 26 July 2026 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 125 pages of Telegram’s post history, 20 posts per page.
ERR · 30 days
1.37%
avg views ÷ 76,726 subscribers
Avg views / post
1,050
79 posts measured
Reaction rate
0.336%
reactions ÷ views · ER floor
Posts in window
79
of 193 held
ERR is average views per post over the last 30 days divided by subscribers, the definition TGStat uses, so this figure is comparable with the one you will see elsewhere. It falls structurally as a channel grows: a high ERR on a small channel and a low one on a large channel describe reach mathematics, not quality. We publish the figure and the sample it came from and pass no verdict on it.
ER is defined industry-wide as (forwards + reactions + comments) ÷ views — note the denominator is views, not subscribers. Telegram’s public web preview carries views and reactions but not forward or comment counts, so the reaction rate above is the reactions term only and is therefore a floor: the true ER for this channel is higher by an amount we have not measured and will not estimate. It is computed over the 52 of 79 measured posts that carry a reaction reading, and over those same posts' views.
What these figures were computed from
Window
Rolling 30 days · latest post in window 29 September 2026
Posts held
193 (26 July 2026 – 29 September 2026)
Views total
82,820
Reactions total
196
Forwards / comments
not exposed by the public surface — not measured, not estimated
Readings taken
6 Oct 2026, 15:10 UTC
Views are a single reading per post, taken at the time above. A post published in the last day or two is still accumulating views, which pulls the 30-day average down slightly. That is a property of the standard definition rather than a fault in it, so we keep the definition rather than “correcting” the number into something nobody can reproduce.
Precision. Telegram publishes view counts on its public widget in short form — 8.12K, 3.7M — so any reading at or above 1,000 reaches us rounded to three significant figures, and only counts below 1,000 are exact. Averages and rates derived from them are shown to the same precision rather than to the unit: a figure like 3,701,250 would assert digits nobody measured.
Reaction counts are published per emoji and rounded the same way, so a total below 1,000 is exact and a larger one is a sum that may carry a rounded component from each emoji above 1,000. Because it is a sum, it does not look rounded — read a large reaction total as three significant figures per contributing emoji rather than as the figure it prints.
What this channel posts
Photos
599
Videos
1
Links
569
Lifetime counters from Telegram’s own channel header, read 6 October 2026 — not the date at the top of this page, which is when the subscriber count was last read. Below Telegram’s rounding threshold, so these counts are exact.
Video runtime
30s
Average length
30s
Measured directly from 1 video with a duration reading, out of the posts we hold for this channel — not this channel’s whole posting history, only the sample this register has actually read. An exact reading to the second, taken from the post itself rather than from Telegram’s own rounded chrome, so it carries no ≈ mark.
Reaction mix
524 reactions across 130 posts, in 7 distinct kinds. The most used accounts for 96.6% of them.
Every reaction kind recorded on the sample, most used first
Reaction
Count
Share
Share, drawn
❤
506
96.6%
👍
9
1.72%
👏
5
0.954%
🎉
1
0.191%
😍
1
0.191%
🤔
1
0.191%
🤣
1
0.191%
No sentiment is inferred, and none should be read in. This table is ordered by count and by nothing else. Emoji do not carry stable meaning across languages or communities — 🙏 is thanks in one channel and mourning in another — so we publish which ones were pressed and how often, and pass no judgement on what an audience meant by them.
Precision. Telegram publishes reaction counts per emoji and short-forms each one — 4.34K, 1.2M — so any single kind at or above 1,000 reaches us at three significant figures, and only counts below 1,000 are exact. The shares above are ratios of those figures and carry the same error. This is also why the total here can differ slightly from a reaction total printed elsewhere on the page: both are sums of the same rounded parts, taken over samples with different edges.
Coverage. Reactions were read on 135 of the 193 sampled posts in this sample. Summed by Telegram’s own count on each post — not by adding up the per-emoji breakdown above — those same posts carry 524 reactions in total: the kind of figure the paragraph above means by “a reaction total printed elsewhere on the page”.
Measured over the 193 most recent posts we hold, published 26 July 2026 to 29 September 2026, using the newest reading held for each. Telegram Stars are excluded: they are a payment, not a reaction, and they have their own section.
SQL Interview Series — Part 2
📌 Question 2: Find Duplicate Records
Suppose you have an Employee table:
Employee
• employee_id
• employee_name
• department
• email
❓ Find all email addresses that appear more than once in the Employee table.
Example:
employee_id | employee_name | email
------------|---------------|-------------------
1 | Amit | [email protected]
2 | Rahul | ra…
𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗟𝗲𝗮𝗿𝗻 𝗔𝗜 𝗶𝗻 𝟮𝟬𝟮𝟲🚀
Explore 6 free resources covering AI fundamentals, tools, deep learning, research and real-world applications.
✅ 100% Free Learning
✅ Beginner-Friendly
✅ AI • ML • Deep Learning
✅ Real-World Applications
🔗 𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 👇
https://pdlink.in/4AFHq5R
📢 Share this valuable opportunity with your friends and classmates!
SQL Interview Series — Part 1
Hi guys, let's start a SQL interview series covering frequently asked and important SQL interview questions.
Each part will cover 1 practical interview question with:
✅ Problem statement
✅ SQL solution
✅ Approach
✅ Interview tip
📌 Question 1: Find the Second Highest Salary
Suppose you have an Employee table:
Employee
• employee_id
• employee_name
• salary
Example data:
empl…
🧠 Real-World SQL Scenario-Based Questions & Answers
1. Get the 2nd highest salary from the Employees table
SELECT MAX(salary) AS SecondHighest
FROM Employees
WHERE salary < (SELECT MAX(salary) FROM Employees);
2. Find employees without assigned managers
SELECT * FROM Employees
WHERE manager_id IS NULL;
3. Retrieve departments with more than 5 employees
SELECT department_id, COUNT(*) AS employee_count
FROM Employee…
🎓 𝗛𝗔𝗥𝗩𝗔𝗥𝗗 𝗨𝗡𝗜𝗩𝗘𝗥𝗦𝗜𝗧𝗬 𝗙𝗥𝗘𝗘 𝗢𝗡𝗟𝗜𝗡𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦 😍
Dreaming of learning from one of the world’s most prestigious universities? Explore Harvard’s online courses and build valuable, career-ready skills from home!
💡 Beginner-friendly options
⏰ Learn at your own pace
🌍 Accessible online worldwide
🎯 Ideal for students, freshers and working professionals
🔗 𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 👇
https://pdlink.in/4xPUdzU
📢 Share this valuable
𝗟𝗲𝘃𝗲𝗹 𝗨𝗽 𝗬𝗼𝘂𝗿 𝗦𝗸𝗶𝗹𝗹𝘀 𝘄𝗶𝘁𝗵 𝗧𝗵𝗲𝘀𝗲 𝗚𝗮𝗺𝗲-𝗖𝗵𝗮𝗻𝗴𝗶𝗻𝗴 𝗖𝗼𝘂𝗿𝘀𝗲𝘀!
Looking to learn practical, in-demand skills? These courses cover Generative AI, Cybersecurity, AI tools and Digital Marketing.
💫 Learn at your own pace
⚡Build career-relevant skills
🔥Practical learning opportunities
𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝘁𝗵𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 :-
https://pdlink.in/4z3vOYU
Save this post and share with your friends
Answer: Both uncommitted updates are rolled back, assuming the statements executed within the same transaction and the database/session supports the shown transaction behavior.
🔥 Mini Challenge
Imagine an order-processing system. You need to:
1. Create an order.
2. Add an order item.
3. Reduce inventory.
4. Commit everything if successful.
5. Roll back if a critical operation fails.
Write a transaction struct…
The exact workflow should follow your organization's production-change and approval procedures.
29️⃣ COMMIT vs SAVEPOINT vs ROLLBACK
Remember:
• COMMIT → Save the transaction
• ROLLBACK → Undo uncommitted transaction changes
• SAVEPOINT → Mark a point inside a transaction
• ROLLBACK TO SAVEPOINT → Undo changes after that point
Example:
BEGIN;
UPDATE customers
SET status = 'Active'
WHERE customer_id = 101;
S…
ROLLBACK;
If everything is correct:
COMMIT;
This can be useful when performing potentially dangerous data modifications.
1️⃣8️⃣ A Safe Pattern for Data Changes
Before executing a large UPDATE or DELETE, analysts often first run a SELECT using the same condition.
Instead of immediately doing:
UPDATE customers
SET status = 'Inactive'
WHERE last_order_date < DATE '2024-01-01';
first check:
SELECT *
FROM custome…
will behave identically across every database.
Always check the behavior of your specific database.
21️⃣ Transaction Isolation Levels
Isolation is one of the deeper transaction concepts.
Common isolation levels include:
• READ UNCOMMITTED
• READ COMMITTED
• REPEATABLE READ
• SERIALIZABLE
Some databases also support additional modes or implement these differently.
The general idea is:
• More isolation ↓ Str…
The transaction can continue from there.
Conceptually:
Transaction starts ↓ Update 101 ↓ SAVEPOINT ↓ Update 102 ↓ ROLLBACK TO SAVEPOINT ↓ Update 101 remains, Update 102 is undone
Exact savepoint syntax varies by database.
8️⃣ Why Are Transactions Important?
Imagine an order-processing system.
Creating an order might require:
1. Create order
2. Create order items
3. Reduce inventory
4. Record payment
5. Upd…
❤2
Showing the 12 most recent of 193 posts we hold for @sqlanalyst. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked ≈ was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.
Polls
The 4 polls we hold for this entry, as Telegram rendered them when we read the post. A poll’s figures keep moving after that, so each one is dated.
Which JOIN returns only matching records from both tables?
A) LEFT JOIN5%
B) RIGHT JOIN2%
C) INNER JOIN81%
D) FULL OUTER JOIN11%
Shares as published, totalling 99%. No per-option vote count is published by Telegram, so none is shown.
Percentages only — there are no per-option vote counts here, because Telegram publishes none. The public post preview gives each option’s share and a single voter total, and nothing else. Multiplying one by the other would produce a per-option tally that looks measured and is not: the shares are rounded to whole numbers before we ever see them. We print what was published and leave the column that does not exist empty.
The shares need not add up to 100. Rounding alone puts many polls at 99 or 101. A poll that allows more than one answer per voter runs well past 100 by design, and several here do. The bars are drawn against a fixed 100% track at each option’s own percentage rather than normalised to the total, so a poll that exceeds it shows that it does instead of being quietly rescaled.
Read from the 193 most recent posts we hold, published 26 July 2026 to 29 September 2026. Telegram labels each poll by kind — an anonymous poll, a quiz, a closed set of final results — and that label is reproduced rather than paraphrased.
Mentions
Named by 12 registered channels — every channel on the register whose own posts have named this one, by its current username or any other username it currently holds, merged from two separately captured readings of the same fact so a namer caught by only one of them is not missed and a namer both caught is not counted twice. A username this channel has since dropped is not matched — that handle may belong to someone else now, and crediting today’s namer to yesterday’s owner would misattribute it.
Named by
Channels on the register whose posts name this channel's handle.
A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.
Channels Telegram recommends alongside this one
Telegram’s own answer, not this register’s. When this register asks Telegram’s API what is similar to this channel, this is the list it returns, in the exact order Telegram returns it — never re-sorted by subscribers or by anything else this register measures. The relationship, and the order, are Telegram’s; we record them and date them, and make no claim of our own about which of these channels actually resemble this one.
AI Post — Artificial Intelligence @aipost · 692,514#85
Read from Telegram’s recommendation API, most recently 19 August 2026. Telegram holds a list like this for a small and growing share of the register — how this is measured, and why most channel pages show nothing here.
Appears in Telegram’s recommendations for other channels
The reverse of the list above, and a different kind of signal. This does not require this channel to have ever been asked about directly — each row below is a channel we DID ask Telegram about, whose Telegram-generated list happened to include this one. A channel can appear here with an empty list above it, because being named by someone else’s query is independent of having been queried itself.
Python for Data Analysts @pythonanalyst · 51,785 Telegram ranks this channel #1 of 82 here — alongside 81 others — read 24 August 2026
Data Analysis Books | Python | SQL | Excel | Artificial Intelligence | Power BI | Tableau | AI Resources @learndataanalysis · 53,280 Telegram ranks this channel #1 of 83 here — alongside 82 others — read 24 August 2026
MS Excel for Data Analysis @excel_analyst · 73,068 Telegram ranks this channel #1 of 84 here — alongside 83 others — read 20 August 2026
Data Analytics @sqlspecialist · 110,946 Telegram ranks this channel #1 of 83 here — alongside 82 others — read 14 August 2026
Data Analyst Interview Resources @dataanalystinterview · 52,555 Telegram ranks this channel #2 of 85 here — alongside 84 others — read 24 August 2026
Data Analyst Jobs @jobs_SQL · 91,352 Telegram ranks this channel #2 of 86 here — alongside 85 others — read 17 August 2026
Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources @sqlproject · 39,673 Telegram ranks this channel #3 of 84 here — alongside 83 others — read 30 August 2026
Computer Science Interview Books @InterviewBooks · 40,500 Telegram ranks this channel #3 of 78 here — alongside 77 others — read 30 August 2026
Python Programming Books @dsabooks · 59,152 Telegram ranks this channel #3 of 89 here — alongside 88 others — read 22 August 2026
Data Science Portfolio - Kaggle Datasets & AI Projects | Artificial Intelligence @DataPortfolio · 38,029 Telegram ranks this channel #4 of 83 here — alongside 82 others — read 31 August 2026
Python Projects & Resources @pythondevelopersindia · 63,484 Telegram ranks this channel #4 of 86 here — alongside 85 others — read 21 August 2026
Artificial Intelligence @machinelearning_deeplearning · 56,257 Telegram ranks this channel #5 of 86 here — alongside 85 others — read 23 August 2026
Coding & AI Resources @leadcoding · 35,403 Telegram ranks this channel #6 of 79 here — alongside 78 others — read 2 September 2026
Data Science @sql_databases · 70,807 Telegram ranks this channel #7 of 73 here — alongside 72 others — read 20 August 2026
Free Courses with Certificate - Python Programming, Data Science, Java Coding, SQL, Web Development, AI, ML, ChatGPT Expert @free4unow_backup · 74,642 Telegram ranks this channel #8 of 78 here — alongside 77 others — read 30 September 2026
Programming Resources | Python | Javascript | Artificial Intelligence Updates | Computer Science Courses | AI Books @programming_guide · 56,004 Telegram ranks this channel #8 of 84 here — alongside 83 others — read 23 August 2026
Coding Projects @Programming_experts · 67,911 Telegram ranks this channel #9 of 84 here — alongside 83 others — read 20 August 2026
Finance | Trading Tips | Stock Marketing | Business News @Finance_Stock_Trading · 23,184 Telegram ranks this channel #10 of 80 here — alongside 79 others — read 19 September 2026
Data Engineers❤️ @shubham_wadekar_jobs · 24,741 Telegram ranks this channel #10 of 93 here — alongside 92 others — read 15 September 2026
Coding Interview Resources @crackingthecodinginterview · 52,215 Telegram ranks this channel #10 of 83 here — alongside 82 others — read 24 August 2026
Data Analytics & AI | SQL Interviews | Power BI Resources @Data_Visual · 27,522 Telegram ranks this channel #12 of 83 here — alongside 82 others — read 10 September 2026
Thedataschoool @thedataschoool · 42,432 Telegram ranks this channel #13 of 85 here — alongside 84 others — read 29 August 2026
Machine Learning @MachineLearning9 · 41,624 Telegram ranks this channel #16 of 79 here — alongside 78 others — read 30 August 2026
ChatGPT & Free AI Resources @learngpt · 38,441 Telegram ranks this channel #17 of 79 here — alongside 78 others — read 31 August 2026
This channel appears in 141 seed channels' Telegram-generated recommendation lists in total, of which the 24 where it ranks highest are shown above. Each is Telegram’s list for THAT channel, not this one — see how this is measured.
Cite this entry
A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 5 October 2026 — this
entry's latest reading, not the date you are reading this.
“SQL Programming Resources” (@sqlanalyst), 76,726 subscribers as measured 5 October 2026. Telegram Register, tgregister.com/channel/sqlanalyst.
Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.