Telegram Contest for JavaScript Developers, Round 1

Prize Fund: $30,000
Deadline: 23:59 on February 21 (Dubai time)
Who can participate: Everyone
Results: March 2025

Telegram is hosting a contest for JavaScript developers to implement a new feature in Telegram Web A and enhance the existing part of the app.

Link: https://dev.to/henryclapton/telegram-contest-for-javascript-developers-round-1-4ojg

4 Open Vacancies at Safaricom & M-Pesa Africa

* IT Service Desk Engineer
* M-Pesa Africa - IT Operations Service Governance Specialist
* Commercial Manager, Farmer Solutions
* Financial Products Manager

Apply Here: https://kenyatrends.co.ke/4-open-vacancies-at-safaricom-m-pesa-africa/

𝟏️⃣ 𝗦𝗘𝗟𝗘𝗖𝗧, 𝗪𝗛𝗘𝗥𝗘, 𝗮𝗻𝗱 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬
⤷ Retrieve data from tables
⤷ Filter records with WHERE
⤷ Sort results using ORDER BY

𝟐️⃣ 𝗝𝗢𝗜𝗡𝗦 (𝗜𝗻𝗻𝗲𝗿, 𝗟𝗲𝗳𝘁, 𝗥𝗶𝗴𝗵𝘁, 𝗙𝘂𝗹𝗹)
⤷ Combine data from multiple tables
⤷ Use INNER JOIN for common records
⤷ Use LEFT JOIN to keep all left table records

𝟑️⃣ 𝗔𝗚𝗚𝗥𝗘𝗚𝗔𝗧𝗜𝗢𝗡 (𝗖𝗢𝗨𝗡𝗧, 𝗦𝗨𝗠, 𝗔𝗩𝗚, 𝗠𝗔𝗫, 𝗠𝗜𝗡)
⤷ Summarize and analyze data
⤷ Use GROUP BY for grouped metrics
⤷ Filter groups with HAVING

𝟒️⃣ 𝗦𝗨𝗕𝗤𝗨𝗘𝗥𝗜𝗘𝗦 𝗮𝗻𝗱 𝗖𝗧𝗘𝘀
⤷ Nested queries for advanced filtering
⤷ WITH clause to improve readability

𝟓️⃣ 𝗪𝗜𝗡𝗗𝗢𝗪 𝗙𝗨𝗡𝗖𝗧𝗜𝗢𝗡𝗦
⤷ Use RANK(), DENSE_RANK(), ROW_NUMBER()
⤷ Analyze running totals and moving averages

𝟔️⃣ 𝗘𝗙𝗙𝗜𝗖𝗜𝗘𝗡𝗖𝗬 𝗪𝗜𝗧𝗛 𝗜𝗡𝗗𝗘𝗫𝗘𝗦
⤷ Speed up queries using indexing
⤷ Understand clustered vs. non-clustered indexes

🔗 𝘓𝘦𝘢𝘳𝘯 𝘚𝘘𝘓 𝘍𝘙𝘌𝘌 𝘸𝘪𝘵𝘩 𝘵𝘩𝘦𝘴𝘦 𝘳𝘦𝘴𝘰𝘶𝘳𝘤𝘦𝘴:
⤷ Resources - t.me/sqlresourcestp
⤷ 𝘞𝟹𝘚𝘤𝘩𝘰𝘰𝘭𝘴 - w3schools.com/sql/

Certificates have their own value in proving your skills, but completing a course just for the sake of a certificate won’t help you at all.

What truly matters is how well you understand and apply what you’ve learned.

Whatever course you take, focus on learning, practicing, and mastering the skill rather than just collecting certificates. The real proof of your expertise is in solving real-world problems, not in the number of certificates you have.

That's why I always recommend building Projects. Projects help you apply your knowledge, work with real data and tackle challenges similar to what you’d face in a real job.

They also showcase your problem-solving skills, creativity, and ability to draw meaningful insights—things no certificate alone can prove.

Here, you can find free resources to build skills & projects
👇👇
https://t.me/TechPsyche

Hope it helps :)

🔗 What is an AI Agent?

An AI agent is a software program that can interact with its environment, gather data, and use that data to achieve predetermined goals. AI agents can choose the best actions to perform to meet those goals.

Key characteristics of AI agents are as follows:

