PinnedSatyam SahuThe Most Overlooked SQL Functions Every Data Analyst Should KnowUse These Hidden Gems to Simplify Your Queries and Get More Out of Your Data2d ago2d ago
PinnedSatyam SahuSQL Window Functions: Go Beyond Basic QueriesAdvanced Techniques to Get the Most Out of Your DataSep 30Sep 30
PinnedNathan Timothy HandokoChecking Differences Between Two Tables in BigQuery SQL: A Step-by-Step GuideThe easiest method to detect changes and discrepanciesSep 24Sep 24
RisingWave LabsHow Randomized SQL Testing Can Help Detect Bugs?We chose to build our own SQLSmith in Rust. SQLSmith is a tool used for automated SQL query generation and testing.Sep 24Sep 24
Samhitha PoreddyFind me a Job Social Network Schema using SQL Graph DatabasesIn this article, we will discuss how to use a graph database as a powerful recommendation engine for job seekers. We will start by defining…Sep 23Sep 23
Sai Krupa Reddy SurarapuExploring the Most Popular Databases: A Comprehensive GuideIn the world of data management, the choice of database is crucial for effective data storage, retrieval, and manipulation. With a plethora…Sep 3Sep 3
Rui CarvalhoUnderstanding SQL’s ROW_NUMBER() and PARTITION BY: Benefits and ConsiderationsLearn how they can optimize your data sorting, pagination, and deduplication tasks, along with important performance and complexity…Aug 26Aug 26
Karim FayedUnlocking Data Power: A Beginner’s Guide to SQL FundamentalsKicking off my data career more than 2 years ago, I learned quickly that SQL is a must-have skill. SQL is the most common language used by…Aug 24Aug 24
Kunu WakoBest Practices for Database Design in SQLDesigning a database is one of the most crucial steps in software development. A well-designed database ensures data integrity, optimizes…Aug 5Aug 5
Zach QuinnValidate Your BigQuery SQL Table Metadata Using Just 1 WordLeverage BigQuery SQL table metadata to deduplicate, partition and delete data — all using only one word.Aug 5Aug 5
