Articles by Tag #sql
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Count(*) vs Count(1) in SQL
When working with SQL databases, efficient data retrieval and manipulation are crucial. One common...
Advanced SQL: Mastering Query Optimization and Complex Joins
Hello everyone, السلام عليكم و رحمة الله و بركاته SQL (Structured Query Language) is an essential...
Mastering SQL: Comprehensive Guide To Structured Query Language
Introduction In the previous blog article we've explored together a comprehensive guide...
Improving Performance of PostgreSQL queries
I recently wanted to implement some raw SQL queries and work on the efficiency of them so that...
Guide To Choose A Database For Your Next Design
Why we need to choose a database? A database is an organized collections of data that can...
5-Week Data Career Boot Camp: Orientation and Foundations.
5-Week Data Career Boot Camp is LuxDevHQ program that aims to demystify data careers, make learning...
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️
Database tools are the critical enablers that bridge the diverse needs of developers, database...
How SQL Query works? SQL Query Execution Order for Tech Interview
How SQL Query works? Understanding SQL Query Execution Order for Tech Interview
As a Google Web Developer, I’d like to introduce my top 5 go-to tools
I’m a Web Developer who has been working at Google for 5 years. I often get asked by other...
SQL Complete guide for Interview
Structured Query Language or SQL is a standard database language that is used to create, maintain,...
Creating Unique Slugs on Supabase with PostgreSQL
In web development, creating clean and SEO-friendly URLs is crucial. One way to achieve this is by...
5 Essential SQL Skills Learned from a Decade of Experience
In my ten years of working with SQL, I've honed several critical skills that significantly enhance...
The Log Is (not) The Database
There is a common saying "The Log Is The Database", to explain some database innovations in...
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
Recursive queries in SQL, enabled by Common Table Expressions (CTEs), allow us to work with...
Introducing StackQL - Manage Your Cloud Services & Interact with APIs using SQL 🧑💻🔥
In the fast-paced digital age, modern cloud stacks have become more complex, meaning users often have...
😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁
If you work with databases, SQL AI tools can significantly improve your productivity and efficiency....
Best way to learn SQL
How I Learned SQL (And How You Can Too) I’m Brandon, CEO and Co-Founder of Outerbase. We...
Comparing DB engines by CPU instructions for simple DML
When comparing databases, people often focus on the response time, but it's also essential to...
🤖AI-Powered Data Queries: Ask Questions in Plain English, Get Instant Results!🚀
You've might have heard of SQL. It's a widely used programming language for storing and processing...
SQL Leetcode Questions
SQL Leetcode Questions. Combine Two Tables - 175. Combine Two Tables Second Highest...
LuxDevHQ (Lux Academy and Data Science East Africa) Training Program in AI, Data Science, Analytics, and Data Engineering
LuxDevHQ (Lux Academy and Data Science East Africa ) offers a 6-month intensive Data Science,...
SQL Cheatsheet: A Handy Reference for SQL Commands with Examples
Welcome to the ultimate SQL Cheatsheet! If you're working with databases, you know how crucial SQL...
🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐
You know, sometimes Go is all you need to... well, go far. In this tutorial, we’re going full-stack...
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
Yesterday I attempted to solve alphanumeric sorting in MySQL and failed. (read that article here) I...
Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ
Databases are at the core of modern applications, from e-commerce to social platforms, powering...
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤
Our QA team are absolute monsters, they're monsters I tell you! No matter how much I try to bribe...
Streaming SQL in Stateful DataFlows
Streaming SQL Functionality SQL Streaming Queries and Stream Processing Operations is...
Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE
1. Simple-.NET-MVC-5-Shopping-Cart An experimental online shopping cart built using C#...
Choosing the Right Database for Your Project: Beyond Personal Experience
Hello, fellow developers!🧑🏼💻 When architecting a new project and selecting a database type,...
Comprehensive LuxDevHQ Data Engineering Course Guide
This comprehensive course spans 4 months (16 weeks) and equips learners with expertise in Python,...