MySQL
قاعدة البيانات مفتوحة المصدر الأكثر انتشارًا على الويب.
MySQL is the open-source database behind WordPress, countless PHP and Laravel apps, and some of the largest sites on the web. You already speak SQL from the SQL track, so this course maps what you know onto MySQL 8.4 LTS and shows where it differs from PostgreSQL: the mysql client, data types, utf8mb4 for Persian text and emoji, InnoDB and its clustered primary key, EXPLAIN, transactions under REPEATABLE READ, upserts with ON DUPLICATE KEY UPDATE, least-privilege users and backups you can actually restore.
Every lesson is short and practical, and the result sets stay tiny, so you can check every answer by eye.
- الدروس
- ١٤
- الوقت
- ٢ ساعة
- المستوى
- متوسط
دروس هذا المسار بالإنجليزية حاليًا.
- البرونز متاحة
- الفضة متاحة
- الذهب مقفلة
مستعد لإثبات نفسك؟
ثلاثة امتحانات في انتظارك: البرونز والفضة والذهب.
ما ستتمكن من فعله
- Connect with the
mysqlclient and find your way around databases and tables - Translate PostgreSQL habits into MySQL:
AUTO_INCREMENT, booleans,DATETIMEandTIMESTAMP - Store Persian text and emoji safely with
utf8mb4 - Read
EXPLAINand design indexes around InnoDB's clustered primary key - Use transactions and
INSERT ... ON DUPLICATE KEY UPDATEcorrectly - Create least-privilege users and take backups you can restore
الرحلة
١ الوحدة ١MySQL for SQL people
Where MySQL runs, the mysql client, the data types that differ from PostgreSQL, and utf8mb4.
٠ / ٤٢ الوحدة ٢Running MySQL well
InnoDB and indexes, transactions, upserts, users and backups.
٠ / ٦٣ الوحدة ٣Next steps
Replication, slow queries, JSON columns and changing big tables without downtime.
٠ / ٤