Database Management
154 Threads
Wanna learn SQL? Stop taking yet-another-online-course. Do this instead 🧵
Need SQL Project Idea? Open this:
I am using SQL since 2004. If I have to start learning it today, I'll do this:
Need SQL Project Ideas? Open this:🧵
The "window" in "window function" refers to a set of rows. SQL windows function clearly explained:
SQL Indexes are quite useful but can also cause issues! The Truth about SQL Index
One concept I struggled to understand as a Data Analyst was DataBase Normalization I'm going to explain it to you so you don't have to /🧵/
Need SQL Project Ideas? Open this:
12 database types you can use in 2024 and when to use them: 1 - Relational Databases (SQL) - Ideal choice when your data is structured and needs to be consistent - Supports ACID...
Bringing AI into your Databases! 🔥 Introducing SuperDuperDB an open-source framework for building AI Applications right in your databases. Thread🧵👇 https://t.co/VO8kLpTPpO
Mastering SQL Server Log Shipping: A Case Study 📊 https://t.co/Oo3FkQ4oTC
How Discord Stores Trillions of Messages In 2015, Discord started using MongoDB to store messages. By November 2015, there were already 100 million messages that did not fit in RA...
Be an SQL Expert in 2023 A complete roadmap for absolute beginners:
I think many struggle with OLTP relational databases because we do a bad job educating people, and many of our best practices are not actually best practices. RDBMSes can do a lot...
SQL subqueries can be one of the most challenging parts of SQL to learn. To help you grasp them I've put together this super-simple guide:
Backend language: 🧮 JavaScript 🧮 Python 🧮 Java 🧮 PHP 🧮 Go 🧮 C# 🧮 Ruby 🧮 Kotlin 🧮 Rust Frontend language: 🖥️ JS 🖥️ TS UI: 🎨 React 🎨 Vue 🎨 Angular 🎨 Svelte DB: 📁 PostgreSQL 📁 MySQ...
R.I.P. SQL? The most powerful AI can now query databases. Here’s the step by step guide:
Dear DATA Analysts.🚀 Last week, I shared resources on EXCEL, DATA VISUALIZATIONS (PowerBI and Tableau), with FREE places to acquire CERTIFICATION for your DATA ANALYTICS course....
To master SQL, you need to have an extremely good understanding of SQL statements: They're mainly divided into 5 categories: DDL, DQL, DML, DCL, TCL Here's the simplest guide to...
SQL Notes Thread 🧵 https://t.co/6HjGgXWfjm
If you want to know the secret to optimizing SQL queries, open this: 🧵 https://t.co/qVJNI1hePz
Vector databases may be the next "big thing" • Vector databases explained • What is Unstructured data? • When to use vector databases • Embeddings. • Use-cases All you need to kn...
Are you completely new to SQL and do not know where to start? Here is a simple concept roadmap for learning SQL as a complete beginner: 🧵 https://t.co/aaPwA4RCzv
NoSQL databases have skyrocketed in popularity. But we use NoSQL as a common term for anything that's not SQL. In reality, NoSQL databases come in 4 different flavors. And each...