Tweet Teratas untuk #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ππ
Tagar Terakhir Terlihat di Sotwe
Ω
ΩΩΨ§_ΨΨ΅Ψ±ΩΨ§Ψͺ
Dilihat dari Saudi Arabia
ΰΈ«ΰΈ₯ΰΈΈΰΈΰΈΰΈ²ΰΈΰΈΰΉΰΈ²ΰΈ
Dilihat dari Thailand
pyt()**********
Dilihat dari United States
jerking
Dilihat dari United States
goon
Dilihat dari Turkey
CaughtOnCamera
Dilihat dari United Kingdom
incestlover
Dilihat dari United States
Ψ§ΩΩΨ¬
Dilihat dari United States
RCRP
Dilihat dari United States
sanpchat
Dilihat dari United States
Tren untuk Anda
Pengguna Paling Populer
Elon Musk 
@elonmusk
241.5M pengikut
Barack Obama
@barackobama
118.8M pengikut
Cristiano Ronaldo
@cristiano
114.5M pengikut
Donald J. Trump
@realdonaldtrump
111.9M pengikut
Narendra Modi
@narendramodi
107.1M pengikut
Rihanna
@rihanna
98.7M pengikut
NASA
@nasa
92.3M pengikut
Justin Bieber
@justinbieber
91.8M pengikut
KATY PERRY
@katyperry
90M pengikut
Taylor Swift
@taylorswift13
84M pengikut
Lady Gaga
@ladygaga
75.5M pengikut
Virat Kohli
@imvkohli
73.4M pengikut
Kim Kardashian
@kimkardashian
70.8M pengikut
YouTube
@youtube
68.7M pengikut
Neymar Jr
@neymarjr
66.4M pengikut
Bill Gates
@billgates
65.2M pengikut
Selena Gomez
@selenagomez
63.1M pengikut
The Ellen Show
@theellenshow
62.2M pengikut
CNN
@cnn
61.7M pengikut
X
@x
60.7M pengikut