teleren/devto huggingface dataset:
PostgreSQL Basics: Exploring Column Alias
Tags: postgres, postgressql, beginners, tutorial
Published: 2023-07-04 08:14:11

In this tutorial, we will be exploring column alias and how to assign temporary names to different columns.

## Introduction
Column aliases are used to assign temporary name to column or expression in SELECT statement. The whole purpose of aliases is to provide meaningful names to the outputs.
We use these aliases to also merge results from two different columns for creating more meaningful single columns.
For example: extracting first name and second name from table and then merging those results and giving them name as Full name using alias.

## Basic Syntax

```
SELECT column_name AS alias_name
FROM table_name;
```

alias_name is used instead of column_name in the result of above query.

**Note: **The AS is optional here. Hence, removing AS from the above query will provide similar result.

**Note: **For using alias with spaces in between, alias should be placed inside "". Following is an example demonstration.

```
SELECT column_name AS "alias name"
FROM table_name;
```
## Examples

Assume we have customer table and we run following query.

**Code**

```
SELECT first_name, last_name
FROM customer;
```
**Output**
![Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/p3bcf8mij2snnfp1ue3a.png)

Now assume, in our particular case, surname is more commonly used instead of last name.
Hence, we need to rename our column name as surname as it's more understandable in our region. This is where we could use Alias!

**Code**
```
SELECT first_name, last_name AS surname
FROM customer;
```

**Output**

![Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iztty8e5pvs2d8ob31cx.png)

As, you can see last name is changed to surname.

Now, we gonna look at the example where we combine fist name and last name as talked about earlier.

first, let's just combine them, later we gonna use alias to give it meaningful name.

**Code**

```
SELECT first_name || ' ' || last_name 
FROM customer;
```
**Note: ** `||` is an operator, used in postgreSQL to concatinate two or more strings.

**Output**

![Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6yr1u1shzb5z77c1qyhc.png)

As, you can see, we do have a required result but with no meaningful heading. Hence, now we would use Alias to give this expression meaningful name as full_name.

**Code**

```
SELECT first_name || ' ' || last_name AS full_name
FROM customer;
```
**Output**

![Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4wu1aeuzakw2b8vl1a7i.png)

Now, we will explore the use of "" in alias to give our result Full Name as Alias.

**Code**

```
SELECT first_name || ' ' || last_name AS "full name"
FROM customer;
```

**Output**

![Table](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xvg9viycnbtkcfq4hxtz.png)

That's it for now!
🎉🇺🇸 Happy #IndependenceDay, July 4th: Celebrating This Valuable Date and in the #Tech World 🎉🎆🥳🎇
Tags: startup, webdev
Published: 2023-07-04 07:50:47

The amazing achievements of #startups and entrepreneurs have had a significant impact on the concept of independence and freedom in the ever-changing world of #technology. They have transformed industries, empowered individuals, and changed societies 🌟

Here is a list of startups and new ventures that support independence, the United States as a developed nation, and substantial contributions to global development 🚀: 

🟢 Robinhood - Commission-free stock trading app and #investment #platform.
🟢 23andMe - Genetic testing and personal genomics company.
🟢 Patreon - Membership platform that enables artists and creators to get paid by their fans.
🟢 Calm - Meditation and sleep app for stress reduction and better sleep.
🟢 Buffer - Social media management tool for scheduling and analyzing posts.
🟢 Skyscanner - Travel search engine that compares flight, hotel, and car rental prices.
🟢 Honey - Browser extension that automatically finds and applies coupon codes when shopping online.

These startups may not be as well-known as some of the larger #IT behemoths, but they have grown in popularity and are making significant contributions in their respective fields. 

#Hire developers for your startup with [Devler.io ](https://devler.io/) - Platform for #matching top #developers with clients. 

Let’s expand this list together! What else can be added to this line? Write in the comments below 💡
#LearnedToday: Web Speech API
Tags: javascript, learnedtoday, texttospeech, browserapi
Published: 2023-07-04 07:46:45

🗣 Do you know that you can make your browser talk?

...What if I told you that all you have to do is write ONE line of JavaScript code?

