Data Science & Machine Learning
- №20 в категории «Технологии»
- №277 среди международных каналов
- №405 среди каналов на языке «английский»
- №1 426 в мире
Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free For collaborations: @love_data
- 24 часа
- −15
- 7 дней
- –
- 30 дней
- –
- Реакции
- 2
- Репосты
- 3
- Комментарии
- 0
Динамика подписчиков
Подписчиков у канала «Data Science & Machine Learning»: 77 616. Средний охват поста за сутки около 561, вовлечённость 0,7 %.
По дням, последние 30 дней
| Дата | Подписчики | Изменение | Посты | Ср. просмотры поста |
|---|---|---|---|---|
| 15 ноя | 77 616 | −16 | 2 | 425 |
| 14 ноя | 77 632 | – | 2 | 776 |
Просмотры по возрасту поста
Средние просмотры в каждом возрасте, посты за последние 30 дней.
- 3 ч
- 212
- 12 ч
- 401
- 24 ч
- 545
- 48 ч
- 757
- 3 дня
- 946
Когда публикует
Время по UTC. 23 поста за 90 дней.
Последние посты
-
𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗘𝘅𝗰𝗲𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 📊 🎓 Explore 4 FREE Excel Courses to upgrade your skills! ✅ Excel Formulas & Functions ✅ Pivot Tables & Charts ✅ Data Cleaning & Analysis ✅ Dashboards & Reporting 🎯 Perfect for Students, Freshers & Aspiring Data Analysts! 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/48mO4B2 📌 SAVE & SHARE with friends who want to master Excel! 🔥
-
𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝗪𝗜𝗧𝗛 𝗧𝗢𝗣 𝗖𝗢𝗠𝗣𝗔𝗡𝗜𝗘𝗦! 🎓 💻 Explore FREE Virtual Internship & Job Simulation Programs from leading companies! ✅ Learn Industry-Relevant Skills ✅ Work on Practical Tasks ✅ Self-Paced Online Learning ✅ Explore Completion Certificates ✅ Strengthen Your Resume & LinkedIn Profile 🎯 Perfect for Students, Freshers & Job Seekers 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/4t8DRlq 📲 SAVE & SHARE with friends looking for career opportunities!
-
𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗚𝗲𝘁 𝗬𝗼𝘂𝗿 𝗗𝗿𝗲𝗮𝗺 𝗝𝗼𝗯 𝗜𝗡 𝗚𝗼𝗼𝗴𝗹𝗲🔥 Discover *4 FREE resources* to help you prepare for a career at Google! ✅ Improve Your Coding Skills ✅ Strengthen Interview Preparation ✅ Build Technical Knowledge ✅ Prepare for Top Tech Opportunities 🎓Perfect for Students, Freshers & Aspiring Software Engineers! 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/4AwRPQy 📲 SAVE & SHARE with friends dreaming of working at Google!
-
𝟯 𝗙𝗥𝗘𝗘 𝗛𝘂𝗯𝗦𝗽𝗼𝘁 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗦𝘁𝘂𝗱𝗲𝗻𝘁𝘀 & 𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲🎓 💫HubSpot Academy offers three free online certifications that match these interests. 💫Pick one free course and try it out on your next college event and the certification is free. 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4iM5xaQ 📲 *Save & Share with your friends! 🔥*
-
CTE: WITH employee_data AS ( SELECT ** FROM employees ) SELECT ** FROM employee_data; View: CREATE VIEW employee_data AS SELECT ** FROM employees; The main difference is that a CTE is temporary within a statement, while a view has a persistent definition in the database. 🔹 9. Real-World Data Science Use Cases CTEs are widely used in analytical SQL queries to: • Calculate monthly revenue before comparing sales performance. • Identify high-value customers. • Find products with declining sales. • Calculate department-wise employee statistics. • Prepare clean datasets for reporting. • Break complex business queries into smaller steps. Example: Find customers whose total spe...
1 100 просмотров 6 Реакции 5 Репосты -
Фото
Смотреть в Telegram
645 просмотров 1 Реакции 4 Репосты
-
Example of a subquery: SELECT ** FROM employees WHERE salary > ( SELECT AVG(salary) FROM employees ); Equivalent approach using a CTE: WITH average_salary AS ( SELECT AVG(salary) AS avg_salary FROM employees ) SELECT ** FROM employees WHERE salary > ( SELECT avg_salary FROM average_salary ); Both approaches solve the same problem. 🔹 8. CTE vs View Another important interview concept.
666 просмотров 1 Реакции 5 Репосты -
Фото
Смотреть в Telegram
527 просмотров 1 Реакции 3 Репосты
-
You can now use this result in another query. For example, find departments with an average salary above 70,000. WITH department_salary AS ( SELECT department, AVG(salary) AS average_salary FROM employees GROUP BY department ) SELECT ** FROM department_salary WHERE average_salary > 70000; 🔹 5. Using Multiple CTEs You can create multiple CTEs within a single SQL query. This is especially useful when solving complex business problems step by step. Suppose you want to: • Calculate total sales by product. • Find products generating more than 1,00,000 in sales. WITH product_sales AS ( SELECT product_id, SUM(amount) AS total_sales FROM o...
586 просмотров 1 Реакции 5 Репосты -
Фото
Смотреть в Telegram
457 просмотров 1 Реакции 3 Репосты
-
SELECT customer_id, customer_name FROM customers c WHERE NOT EXISTS ( SELECT 1 FROM orders o WHERE o.customer_id = c.customer_id ); This is a common technique for finding missing relationships between tables. 🔹 8. Subquery in SELECT You can also use a subquery inside the SELECT statement. Example: Display each employee's salary along with the company's average salary. SELECT employee_name, salary, ( SELECT AVG(salary) FROM employees ) AS average_salary FROM employees; The average salary is calculated by the inner query and displayed alongside each employee. 🔹 9. Subquery in FROM A subquery can also be used inside the FROM clause. This is c...
1 600 просмотров 4 Реакции -
🚀 Data Science Roadmap 2026 📍 Phase 3: SQL for Data Science 📖 Topic 12: Subqueries in SQL Hi guys! Today, let's understand one of the most important SQL concepts: Subqueries. Subqueries are frequently used in SQL interviews and real-world data analysis. They help us solve complex problems by writing one query inside another query. 🔹 1. What is a Subquery? A Subquery is a SQL query written inside another SQL query. It is also called an inner query or nested query. The outer query uses the result returned by the inner query. Example: SELECT employee_name, salary FROM employees WHERE salary > ( SELECT AVG(salary) FROM employees ); Let's understand this step by step: • T...
1 210 просмотров 4 Реакции -
𝗚𝗢𝗢𝗚𝗟𝗘 𝟱 𝗙𝗥𝗘𝗘 𝗧𝗘𝗖𝗛 𝗖𝗢𝗨𝗥𝗦𝗘𝗦 𝟮𝟬𝟮𝟲! 🎓💻 Explore 5 FREE Google learning courses to build in-demand technical skills and strengthen your resume! 🚀 ✅ FREE Learning Resources ✅ Beginner-Friendly Courses ✅ Learn at Your Own Pace ✅ Explore Hands-On Learning Opportunities ✅ Build Skills for AI, ML & Cloud Careers 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4kMcA5X ⚡ Don't wait to upgrade your skills — start learning today!
-
Опрос
Смотреть в Telegram
1 130 просмотров 1 Репосты
-
CTE: WITH employee_data AS ( SELECT ** FROM employees ) SELECT ** FROM employee_data; View: CREATE VIEW employee_data AS SELECT ** FROM employees; The main difference is that a CTE is temporary within a statement, while a view has a persistent definition in the database. 🔹 9. Real-World Data Science Use Cases CTEs are widely used in analytical SQL queries to: • Calculate monthly revenue before comparing sales performance. • Identify high-value customers. • Find products with declining sales. • Calculate department-wise employee statistics. • Prepare clean datasets for reporting. • Break complex business queries into smaller steps. Example: Find customers whose total spe...
1 100 просмотров 6 Реакции 5 Репосты -
Опрос
Смотреть в Telegram
1 050 просмотров 1 Репосты 1 Комментарии
-
🚀 𝗠𝗜𝗖𝗥𝗢𝗦𝗢𝗙𝗧 + 𝗟𝗜𝗡𝗞𝗘𝗗𝗜𝗡 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! 🎓🔥 😍 Explore 5 FREE Career Learning Paths to boost your resume! 📊 Data Analytics | ☁️ Cloud Computing | 🤖 AI | 🔐 Cybersecurity | 💻 Software Development ✅ Learn In-Demand Skills ✅ Explore Certificate Opportunities ✅ Perfect for Students, Freshers & Job Seekers 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4eOufX9 📲 Share with your friends! 🔥
-
Опрос
Смотреть в Telegram
956 просмотров 1 Реакции 1 Репосты
-
🎓 𝟰 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀 Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies 📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/45vk5ph 💫 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 :- https://pdlink.in/3SuUeuD ☁️ 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- :- https://pdlink.in/48kyZjt 🛡️ 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 :- :- https://pdlink.in/4fWJVID 🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!
-
Опрос
Смотреть в Telegram
838 просмотров 1 Репосты
Вопросы о канале «Data Science & Machine Learning»
Сколько подписчиков у канала «Data Science & Machine Learning»?
У канала «Data Science & Machine Learning» (@datasciencefun) 77 616 подписчиков на 15 ноября 2026 г.
Сколько человек видят пост в канале «Data Science & Machine Learning»?
Средний пост набирает около 560 просмотров за 24 часа, это примерно 1 % подписчиков (ERR).
О чём канал «Data Science & Machine Learning»?
Канал в категории «Технологии», язык постов: английский. Описание канала: «Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free For collaborations: @love_data»
Какое место занимает канал «Data Science & Machine Learning»?
По числу подписчиков: №20 в категории «Технологии», №277 среди международных каналов, №405 среди каналов на языке «английский», №1 426 в мире.
Публикует ли канал «Data Science & Machine Learning» рекламу?
За последние 30 дней ни один из 23 постов не помечен как реклама (#ad, Sponsored, «Реклама»). Рекламу без пометки определить нельзя.
Статистика обновлена 4 часа назад.