Complex DB queries. Profiling and optimising queries. Views, Procedures. Tips and tricks for composing queries. Scaling, sharding, replication

Transactions isolation, concurrency, and deadlocks

Course introduction. HTML/CSS/Javascript, Modern Web ecosystem

Relational databases architecture, SQL. Approaches to database design. Indexes explained

How do web servers work? HTTP/1, HTTPS, HTTP/2, reverse proxies, load balancing, CGI protocols

Components of the modern web application. Routing, middleware, ORM, queues, background jobs

Approaches to designing and documenting application API. REST, gRPC, GraphQL

Asynchronous web applications. Eventloop crash-course. Resources management. WebSockets, Long-polling

Javascript frameworks: browser APIs, jQuery, Angular, React

Javascript and ecosystem around it. Dialects, Build tools. Javascript architecture: prototypical inheritance, classes, modules

Authentication and Authorisation. Approaches to confirming user identity and permissions management in distributed systems

Testing web-applications

Security of web applications. Frontend and backend threats

Scalable architecture. Stateless applications. 12 factor apps

Modern infrastructure for running web applications: Containerisation, service-mesh. Clouds and Kubernetes