PHP Developer Interview
Technical interview for a PHP developer position. 350k salary fork. There were two tasks: code review and database design, followed by theoretical questions on SQL, PHP, architecture, and security.
Based on the technical interview, I advanced to the next stage.
My TG - https://t.me/+LRgMEl62vxdmNjZi
Timecodes:
00:00 - Introduction
01:06 - First task (code review)
23:12 - Second task (DB design)
56:18 - How is a left join different from an inner join?
56:53 - Have you heard of a cross join?
57:27 - What's the difference between a WHERE and a HAVING?
58:11 - How do indexes affect insert and update operations?
58:49 - How do indexes work?
59:59 - Have you heard of WITH
01:01:52 - common table expression?
01:02:50 - What mechanisms implement atomicity and isolation at the DBMS level?
01:04:26 - What is the difference between read committed and repeatable read?
01:06:17 - What is autoloading in PHP? And can you implement it yourself?
01:09:48 - What is the unserialize function?
01:10:43 - Are arguments passed by reference or by value in PHP?
01:11:51 - Which architecture do you prefer for your applications?
01:15:24 - How to ensure flexibility when switching DBMSs?
01:17:04 - How to minimize risks/instability of external systems?
01:21:14 - What to do if the message broker crashes?
01:21:02 - What are some ways to protect against vulnerabilities?
01:24:43 - How to protect cookies?
01:26:42 - What is a JWT token?
Auf dieser Seite können Sie das Online-Video PHP Developer Interview mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Mikhail Savin | PHP 26 Oktober 2025 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 5,607 Mal angesehen und es wurde von 151 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
