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?
Nesta página do site você pode assistir ao vídeo on-line PHP Developer Interview duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Mikhail Savin | PHP 26 Outubro 2025, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 5,607 vezes e gostou 151 espectadores. Boa visualização!
