The Complete SQL Tutorial: From Basics to Scaling Databases
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: https://www.skool.com/web-dev-mastery
🔖 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
Watch video The Complete SQL Tutorial: From Basics to Scaling Databases online without registration, duration hours minute second in high quality. This video was added by user Hayk Simonyan 19 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 446 once and liked it 37 people.