Top Tweets for #15daysofpostgres
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
π 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
π 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
π 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
π 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
π 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
π 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
π 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
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ππ
Last Seen Hashtags on Sotwe
minichatt ()()()()()**************************** filter:videos
Seen from United States
ifΕa #video
Seen from Turkey
bigtits china
Seen from Turkey
leathergod
Seen from Belgium
minichatt
Seen from Brazil
karamangay
Seen from Turkey
Ψ³ΩΨ³
funnysex
Seen from Turkey
mslut #hbull
Seen from Pakistan
sleeping spy
Seen from Turkey
Most Popular Users
Elon Musk 
@elonmusk
241.5M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.4M followers
Kim Kardashian
@kimkardashian
70.8M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.4M followers
Bill Gates
@billgates
65.2M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.7M followers