Telegram Web Link
Hello Everyone,

I’m flying to Lisbon tomorrow morning on a business trip ✈️.

If any of you are around and would like to meet up, feel free to send me a message, would love to connect! 😊
πŸ‘4❀2
This media is not supported in your browser
VIEW IN TELEGRAM
❀23πŸ”₯4πŸ‘3πŸ₯°1
SQL/MySQL Learning Series: Day 1️⃣1️⃣
πŸ”Ή UPDATE – Modifying Existing Data

🧠 Once you've inserted data, real-world needs often change.
Need to correct a typo or give someone a raise? That’s where UPDATE comes in!

---

πŸ“Œ Syntax:

UPDATE table_name
SET column1 = value1, column2 = value2
WHERE condition;


Always include WHERE to avoid updating *all* rows by accident!

---

πŸ“Œ Example:
Alice got a raise! Let’s update her salary:

UPDATE employees
SET salary = 75000.00
WHERE name = 'Alice';


Updated result:

+----+---------+------------+----------+------------+
| id | name | department | salary | hire_date |
+----+---------+------------+----------+------------+
| 1 | Alice | IT | 75000.00 | 2022-03-01 |
| 2 | Bob | HR | 55000.00 | 2021-11-15 |
| 3 | Charlie | Finance | 60000.00 | 2023-01-10 |
| 4 | Diana | IT | 80000.00 | 2020-08-22 |
+----+---------+------------+----------+------------+


---

🚨 Warning: Without a WHERE clause, all rows will be updated!
Double-check before running your query.

Next: We’ll learn how to remove data with DELETE.


#SQL #MySQL #SqlLearningSeries
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
SQL/MySQL Learning Series: Day 1️⃣2️⃣
πŸ”Ή DELETE – Removing Data

πŸ—‘ Sometimes, data needs to go – whether it’s outdated, incorrect, or no longer needed.
That’s where DELETE steps in.

---

πŸ“Œ Syntax:

DELETE FROM table_name
WHERE condition;


Just like with UPDATE, never forget the `WHERE` clause unless you *want* to delete everything!

---

πŸ“Œ Example:
Let’s remove Bob from the employees table:

DELETE FROM employees
WHERE name = 'Bob';


Result:

+----+---------+------------+----------+------------+
| id | name | department | salary | hire_date |
+----+---------+------------+----------+------------+
| 1 | Alice | IT | 75000.00 | 2022-03-01 |
| 3 | Charlie | Finance | 60000.00 | 2023-01-10 |
| 4 | Diana | IT | 80000.00 | 2020-08-22 |
+----+---------+------------+----------+------------+


---

πŸ’£ Want to delete *everything* from a table?

DELETE FROM employees;


Or faster (but irreversible):

TRUNCATE TABLE employees;


Use with caution! ⚠️

#SQL #MySQL #SqlLearningSeries
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
❀5πŸŽ‰1
Yesterday was Linux's birthday. Can you guess how old is Linux now?
Anonymous Quiz
10%
17
26%
28
32%
34
33%
40
πŸ‘2πŸ€”1
Machine Learning with Python: from Linear Models to Deep Learning

πŸƒβ€β™‚οΈ Instructor-paced
⏰ 15 weeks - 10-14 hours per week
InstructorsπŸ‘¨β€πŸ«: Regina Barzilay and Tommi Jaakkola

πŸ”— Course Link

#machinelearning #python
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
❀3
Cool API quick reference PDF πŸ‘‡
πŸ”₯4
πŸš€ Give Name To Our Platform! πŸš€

Hey friends! πŸ‘‹

Remember the platform I mentioned earlier – the one that we are building and that will share free courses, books, coupons, APIs and more for programmers? Well, it’s almost ready… but it still needs a name! 🌐✨

Name needs to be short and catchy. Drop your best ideas in the comments. The winning entry will not only get a Amazon/Google/Flipkart gift card or a paid course of your choice, but will also have the bragging rights of saying:
I named that platform!

πŸ’‘πŸ”₯

Let’s see your creativity! πŸ™Œ

PS. to check if that domain name is taken you can use namecheap

Love from @bigdataspecialist ❀️
❀5
Forwarded from Cool GitHub repositories
FreeDomain

DigitalPlat FreeDomain is a nonprofit initiative that provides free domain names under several non-standard TLDs for everyone. You can register a domain through their dashboard and manage it using your preferred DNS providerβ€”like Cloudflare, FreeDNS, or Hostry.

