Tag: SQL Server

Nov 26

Student Course Instructor based SQL Queries

Interview questions

In my last post we discussed about Student, Course and Instructor based database design and relationships. In this post I will show you how interviewer will ask questions. I hope you already went through previous post. Question: Find students who enrolled more than two courses SELECT s.StudentId, (s.FirstName + ‘ ‘ + s.LastName) as Student, …

Continue reading »

Nov 25

Student Course Instructor based SQL Interview Questions

School based system design is one of most used case to start with any learning application. The typical school based system has four main entities i.e. Student, Instructor, Department and Course There are number of possibilities that interviewer may ask questions. So here I will show you the detail understanding of School based system. Database or …

Continue reading »

Nov 21

Frequently asked SQL Queries in Interviews

Interview questions

Today we discuss about the most frequently asked SQL queries in the interviews. In my previous article we discussed we created two tables i.e. Employee and Department with dummy data. I use same table and data from there except department. CREATE TABLE [dbo].[Employee]( [EmployeeId] [int] IDENTITY(1,1) NOT NULL, [EmployeeName] [varchar](50) NOT NULL, [Salary] [int] NOT NULL, …

Continue reading »

Nov 16

Sorting, Filtering, Searching and Pagination using SQL Stored Procedure

Application performance is one of the important aspect in any kind of software application. This non functional requirement (NFR)  developers forget while implementing (this in generally I observed while doing code reviews) table or grid design . Developers generally try to fetch all the records from database and displays using third party grids or open …

Continue reading »

Nov 12

SQL Triggers

A SQL Trigger is a special type of stored procedure that automatically executes when an event occurs in the database server. In my previous post we created employee table. So here I will use same table to create history of employee. This post explains how to create history on performing Insert, update or delete operation …

Continue reading »