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.
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
-
7:49
hayksimonyanrumble
6 months agoSQL Tutorial for Beginners
5 -
8:37
Learn and Grow
1 year agoSQL Basic Data Types Tutorial
2 -
3:47
Learn and Grow
1 year agoSQLservertutorial.net Walkthru
2 -
4:02
Learn and Grow
1 year agoSQL Server System Databases - Overview
1 -
4:00
Learn and Grow
1 year agoSQLBolt Introduction (Overview)
2 -
9:39
Learn and Grow
1 year agoSQL Server STUFF Function Tutorial
-
4:07
Learn and Grow
1 year agoSQL SELECT INTO Tutorial
2 -
23:22
Game Development
1 year agoUnreal & SQL Databases - Part 4 - Relational DB Primer
2 -
8:17
Learn and Grow
1 year agoSQL SELF JOIN Tutorial
1 -
8:51
Learn and Grow
1 year agoSQL Stored Procedure Tutorial
3