Creator:   DigitalPlatDev
Stars ⭐️:  89,000
Forked by:  2,000

Github Repo:
https://github.com/DigitalPlatDev/FreeDomain
  
#freedomain      
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–    
Join @github_repositories_bds for more cool repositories. This channel belongs to @bigdataspecialist group
❀5
Mastering Recommender Systems

πŸƒβ€β™‚ Self-paced
⏰ 47 minutes
InstructorπŸ‘¨β€πŸ«: NVIDIA Developer

πŸ”— Course Link

#machinelearning #computerscience
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
πŸ‘3❀1
Few weeks ago a couple of you asked me about data engineering course. I said that I will ask senior data engineer of company I am working for and get back with answers. Unfortunately all courses he shared were paid ones, so I tried finding free ones myself (with help of my friend who already prepared many courses for you).

I found many courses and books and I will share all of them later, tomorrow or maybe next weekend, but here i wanted to share just one course (actually one complete IBM specialization containing 13 courses) from Coursera first and show you how to enroll to it for free.

IBM Data Engineering Professional Certificate
Launch your new career in Data Engineering. Master SQL, RDBMS, ETL, Data Warehousing, NoSQL, Big Data and Spark with hands-on job-ready skills.

There are 13 courses in this program

Course 1: Introduction to Data Engineering
Course 2: Python for Data Science, AI & Development
Course 3: Python Project for Data Engineering
Course 4: Introduction to Relational Databases (RDBMS)
Course 5: Databases and SQL for Data Science with Python
Course 6: Hands-on Introduction to Linux Commands and Shell Scripting
Course 7: Relational Database Administration (DBA)
Course 8: ETL and Data Pipelines with Shell, Airflow and Kafka
Course 9: Getting Started with Data Warehousing and BI Analytics
Course 10: Introduction to NoSQL Databases
Course 11: Introduction to Big Data with Spark and Hadoop
Course 12: Data Engineering and Machine Learning using Spark
Course 13: Data Engineering Capstone Project

These courses are paid but you can enroll to any of these courses for free just by clicking to audit this course. I will share image in this post comment so you can find audit more easily.

PS. Please let me know with reactions and in comments if this post is helpful. This channel takes me lots of energy and even money (yes you read it right - i do pay people to help me find courses) so your reaction is what will help me decide if this fight to help people is actually worth it or not...

#data_engineering #spark #hadoop #nosql #bigdata #linux #databases #rdbms #IBM #coursera #kafka
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for more
❀14πŸ‘7πŸ”₯1
Forwarded from Data visualization
Is Stack Overflow dying?
πŸ‘4
Since the arrival of ChatGPT, Stack Overflow has experienced a sharp decline in activity and number of questions (check chart above ☝️)

Stack Overflow has struggled with a reputation for gatekeeping and unkind responses.
This is how I imagine those bullies right now πŸ˜…
🀣7❀3πŸ‘Ž2
Intro to CS & Programming Using Python – MIT OCW (Fall 2022)

Modern MIT intro‑to‑CS course using Python. Updated in 2022, complete with up-to-date coding exercises and lecture videosβ€”ideal for new learners and self-learners.


πŸ“ Topic: Python fundamentals, algorithms, OOP, recursion
πŸ“‘ Materials: Lecture videos, notes, assignments, quizzes
🎬 10 video lessons

πŸ”— Course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/
πŸ”—Video lessons link: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/download/

#python
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
❀6
🚨 Cloudflare just stopped the largest DDoS attack ever recorded - peaking at 11.5 Tbps.

It lasted only 35 seconds… but experts warn these β€œtsunami” attacks can be smoke screens for data theft and deeper breaches.

For those who want to know more, here’s the link πŸ‘‡

https://thehackernews.com/2025/09/cloudflare-blocks-record-breaking-115.html
😱3❀2πŸ‘2
Fundamentals of Data Engineering Masterclass

🎬 Free Video Lesson
πŸƒβ€β™‚Self Paced
⏰ Duration : 3 Hours
Instructor πŸ‘¨β€πŸ«:  Darshil Parmar

πŸ”— Course Link


#Data_engineering #Data_analysis #Data_modeling #Python
βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–
πŸ‘‰Join @bigdataspecialist for moreπŸ‘ˆ
πŸ‘3❀2
2025/10/26 09:57:22
Back to Top
HTML Embed Code: