متاح الآن! بحث تيليغرام 2025 — أهم رؤى العام 
SQL Programming Resources
الذهاب إلى القناة على Telegram
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
إظهار المزيد📈 نظرة تحليلية على قناة تيليجرام SQL Programming Resources
تُعد قناة SQL Programming Resources (@sqlanalyst) في القطاع اللغوي الإنكليزية لاعباً نشطاً. يضم المجتمع حالياً 75 820 مشتركاً، محتلاً المرتبة 1 690 في فئة التكنولوجيات والتطبيقات والمرتبة 4 344 في منطقة الهند.
📊 مؤشرات الجمهور والحراك
منذ تأسيسه في невідомо، حقق المشروع نمواً سريعاً وجمع 75 820 مشتركاً.
بحسب آخر البيانات بتاريخ 07 يونيو, 2026، تحافظ القناة على نشاط مستقر. خلال آخر 30 يوماً تغيّر عدد الأعضاء بمقدار 518، وفي آخر 24 ساعة بمقدار 23، مع بقاء الوصول العام مرتفعاً.
- حالة التحقق: غير موثّقة
- معدل التفاعل (ER): يبلغ متوسط تفاعل الجمهور 3.38%. وخلال أول 24 ساعة من النشر يحصد المحتوى عادةً 1.29% من ردود الفعل نسبةً إلى إجمالي المشتركين.
- وصول المنشورات: يحصل كل منشور على متوسط 2 561 مشاهدة. وخلال اليوم الأول يجمع عادةً 978 مشاهدة.
- التفاعلات والاستجابة: يتفاعل الجمهور بانتظام؛ متوسط التفاعلات لكل منشور يبلغ 4.
- الاهتمامات الموضوعية: يركز المحتوى على مواضيع رئيسية مثل row, sql, customer_id, logic, desc.
📝 الوصف وسياسة المحتوى
يصف المؤلف القناة بأنها مساحة للتعبير عن الآراء الذاتية:
“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”
بفضل وتيرة التحديث المرتفعة (أحدث البيانات بتاريخ 08 يونيو, 2026) تحافظ القناة على حداثتها ومستوى وصول مرتفع. وتُظهر التحليلات تفاعلاً نشطاً من الجمهور، ما يجعلها نقطة تأثير مهمة ضمن فئة التكنولوجيات والتطبيقات.
75 820
المشتركون
+2324 ساعات
+1907 أيام
+51830 أيام
جاري تحميل البيانات...
القنوات المماثلة
75.0K
70.6K
47.6K
6.3K
4.5K
1
سحابة العلامات
الإشارات الواردة والصادرة
---
---
---
---
---
---
جذب المشتركين
يونيو '26
يونيو '26
+201
في 5 قنوات
مايو '26
+597
في 9 قنوات
Get PRO
أبريل '26
+494
في 4 قنوات
Get PRO
مارس '26
+166
في 6 قنوات
Get PRO
فبراير '26
+741
في 13 قنوات
Get PRO
يناير '26
+716
في 5 قنوات
Get PRO
ديسمبر '25
+863
في 4 قنوات
Get PRO
نوفمبر '25
+771
في 6 قنوات
Get PRO
أكتوبر '25
+676
في 4 قنوات
Get PRO
سبتمبر '25
+468
في 12 قنوات
Get PRO
أغسطس '25
+502
في 25 قنوات
Get PRO
يوليو '25
+625
في 21 قنوات
Get PRO
يونيو '25
+1 033
في 37 قنوات
Get PRO
مايو '25
+2 110
في 26 قنوات
Get PRO
أبريل '25
+3 784
في 40 قنوات
Get PRO
مارس '25
+1 190
في 27 قنوات
Get PRO
فبراير '25
+881
في 30 قنوات
Get PRO
يناير '25
+1 239
في 36 قنوات
Get PRO
ديسمبر '24
+1 240
في 22 قنوات
Get PRO
نوفمبر '24
+3 503
في 23 قنوات
Get PRO
أكتوبر '24
+3 975
في 29 قنوات
Get PRO
سبتمبر '24
+4 469
في 26 قنوات
Get PRO
أغسطس '24
+5 990
في 23 قنوات
Get PRO
يوليو '24
+8 180
في 25 قنوات
Get PRO
يونيو '24
+7 119
في 22 قنوات
Get PRO
مايو '24
+5 879
في 12 قنوات
Get PRO
أبريل '24
+5 286
في 13 قنوات
Get PRO
مارس '24
+6 156
في 17 قنوات
Get PRO
فبراير '24
+4 581
في 8 قنوات
Get PRO
يناير '24
+5 285
في 4 قنوات
Get PRO
ديسمبر '23
+7 504
في 8 قنوات
| التاريخ | نمو المشتركين | الإشارات | القنوات | |
| 08 يونيو | +7 | |||
| 07 يونيو | +24 | |||
| 06 يونيو | +10 | |||
| 05 يونيو | +48 | |||
| 04 يونيو | +62 | |||
| 03 يونيو | +28 | |||
| 02 يونيو | +18 | |||
| 01 يونيو | +4 |
منشورات القناة
🎓 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗪𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀 🚀
Here are some amazing FREE online courses that can help you learn in-demand skills and earn valuable certificates. 📚✨
✅ 100% Free Learning Resources
✅ Industry-Recognized Certifications
✅ Self-Paced Learning
✅ Beginner-Friendly Courses
✅ Boost Your Resume & LinkedIn Profile
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/4uZQAXC
📌 Save this post and share it with friends who are looking to learn new skills for free!
| 2 | Let's now understand the above Data Analyst Roadmap in detail: 🧠↗️
1️⃣ Learn Excel ⭐️
The foundation of data analysis. Learn formulas, pivot tables, charts, VLOOKUP/XLOOKUP, and conditional formatting. It helps in quick data cleaning and presenting insights.
Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i
2️⃣ Learn SQL 💻
Essential for working with databases. Focus on SELECT, JOIN, GROUP BY, WHERE, and subqueries to extract and manipulate data from relational databases.
SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
3️⃣ Learn Python 📱
A powerful tool for data manipulation and automation. Master libraries like pandas, numpy, matplotlib, and seaborn for data cleaning and visualization.
Python Resources: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
4️⃣ Learn Power BI / Tableau 📈
These tools help create interactive dashboards and visual reports. Learn how to import data, create filters, use DAX (Power BI), and design clear visualizations.
Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
5️⃣ Learn Statistics & Probability 🛍
Know about descriptive stats (mean, median, mode), inferential stats, distributions, hypothesis testing, and correlation. Vital for making sense of data trends.
Statistics Resources: https://whatsapp.com/channel/0029Vat3Dc4KAwEcfFbNnZ3O
6️⃣ Learn Data Transformation 📈
Learn how to clean, shape, and prepare data for analysis. Use Python (pandas) or Power Query in Power BI, and understand ETL (Extract, Transform, Load) processes.
Data Cleaning: https://whatsapp.com/channel/0029VarxgFqATRSpdUeHUA27
7️⃣ Learn Machine Learning 🧠
Understand basic concepts like regression, classification, clustering, and decision trees. You don’t need to be an ML expert, just grasp how models work and when to use them.
Machine Learning: https://whatsapp.com/channel/0029VawtYcJ1iUxcMQoEuP0O
8️⃣ Build Projects & Portfolio 🏹
Apply what you’ve learned to real datasets—like sales analysis, churn prediction, or dashboard creation. Showcase your work on GitHub or a personal website.
Data Analytics Projects: https://whatsapp.com/channel/0029VbAbnvPLSmbeFYNdNA29
9️⃣ Apply for Jobs 💼
With your skills and portfolio in place, start applying for data analyst roles. Tailor your resume using keywords from job descriptions and prepare to answer SQL and Excel tasks in interviews.
Jobs & Internship Opportunities: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
Share with credits: https://t.me/sqlspecialist
Double Tap ♥️ for more | 802 |
| 3 |  𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗦𝘂𝗽𝗽𝗼𝗿𝘁😍
Build a Career in Data Science & AI with a job-focused curriculum designed by industry experts.
✅ Learn from IIT Alumni & Top Industry Professionals
✅ 500+ Hiring Partners
✅ 100% Job Assistance
✅ Real-World Projects & Case Studies
✅ Mock Interviews & Career Support
Whether you're a student, fresher, or working professional, this program can help you transition into high-growth Data & AI roles.
🎯 Don't wait for opportunities — create them!
𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-
https://pdlink.in/4fdWxJB
⚡ Limited Seats Available – Apply Fast! | 904 |
| 4 | ✅ SQL Interview Challenge 💼🧠
𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: How would you count how many employees are in each department?
𝗠𝗲: I’d use the GROUP BY clause with COUNT(*) to aggregate employee counts per department.
🔹 Query:
SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department;
✔ Why it works:
– GROUP BY groups rows by department
– COUNT(*) counts employees in each group
– Clean, scalable, and works with large datasets
🔎 Bonus Insight:
To filter only departments with more than 5 employees:
SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;
– HAVING filters aggregated results
– Useful in dashboards, reports, and business logic
💬 Tap ❤️ for more SQL interview tips! | 1 128 |
| 5 | 🔥 Top SQL Projects for Data Analytics 🚀
If you're preparing for a Data Analyst role or looking to level up your SQL skills, working on real-world projects is the best way to learn!
Here are some must-do SQL projects to strengthen your portfolio. 👇
🟢 Beginner-Friendly SQL Projects (Great for Learning Basics)
✅ Employee Database Management – Build and query HR data 📊
✅ Library Book Tracking – Create a database for book loans and returns
✅ Student Grading System – Analyze student performance data
✅ Retail Point-of-Sale System – Work with sales and transactions 💰
✅ Hotel Booking System – Manage customer bookings and check-ins 🏨
🟡 Intermediate SQL Projects (For Stronger Querying & Analysis)
⚡ E-commerce Order Management – Analyze order trends & customer data 🛒
⚡ Sales Performance Analysis – Work with revenue, profit margins & KPIs 📈
⚡ Inventory Control System – Optimize stock tracking 📦
⚡ Real Estate Listings – Manage and analyze property data 🏡
⚡ Movie Rating System – Analyze user reviews & trends 🎬
🔵 Advanced SQL Projects (For Business-Level Analytics)
🔹 Social Media Analytics – Track user engagement & content trends
🔹 Insurance Claim Management – Fraud detection & risk assessment
🔹 Customer Feedback Analysis – Perform sentiment analysis on reviews ⭐
🔹 Freelance Job Platform – Match freelancers with project opportunities
🔹 Pharmacy Inventory System – Optimize stock levels & prescriptions
🔴 Expert-Level SQL Projects (For Data-Driven Decision Making)
🔥 Music Streaming Analysis – Study user behavior & song trends 🎶
🔥 Healthcare Prescription Tracking – Identify patterns in medicine usage
🔥 Employee Shift Scheduling – Optimize workforce efficiency ⏳
🔥 Warehouse Stock Control – Manage supply chain data efficiently
🔥 Online Auction System – Analyze bidding patterns & sales performance 🛍️
🔗 Pro Tip: If you're applying for Data Analyst roles, pick 3-4 projects, clean the data, and create interactive dashboards using Power BI/Tableau to showcase insights!
React with ♥️ if you want detailed explanation of each project
Share with credits: 👇 https://t.me/sqlspecialist
Hope it helps :) | 1 241 |
| 6 |  𝗧𝗼𝗽 𝟱 𝗙𝗥𝗘𝗘 𝗔𝗜 & 𝗠𝗟 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🚀
These FREE courses can help you develop industry-relevant skills and create a strong foundation in ML & AI. 📈
✅ 100% Free Learning Resources
✅ Beginner-Friendly Content
✅ Hands-On Projects
✅ Build an ML Portfolio
✅ Boost Your Resume & Career Opportunities
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/4dXk9Sc
📌 Save this post and start your AI journey today! | 1 262 |
| 7 | What will this query return?
SELECT REPLACE('I love Java', 'Java', 'SQL'); | 1 509 |
| 8 | Which function removes extra spaces from text? | 1 363 |
| 9 | What does CONCAT() do in SQL? | 1 276 |
| 10 | Which function converts text to uppercase? | 1 236 |
| 11 | 🚀 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 | 𝗚𝗲𝘁 𝗛𝗶𝗿𝗲𝗱 𝗶𝗻 𝗧𝗼𝗽 𝗧𝗲𝗰𝗵 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀! 💼🔥
Master the most in-demand tech skills and kickstart your career with industry-leading training.
🎯 Program Highlights:
✅ Learn Coding from Industry Experts
✅ Real-World Projects & Interview Preparation
✅ Dedicated Placement Support
✅ Avg. Package: ₹7.2 LPA
✅ Highest Package: ₹41 LPA 🚀
🎓 Perfect for Freshers, Students & Career Switchers
𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.🏃♂️ | 1 431 |
| 12 | 🔥Now, let’s move to the next topic:
✅ SQL String Functions
🧠 1. What are String Functions?
String functions are used to
👉 manipulate text data
👉 clean messy data
👉 format outputs
Used heavily in:
✔ Data Analytics
✔ Reporting
✔ ETL processes
⚡ 2. Common String Functions
Function : Purpose
UPPER() : Convert to uppercase
LOWER() : Convert to lowercase
LENGTH() : Count characters
CONCAT() : Join strings
SUBSTRING() : Extract part of string
TRIM() : Remove spaces
REPLACE() : Replace text
🔥 3. UPPER() & LOWER()
SELECT UPPER(name) AS upper_name
FROM employees;
SELECT LOWER(name) AS lower_name
FROM employees;
🔥 4. LENGTH()
👉 Count number of characters
SELECT name, LENGTH(name) AS total_chars
FROM employees;
🔥 5. CONCAT()
👉 Combine strings
SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;
🔥 6. SUBSTRING()
👉 Extract part of string
SELECT SUBSTRING(name, 1, 3)
FROM employees;
✔ Extracts first 3 characters
🔥 7. TRIM()
👉 Remove extra spaces
SELECT TRIM(' SQL ');
✔ Result → SQL
🔥 8. REPLACE()
👉 Replace text inside string
SELECT REPLACE('I love Java', 'Java', 'SQL');
✔ Result → I love SQL
🎯 9. Practice Tasks
1. Convert names to uppercase
2. Convert emails to lowercase
3. Combine first & last names
4. Extract first 4 letters of names
5. Remove extra spaces from city names
⚡ Mini Challenge 🔥
👉 Create employee usernames using:
first 3 letters of name + employee ID
Example:
Amit + 101 → Ami101
🔥 Mini Challenge Solution 💯
👉 Requirement:
Create username using:
• First 3 letters of name
• Employee ID
Example:
Amit + 101 → Ami101
✅ SQL Solution
SELECT name,
emp_id,
CONCAT(SUBSTRING(name, 1, 3), emp_id) AS username
FROM employees;
✅ Example Output
name : emp_id : username
Amit : 101 : Ami101
Neha : 102 : Neh102
Ravi : 103 : Rav103
🧠 How It Works
👉 SUBSTRING(name, 1, 3)
Extracts first 3 letters
👉 CONCAT()
Combines extracted text with employee ID
🔥 Real-World Usage:
String functions are commonly used for:
👉 Username generation
👉 Email formatting
👉 Data cleaning
👉 Customer IDs 💯
Double Tap ❤️ For More | 1 575 |
| 13 |  🚀 𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 – 𝗘𝗻𝗿𝗼𝗹𝗹 𝗡𝗼𝘄!
TCS iON is offering FREE certification courses to help students, freshers & professionals build job-ready skills from home 🌍
✅ 100% Free Online Courses
✅ Free Verified Certificates
✅ Self-Paced Learning
✅ Beginner-Friendly Programs
✅ Learn from TCS Industry Experts
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/4nTGSDh
🔥 Excellent opportunity to gain valuable certifications from one of India’s top IT companies completely FREE. | 2 015 |
| 14 | 🔥 Now, Let’s move to the next topic:
✅ UNION & UNION ALL in SQL
🧠 1. What is UNION?
UNION is used to combine results from multiple SELECT queries.
"Merge data from two tables into one result.”
⚡ 2. Rules for UNION
✔ Same number of columns
✔ Same datatype/order of columns
📊 Example Tables
👨💼 employees₂024
name
• Amit
• Neha
👨💼 employees₂025
name
• Ravi
• Neha
🔥 3. UNION Example
SELECT name FROM employees_2024
UNION
SELECT name FROM employees_2025;
✔ Removes duplicates automatically
✅ Result
name
• Amit
• Neha
• Ravi
⚡ 4. UNION ALL
SELECT name FROM employees_2024
UNION ALL
SELECT name FROM employees_2025;
✔ Keeps duplicates
✔ Faster than UNION
✅ Result
name
• Amit
• Neha
• Ravi
• Neha
🔥 5. UNION vs UNION ALL
UNION
• Removes duplicates
• Slower
• Doesn't keep all rows
UNION ALL
• Doesn't remove duplicates
• Faster
• Keeps all rows
⚡ 6. ORDER BY with UNION
SELECT name FROM employees_2024
UNION
SELECT name FROM employees_2025
ORDER BY name;
🎯 7. Practice Tasks
1. Combine employee names using UNION
2. Combine employee names using UNION ALL
3. Identify duplicate removal
4. Sort UNION result using ORDER BY
5. Compare UNION vs UNION ALL output
⚡ Mini Challenge 🔥
👉 Combine customer names from two branches and keep duplicates
🔥 Mini Challenge Solution 💯
👉 Since duplicates should remain → use UNION ALL
✅ Example Tables
🏢 branch_a_customers
customer_name
• Amit
• Neha
🏢 branch_b_customers
customer_name
• Ravi
• Neha
✅ SQL Solution
SELECT customer_name
FROM branch_a_customers
UNION ALL
SELECT customer_name
FROM branch_b_customers;
✅ Result
customer_name
• Amit
• Neha
• Ravi
• Neha
✔ Duplicate Neha is preserved 💯
🧠 Why UNION ALL?
👉 UNION → removes duplicates
👉 UNION ALL → keeps duplicates + faster
Double Tap ❤️ For More | 3 099 |
| 15 |  𝗧𝗼𝗽 𝟯 𝗙𝗥𝗘𝗘 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗜𝗻 𝟮𝟬𝟮𝟲! 🚀💻
These FREE certification courses can help you build strong programming skills and stand out from the crowd 👇
✅ Free Learning Resources
✅ Certificate Opportunities
✅ Beginner Friendly
✅ Boost Your Resume & Tech Skills
🌟 Perfect for students, freshers, aspiring developers, data analysts, and tech enthusiasts.
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/43DnP6S
📌 Start learning today and level up your career with Python! | 2 588 |
| 16 | If you're working with data pipelines, these repositories are very useful: 🚀📊
ibis: A Python API that allows you to write queries once and run them on different data backends, such as DuckDB, BigQuery, and Snowflake. 🐍🔗
https://github.com/ibis-project/ibis
pygwalker: Instantly turns a DataFrame into an interactive UI for visual data exploration. 📈🖥️
https://github.com/Kanaries/pygwalker
katana: A fast and scalable web crawler, often used for security testing and large-scale data collection/search. 🕷️🔒
https://github.com/projectdiscovery/katana
Double Tap ❤️ For More Free Resources | 3 576 |
| 17 |  𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝘄𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜 𝗢𝗻𝗹𝗶𝗻𝗲 𝗪𝗲𝗯𝗶𝗻𝗮𝗿 😍
AI is replacing analysts who don't adapt.
Learn Data Analytics + GenAI with IBM & Microsoft certifications. Land your dream role with dedicated placement support.
🎓1200+ Hiring Partners. 128% avg hike. 35 LPA Highest CTC in Placements.
💫𝗕𝗼𝗼𝗸 𝘆𝗼𝘂𝗿 𝗙𝗥𝗘𝗘 𝘄𝗲𝗯𝗶𝗻𝗮𝗿 :-
https://pdlink.in/4uwBw3q
Hurry Up ♂️! Limited seats are available. | 3 162 |
| 18 | What is the purpose of constraints in SQL? | 3 252 |
| 19 |  𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀🎓
✨ Learn In-Demand Tech Skills
✨ Boost Your Resume & LinkedIn Profile
✨ Improve Career Opportunities
✨ Self-Paced Online Learning
✨ Great for Freshers & Students
🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:
https://pdlink.in/49p31Uh
🔥 Start learning today and prepare for high-paying tech careers with Microsoft free certification programs | 3 293 |
| 20 | 🔥 Now, let's move to the next topic:
✅ SQL Constraints
Essential for data integrity & important in interviews 💯
🧠 1. What are Constraints in SQL?
Constraints are rules applied on table columns
👉 to maintain accurate & valid data
Think like this 👇
👉 “Database safety rules”
⚡ 2. Why Use Constraints?
✔ Prevent invalid data
✔ Maintain consistency
✔ Improve data integrity
✔ Enforce relationships
📊 Types of Constraints
NOT NULL
• Purpose: Prevent NULL values
UNIQUE
• Purpose: No duplicate values
PRIMARY KEY
• Purpose: Unique identifier
FOREIGN KEY
• Purpose: Create relationship
CHECK
• Purpose: Apply condition
DEFAULT
• Purpose: Set default value
🔥 3. NOT NULL Constraint
👉 Column cannot contain NULL
CREATE TABLE employees (
emp_id INT,
name VARCHAR(50) NOT NULL
);
🔥 4. UNIQUE Constraint
👉 Prevent duplicate values
CREATE TABLE users (
email VARCHAR(100) UNIQUE
);
🔥 5. PRIMARY KEY
👉 Unique + NOT NULL
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
name VARCHAR(50)
);
✔ Every row must have unique emp_id
🔥 6. FOREIGN KEY
👉 Creates relationship between tables
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
dept_id INT,
FOREIGN KEY (dept_id)
REFERENCES departments(dept_id)
);
✔ dept_id must exist in departments table
🔥 7. CHECK Constraint
👉 Restrict values using condition
CREATE TABLE employees (
salary INT CHECK (salary > 0)
);
✔ Salary cannot be negative
🔥 8. DEFAULT Constraint
👉 Assign default value automatically
CREATE TABLE employees (
city VARCHAR(50) DEFAULT 'Pune'
);
🎯 9. Practice Tasks
1. Create table using PRIMARY KEY
2. Add UNIQUE constraint on email
3. Create FOREIGN KEY relationship
4. Use CHECK for salary > 0
5. Add DEFAULT city value
⚡ Mini Challenge 🔥
👉 Create students table with:
• student_id → PRIMARY KEY
• email → UNIQUE
• age > 18 using CHECK
• city default = 'Mumbai'
Double Tap ❤️ For More | 2 885 |
