AI & ML Papers
32.9K subscribers
7.09K photos
529 videos
24 files
7.76K links
Advancing research in Machine Learning – practical insights, tools, and techniques for researchers.

Admin: @HusseinSheikho || @Hussein_Sheikho
Download Telegram
Top 100 Data Analyst Interview Questions & Answers

#DataAnalysis #InterviewQuestions #SQL #Python #Statistics #CaseStudy #DataScience

Part 1: SQL Questions (Q1-30)

#1. What is the difference between DELETE, TRUNCATE, and DROP?
A:
DELETE is a DML command that removes rows from a table based on a WHERE clause. It is slower as it logs each row deletion and can be rolled back.
TRUNCATE is a DDL command that quickly removes all rows from a table. It is faster, cannot be rolled back, and resets table identity.
DROP is a DDL command that removes the entire table, including its structure, data, and indexes.

#2. Select all unique departments from the employees table.
A: Use the DISTINCT keyword.

SELECT DISTINCT department
FROM employees;


#3. Find the top 5 highest-paid employees.
A: Use ORDER BY and LIMIT.

SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 5;


#4. What is the difference between WHERE and HAVING?
A:
WHERE is used to filter records before any groupings are made (i.e., it operates on individual rows).
HAVING is used to filter groups after aggregations (GROUP BY) have been performed.

-- Find departments with more than 10 employees
SELECT department, COUNT(employee_id)
FROM employees
GROUP BY department
HAVING COUNT(employee_id) > 10;


#5. What are the different types of SQL joins?
A:
(INNER) JOIN: Returns records that have matching values in both tables.
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table.
FULL (OUTER) JOIN: Returns all records when there is a match in either the left or right table.
SELF JOIN: A regular join, but the table is joined with itself.

#6. Write a query to find the second-highest salary.
A: Use OFFSET or a subquery.

-- Method 1: Using OFFSET
SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 1 OFFSET 1;

-- Method 2: Using a Subquery
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);


#7. Find duplicate emails in a customers table.
A: Group by the email column and use HAVING to find groups with a count greater than 1.

SELECT email, COUNT(email)
FROM customers
GROUP BY email
HAVING COUNT(email) > 1;


#8. What is a primary key vs. a foreign key?
A:
• A Primary Key is a constraint that uniquely identifies each record in a table. It must contain unique values and cannot contain NULL values.
• A Foreign Key is a key used to link two tables together. It is a field (or collection of fields) in one table that refers to the Primary Key in another table.

#9. Explain Window Functions. Give an example.
A: Window functions perform a calculation across a set of table rows that are somehow related to the current row. Unlike aggregate functions, they do not collapse rows.

-- Rank employees by salary within each department
SELECT
name,
department,
salary,
RANK() OVER (PARTITION BY department ORDER BY salary DESC) as dept_rank
FROM employees;


#10. What is a CTE (Common Table Expression)?
A: A CTE is a temporary, named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. It helps improve readability and break down complex queries.
2
Gradio: Hassle-Free Sharing and Testing of ML Models in the Wild

📝 Summary:
Gradio is an open-source Python package that creates visual interfaces for ML models, making them accessible to non-specialized users via a URL. This improves collaboration by allowing easy interaction, feedback, and trust-building in interdisciplinary settings.

🔹 Publication Date: Published on Jun 6, 2019

🔹 Paper Links:
• arXiv Page: https://arxiv.org/abs/1906.02569
• PDF: https://arxiv.org/pdf/1906.02569
• Github: https://github.com/gradio-app/gradio

🔹 Models citing this paper:
https://huggingface.co/CxECHO/CE

Datasets citing this paper:
https://huggingface.co/datasets/society-ethics/papers

Spaces citing this paper:
https://huggingface.co/spaces/orYx-models/Nudge_Generator
https://huggingface.co/spaces/society-ethics/about
https://huggingface.co/spaces/mindmime/gradio

==================================

For more data science resources:
https://xn--r1a.website/DataScienceT

#Gradio #MachineLearning #MLOps #Python #DataScience
👩‍💻 FREE 2026 IT Learning Kits Giveaway

🔥Whether you're preparing for #Cisco #AWS #PMP #Python #Excel #Google #Microsoft #AI or any other in-demand certification – SPOTO has got you covered!

🎁 Explore Our FREE Study Resources
·IT Certs E-book : https://bit.ly/3YvSMHL
·IT exams skill Test : https://bit.ly/4r4VHnd
·Python, ITIL, PMP, Excel, Cyber Security, cloud, SQL Courses : https://bit.ly/4qNWl8r
·Free AI online preparation material and support tools : https://bit.ly/4qKiKTN