* An agent can perform autonomous actions without constant human intervention. Also, they can have a human in the loop to maintain control.
* Agents have a memory to store individual preferences and allow for personalization. It can also store knowledge. An LLM can undertake information processing and decision-making functions.
* Agents must be able to perceive and process the information available from their environment.
* Agents can also use tools such as accessing the internet, using code interpreters and making API calls.
* Agents can also collaborate with other agents or humans.

AI Resources: t.me/airesourcestp

🔗 Neuralink Has Taught Paralyzed Patients to Draw Using Only Their Thoughts!

Elon Musk’s Neuralink has not only enabled paralyzed patients to play video games and control robotic arms, but now they can draw using only their thoughts!

How Does It Work?

💡The Neuralink chip detects brain signals and translates them into cursor or brush movements.

🖌 Patients mentally control a virtual hand, drawing lines, shapes, and even intricate patterns.

🎨 This breakthrough opens new possibilities for self-expression, rehabilitation, and therapy for people with disabilities.

🚀 What’s Next?

Neuralink aims to refine the technology so that users can not only draw but also write, operate complex systems, and even "telepathically" interact with machines.

Read Here: https://dev.to/techlyst/neuralink-has-taught-paralyzed-patients-to-draw-using-their-thoughts-5b86

Languages used by data engineers:

📍SQL
📍Python
📍Scala
📍Pyspark
📍Spark SQL

What is Python?

- Python is a programming language 🐍

- It's known for being easy to learn and read 📖

- You can use it for web development, data analysis, artificial intelligence, and more 💻🌐📊

- Python is like writing instructions for a computer in a clear and simple way 📝💡

- Python supports working with a lot of data, making it great for projects that involve big data and statistics 📈🔍

- It has a huge community, which means lots of support and resources for learners 🌍🤝

- Python is versatile; it's used in scientific fields, finance, and even in making movies and video games 🧪💰🎬🎮

- It can run on different platforms like Windows, macOS, Linux, and even Raspberry Pi 🖥️🍏🐧🍓

- Python has many libraries and frameworks that help speed up the development process for web applications, machine learning, and more 🛠️🚀

Python Resources: t.me/pythonresourcestp

Being a "real" data scientist isn't about:

- Your degrees
- Knowing every algorithm
- Building complex models

It's about:

