🎓Agri. & Env. Eng, @BukNigeria. -Building Exp in Data Engineering/learning python, Sql, Bi tools. - SDG Advocate /passion for sustainable tech & Data Solutions
"We will not tell you who to vote for because you are a witness of everything happening.
If you like the current price of Petroleum, the poverty and hardship in the country, the insecurity happening, then vote for this Government to continue"
“Why is it that most of the major, religious based crisis we have in Northern Nigeria it is only in Christian dominated areas that we have those faith based crisis?
Why don’t we have it in Kano, don’t we have Christians in Kano? Why don’t we have it in Katsina, Jigawa, Sokoto, Kebbi, don’t we have Christians in those areas?”
- JA’AFAR SANI BELLO
Today it's Sani @Waspapping_, tomorrow it could be you or me.
We may not support his views, but silence is not an option. His arrest is a clear injustice and attack on freedom of expression.
Free Waspapping now! #FreeWaspapping
I have learned that the lawless Department of State Services (DSS) has arbitrarily and unlawfully detained a social media influencer known as Sarki @Waspapping_.
He was reportedly arrested over comments he made about the Israel–Iran war, particularly criticisms directed at the State of Israel over its egregious warmongering and crimes against humanity in Gaza and elsewhere.
No Nigerian citizen should be arrested or detained simply for expressing opinions about the actions of foreign governments or commenting on ongoing international conflicts. Freedom of expression must apply equally to discussions about global affairs and acts of war involving foreign interests.
The DSS must therefore immediately release Sarki @Waspapping_ and end this unlawful detention.
Nigeria cannot claim to be a democracy while citizens are arrested for expressing views on international events.
#FreeWasPappingNOW.
Someone literally built a free AI university - all in one repo, covering real-world AI systems step by step
Link - github.com/jamwithai/arxi…
Here’s what you’ll learn:
Week 1 - Setup everything
Docker, FastAPI, databases
Beginner-friendly foundation
Week 2 - Feed it real data
Automatically fetch research papers
Fully automated data pipeline
Week 3 - Teach it to search
BM25 keyword search implementation
Your own Google-like search system
Week 4 - Make it smarter
Hybrid search enabled
Understands meaning, not just keywords
Week 5 - It talks back
Complete RAG system
Ask questions, get accurate answers
Week 6 - Production ready
Caching and monitoring added
Runs like a real product
Week 7 - Give it a brain
Agentic AI with LangGraph
Even works with Telegram
The Chairman of the US Joint Chiefs of Staff was dismissed after warning Trump about the consequences of an attack on Iran.
According to Reuters, after the warning from the head of the Pentagon's Joint Chiefs of Staff, Fred Kacher, to Trump about an attack on Iran leaked to the media, he was dismissed from his position, having served in it for just 3 months.
💔 Arewa, wake up.
Kidnapping Survivor Who Paid ₦100M Ransom Joins ADC, Sounds Alarm on Nigeria’s Deadly Crisis.
Ismail Sahabi, kidnapped on the Kaduna Abuja Expressway, cited ₦2 trillion in ransoms, 600,000 annual killings in Nigeria mostly in the North & warned against supporting President Bola Tinubu & the APC.
💔😭 Fear drives her to call the Army Commissioners all they want is peace. Seeing videos like this about insecurity breaks my heart May Allah restore peace and unity in Nigeria.
Bauchi is bleeding. Katsina is mourning. Kebbi is grieving. Zamfara is under siege.
Benue isn't safe. So is Plateau.
Families are being torn apart by bandits and terrorists.
Children are orphaned. Mothers are burying their sons.
Villages are burning.
Yet, the political class is already consumed with campaigns, alliances, and 2027 permutations.
What is the value of power if the people are not safe?
What is democracy without security?
What is leadership without responsibility?
Northern Nigeria cannot continue like this. We cannot normalize mass killings. We cannot normalize silence. We cannot normalize excuses.
Lives must matter more than elections.
History will remember who spoke up; and who stayed silent.
#SaveNorthernNigeria
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
AREWA IS BLEEDING 🩸
Quote and repost please 🙏🏻
They are killing us, yet the government is saying nothing. They have turned all our children into orphans; there is no compassion. By Allah, we will not forgive.
Our children went for Tafsir (Qur’anic lessons). On their way back, they were ambushed, slaughtered, and all of them were killed.
AREWA 💔💔
Data Engineering Zoomcamp has gained over 38,000 stars on GitHub 🎉
Thank you for your interest and support.
If you're interested in learning data engineering, this is an excellent starting point!
Learn here: github.com/DataTalksClub/…
I need study partners for people whose new year's resolution is to study Data Analytics. Those who are serious and want to lock in like mad serious. Let create a WhatsApp group and be sharing our daily and weekly progress or challenges there. Comment below I will DM y'all and create that WhatsApp group. Mentors too are encouraged to join for guidance.
> SQL Interview Questions Frequently Asked by Adobe (Beginner → Advanced)
1. BEGINNER (10 Questions): SQL Fundamentals + Product Analytics Thinking
→ Difference between WHERE, HAVING, and QUALIFY, how would Adobe expect you to use each in product analytics queries?
→ Explain INNER JOIN, LEFT JOIN, and CROSS JOIN using examples from user events, page views, or campaign data.
→ How does SQL handle NULLs in filters, joins, and aggregates, why this matters for Adobe Analytics data?
→ COUNT(*), COUNT(1), COUNT(column), what differences actually matter in large analytical datasets?
→ What happens when you run ORDER BY on large tables without LIMIT, why this is risky in Adobe-scale data?
→ UNION vs UNION ALL, when deduplication breaks funnel or attribution analysis?
→ Primary keys vs surrogate keys, which one fits better for event-based product data and why?
→ What is an index, and why columnar analytics systems (like those used at Adobe) rely less on them?
→ DELETE vs TRUNCATE, how does this differ in data warehouses vs transactional databases?
→ Normalization vs denormalization, when denormalized schemas are preferred for reporting and dashboards?
2. INTERMEDIATE (10 Questions): Analytics, Funnels & Business Metrics
→ Write a query to find the second highest metric per dimension (e.g., revenue per campaign).
→ Identify users with consecutive-day activity from Adobe-style event logs.
→ Rank pages, features, or campaigns using window functions.
→ GROUP BY vs window functions, when grouping destroys valuable user-level context.
→ Explain ROW_NUMBER, RANK, DENSE_RANK using A/B tests or feature adoption examples.
→ Detect duplicate events caused by retries or tracking issues.
→ Given daily user activity, find users active all 7 days of a week.
→ Correlated vs non-correlated subqueries, performance implications in analytical workloads.
→ How do you validate analytics queries to ensure dashboards and KPIs are trustworthy?
→ CTEs, when they improve readability vs when they silently hurt performance.
3. ADVANCED (10 Questions): Large-Scale Analytics & Data Engineering
→ Write a query to get top N items per category efficiently on billions of rows.
→ Detect missing or delayed events in time-series user interaction data.
→ Calculate retention, churn, and conversion funnels using pure SQL.
→ Design sessionization logic using timestamps and inactivity thresholds.
→ Compute rolling metrics (7-day averages, cumulative metrics) efficiently.
→ How does distributed SQL execution differ from traditional single-node databases?
→ Explain query optimization in columnar storage (predicate pushdown, partition pruning).
→ How do you handle data skew in joins at Adobe-scale event volumes?
→ OLTP vs OLAP, why Adobe products are fundamentally OLAP-driven.
→ How would you design tables for petabyte-scale analytics with frequent reads and evolving schemas?
Data Engineering Roadmap you can start looking into as you plan ahead for 2026.
It might look overwhelming but take it one step at a time. The Link has detailed information.
Linux → Python → Git → DSA
SQL → Data Modeling → Postgres
ETL → Airflow
Cloud + Parquet + Iceberg + dbt
PySpark → Kafka
Docker → Terraform → Observability
If you find it useful, Share it with others. We will grow our community.
speckle-bluebell-417.notion.site/Data-Engineeri…