🔗 Need IT Certs Exam Help? contact: wa.link/dm4kyz
📲 Join IT Study Group for insider tips & expert support:
https://chat.whatsapp.com/BEQ9WrfLnpg1SgzGQw69oM
4
Numba-Accelerated 2D Diffusion-Limited Aggregation: Implementation and Fractal Characterization

📝 Summary:
This paper details a Numba-accelerated Python framework for 2D DLA simulations. It confirms a fractal dimension of 1.71 for dilute regimes but reveals a crossover to 1.87 compact growth in high-density environments. This provides an open-source testbed.

🔹 Publication Date: Published on Jan 21

🔹 Paper Links:
• arXiv Page: https://arxiv.org/abs/2601.15440
• PDF: https://arxiv.org/pdf/2601.15440
• Project Page: https://pypi.org/project/dla-ideal-solver/
• Github: https://github.com/sandyherho/dla-ideal-solver

==================================

For more data science resources:
https://xn--r1a.website/DataScienceT

#DLA #Fractals #ScientificComputing #Python #Simulations
1
🎯 Want to Upskill in IT? Try Our FREE 2026 Learning Kits!

SPOTO gives you free, instant access to high-quality, updated resources that help you study smarter and pass exams faster.
Latest Exam Materials:
Covering #Python, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #AI, #Excel, #comptia, #ITIL, #cloud & more!
100% Free, No Sign-up:
All materials are instantly downloadable

What’s Inside:
📘IT Certs E-book: https://bit.ly/3Mlu5ez
📝IT Exams Skill Test: https://bit.ly/3NVrgRU
🎓Free IT courses: https://bit.ly/3M9h5su
🤖Free PMP Study Guide: https://bit.ly/4te3EIn
☁️Free Cloud Study Guide: https://bit.ly/4kgFVDs

👉 Become Part of Our IT Learning Circle! resources and support:
https://chat.whatsapp.com/FlG2rOYVySLEHLKXF3nKGB

💬 Want exam help? Chat with an admin now!
wa.link/8fy3x4
🎯 2026 IT Certification Prep Kit – Free!

🔥Whether you're preparing for #Python, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #AI, #Excel, #comptia, #ITIL, #cloud or any other in-demand certification – SPOTO has got you covered!

What’s Inside:
・Free Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS courses: https://bit.ly/3M9h5su
・IT Certs E-book: https://bit.ly/3Mlu5ez
・IT Exams Skill Test: https://bit.ly/3NVrgRU
・Free Cloud Study Guide: https://bit.ly/4kgFVDs
・Free AI material and support tools:https://bit.ly/46qvpDX

👉 Become Part of Our IT Learning Circle! resources and support:
https://chat.whatsapp.com/FlG2rOYVySLEHLKXF3nKGB

💬 Want exam help? Chat with an admin now!
wa.link/8fy3x4
1
🎁 23 Years of SPOTO – Claim Your Free IT Certs Prep Kit!

🔥Whether you're preparing for #Python, #AI, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #Excel, #comptia, #ITIL, #cloud or any other in-demand certification – SPOTO has got you covered!

Free Resources :
・Free Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS courses: https://bit.ly/4lk4m3c
・IT Certs E-book: https://bit.ly/4bdZOqt
・IT Exams Skill Test: https://bit.ly/4sDvi0b
・Free AI material and support tools: https://bit.ly/46TpsQ8
・Free Cloud Study Guide: https://bit.ly/4lk3dIS

🎁 Join SPOTO 23rd anniversary Lucky Draw:
📱 iPhone 17
🛒free order
🛒 Amazon Gift Card $50/$100
📘 AI/CCNA/PMP Course Training + Study Material + eBook
Enter the Draw 👉: https://bit.ly/3NwkceD

👉 Become Part of Our IT Learning Circle! resources and support:
https://chat.whatsapp.com/Cnc5M5353oSBo3savBl397

💬 Want exam help? Chat with an admin now!
wa.link/rozuuw

Last Chance – Get It Before It’s Gone!
🔥21👍1👏1
🎁 23 Years of SPOTO – Claim Your Free IT Certs Prep Kit!

🔥Whether you're preparing for #Python, #AI, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #Excel, #comptia, #ITIL, #cloud or any other in-demand certification – SPOTO has got you covered!

Free Resources :
・Free Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS courses: https://bit.ly/4lk4m3c
・IT Certs E-book: https://bit.ly/4bdZOqt
・IT Exams Skill Test: https://bit.ly/4sDvi0b
・Free AI material and support tools: https://bit.ly/46TpsQ8
・Free Cloud Study Guide: https://bit.ly/4lk3dIS


👉 Become Part of Our IT Learning Circle! resources and support:
https://chat.whatsapp.com/Cnc5M5353oSBo3savBl397

💬 Want exam help? Chat with an admin now!
wa.link/rozuuw
🔥2026 New IT Certification Prep Kit – Free!

