How to Create A PostgreSQL on Neon: A Step by Step Tutorial for Beginners

How to Create A PostgreSQL on Neon: A Step by Step Tutorial for Beginners

Description:
In this tutorial, you will how to setup a Neon Account & Create a PostgreSQL Database & Tables to organize your documents for a future RAG System.

In this tutorial, you'll learn:

How To Set Up a New Neon Account
How To Create New Projects
What Are Branches?
How To View & Add Databases & Roles
How To Add Tables To Database
How To Add Data To Database
——————

Neon Docs:
Overview of Neon Databases:
https://neon.com/docs/manage/overview

Managing Databases:
https://neon.com/docs/manage/databases#create-a-database

RAG Tutorial:
https://youtu.be/OB4GZ_WugQI

——————
✅ Chapters:
00:00 Intro: About The Tutorial
01:17 Create Neon Account
01:38 New Project Setup
02:11 Create New Projects
02:29 Neon Org Chart
02:53 Change Org Name
03:16 API Keys
03:33 Branches
03:54 Open Projects
04:06 View All Branches
04:55 View All Databases
05:26 Create New Database
05:50 Database Creation
06:15 Create New Role
06:50 Edit Databases
07:22 Google Sheets
07:53 Create New Table
08:05 Enter Table Name
08:21 Add Column Headers
09:26 Column Order
09:46 Review & Create
10:02 Add Rows & Data
10:40 Save Table
11:11 Row Limits
11:31 Drop (Delete) Tables
11:58 Create Additional Tables
12:44 Outro
12:59 Next Tutorial...pgvector
——————

🪜 **How To Create New Neon Account & Project

Visit https://neon.com
Click 'Sign Up'
Sign up using Google Account
Check Email & Activate Account
Enter Project Name
Cloud Service Provider: AWS
Region: N. Virginia
Click Create
Go To Settings & Change Organization Name
🪜 How To Create a PostgreSQL Database on Neon

Click 'Branches' in the sidebar
Click on 'Production (default)' branch
Click on 'Roles & Databases'
Click 'Add Database'
Enter Database Name (no hyphens!)
Select Owner (neondb_owner)
Click 'Create'
Click Plus(+)
Click 'Create Table'
Enter Table Name (mmu_podcast)
Click 'Add Columns' and repeat
Click 'Review & Create'
Click 'Add Record'
Add data to cells
Click 'Save 1 Change'
Repeat
——————Resources———————
➜Gear I Use: https://mikemurphy.co/resources
➜Adobe After Effects: https://mikemurphy.co/adobe
➜Terrapin Textures: https://terrapintextures.com
➜ Adobe Audition Course (Domestika): https://mikemurphy.co/domestika

➜Amazon Influencer Store: https://www.amazon.com/shop/mikemurphyco
➜See All My Gear: https://www.mikemurphy.co/podgear
➜ Get Adobe Creative Cloud: https://mikemurphy.co/adobe
➜ Screenflow: https://mikemurphy.co/screenflow

➜ Website: https://mikemurphy.co
➜ Podcast: https://mikemurphy.co/mmu
➜ Instagram: http://instagram.com/mikeunplugged
➜ X: http://x.com/mikeunplugged
➜ YouTube: https://mikemurphy.co/youtube

Amazon Associates Disclosure:
Mike Murphy is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

Видео How to Create A PostgreSQL on Neon: A Step by Step Tutorial for Beginners канала Mike Murphy | AI Handyman