Tag: Interview Questions

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 05

SQL Query – Customer having maximum number of accounts

Interview questions

Today, we will discuss one interested and most frequently asked interview question in sql server on customer and account table. I asked this question to may candidates, some gave right answer and some failed to answer it. The question was “Write down sql query to retrieve the customer having maximum number of accounts”. The problem …

Continue reading »

Sep 16

Entity Framework Interview Questions

Interview questions

Entity framework is now quite old ADO.NET approach and peoples uses this almost in every projects. I have made consolidated list of all frequently asked entity framework interview questions and generally useful for junior and senior developers. What is ORM? Which ORM did you used? Any other ORM’s do you Know? What is Entity Framework?a …

Continue reading »