The Complete SQL Tutorial: From Basics to Scaling Databases

7 months ago
8

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.

For weekly insights on web development that you won’t want to miss, subscribe to My Newsletter: https://hayksimonyan.substack.com

Connect With Me On Other Platforms:
✍️ Medium: https://hayk-simonyan.medium.com
🆇 Twitter: https://twitter.com/hayksimonyann
💼 LinkedIn: https://linkedin.com/in/hayksimonyan
🧑‍💻 GitHub: https://github.com/hayk-simonyan
🌐 Website: https://hayksimonyandev.web.app

🔖 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

Loading comments...