teleren/devto huggingface dataset:
🔗 Linking Gender Equality UN SDGs and country's Open Data
Tags: datascience, techtalks, opendata, showdev
Published: 2024-04-10 20:48:27

## 💭 About

Imagine the following data:

- **🎯 A set of strategic goals** (and related KPIs) described from APIs
- **🗂️ A collection of datasets**, delivered as `csv` (and metadatas)

... now imagine you have **a set of keys that make it possible to link them.**

👉 This pattern is a very common one, both **for profit or non-profit organizations as any organization's aim is to achieve strategic goals... and if it's data-driven...based on data.**

## 🎯 What we'll do

Well, this is what was done during my `#NODES23` session, and today I'll show the benefits of this approach on a very concrete case : **discover everything we can know about women in a country, from a strategic data-driven perspective, interactively and within less than 10'.**

In our case, we'll use : 

- **🎯 Strategic goals** from [UN SDGs](https://sdgs.un.org/goals) and Open Data from [Pacific Data Hub](https://pacificdata.org/) 
- **🗂️ Datasets** from [`data.gouv.nc`](https://data.gouv.nc/) Open Data

## 🍿 Demo

{% youtube b6wBSTHZh20 %}


## 📕 _"Metadata Matters"_

Notice that this work was made possible by computing and putting metadatas together to reach higher levels of knowledge.

> "Metadata Matters explains how metadata is the foundation of digital strategy. If digital assets are to be discovered, they want to be found. The path to good metadata design begins with the realization that digital assets need to be identified, organized, and made available for discovery." - John Horodyski

[![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/069oo3spl79eonq6bofi.png)](https://www.metadatamatters.guide/)
Make an alias for existing branch
Tags: git
Published: 2024-04-10 20:42:58

---
title: Make an alias for existing branch
published: true
description:
tags: git
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3ezumsv3r7llh0x3meek.jpg
---

> Photo by <a href="https://unsplash.com/@afgprogrammer?utm_content=creditCopyText&utm_medium=referral&utm_source=unsplash">Mohammad Rahmani</a> on <a href="https://unsplash.com/photos/a-close-up-of-a-keyboard-on-a-table-lPKIb8dJ8kw?utm_content=creditCopyText&utm_medium=referral&utm_source=unsplash">Unsplash</a>
  

If you happened to miss the `master` branch and your organization uses the more populistic `main` naming convention as the default branch, don't worry!
You can easily switch back to the previous environment without causing any issues using a simple Git alias command.: 

```shell
$ git symbolic-ref refs/heads/master refs/heads/main
```

This tool won't replace everything, but it can help you use old commands like:

```shell
$ git checkout master

$ git rebase -i master

$ git diff master
```
The Challenge for Non-Technical Founders: Bridging the Technical Empathy Gap
Published: 2024-04-10 20:18:47

In the tech landscape, it's possible for non-technical individuals to rise as outstanding founders. However, the companies that leave a significant mark tend to have leaders with a deep technical background. This "technical empathy" - an innate understanding of and connection to the process of engineering technology solutions - is a distinct edge.

Technical know-how is not just about expertise; it's about an empathetic connection to the process of engineering development, a quality seldom found in those without a technical grounding.

Consider Nvidia's Jensen Huang: although he may not be hands-on with GPU design now, his background equips him with a profound understanding of his team's challenges and the subtleties of their work. This kind of technical empathy, born from direct technical experience, is a hallmark of tech industry luminaries such as Elon Musk (Tesla, SpaceX), Bill Gates (Microsoft), and Mark Zuckerberg (Meta), Larry Page/Sergey Brin (Google), Steve Wozniak (Apple), Linus Torvalds (LINUX, Git), Henry Samueli (Broadcom), Larry Ellison (Oracle) & Irwin Jacobs (Qualcomm) among others.

Yet, this brings us to a critical point: my discussions with over 400 senior engineering leaders have revealed a nuanced issue in Scrum and Value Stream Management (VSM) as they are conventionally practiced. There's an inherent lack of technical empathy baked into these methods, leading to ineffective management of Technical Debt. This oversight lets Technical Debt accumulate unchecked, eroding software developers' productivity, particularly noticeable within just 2-3 years of Agile sprints.

Non-technical founders and co-founders encounter a specific challenge: rigid adherence to Scrum or VSM methodologies doesn't fully meet the complex demands of engineering teams or promote lasting agility. I think the reason engineering leaders often view Scrum and VSM with skepticism (and often with disdain) is due to the absence of technical empathy within these frameworks. If you're keen on exploring this issue further, consider reaching out using our [contact page](https://www.edensoftlabs.com/71-2/contact/) for a sneak peek at our upcoming whitepaper. It aims to highlight these challenges and suggest methods for overcoming the technical empathy gap in leadership practices.
Passing The DataCamp SQL Associate Certificate
Tags: sql, datacamp, certification
Published: 2024-04-10 20:11:05

---
title: Passing The DataCamp SQL Associate Certificate
published: true
description: Tips and Concepts for Acing the DataCamp Cert Exam
tags: SQL,DataCamp,Certification
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pok1svpk995ppo020ojt.jpg
# Use a ratio of 100:42 for best results.
# published_at: 2024-04-07 15:05 +0000
---

I just passed the DataCamp SQL Associate Exam. Here's a short list of concepts you should be comfortable with for the exam, and some notes I have about the exam itself.

## Timed Quiz Portion

The timed quiz portion of the exam tests your knowledge on SQL syntax, queries, data manipulation, and general knowledge database management concepts like normalization, data modeling.

Here's a shortlist the SQL concept(s) covered. If you're familiar with the terms, or have used them at least once, you'll be able to answer most questions.

- Joins: LEFT JOIN, FULL JOIN, INNER JOIN, UNION, UNION ALL

- String Manipulation: UPPER, LOWER, LIKE, ILIKE, ~, REGEX, TRIM, LEFT, RIGHT

- Date Manipulation: DATE_PART, DATE_TRUNC, TO_CHAR

- Number Manipulation: ROUND, TRUNC

- AGGREGATE FUNCTIONS: MAX, MIN, AVG, percentiles


The more general database questions may require taking the DataCamp courses because they seem to expect you to use the same language that instructors use in those courses.

## Timed Practical Exam Portion

The timed practical exam is a mutli-part question where you write queries for some provided tables.

Most of the queries require simple joins, where clauses, and occasionally manipulating data such as missing values.

DataCamp provides a practical exam that's a good reference point for if you're ready. If you can complete the practice exam, you are more than prepared to complete the practical exam. 

When you take the practical you're given 4 hours to complete it. If you've done the practice exam, you can complete much faster than in 4 hours.

You'll need to be able to:
- Join tables together
- Use subqueries and where clauses to filter out data
- Manipulate data to handle missing values, or set default values for columns

## Preparing for the Certification Exam
Based on the exam(s) and the courses I've taken, these DataCamp courses reflect the content that I saw on the exam:

- SQL for Business Analysts
- Functions for Manipulating Data in PostgresSQL
- Manipulating Data in SQL
- Database Design
- Joining Data in SQL

If you want more SQL practice outside of DataCamp courses, I've used DataLemur, and StrataScratch to practice SQL data analysis questions.

## Taking the Exam

Overall, I thought the exam felt like a survey of beginner to intermediate SQL knowledge. The timed exam has a handful of tricky questions, but overall a general understanding of SQL should allow you to a pass. The practical exam is also beginner to intermediate level SQL. If you know how to join tables, use filter clauses like WHERE and IN, manipulate text and numbers, and set default values, you can pass the exam.
Planning for deprecation of dependencies
Published: 2024-04-10 19:55:06


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jw9ow1y9fftt9la3j9ex.png)

As time marches on, so does technology. Either you adopt to the changes as they approach, or wake up to A Bad Day at work. That's what happened to one of my customers way back in 2013 when they found they could not connect RDP to their fleet of >1000 Windows instances because they were not updating the images, even though the breaking change was communicated for 3 years prior. Restarting the instances with a user data Powershell script to update the instances fixed the issue, but it took a few days of development and testing before services were back online.

**Don't have a bad day and take a look at your stack for possible deprecation!**

Here are three examples that you may want to pay attention to if you work on AWS:

1. The Amazon EC2 Instance Metadata Service will be switching to IMDSv2 for new instances this summer. You can read more about that in this [blog post](https://aws.amazon.com/blogs/aws/amazon-ec2-instance-metadata-service-imdsv2-by-default/). While you can still turn on v1, there are [good security reasons to migrate](https://aws.amazon.com/blogs/security/defense-in-depth-open-firewalls-reverse-proxies-ssrf-vulnerabilities-ec2-instance-metadata-service/). Read the docs on how to [transition from v1 to v2](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-metadata-transition-to-version-2.html) today!

2. The AWS Go SDK v1 [will enter maintenance mode](https://aws.amazon.com/blogs/developer/announcing-end-of-support-for-aws-sdk-for-go-v1-on-july-31-2025/) and be unsupported effective June 31, 2024. Time to update all those Terraform scripts! 

3. While Amazon Linux 2 End-Of-Life was extended to 2025, you should really start migrating to AL2023 as soon as possible. There are lot of fundamental differences that have a high chance of disrupting your applications if you do not test them. Read more about that the [differences in the AL2 and AL2023](https://docs.aws.amazon.com/linux/al2023/ug/compare-with-al2.html) in the documentation and make plans to migrate within the next 6 months. 

These are just a couple of the examples I had conversations about in the last few weeks, there are more. It's worth repeating: 

**Don't have a bad day and take a look at your stack for possible deprecation!**
Why Isn't AI As Smart As We Always Expect?
Tags: chatgpt, beginners, ai, productivity
Published: 2024-04-10 19:43:19

Let me share a personal experience that changed how I use AI (Artificial Intelligence).

I was developing an application that generated two spreadsheets from different sources. After gathering the information, I needed to merge these sheets. I decided to leverage AI to handle the task, and it completed the merge. However, there was a problem: the first row of the new sheet was blank.

Here's where my thinking shifted. I explained the issue to the AI, and it provided code that attempted to avoid the blank row during the merge. Unfortunately, this solution didn't work. The AI kept trying variations on the same approach –  focusing on removing the blank row while merging. It was like a robot stuck in a loop, repeatedly applying the same unsuccessful solution.

This made me question the AI's "intelligence." Why wasn't it trying a different approach?

With that in mind, I suggested: "Why not merge the sheets first, ignoring the blank row, and then address it afterward?"

Eureka! The AI followed my suggestion and solved the problem, saving me time. This experience transformed my perspective on AI. I began to view them as powerful automation tools, recognizing that I provide the ideas and creativity. My prompts to the AI have evolved significantly.

Now, I prefer to offer guidance or analyze the proposed solution and provide feedback. In other words, I don't expect the AI to be creative or independently assess its solutions.  I am the intelligence; the AI is an extension of me.

By adopting this mindset, I'm unlocking the true potential of AI. I hope this experience helps others move beyond initial misconceptions about how AI can be effectively utilized.
New Beginnings
Tags: firstpost, frontend, webdev, javascript
Published: 2024-04-10 19:11:46

Hello world!👋🏾 and welcome to my first article. I created this blog with the hope that I can improve my coding skills, ability to write and also share what I'm learning. A place I can always refer to for my growth and in doing so share my knowledge and failings.

Here's a bit about me:
 My name is **Jonathan Roy Mugisha** and I'm a software developer and I'm currently learning JavaScript and building projects. Best way to master any skill. When I'm not coding, I read books, play video games and do sports.

If all goes to plan, I'll be sharing what I learn on here on my journey to becoming Full-Stack. It's never too early for feedback. Thanks for reading and see you in the next one!✨
Dasturlash tili?
Tags: bilarmidingiz
Published: 2024-04-10 18:59:45

Hamma har xil o'ylaydi.Biladiki dasturlash olami.Men uchun bu olam boshqa olam.Ya'ni nisbiy tushuncha bu bilan boshqa bir dunyolarni emas.Bu bir til coding olami deb tushunsangiz bo'ladi.Ajoyibligi oddiy keyboard va methodlar orqali nimadir ishlab chiqilad.Ha bu narsalar hozirgi zamonda oddiy tuyulishi mumkin.Lekin baribir coding ajoyib.Insonga ajoyib taffakur berilgan, bu bir ne'mat...
Keling endi bu olamga kiramiz "Javascript" skriptlangan dasturlash tili."Dasturlash tili" => aslida biz komputer bilan muloqot.Yaxshi grammatikasini, gapirishni bilmasangiz sizni azoblaydi.Albatta hazil.Biz concept va ishlab topilgan methodlar orqali, komputer bilan gaplashamiz deb tushunsak bo'ladi.Yani ingliz tili orqali boshqa foreign(chet el) odamlari bilan muloqat olib, ular bilan ishlash kabi.


 
Ho'p scriptlangan dasturlash tili => Javascript haqida tarixi haqida ko'plab ma'lumotlar tarixini internetdan bilib olganingiz yaxshiroq.Ko'proq conceptlarga tayanganimiz muhimroq ekan.Biz oldin interactivelik haqida gaplashgan edik.Ho'p bu til intractivelikka yordam beradi...

Javascript =>  Javascriptning hozirgacham 6 ta versiyasi chiqqan.
Keling Hello world yozamiz.

let a = "Hello world";
console.log(a);
                natija esa: Hello world 

Syntax => bu ingliz tilidagi grammatikaga o'xshaydi.
//=>used for comment =>     // let a = "Hello world" //
;=>semicolon ishlatishimiz shart =>   let a = "Hello world";
{}=> bu scopelar haqida biror bir funksiy yozilganda gaplashamiz.

Ertaga o'zgaruvchilar haqida gaplashamiz see you.
hello world asl mohiyatini bilib olamiz...
Ставки 777
Published: 2024-04-10 18:35:19

[Топ-5 самых популярных видов ](http://1xbet-officialnyi-sait.ru/)ставок: их особенности и стратегии

Ставки представляют собой увлекательный и азартный вид досуга, который позволяет участвовать в спортивных и других событиях, добавляя в них интерес и азарт. Существует множество различных видов ставок, но некоторые из них выделяются особой популярностью. Вот топ-5 самых популярных видов ставок, их особенности и стратегии.

1. Ординарная ставка
Ординарная ставка - самый простой и распространенный вид ставок. Здесь вы делаете прогноз на исход одного события, и если ваш прогноз оказывается верным, вы выигрываете. Основная стратегия - тщательный анализ и информированность о событии, на которое вы ставите.

2. Экспресс-ставка
Экспресс-ставка представляет собой комбинацию нескольких ординарных ставок. Выигрыш возможен только в случае, если все ваши прогнозы оказываются верными. Здесь важна балансировка между вероятностью и выигрышем, а также предельный размер экспресс-ставки.

3. Live-ставка
Live-ставка предполагает заключение ставок в режиме реального времени во время игры или соревнования. Основная стратегия - быстрая реакция на изменяющиеся обстоятельства и умение четко оценивать текущую ситуацию.

4. Тотализатор
Тотализатор - это игровая форма, где участники ставят деньги на общий банк, который потом делится между теми, кто правильно угадал исход события. Основная стратегия - сбалансированное выбор ставок с учетом возможной прибыли.

5. Фора
Фора предполагает учет фактического положения команд или участников турнира при принятии ставки. Основная стратегия - анализ формы команд, составов и психологического настроя игроков.

В зависимости от ваших предпочтений и понимания событий, можно выбрать то, что больше всего подходит для вас. Так или иначе, ключ к успеху в ставках - это информированность, анализ и разработка собственной стратегии.

Если хочешь зарабатывать, то играй  на http://1xbet-officialnyi-sait.ru/  #rich #мелстроймемы #mellstroy #money
Ставки
Tags: webdev, beginners, javascript, programming
Published: 2024-04-10 18:33:46

Лайв-ставки: как выиграть, делая ставки во время спортивных событий

[Лайв](http://1xbet-officialnyi-sait.ru/)-ставки, или ставки в режиме реального времени, становятся все более популярными среди азартных игроков. [Возможность](http://1xbet-officialnyi-sait.ru/) делать ставки на спортивные события во время их проведения открывает уникальные возможности для тех, кто умеет анализировать игровую ситуацию и принимать соответствующие решения. Вот несколько стратегий, которые могут помочь вам выигрывать, делая ставки во время спортивных событий.

1. Будьте внимательны к событиям на поле
Одна из ключевых стратегий для успешных лайв-ставок - это умение тщательно следить за спортивными событиями, на которые вы делаете ставки. Внимательно наблюдайте за ходом игры, формой команды, физическим состоянием игроков. Это поможет вам лучше понимать, какие ставки можно сделать, исходя из текущей ситуации.

2. Используйте статистику
Знание статистики прошлых матчей, процентов владения мячом, количество ударов в створ ворот поможет вам принимать более обоснованные решения при проведении лайв-ставок. Статистика может говорить о тенденциях и предпочтениях команд, что может поспособствовать прогнозированию исхода матча.

3. Быстрые реакции
Лайв-ставки требуют от игрока быстрой реакции на изменяющуюся ситуацию на поле. С учетом того, что коэффициенты меняются очень быстро во время матча, игроку необходимо быстро анализировать ситуацию и делать ставки в момент, когда он видит подходящую возможность.

4. Управление банкроллом
Важно помнить о ставках и контролировать свой банкролл. Используйте правило о не ставить более 5% от вашего общего банкролла на одну ставку. Это поможет вам сохранить финансовую устойчивость и уменьшить риски потерь.

5. Используйте ставки на результаты второго тайма
Исследования показывают, что многие матчи имеют другую динамику и характер во втором тайме. Используйте этот факт для делания ставок на изменение ситуации и результат во втором тайме матча.

Лайв-ставки требуют аналитического мышления, быстрой реакции и умения принимать быстрые решения. Помните, что они также могут быть рискованными, поэтому важно быть осторожными и контролировать свои ставки. Всегда помните, что азартный досуг должен быть разумным и контролируемым.

Если хочешь зарабатывать, то играй  на http://1xbet-officialnyi-sait.ru/  #rich #мелстроймемы #mellstroy #money
Next.js Intercepting Routes 101
Tags: webdev, nextjs, javascript, react
Published: 2024-04-10 18:31:57

Recently, I was working on a side project where I encountered a problem that piqued my interest.

I wanted to create a modal with the same content as the authentication page without opening the page itself and displaying it inside the home page when I clicked on the sign-in button.

This is where I came across Intercepting Routes in Next.js 14.

In short, it does what I wanted it to do. It helps you display specific content that is normally under a different route, and when you refresh, it takes you to the route of the displayed content and loads its page.

The syntax may seem a bit strange, but it is as follows (the example I will explain is in the images):

Create a folder prefixed with @, which we call a slot. Like dynamic routes, the slot does not appear in the params.

Here, to display the content of the page under the sign-in route, I create a folder prefixed with (.) and named the route with the same name as the targeted route. Under the folder, you create your UI as usual and call the same functionality to perform the same task.

Finally, you create a default file to act as a fallback if the route does not exist or if an error occurs.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2wdiez8l37ym8d9oo9it.png)
Calculate Module of negative values FASTER.
Tags: cpp, algorithms, math
Published: 2024-04-10 18:31:38

Many of us have attempted to calculate the absolute value of negative numbers at some point then went to Stackoverflow and tried to find an answer and probably found this code:
```
// C/C++
int module(int a, int b) {
    return ((a % b) + b) % b;
}
```
HOWEVER it is doing two divisions (module same thing for x86-cpus)
You probably know divisions is a terribly slow operation
Exactly 7-15 times slower than addition operation in modern cpus

BUT you can lower this division usage in your module calculation this way:
```
int module(int a, int b) {
    return (a % b) + (((a ^ b) >> 31) & a);
}
```
This way uses trick checks if a * b is negative but you won't gonna see any multiplication or '<' symbol:
((a ^ b) >> 31) this part does the job (a ^ b) is calculating a * b s symbol and '>> 31' this making sign bit to copy 31 times into all bits.
Navigating the Tech Landscape: How Tech Institutes Are Adapting to Industry Shifts
Tags: education
Published: 2024-04-10 17:57:04

Founded in 1991, [Sabaragamuwa University of Sri Lanka](http://www.sab.ac.lk) is situated at Belihuloya, Balangoda. The institution, which is located in the picturesque and environmentally stunning Sabaragamuwa Province, provides a broad range of undergraduate and graduate programmes in subjects like the natural sciences, social sciences, management studies, agricultural sciences, humanities, and applied sciences.

Along with state-of-the-art amenities including lecture halls, labs, libraries, computer centres, and sports facilities, the university campus also offers dorms for its students. These facilities offer a favourable setting for education and research.

Apart from teaching and research, the institution also promotes extracurricular, cultural, and athletic involvement among its students. Campus clubs, societies, and organisations serve a wide range of interests and promote personal development outside of the classroom.
Benching Plan with emBench
Tags: node, typescript, express, benchmark
Published: 2024-04-10 17:25:41

Have you ever thought of expressing the node with some benchmark? How your API behaves, when you look away. 😂 Yes, it might put that `GET` into the cookie jar.

Without being too long, There is a package you might want to try and test out for you naughty API's. 

It is designed for Express.js API's on TypeScript and JavaScript support. Very lightweight to keep everything under wraps. Basically, it runs when an endpoint is invoked. Gives the start, end and duration it took for the endpoint to do its magic.

{% embed https://www.npmjs.com/package/em-bench %}

Shoot in the dark, and hope you get target. Don't forget to do the basics.

Till never like next time. 🕊