Lag Function: Access data in a previous row in the same result set without having to join the table to itself.
How to use the SQL LAG window function to compare current and previous row values, with practical query and table output.
Sql
Project: Royal Stock Exchange(RSE) - How to Scale Our System to Millions? - Part 4
10,000 ft overview on how we plan to scale to our first 1,000,000 concurrent users
Project: Royal Stock Exchange(RSE) - First "Demo-able" Work - Part 3
Basic functionality of a stock exchange including Carousel Ticker, Line & Candlestick Charts, Portfolio page/screen & more.
Project: Royal Stock Exchange(RSE) - Seeding Stock Market data in SQL - Part 2
Seeding database records for our clients, understanding our records data types, and validating/designing relationships between resources.
Project: Royal Stock Exchange(RSE). Building a Full Stack Stock Exchange - Part 1
Build a stock exchange with .NET, Entity Framework, Flutter, Azure & more. Write backend code in C# & frontend using Flutter
Mastering PostgreSQL: Beyond Basic SQL
Learn how PostgreSQL extends standard SQL with advanced features, reliability, and open-source flexibility. This guide covers practical commands, differences from generic SQL, and tips for effective database work.