Recently I was rolled out 4 number of @OracleDatabase focusing on #SQL's curriculums. Happy learning and after you master these knowledge, making your company or enterprise benefit as soon as possible! 1) Elegantly Solving Impressed Pain Spots You’ve Encountered Once About Oracle SQL Development (17 episodes) - quanwenzhao.gumroad.com/l/ES… 2) Elegantly Solving Impressed Pain Spots You’ve Encountered Once About Oracle Performance and Tuning (12 episodes) - quanwenzhao.gumroad.com/l/ES… 3) Elegantly Solving Impressed Pain Spots You’ve Encountered Once About Oracle-Specific Features (11 episodes) - quanwenzhao.gumroad.com/l/ES… 4) Elegantly Solving Impressed Pain Spots You’ve Encountered Once About Oracle Diagnostics and DevOps (7 episodes) - quanwenzhao.gumroad.com/l/ES… Stay tuned with the other fresh curriculum! @Oracle @gumroad #ModernSQL #curriculum #HappyLearning

(re. the video) @ModernSQL solves a lot of SQL92's "unexpressive" reputation, and proper indexing/profiling prevents "surprise" table-scans. As swell as ORMs are for quotidian queries, with more complex query logic, I prefer SQL's readability/predictability every time.

Gentlemen: great episode; many thanks! Will be recommending to others.

New episode: "Modern SQL" Michael is joined by @MarkusWinand, creator of use-the-index-luke.com and modern-sql.com, to discuss @ModernSQL — what it means, why it matters, and a phrase that should be on a t-shirt. 🎧 postgres.fm/episodes/modern-… 📺 youtu.be/mGqqQg-dG-w

The major problem stems not from the DB size but from the choice to use OFFSET. Instead, paginate using keys that are indexed. /cc @ModernSQL use-the-index-luke.com/sql/p…

Omg this will settle wars!

This is exactly the kind of improvements that brings joy to developers. Language designers should focus more on such low hanging fruits. BTW, the underscore was already in use 1979 in ADA (The rationale of the design of the Ada programming language, doi.org/10.1145/956653.95665… )

Firebird 4.0 has added cryptographic hash functions and you can specify md5 algorithm to the crypt_hash() function stackoverflow.com/a/55080426 #FirebirdSQL #SQL #RDbms

Using INTEGER feels a bit like using 2 digits to store the year 😉

Yes. Outer join presents absence of data as unknown data

The absence of value doesn't bring uncertainty. I see NULL as unknown. We don't even know if it is absent and that's why NOT IN (1,2,null) is unknown

Published yesterday (31 May), available for purchase today! Major props to my fellow editors -- Jörn Bartels, Stephen Cannan, and Stefan Plantikov -- for an incredible job very well done!!

I still don't understand why I should pay for a standard 🤷

TE INVITO A SUSCRIBIRTE AL SIGUIENTE CANAL youtu.be/jp2Sbr6Xsyg #ChatGPT账号 #ChatGPT #SQL @ChatGPTNFTs @ChatGPT_Nieuws @chatgptandai @ChatGPTUpdates @SQLServer @MySQL @PostgreSQL @SQLPerfTips @planetpostgres @ModernSQL @sqldaily @sqlpros @SQLProApp @DATA_SAPIENS

Have I got a treat for you. If you've not encountered @MarkusWinand's use-the-index-luke.com/ and sibling @ModernSQL, that pair will *really* up your SQL game and indexing.

rowalesce() is to @PostgreSQL composite types what coalesce() is to individual fields. github.com/bigsmoke/pg_rowal… #PostgreSQL @ModernSQL #SQL

I just added @ModernSQL to @PlanetMysqlComT, sorry I did not do this earlier, it should have been there for a while. github.com/oursqlcommunity-o…

I wish I could like this twice and retweet it thrice.

SQL TRIM() was introduced in Firebird 2.0 firebirdsql.org/refdocs/lang… #SQL #FirebirdSQL

I didn't know about explicit `WINDOW` clauses. Thanks!