SPOTO cover: #Python #AI #Cisco #PMI #Fortinet #AWS #Azure #Excel #CompTIA #ITIL #Cloud + more

Grab yours free kit now:
• Free Courses (Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS)
👉 https://bit.ly/3Ogtn3i
• IT Certs E-book
👉 https://bit.ly/41KZlru
• IT Exams Skill Test
👉 https://bit.ly/4ve6ZbC
• Free AI Materials & Support Tools
👉 https://bit.ly/4vagTuw
• Free Cloud Study Guide
👉 https://bit.ly/4c3BZCh

💬 Need exam help? Contact admin: wa.link/w6cems

Join our IT community: get free study materials, exam tips & peer support
https://chat.whatsapp.com/BiazIVo5RxfKENBv10F444
1
💡 Level Up Your IT Career in 2026 – For FREE

Areas covered: #Python #AI #Cisco #PMP #Fortinet #AWS #Azure #Excel #CompTIA #ITIL #Cloud + more

🔗 Download each free resource here:
• Free Courses (Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS)
👉https://bit.ly/4ejSFbz

• IT Certs E-book
👉 https://bit.ly/42y8owh

• IT Exams Skill Test
👉 https://bit.ly/42kp7Dv

• Free AI Materials & Support Tools
👉 https://bit.ly/3QEfWek

• Free Cloud Study Guide
👉https://bit.ly/4u8Zb9r

📲 Need exam help? Contact admin: wa.link/40f942

💬 Join our study group (free tips & support): https://chat.whatsapp.com/K3n7OYEXgT1CHGylN6fM5a
Forwarded from Machine Learning
🔖 A huge open-source course on AI Engineering from scratch

In the repository, we've collected:
— 435 lessons;
— 320+ hours of content;
Python, TypeScript, and Rust;
— AI agents, MCP servers, prompts, and AI skills.

Moreover, almost every lesson includes practical tasks, so this isn't just theory, but a full-fledged roadmap for AI Engineering. 🚀

⛓️ Link to the repository
https://github.com/rohitg00/ai-engineering-from-scratch

#AI #MachineLearning #Python #Rust #OpenSource #Tech

Join Best TG Channels https://xn--r1a.website/addlist/0f6vfFbEMdAwODBk

⭐️ Join Our WhatsApp Channel https://whatsapp.com/channel/0029VaC7Weq29753hpcggW2A
3
🎁 SPOTO Mid-Year Sale – Grab Your IT Certification Success Kit!

🔥 Whether you're prepping for #Python, #AI, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #Excel, #Comptia, #ITIL, #Cloud or any other hot certification – SPOTO has your back with real exam dumps and hands-on training!

Free Resources:
・Free Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS courses: https://bit.ly/4alTSfk
・IT Certs E-book: https://bit.ly/49ub0zq
・IT Exams Skill Test: https://bit.ly/4dVPapB
・Free AI material and support tools: https://bit.ly/4elzcpl
・Free Cloud Study Guide: https://bit.ly/4u7sdG0

🎁 Join SPOTO Mid-Year Lucky Draw:
📱 iPhone 17 🛒 Free Order
🛒 Amazon Gift $100 📘PMP/ AWS/ CCNA Course


👉 Enter the Draw Now → https://bit.ly/4uN3lVt

👉 Join Our IT Learning Community for free resources & support:
https://chat.whatsapp.com/FmbIbbqm2QhKglVpVTSH4d
💬 Want exam help? Chat with an admin now:
https://wa.link/knicza

Mid-Year Deal Ends Soon – Don't Miss Out!
🎁 SPOTO Mid-Year Sale – Grab Your IT Certification Success Kit!

🔥 Whether you're prepping for #Python, #AI, #Cisco, #PMI, #Fortinet, #AWS, #Azure, #Excel, #Comptia, #ITIL, #Cloud or any other hot certification – SPOTO has your back with real exam dumps and hands-on training!

Free Resources:
・Free Python, Excel, Cyber Security, Cisco, SQL, ITIL, PMP, AWS courses: https://bit.ly/4alTSfk
・IT Certs E-book: https://bit.ly/49ub0zq
・IT Exams Skill Test: https://bit.ly/4dVPapB
・Free AI material and support tools: https://bit.ly/4elzcpl
・Free Cloud Study Guide: https://bit.ly/4u7sdG0

🎁 Join SPOTO Mid-Year Lucky Draw:
📱 iPhone 17 🛒 Free Order
🛒 Amazon Gift $100 📘PMP/ AWS/ CCNA Course


👉 Enter the Draw Now → https://bit.ly/4uN3lVt

👉 Join Our IT Learning Community for free resources & support:
https://chat.whatsapp.com/FQOG04r9xSiIa2ElhaNUJU
💬 Want exam help? Chat with an admin now:
https://wa.link/knicza

Mid-Year Deal Ends Soon – Don't Miss Out!