Thanks to the [WebSpeechAPI](https://developer.mozilla.org/en-US/docs/Web/API/Web_Speech_API) you can now add text-to-speech and speech-to-text functions to your app with ease! 

Check out my new [blog post](https://dev.to/danielzotti/how-to-make-your-browser-talk-in-one-line-of-code-2pgn) and have a look at the Stackblitz demo I created to test it!

🗄 Docs: https://developer.mozilla.org/en-US/docs/Web/API/SpeechSynthesisUtterance

ℹ Browser support: https://caniuse.com/?search=SpeechSynthesisUtterance
My JavaScript journal
Tags: javascript, beginners, worldofwarcraft, gaming
Published: 2023-07-04 07:29:48

I am a beginner in learning JavaScript, oh my goodness, it can be so difficult some days!

I will keep a journal to track my progress and development.

That will help me stay motivated and not lose hope.
I've realized that JavaScript is completely different from learning CSS and HTML.

I spent several weeks trying to understand CSS flexbox and CSS grid, and now I've encountered an even more challenging beast: the realm of JavaScript.

This journal will be written in a somewhat fictionalized manner :) I love video games, especially World of Warcraft! I've been playing it for 18 years now (oh my goodness... time flies).

I can indeed help myself by explaining the workings of JavaScript, as when I explain what I have just learned, it further enhances my understanding of its logic.

It allows me to solidify my knowledge by articulating concepts and processes in my own words.
Additionally, writing about JavaScript can serve as a reference for my future learning and troubleshooting.

So I should go ahead and document my journey in my journal—it will not only aid my understanding but also serve as a valuable resource for my continued growth in JavaScript.

In this journal, we will follow the adventures of Murloc the Noob, Sylvanas the Huntress, Arthas the valiant Paladin, Onyxia the Dragon, and other adorable characters from World of Warcraft.
Bazaars BZR Price
Tags: bazaars, bzr, cryptocurrency, blockchain
Published: 2023-07-04 07:16:04

The price of [Bazaars BZR](https://bazaars.io/) is difficult to predict, as it is a relatively new cryptocurrency. However, there are a few factors that could influence its price in the future.

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

One factor is the growth of the decentralized finance (DeFi) market. DeFi is a financial system that is built on blockchain technology and does not rely on traditional financial institutions. Bazaars BZR is a DeFi token, so its price could increase if the DeFi market continues to grow.
Another factor is the adoption of Bazaars BZR by merchants and consumers. If more merchants start accepting Bazaars BZR as payment, and if more consumers start using Bazaars BZR to buy goods and services, then the price of Bazaars BZR could increase.
Finally, the price of Bazaars BZR could also be affected by the overall market sentiment towards cryptocurrencies. If there is a lot of positive sentiment towards cryptocurrencies, then the price of Bazaars BZR could increase. However, if there is a lot of negative sentiment towards cryptocurrencies, then the price of Bazaars BZR could decrease.
Overall, the price of Bazaars BZR is difficult to predict. However, there are a few factors that could influence its price in the future. If the DeFi market continues to grow, if Bazaars BZR is adopted by merchants and consumers, and if there is positive sentiment towards cryptocurrencies, then the price of Bazaars BZR could increase. However, if the DeFi market declines, if Bazaars BZR is not adopted by merchants and consumers, and if there is negative sentiment towards cryptocurrencies, then the price of Bazaars BZR could decrease.
Here are some price projections for Bazaars BZR from different sources:
CoinMarketCap: CoinMarketCap predicts that Bazaars BZR could reach $1.50 by the end of 2023 and $5.00 by the end of 2025.
DigitalCoinPrice: DigitalCoinPrice predicts that Bazaars BZR could reach $1.40 by the end of 2023 and $3.00 by the end of 2025.
WalletInvestor: WalletInvestor predicts that Bazaars BZR could reach $1.20 by the end of 2023 and $2.50 by the end of 2025.
It is important to note that these are just predictions and the actual price of Bazaars BZR could be higher or lower. It is always advisable to do your own research before investing in any cryptocurrency.
MBP18 Exam Dumps: The Best Way to Prepare for the Certification
Published: 2023-07-04 07:13:49

[MBP18 Dumps](https://dumpsboss.com/bcs-exam/mbp18/) You will acquire the modern day BCS MBP18 examination questions on the time of buy and this unfastened three months updates provide is a bonus. Since you need to hold consistent with the continuously converting content material of the MBP18 Business Analysis examination, so DumpsBoss gives unfastened MBP18 questions updates frequently. This guarantees which you are constantly updated with the modern day BCS Practitioner Certificate in Modelling Business Processes Exam MBP18 examination questions cloth and the MBP18 Business Analysis examination modifications. BCS MBP18 Exam Questions - 

One-Click Free Trial DumpsBoss additionally gives a freed from price trial model of the BCS [MBP18 Exam Dumps](https://dumpsboss.com/bcs-exam/mbp18/) Practitioner Certificate in Modelling Business Processes Exam MBP18 examination questions education earlier than charge. This lets in you to strive out the Business Analysis MBP18 exercise examination and make a higher choice earlier than committing to the acquisition. BCS MBP18 Exam Questions In The Refund Guarantee DumpsBoss guarantees complete charge refund in case you failed the MBP18 BCS Practitioner Certificate in Modelling Business Processes Exam the usage of BCS MBP18 examination questions education. DumpsBoss confirms your first try fulfillment withinside the MBP18 Business Analysis examination with the aid of using the usage of its BCS MBP18 examination questions with refund assure. 

Get Upto 90% Off >>>>>> https://dumpsboss.com/bcs-exam/mbp18/
Running Bar Chat
Tags: python, visualization
Published: 2023-07-04 06:51:16

**Intro**:
Visualizing data can be a powerful way to convey complex information in a simple and engaging manner. When it comes to understanding long-term trends or patterns, such as the increase in property prices over a span of 25 years, traditional static charts or graphs may not effectively capture the dynamic nature of the data. By creating a visual representation that shows the changes in property prices over time, month by month, for the entire 25-year period, we can depict the price fluctuations as a continuous flow of information, allowing viewers to grasp the overall trend and observe how prices rise and fall over the years.

**Packages**:
_bar_chart_race_, a python package for creating bar chart races

```
pip install bar_chart_race
import bar_chart_race as bcr
```

**Data Source**:
The UK House Price Index (UK HPI) captures changes in the value of residential properties at regional level.


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


**<u>Data Pre Process</u>**:
Pre-processing would include to convert the 'Date' column to a datetime format and creates a pivot table (pvdata) with the average values of the 'Detached_Average_Price' column, using 'Date' as the index and 'Region_Name' as the columns.

```
df['Date'] = pd.to_datetime(df['Date'])
pvdata = df.pivot_table("Detached_Average_Price", index = "Date",columns = ["Region_Name"], aggfunc = np.average)
```

Next step would be to sorts the index, fills missing values, adds a 'month_year' column, sets it as the new index, resets the index to a numerical index, and finally groups the data by month and calculates the mean values

```
pvdata.sort_index(inplace=True, ascending=True)
pvdata = pvdata.fillna(0)
pvdata['month_year'] = pvdata.index.strftime('%Y-%m')
pvdata_month = pvdata.set_index("month_year")
pvdata_month.reset_index()
pvdata_monthgr = pvdata_month.groupby('month_year').mean()
```

**<u>Visualizing the data</u>**:


```
bcr.bar_chart_race(df = pvdata_monthgr, 
filename = "growthbyregion.gif", 
filter_column_colors = True, 
cmap = "prism", 
title = "Average House Price By Months")
```





![Image description](https://media.giphy.com/media/v1.Y2lkPTc5MGI3NjExYzYzODhtMTNyczQ4aXA4OTQ1NjlwMTR5d3UyNGgxd3I5dmNkM21hZSZlcD12MV9pbnRlcm5hbF9naWZfYnlfaWQmY3Q9Zw/w8NsymOZnitpkB6cVc/giphy.gif)


**Summary**:
The animation can convey a sense of movement and progression, providing a more intuitive and engaging understanding of the data than a static chart or graph and allowing viewers to easily grasp the complex information and gain valuable insights from the data

**<u>Reference</u>**:

1. [Bar Chart Race](https://www.dexplo.org/bar_chart_race/)

2. [UK House Price Index](https://www.gov.uk/government/publications/about-the-uk-house-price-index/about-the-uk-house-price-index#introduction)
Azure AZ900: Optimizing Cost and Performance in the Cloud
Published: 2023-07-04 07:11:48

Passing the test Labs Dumps Azure Fundamentals test can be a stepping gravestone toward<a href="https://examlabsdumps.com/microsoft-exam/azure-az-900-exam-is-hard-or-not/">Azure AZ900</a>  medication for other Azure part- grounded or specialty instruments, but it isn't a prerequisite for any of them. 
Azure Fundamentals can be used to prepare for other Azure part- grounded or specialty instruments, but it isn't a prerequisite for any of them. 
For individualities with previous experience using Azure services, this is an excellent chance to demonstrate their understanding of the abecedarian generalities of Azure, including its multitudinous services, pricing, security,<a href="https://examlabsdumps.com/microsoft-exam/azure-az-900-exam-is-hard-or-not/">Is AZ900 Hard</a>  administration, and support. Computing, storehouse, networking, operation services, artificial intelligence( AI), internet of effects( IoT), integration, and security are just a many of the features that Azure services offer. 

"Unbeatable Offers Await! Discover Amazing Deals on our Website Today!">>>>> https://examlabsdumps.com/amazon-aws-exam/az900-sample-questions/
Alexander c petree
Tags: testing, writing, github, devjournal
Published: 2023-07-04 07:00:45

Hello 👋  
My name is Alexander petree 
I Live in CA  
My day to day recently 
Has revolved around working on 
Coding and improving my skills 
I now try my luck at bug reports 
As with the blockchain 
Sometimes life leaves the unknown 
As we become so as you learn more
About me you can check out my repositories 
At github username 
Apetree100122 
Or if you are on hackerone and have 
Some time ap1001
EMAIL is apetree1001@email.phoenix.edu 
And a final note 
I wrote this after long days and nights away 
From family and lost in the years 
Sometimes it's better to give up on somethings than to continue an endless road that leaves you lost and never finding the unknown of what could be

2010-2023 
Your left with hurt, pain and a feeling that never goes even as the wind blows away the dust and the leaves from last fall.
Month after month 
Now a year Or two later still
Wondering why anything matters 
As this long time has brought nothing but anger, resentment 
And still wondering how and why this started 
Guess it's time to tip my queen to the pawn sometimes better to chalk it to a loss instead of losing everything to be who I already am 
 | U  N  K  N  O  W  N |
As is all in life give up on what is not available and live in the present as long as you know you no one can win or take that from you 
Alexander Craig petree 
----------------------
[end]
Coding 101: What are Algorithms?
Tags: codenewbie, beginners, discuss
Published: 2023-07-04 07:00:00

_This week's series is dedicated to helping beginners on their coding journey by addressing common doubts and misconceptions. We will delve into fundamental concepts, explore essential tools, and shed light on industry practices, providing clarity and guidance to those who are new to coding. If you're an experienced developer, your valuable insights, explanations, and best practices are highly encouraged and appreciated to support and mentor aspiring coders!_


> Algorithms are at the heart of coding and programming, but what exactly are they? Join the discussion to demystify algorithms, share examples of their application, and discuss their significance in problem-solving and optimization.

Follow the [CodeNewbie Org](https://dev.to/codenewbieteam) and [#codenewbie](https://dev.to/t/codenewbie) for more discussions and online camaraderie!

*{% embed* https://dev.to/codenewbieteam *%}*
Share Your Star Wars-inspired BBQ Creations
Tags: discuss, watercooler
Published: 2023-07-04 07:00:00

It's July 4th, everyone! In the United States, this day is filled with fireworks, 🎆 barbecues, 🍔🌭 boating, ⛵ and other summer activities. So, just for fun, let's embark on an intergalactic culinary adventure and imagine a Star Wars-themed barbecue in a galaxy far, far away. If you were attending this epic gathering, what dish would you bring that captures the essence of the Star Wars universe? Would it be lightsaber skewers, Yoda soda? Share your out-of-this-world barbecue creations and let your imagination take flight. 

May the flavors be with you and have a stellar 4th! 🌌🎉

Follow the DEVteam for more discussions and online camaraderie!

{% embed [https://dev.to/devteam](https://dev.to/devteam) %}
Redirect the user to the default browser on the phone when accessing the website on the web view
Tags: react, javascript, website, typescript
Published: 2023-07-04 06:53:31

I am using reactjs to build my website. I want when users visit my website through web view to automatically redirect to their device's default browser.
I have been able to do it on chrome browser but Safari browser on IOS I can't do it. Do you guys have a solution?
Redirect the user to the default browser on the phone when accessing the website on the web view
Published: 2023-07-04 06:52:14

I am using reactjs to build my website. I want when users visit my website through web view to automatically redirect to their device's default browser.
I have been able to do it on chrome browser with code (window.location.href = "googlechrome://example.com";) but Safari browser on IOS I can't do it. Do you guys have a solution?
Access your localhost from anywhere with NGROK!
Published: 2023-07-04 06:43:27

When you make apps be it Nodejs or React, you use localhost server to see your development progress in realtime. 

Now suppose you have a remote team (or a friend) with which you want to share your progress in realtime. How would you do? 

You will probably use Google Meet or any screen sharing service to show your work. But this is not efficient because they can't access your localhost because it is not publicly available.  

And if you are thinking that you will host the app on a web hosting service, make it live and then share the public url, then my friend it is very inefficient and time consuming. 

In this article, I will share a wonderful tool you can use to achieve this purpose.

<hr>

**NGROK**


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



NGROK is a tool used to tunnel your localhost to a live url.

Steps:

- 
 Go to ngrok.com and signup. After registering you will get a auth token.
- Download the zip file for your respective OS.

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



- Unzip the file and run the executable

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

- Type the following command (replace token with yours)

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

- To start a HTTP tunnel forwarding to your local port 80, run this next (replace the port number with the port of your localhost on which your app is listening):


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




- You will get a url which can be opened from anywhere and the url will show the web page served by your localhost server.
Flowchart editor dgrm.net / Announcement / Share link
Tags: webdev, javascript, programming, startup
Published: 2023-07-04 06:06:52


![Send link to messendgers](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vf5kilb10fnp45ogirh0.png)

[dgrm.net](https://dgrm.net/)

- Mobile: “Share link” to send link to messengers
- PC: group selection with the right mouse button

I’m adding new features to the editor.
Announcements on Twitter: https://twitter.com/boyko_tech
QuickBooks Online Banking not Updating - Troubleshoot Steps
Tags: quickbooks, banking, troubleshooting
Published: 2023-07-04 06:04:28


If you're experiencing issues with [QuickBooks Online Banking not updating](https://www.conectier.com/blog/bank-feeds-not-working-in-quickbooks/), there are Some steps you can take to troubleshoot the problem. Here are some common solutions

**Check your Internet Connection**

Ensure that you have a stable internet connection. Poor connectivity can prevent QuickBooks Online from retrieving the latest banking data.

**Refresh the Page**

Sometimes, a simple page refresh can resolve temporary glitches. Click the refresh button in your browser or press F5 on your keyboard to reload the QuickBooks Online page.

**Clear Cache and Cookies**

Clearing your browser's cache and cookies can help resolve issues caused by stored data conflicts. Access your browser's settings and clear the cache and cookies associated with QuickBooks Online.

**Verify your Bank Credentials**

Double-check that you've entered the correct login credentials for your bank account in QuickBooks Online. Incorrect login information can prevent the software from retrieving updated banking data.

**Manually update the Bank Feed**

If automatic updates are not working, try manually updating the bank feed in QuickBooks Online. Navigate to the Banking or Transactions tab and click on the Update button to refresh the connection and fetch the latest transactions.

**Disable Pop-up Blockers**

Pop-up blockers in your browser can interfere with QuickBooks Online's ability to update banking information. Disable any pop-up blockers or add QuickBooks Online to the allowed list.

**Verify Bank Server Status**

Occasionally, banks may experience technical issues or maintenance that can affect the connectivity with QuickBooks Online. Check your bank's website or contact their customer support to ensure that their servers are operational.