Take your SQL skills to the next level with this beginner’s guide to subqueries. Learn how to write powerful queries using inline, scalar, and correlated subqueries—complete with practical code examples and clear explanations.
Category: Database
Learn how to master SQL JOINS with clear explanations and real-world examples. This third part of our SQL for Beginners series demystifies INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN using easy-to-understand Venn diagrams and sample queries. Perfect for developers looking to connect data across tables.
Unlock the power of NoSQL with this comprehensive guide tailored for RDBMS developers. Learn key differences, data modeling techniques, and practical strategies to transition from relational databases to NoSQL systems like document, key-value, and graph databases.
Take your SQL skills to the next level with this follow-up to our beginner’s guide. Learn intermediate SQL commands like subqueries, JOINs, CASE, and more with practical examples for real-world applications.
Discover the power of polyglot persistence in microservices architecture. Learn how to transition from monolithic designs, choose the right database for each service, and overcome challenges like data consistency and operational complexity. Perfect for database developers embracing microservices, this article provides actionable insights, best practices, and real-world case studies to help you master polyglot persistence and build resilient, high-performing applications.
Discover how Uber’s QueryGPT is revolutionizing SQL query generation with AI! This in-depth article explores the internal workings of QueryGPT, Uber’s cutting-edge tool that transforms natural language into SQL queries. Learn how Uber saves 140,000 hours annually, reduces query time by 70%, and democratizes data access across Uber. Perfect for tech enthusiasts, data professionals, and AI innovators!
Learn SQL from scratch with this beginner-friendly guide. Discover key SQL commands, including SELECT, INSERT, UPDATE, and JOIN, with real-world examples to help front-end developers and beginners master database queries efficiently.
This concise eBook is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.
Unlock the power of Amazon DynamoDB with this comprehensive guide designed for developers. Dive deep into the core concepts, including tables, primary keys, secondary indexes, and data types, all while exploring practical examples using Python. Whether you’re building scalable applications, handling real-time data, or optimizing your database operations, this primer provides the foundational knowledge and advanced features to make the most of DynamoDB’s performance and scalability. Read on for expert insights and code examples to integrate DynamoDB into your projects effectively.
In the ever-evolving world of technology, the year 2023 witnessed remarkable advancements in developer tools and frameworks, shaping the way we build, deploy, and maintain software. This roundup explores features and releases that have defined the developer landscape over the past year.
The First Edition of this book was released in May 2020, about two and a half years ago. Since its…
While developing apps using Redis, if you are trying to use the command DEBUG and Redis throws the error “ERR DEBUG command not allowed.”, here’s how you fix it.
MySQL is an RDBMS platform that stores data in a tabular format in a normalized manner, whereas, MongoDB is a NoSQL database that stores information in the form of documents that are grouped under collections. The representation of data is completely different and hence migration of MySQL table data to MongoDB collections might sound like a mammoth task. Fortunately, Python makes it a breeze with its strong connectivity and data handling capabilities.
Are you looking for resources to get started with migrating SQL Server Databases to PostgreSQL? This is the book for you. This concise eBook is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.
One of the major challenges in Cloud is controlling costs effectively. This article discusses various strategies you can adopt to set up and operate non-critical workloads of your databases with minimal cost.
This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.
This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.
This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.
This post explains a neat way to check if your are running on open source PostgreSQL or AWS Aurora (PostgreSQL compatible)
This article describes a simple and elegant way to allow write access to ASP.NET apps to the App_Data folder. This is required for applications to work properly when deployed in AWS Beanstalk.
DbStudio is a Database access tool that enables you to connect to a wide variety of databases. It is designed…