#15daysofpostgres Etiketinde En Popüler Paylaşımlar

yaklaşık 2 yıl önce

Day 8 of #15DaysOfPostgres: Explored the concept of INNER JOIN and LEFT JOIN. Also dived into the UUID data type in PostgreSQL and its benefits as a primary key for global uniqueness 🔑 #PostgreSQL #SQL #SoftwareDevelopment

300

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 7 of #15DaysOfPostgres: Explored the power of ON CONFLICT DO NOTHING & Upsert to handle data. Dived into relationships & foreign keys, & learned how to add & update relationships between tables. #Database #SoftwareDevelopment

183

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 6 of #15DaysOfPostgres: Learned how to refine query results with LIMIT, OFFSET, and FETCH. Explored operators like IN, BETWEEN, and LIKE/iLIKE. Wrapped up the day with GROUP BY, HAVING, and calculating MIN, MAX, AVG, and SUM 💻 #Database #SoftwareDevelopment

208

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 5 of #15DaysOfPostgres: Worked on table creation and key PostgreSQL queries like INSERT INTO, SELECT FROM, and ORDER BY. Also explored DISTINCT, WHERE, COUNT, and comparison operators. What’s been your favourite part of learning databases? 💡🐘 #PostgreSQL #database

155

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 4 of #15DaysOfPostgres: Dug into VACUUM and ANALYZE to clean up dead rows and optimize query planning. Also explored pg_stat_user_tables to monitor table performance and activity—super helpful for keeping things efficient! 📊 #PostgreSQL #SoftwareEngineering

132

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 3 of #15DaysOfPostgres: Learned about PostgreSQL system columns like ctid, xmin, & xmax. These columns offer valuable insights into row versioning and transactions - fascinating to see how the internals work! 🐘 #PostgreSQL #SoftwareDevelopment #SoftwareEngineering

257

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 2 of #15DaysOfPostgres: Dived into PostgreSQL installation and explored the postgresql.conf file—tweaked some values for experimentation. Looking forward to learning how these settings affect my understanding! ⚙️🐘 #PostgreSQL #DatabaseLearning #PostgresJourney

257

Kanak @kanak2212

yaklaşık 2 yıl önce

🚀 Day 1 of #15DaysOfPostgres: Explored PostgreSQL Architecture 🔍 from Postmaster & Backend Processes to Shared Memory & WAL. Also read about the Information Schema for metadata insights on tables, columns, and more. Excited for what’s next! 🔥 #PostgreSQL #DatabaseLearning

710

Kanak @kanak2212

yaklaşık 2 yıl önce

Hii guys!! 👋 Lets go back to the Days challenges, starting off with a #15DaysOfPostgres challenge! I’ll be diving deep into PostgreSQL & sharing my journey over the next two weeks. 📚🔍 Join me as I explore this & share any resources or tips you have🌟😁

455

#15daysofpostgres Etiketinde En Popüler Paylaşımlar

Sotwe'de En Son Görülen Etiketler

Senin İçin Trendler

En Popüler Kullanıcılar