Day 11: Learn PostgreSQL โ€“ Create Database, Tables & Insert Data | SQL Challenge ๐Ÿ’ป

Subscribers:
10,900
Published on ● Video Link: https://www.youtube.com/watch?v=pcr5Ogz65k0



Duration: 0:00
16 views
0


๐Ÿ”น Day 11 of 30 โ€“ Learn SQL with PostgreSQL!
Today, I covered the basics of creating databases, defining tables, and using INSERT statements to populate data in PostgreSQL.

๐Ÿ’ก PostgreSQL is a powerful open-source database widely used by data analysts and backend developers.

๐ŸŽฏ Key Concepts I Learned:

CREATE DATABASE

CREATE TABLE

INSERT INTO

๐Ÿ“Œ This is part of my 30-Day Data Analyst Learning Challenge where Iโ€™m building real skills in Excel, SQL, Dashboards, and more.

๐Ÿ“บ Subscribe to follow the full journey โ†’ โ€ช@TechWithNicksโ€ฌ

๐Ÿ”’ All data used is fictional and for educational purposes only.

#LearnSQL #PostgreSQL #SQLBasics #TechWithNicks #DataAnalyst #SQLTutorial #30DayChallenge #CreateTable #InsertInto #DataAnalytics




Other Videos By Tech With Nicks


2025-06-15Master Logical Operators in PostgreSQL ๐Ÿง  | SQL in 60 Seconds with Tech With Nicks
2025-06-15PostgreSQL Comparison Operators in 60 Seconds! ๐Ÿ” | Learn SQL with Tech With Nicks
2025-06-15PostgreSQL Arithmetic Operators Explained in 1 Minute! ๐Ÿงฎ | Learn SQL with Tech With Nicks
2025-06-14"Master ALTER TABLE in SQL | Add Columns, Change Data Types & More ๐Ÿ”ฅ #Day14"
2025-06-13Day 13 Night โ€“ Mastering Query Toolbar in PostgreSQL ๐Ÿง  | Speed Up Your SQL Workflow!
2025-06-13Day 13 Evening โ€“ SQL Toolbar Tour ๐Ÿงฐ | Boost Your PostgreSQL Speed & Workflow
2025-06-13Day 13 โ€“ UPDATE in SQL with WHERE Clause ๐Ÿ” | Modify Data in PostgreSQL Like a Pro!
2025-06-13Day 12 Night โ€“ All SQL Constraints in PostgreSQL Explained! โœ… | Learn SQL Theory Fast
2025-06-13Day 12 Evening โ€“ All SQL Data Types Explained in PostgreSQL! ๐Ÿง  | Learn SQL Fast ๐Ÿš€
2025-06-12Day 12 (Morning) : Delete Rows & Columns in PostgreSQL | SQL for Data Analysts ๐Ÿ”ฅ
2025-06-11Day 11: Learn PostgreSQL โ€“ Create Database, Tables & Insert Data | SQL Challenge ๐Ÿ’ป
2025-06-11"Day 10: Learn SQL Basics in PostgreSQL | DDL, DML, DQL, TCL, DCL Explained | Data Analyst Roadmap"
2025-06-11"Day 9 Excel Dashboard for Gift Shop ๐ŸŽ | Pivot Table + Slicer + Charts | Data Analyst Project"
2025-06-10"Day 8 Excel Magic ๐Ÿง™โ€โ™‚๏ธ | Pivot Table & Slicer for Dynamic Dashboards | Analyst Challenge"
2025-06-09"Day 7 Excel Formulas You Must Know! ๐Ÿ“… | DATE, TEXT, EOMONTH, NETWORKDAYS | Analyst Shortcut
2025-06-09"Day 6 Excel Challenge ๐Ÿ”ฅ | SUMIFS, COUNTIFS, AVERAGEIFS in 60 Seconds! | Data Analyst Roadmap"
2025-06-08Day 5(Night): VLOOKUP, INDEX & MATCH in Excel ๐Ÿ” | Lookup Functions Every Analyst Must Know
2025-06-07Day 5 (Morning): VLOOKUP, INDEX & MATCH in Excel ๐Ÿ” | Lookup Functions Every Analyst Must Know
2025-06-07Day 4 (Night): Master IF, AND, OR, SORT & FILTER in Excel ๐Ÿ’ก | Logical Functions for Analysts
2025-06-07Day 4 (Morning): Master IF, AND, OR, SORT & FILTER in Excel ๐Ÿ’ก | Logical Functions for Analysts
2025-06-07Day 3: Excel Data Cleaning for Data Analysts ๐Ÿงน | Remove Duplicates, Fix Text, Validate Data