> ## Content Index
> Fetch the complete content index at: https://www.anasabaziz.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Practice SQL Data Extraction Yourself (Free Guide with Neon.tech + Power Query)
- URL: https://www.anasabaziz.com/how-to-practice-sql-data-extraction-yourself-free-guide-with-neon-tech-power-query/
- Published: 2025-10-21T09:26:30.000Z
- Updated: 2026-08-27T07:36:45.000Z
- Description: Learn how to practice SQL data extraction for free using Neon.tech PostgreSQL and Power Query. Step-by-step guide to set up your own SQL database and connect it to Power BI or Excel.
- Author: Anas
- Tags: Data Analytics, Excel, SQL, Power BI

Have you ever wanted to *practice extracting SQL data* without access to your company’s internal databases?

Most organizations tightly control their SQL environments for good reason. This makes it hard to learn and experiment on your own.

That’s exactly the problem I faced when I wanted to test query folding in Power BI and Power Query. Instead of waiting for access to corporate systems, I decided to set up my own **free SQL playground**. The best platform I’ve found for this is [**Neon.tech**](https://neon.tech/?ref=anasabaziz.com) that uses PostgreSQL.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-8-1.png)

Neon.tech website

In this guide, I’ll walk you step-by-step through how to set up your own PostgreSQL database on Neon.tech, load sample data, and connect it to Power Query in Power BI or Excel, all **without paying a cent**.

## Why Practice SQL Data Extraction Yourself?

Before diving into setup, let’s talk about *why* this is worth doing.

- **Real-world learning:** SQL is the language behind most business data. Being able to extract and transform data yourself helps you understand how data flows into dashboards.
- **Safe experimentation:** You can try advanced transformations, queries, or even break things. No IT admin will be upset.
- **Power BI / Power Query practice:** Perfect for testing **query folding**, performance optimization, or just understanding how connectors work.

### Why I Recommend Neon.tech (Over Microsoft Fabric or Azure)

When testing SQL integrations, you could use Azure or Microsoft Fabric. But the catch? Both usually require a **subscription** or a **limited-time trial**.

That’s why I switched to **Neon.tech**. It’s a **serverless PostgreSQL platform** that gives you:

- Free tier (no credit card required)
- Instant database creation
- Copy-paste connection strings
- Modern UI and Git-like branching for databases

For most learners or Power BI professionals, Neon is perfect; it's lightweight, free, and reliable.

## Step-by-Step: Using Neon.tech PostgreSQL with Power Query

Let’s go through the exact steps I used to set up my own SQL environment.

### Step 1: Create a Neon.tech Account

- Go to [https://neon.tech](https://neon.tech/?ref=anasabaziz.com).

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-10.png)

Neon.tech landing page

- Sign up with **GitHub** or **Google;** this is the fastest way.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-9.png)

Log in with Google or GitHub for a faster sign-in process

- Once in the dashboard, click **“Create Project.”**

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-11-1.png)

"Create project" to get started

### Step 2: Create a Free PostgreSQL Database

- Enter the following details to set up the project
  - Give your project a name, for example: `SQLTest`.
  - Choose a Cloud service provider; AWS has more server locations than Azure.
  - Choose a region closest to you (e.g., **Singapore** if you’re in Malaysia).

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-23.png)

Enter project details to get started

Neon automatically sets up:

- A **PostgreSQL database**
- A **default branch** (your database environment)
- A **connection string**

Example **connection string** generated:

> psql 'postgresql://neondb\_owner:npg\_VS4rFvQw9oLh@ep-crimson-art-a1tf74hb-pooler.ap-southeast-1.aws.neon.tech/neondb?sslmode=require&channel\_binding=require'

Broken down, the string is interpreted as:

- Server: `ep-crimson-art-a1tf74hb-pooler.ap-soutcheast-1.aws.neon.tech`
- Database:`neondb`
- Username:`neondb_owner`
- Password:`npg_VS4rFvQw9oLh`

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-15.png)

Connection string is shown once project is set up

You’ll use the information above soon to connect Power Query.

### Step 3: Load Sample Data into Neon

Neon starts empty. So let’s create a dataset.

- In your Neon dashboard, open the **SQL Editor**.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-22.png)

neon.tech user main page

- Use ChatGPT or another LLM to generate a sample SQL dataset (check out my guide on [how to get started with vibecoding](https://www.anasabaziz.com/getting-started-with-vibecoding-how-ai-helps-you-code-smarter/)).

> Prompt idea:  
> *“Create an SQL script so that it would create at least 5000 lines of transaction data.”*

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-12.png)

Use ChatGPT to vibe code a table in your database

- Paste the script into Neon’s SQL Editor and click **Run**.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-13.png)

Insert script into the SQL Editor

You now have a **sample transactional dataset** to practice with. It's perfect for testing joins, filters, and aggregations.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-14.png)

Tables page shows the information in the tables generated

### Step 4: Connect Neon Database to Power Query

Now for the fun part, connecting your SQL database to Power BI or Excel. I recommend using Power BI instead of Excel to connect to SQL databases, as there is a high likelihood that a large volume of transactions is expected. It would be easier to visualize this in Power BI rather than Excel.

**If using Power BI Desktop:**

- Open **Power BI** → **Get Data** → **Database** → **PostgreSQL Database**.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-16.png)

Get Data from PostgreSQL database

- The PostgreSQL database menu will pop up.
  - In the *Server* field, enter your Neon host: `ep-crimson-art-a1tf74hb-pooler.ap-southeast-1.aws.neon.tech`
  - In the *Database* field, type:`neondb`

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-17.png)

Insert relevant Server and Database information

- For authentication, use the same **username** and **password** from your connection string.
  - Username:`neondb_owner`
  - Password:`npg_VS4rFvQw9oLh`

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-18.png)

Insert User name and Password

**If using Excel:**

- You will first need a PostgreSQL driver to connect via Excel. The tutorial can be found [here](https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver17&ref=anasabaziz.com).
- Go to **Data** → **Get Data** → **From Database** → **From PostgreSQL Database**;
- Follow the same connection details above.

Once connected, you can view all your tables, preview data, and even check **query folding** behavior directly in Power Query Editor. 

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-19.png)

The relevant tables in the database will be shown in the Power Query Navigator

## Testing Query Folding and Data Extraction

Here’s where the learning happens.

- Start by loading a few tables and applying transformations in Power Query.
- Open the *View Native Query* option to see how Power Query translates your transformations into SQL.
- Experiment with filters, joins, and custom columns to see which operations fold back to the database and which don’t.

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-20.png)

In Power Query, you can see the Native SQL used to pull the data from your database

This kind of hands-on testing gives you a much deeper understanding of how Power BI optimizes data queries behind the scenes. Here's my guide on [how to load SQL data faster](https://www.anasabaziz.com/query-folding-in-power-query-complete-guide-for-faster-data-loading/).

## Troubleshooting Tips

- If Power BI can’t connect,  
  - Delete all previous permission information by opening **Options & Settings** → **Data Source Settings** → **Clear Permissions** → **Clear all permissions**.
  - Check that the **PostgreSQL driver** is installed for older versions of Power BI (Power BI should have the driver pre-installed for version 2020 and beyond).

![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/2025/10/image-21.png)

Clear Permissions to start a fresh new Power BI file

- Some corporate networks block remote database connections. Try from a personal network first.
- You can always reset credentials or generate a new password from Neon’s dashboard.

## Final Thoughts: Build Your Own SQL Playground for Free

Setting up a database on Neon.tech takes just 10 minutes, and it’s one of the best ways to **level up your SQL and Power Query skills**.

You’ll not only learn how to connect and extract data, but also how transformations actually run under the hood. With this knowledge, you now have the skills to make Excel reports that connect directly to SQL databases in your organization.

Whether you’re testing **query folding**, **ETL workflows**, or just brushing up on SQL syntax, this setup is a practical, no-risk way to learn by doing.

Related Articles:

[Power BI to Excel: How to Use OLAP Connections for Always-Up-to-Date ReportsLearn how to connect Power BI to Excel using OLAP tables for always-up-to-date reports. Save time, avoid manual exports, and empower management with live data.![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/icon/favicon-3.ico)Anas Ab AzizAnas![](https://storage.ghost.io/c/10/2b/102b44ac-b001-4e5c-bf76-dad05157f35d/content/images/thumbnail/photo-1517245386807-bb43f82c33c4)](https://www.anasabaziz.com/power-bi-to-excel-how-to-use-olap-connections-for-always-up-to-date-reports/)