How to Build an ML Pipeline With Python and SQL | Aman Kharwal
Learn how to build a practical ML pipeline using Python and SQL, from data extraction to model deployment, with real-world tips.
sql
Six SQL patterns I use to catch transaction fraud
The actual queries I run when I'm hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant clusters, off-hours buys, and window functions.
Build Your First Text-to-SQL App | Aman Kharwal
In this guide, I’ll show you how to build a Text-to-SQL app that takes your questions and uses AI to translate them.
A JavaScript developer's guide to Rails: What is Polymorphic Rails Model?
Learn how Rails polymorphic associations work under the hood, from database schema to model setup, with clear examples for JavaScript developers new to ActiveRecord.
Closing A Back Door In Illinois FOIAI Went To SQL Injection Court — Quarrelsome
How Google Ads Was Able to Support 4.77 Billion Users With a SQL Database 🔥
#60: Break Into Google Spanner Architecture (5 Minutes)
ben-n93/SQL-tips-and-tricks: SQL tips and tricks
SQL tips and tricks.
Difference between WHERE vs HAVING Clause in SQL
While both WHERE and HAVING are used for filtering rows, condition in WHERE clause is applied before grouping of data and condition on HAVING is applied after grouping
Using window functions for advanced data analysis
Window functions are an advanced feature of SQL that provides powerful tools for detailed data analysis and manipulation without grouping data into single output rows, which is common in aggregate functions.
sqlite-schema-diagram
GitLab.com
Happy New Year: GPT in 500 lines of SQL
A complete GPT2 implementation as a single SQL query in PostgreSQL.
SQL for Data Scientists in 100 Queries
New talk: Making Hard Things Easy
Resetting MySQL Root Password in Ubuntu: A Step-by-Step Guide
Introduction: Losing or forgetting the MySQL root password can be a stressful situation, but don't...
Joins 13 Ways
Meet LMQL: An Open Source Query Language for LLMs
Developed by ETH Zürich, the language explores new paradigms for LLM programming.
I Don't Need Your Query Language
Seriously, I don't. I'd prefer SQL.
How to Start Using psql in Terminal (for Beginners)
Intro Hello guys! Today I try to write about how to start using psql in Terminal app,...
Built-In Scalar SQL Functions
Cycle Detection for Recursive Search in Hierarchical Trees - Database Tip
Recursive queries are a straightforward solution to querying hierarchical trees. However, one loop in the relationship references results in a failing or never ending query when cycle detection is not used.
3 Essential SQL Optimization Techniques
Simple hacks to try before moving to a different data model altogether
SQL users: Halve the length of (some of) your queries with this one trick
The QUALIFY clause is pure syntactic sugar
5 Must-Know SQL Techniques Beyond the Basics
Speed up your SQL learning curve.
Essential SQL Commands For Data Science
Data is naturally at the heart of the job of a data scientist or data analyst. You can get your...
INTRODUCTION TO SQL FOR DATA SCIENCE
SQL (Structured Query Language) is a programming language used to manage and manipulate relational...
10 Essential SQL Commands for Data Science
Learn SQL commands for filtering, string operations, alias, joining tables, if-else statements, and grouping.
sqlite-utils: a nice way to import data into SQLite for analysis
Wesley Aptekar-Cassels | Consider SQLite
How To Create a SQL Practice Database with Python
Finally, start practicing SQL with your own database
The Not-so-Sexy SQL Concepts to Make You Stand Out
Databases are the houses of our data and data scientists HAVE TO HAVE A KEY! In this article, I discuss some lesser known concepts of SQL that data scientists do not familiarize themselves with.
6 Lesser-Known SQL Techniques to Save You 100 Hours a Month
Use these simple techniques to make your analysis and data extracts easier
How to Use the SQL GROUP BY Clause and Aggregate Functions
Bringing it back to the basics
Creating Conditional Statements in SQL Queries
A Quick Guide to the IF, CASE, and IFNULL Statements
SQL Basics Cheat Sheet
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
How to build a search engine with Ruby on Rails
Implementing search in your Rails app can be vexing. Here's a great pattern to use that combines the best parts of ActiveRecord and Postgres.
Inserting One Billion Rows in SQLite Under a Minute
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
Advanced SQL operations
Reviewing more advanced SQL operations to extract additional data insights from the Irish Weather dataset.
Ask HN: What is the SQLite of nosql databases?
3 Must-Know SQL Functions For Efficient Data Analysis
SQL is a programming language used by relational database management systems. It provides numerous functions and methods that operate on the data stored in relational databases. SQL is not just a…
The NoSQL Know-It-All Compendium - KDnuggets
Are you a NoSQL beginner, but want to become a NoSQL Know-It-All? Well, this is the place for you. Get up to speed on NoSQL technologies from a beginner's point of view, with this collection of related progressive posts on the subject. NoSQL? No problem!
Tricks for Advanced SQL Querying
One of the most valuable technical skills I use working on a data science team in the retail space is SQL…
A Hitchhiker's Guide to SQLite with Python
To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going...
How to Use SQL RANK and DENSE_RANK Functions
If you’ve been practicing your SQL religiously, like I suggested in Top Skills to Ace Every SQL Interview Question, then you’ve probably…
SQLite Plus: all the missing SQLite functions
The ultimate set of SQLite extensions.
SQLite is not a toy database | Anton Zhiyanov
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
The Last SQL Guide for Data Analysis You'll Ever Need - KDnuggets
The last SQL guide for data analysis you'll need! OK, maybe it’s actually the first, but it’ll give you a solid head start.
Beginner’s Guide to Querying Data Using SQL on GPUs in Python
Historically speaking, processing large amounts of structured data has been the domain of relational databases. Databases, consisting of tables that can be joined together or aggregated…
dolthub/dolt: Dolt – It's Git for Data
Dolt – Git for Data.
4 Advanced SQL Features You Haven’t Used Enough
From the power of hierarchical queries to that of procedural constructs in SQL
SQL Joins
521 votes, 27 comments. 411K subscribers in the computerscience community. The hot spot for CS on reddit.