PostgreSQL for Developers
Go beyond "SELECT * FROM users". This comprehensive course takes you from SQL basics all the way to advanced PostgreSQL features used in production: indexing strategies, query optimization, JSONB, full-text search, row-level security, transactions, and connection pooling. By the end, you will design and optimize databases like a senior engineer.
نظرة عامة على الدورة
- مستوى BEGINNER:
- 7 ساعة 36 دقيقة (HD video)
- 35 محاضرة
- التطبيقات العملية
- الوصول للدورة مدى الحياة
- تعلم بالسرعة التي تناسبك
عملي ومتميز
أهداف الدورة
- Write confident SQL queries from simple SELECTs to complex window functions
- Design normalized, efficient relational schemas
- Implement B-Tree, GIN, and GiST indexes for maximum query performance
- Use JSONB to store and query flexible document-style data
- Build full-text search without external services like Elasticsearch
- Manage transactions, understand isolation levels, and prevent deadlocks
- Secure data with Row Level Security (RLS)
- Configure connection pooling for production traffic
دورة منظمة تماما
محتوى الدورة
الطالب المستهدف
لمن هذه الدورة؟
Backend developers who want to master databases
Junior developers moving from ORM-only to raw SQL
Data analysts who want to write professional-grade queries
System architects designing scalable data models
Full-stack developers who want to stop treating the DB as a black box
ما ينبغي عليك معرفته
المتطلبات الأساسية
Basic computer literacy
No prior SQL knowledge required — we start from zero
A laptop with internet access
Curiosity about how data is stored and retrieved
التوصيات
ما يقوله طلابي
مجهود وتوصيل معلومة بطريقة بسيطة وسلسة , جزيت الخير وربنا يزيدك علم وفهم وينفع بيك الناس
.Mousa A.
Incredible work! Kareem's explanation is succinct and straightforward. Much appreciated!
.Tamer A.
yes it is simple and amazing for more colmplex topics with easy way to understand
.Omar B.