- Solving real problems
- Using the right tool (sometimes it's SQL!)
- Delivering actual value

Data Science Resources: t.me/datascienceresourcestp

Top 10 Computer Vision Project Ideas
1. Edge Detection
2. Photo Sketching
3. Detecting Contours
4. Collage Mosaic Generator
5. Barcode and QR Code Scanner
6. Face Detection
7. Blur the Face
8. Image Segmentation
9. Human Counting with OpenCV
10. Colour Detection
More Resources: t.me/AIResourcesTP

𝗧𝗼𝗽 𝟭𝟱 𝗚𝗮𝗺𝗲 𝗗𝗲𝘃 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀
1. C++: AAA games (Unreal)
2. C#: Unity, indie game
3. JavaScript: Web game
4. Java: Android game
5. Python: Prototypes (Pygame)
6. Lua: Scripting (Roblox)
7. Swift: iOS games
8. Objective-C: Legacy iOS/macOS
9. Rust: System-level (Amethyst)
10. Go: Multiplayer servers
11. HTML5 + JS: Simple 2D games
12. Kotlin: Android apps
13. Haxe: Cross-platform 2D
14. TypeScript: Scalable web games
15. Ruby: Lightweight 2D games
More Resources: t.me/techpsyche

9 API-based project ideas
1. QR code generator
2. Weather app
3. Translation app
4. Chatbot
5. Geolocation app
6. Messaging app
7. Sentiment analysis
8. URL shortener
9. Music player
More Resources: t.me/techpsyche

You could completely change your life by the end of this year.

You could take another job, start learning a new language or skill, cut out junk food and start working out. You can do anything!

You have 100% control over your life.

Sometimes it doesn't feel like it. Like your life is passing you by, but you could make huge changes today that could effect the rest of your life.

Make a plan and do it!

Here are some free coding resources:

1. Codecademy: Interactive coding lessons.

2. freeCodeCamp: Comprehensive web development curriculum.

3. Coursera and edX: Free audit options for courses.

4. MIT OpenCourseWare: Free course materials from MIT.

5. Khan Academy: Beginner-friendly coding lessons.

6. MDN Web Docs: Web development documentation.

7. GitHub Learning Lab: Hands-on Git and coding courses.

8. W3Schools: Tutorials and reference for web technologies.

9. Hackerrank: Coding challenges and competitions.

10. Project Euler: Math-based coding problems.

11. YouTube: Many coding tutorial channels available.

More Resources Here: t.me/techpsyche

Sample email template to reach out to HR’s as fresher

Hi Jasneet,

I recently came across your LinkedIn post seeking a React.js developer intern, and I am writing to express my interest in the position at Airtel. As a recent graduate, I am eager to begin my career and am excited about the opportunity.

I am a quick learner and have developed a strong set of dynamic and user-friendly web applications using various technologies, including HTML, CSS, JavaScript, Bootstrap, React.js, Vue.js, PHP, and MySQL. I am also well-versed in creating reusable components, implementing responsive designs, and ensuring cross-browser compatibility.

I am confident that my eagerness to learn and strong work ethic will make me an asset to your team.

I have attached my resume for your review. Thank you for considering my application. I look forward to hearing from you soon.

Thanks!

I hope you will found this helpful 🙂

Message: +254781819388 if you need help creating a CV or Resume, Revamping your CV, ATS CV and Cover Letter.
Small Cost will be Charged

YandyTech Community Global Internship Programme

Internships available:
1. Frontend Developer Intern
2. Social Media and Content Creation Intern (2)
3. Grant and Resource Mobilisation Intern
4. Research Intern

Location: Remote (worldwide) 🌎

Link: https://kenyatrends.co.ke/yandytech-community-global-internship-programme/

7 DeepSeek-Powered Prompts to Land Your Dream Job

Prompts Here: https://kenyatrends.co.ke/7-deepseek-powered-prompts-to-land-your-dream-job/

Why Tabular Data Reigns Supreme in the Real World of AI

Read Here: https://dev.to/justdetermined/why-tabular-data-reigns-supreme-in-the-real-world-of-ai-5ena

There has never been a better time to become a data analyst.

Tackle the tools:

- Excel
- SQL
- PowerBI/Tableau
- Python/R

Sharpen these soft skills:

- Communication
- Storytelling
- Critical thinking
- Business acumen

And let your journey begin.

Top 15 advanced Power BI interview questions

1. Explain the concept of row-level security in Power BI and how to implement it.

2. What are calculated tables in Power BI, and when would you use them?

3. Describe the differences between DirectQuery, Live Connection, and Import Data storage modes in Power BI.

4. How can you optimize the performance of a Power BI report or dashboard with large datasets?

5. What is the DAX language, and how is it used in Power BI? Provide an example of a complex DAX calculation.

6. Explain the role of Power Query in data transformation within Power BI. What are some common data cleansing techniques in Power Query?

7. What is the purpose of the Power BI Data Model, and how do relationships between tables impact report development?

8. How can you create custom visuals or extensions in Power BI? Provide an example of when you would use custom visuals.

9. Describe the steps involved in setting up Power BI Gateway and its significance in a corporate environment.

10. What are the differences between Power BI Desktop, Power BI Service, and Power BI Mobile? How do they work together in a typical Power BI workflow?

11. Discuss the process of incremental data refresh in Power BI and its benefits.

12. How can you implement dynamic security roles in Power BI, and why might you need them in a multi-user environment?

13. What are Power BI paginated reports, and when would you choose to use them over standard interactive reports?

14. Explain the concept of drill-through in Power BI, including its configuration and use cases.

15. How can you integrate Power BI with other Microsoft products, such as Azure Data Lake Storage or SharePoint?

Hope you'll like it

Like this post if you need more resources like this 👍❤️

IT and Systems Admin Needed at Luton Hospital

Luton Hospital is looking for a skilled IT and Systems Administrator to join their team!
Key Responsibilities:
🔹 Ensure smooth operation of IT infrastructure
🔹 Manage hospital information systems
🔹 Maintain data security & provide technical support
🔹 Ensure compliance with healthcare regulations
Requirements:
✅ Bachelor’s degree in IT, Computer Science, or related field
✅ 3-5 years of IT administration experience (healthcare preferred)
✅ Strong knowledge of networking, cybersecurity, and system administration
✅ HMIS experience is a plus

📍 Location: Luton Hospital, Ngong Road, Nairobi

Ready to take your IT career to the next level?

Apply Here: https://kenyatrends.co.ke/it-and-systems-admin-needed-at-luton-hospital/