The Complete SQL Tutorial: From Basics to Scaling Databases

No video

The Complete SQL Tutorial: From Basics to Scaling Databases

Рет қаралды 361

Күн бұрын

This SQL tutorial covers basic concepts of SQL databases, popular databases like MySQL and PostgreSQL, joins, queries, ACID properties, transaction concepts, isolation levels, scaling techniques like vertical and horizontal scaling, sharding and replication techniques, and performance optimization.
Free Web Developers Community and Courses: www.skool.com/...
🔖 Sections
0:00 What is SQL
0:47 Tables
1:29 Relationships
3:56 Indexes
6:21 Data Structures that are used in SQL
7:50 SQL Transactions and ACID Properties
10:40 Isolation Layers
12:27 Dirty Reads, Non-Repeatable Reads, Phantom Reads
14:01 Database Scaling (Sharding, Replication, etc)
15:46 Performance Techniques
16:35 CAP Theorem
#sql #sqltutorial #sqlforbeginners

Пікірлер: 4

@reynardlee3667 4 ай бұрын

wow i didnt know a lot of these before. very quality video thank you

@hayk.simonyan 4 ай бұрын

Glad to help!

@Ro45-ok8rd 4 ай бұрын

I scanned through your channel, and I appreciate your ability to explain system design concepts quickly and effectively. Your animations and explanations are simple and easy to understand. I particularly enjoyed your examples in TypeScript for design patterns. I would love to see more videos focused on system design, and it would be great if you could make them more structured. I also came across the ByteByteGo channel, and while the videos are good, I found them to be somewhat unstructured in comparison

@hayk.simonyan 4 ай бұрын

Thanks for your feedback, it’s very useful! If you’d like to see the system design videos in a structured way, then you can follow the system design playlist that I have, its structured in order that makes more sense