In this article, we’ll go through the design logic and steps to build a simple airline ticket reservation system by the help of transaction and stored procedure in SQL server.
Category: SQL
Learning SQL: What I learned after 100 LeetCode SQL questions
Building Effective Thinking Framework During the practicing process, I recorded my mistakes and studied how to make my solution more effective. I summarized them all and built up a thinking framework (or flow chart of SQL queries) which include the following essential decision points.
Learning SQL: Differences between JOIN types and Common Questions You have
For SQL learners, it is important to understand the concepts and differences between several JOIN types. A SQL JOIN statement is used to combine data and rows from two or more tables based on a common field between them. Let’s start with a classical venn diagram from C.L. Moffat, which clearly show the differences between…