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, …
Tag: Interview Questions
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 …
Nov 21
Frequently asked SQL Queries in Interviews
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, …
Nov 05
SQL Query – Customer having maximum number of accounts
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 …
Sep 16
Entity Framework 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 …