Unions in PostgreSQL @AlexTheAnalyst
Unions in PostgreSQL  @AlexTheAnalyst
Uploaded August 2026 | Updated November 2026, 3 days ago
Create the Database with this script: github.com/AlexTheAnalyst/PostgresqlYouTubeSeries

Practice Postgresql here: analystbuilder.com/questions

In this series I want to teach you Postgresql! It's one of the most popular types of SQL right now and is becoming even more popular with the rise of AI. I'll teach you all the syntax and how to use it as well as go beyond just querying!

Code:
CREATE TABLE character_info_extra (
character_id SERIAL PRIMARY KEY,
character_name TEXT NOT NULL,
species TEXT,
planet_id INT,
ship_id INT,
estimated_net_worth NUMERIC(12,2),
has_both_arms CHAR(1),
birth_date DATE
);

INSERT INTO character_info_extra
(character_name, species, planet_id, ship_id, estimated_net_worth, has_both_arms, birth_date)
VALUES
('Ahsoka Tano', 'Togruta', 3, NULL, 220000.00, 'Y', '1985-10-14'),
('Mace Windu', 'Human', 4, 5, 950000.00, 'Y', '1950-02-03'),
('Rey', 'Human', 1, 2, 120000.00, 'Y', '1999-04-10'),
('Finn', 'Human', 1, NULL, 45000.00, 'Y', '1992-07-21'),
('Poe Dameron', 'Human', 2, 1, 310000.00, 'Y', '1982-03-09'),
('General Hux', 'Human', 7, NULL, 80000.00, 'Y', '1984-11-18'),
('BB-8', 'Droid', 2, 6, 5000.00, 'Y', '2014-01-01'),
('Kylo Ren', 'Human', 2, 3, 2000000.00, 'N', '1989-12-18'),
('Luke Skywalker', 'Human', NULL, 2, 150000.00, 'N', '1977-09-25');


____________________________________________

RESOURCES:

💻Analyst Builder - analystbuilder.com

📖Take my Full MySQL Course Here: bit.ly/3tqOipr
📖Take my Full Python Course Here: bit.ly/48O581R
📖Practice Technical Interview Questions: bit.ly/46pDqqL

Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________

Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Unions in PostgreSQLMicrosoft Copilot Cowork Just Launched | Heres What You Need to KnowLearn Power BI in Under 3 Hours | Formatting, Visualizations, Dashboards + Full ProjectMy Career Progression 7+ Years | Recreational Therapist to Data Analyst | Alex The Analyst Show 27Joins in PostgreSQLWhat are KPIs and Metrics? | Data Fundamental for BeginnersWhat is IDP in Databricks?Day in the Life of a Data Analyst: Meetings, SQL, So Much FoodAmazon Athena in AWS | AWS FundamentalsSemantic Layers in the Age of AI are 100% NeededHow to Become a Healthcare Analyst in 2025Connecting Git to GitHub
Alex The Analyst |

Unions in PostgreSQL

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER