Category: Other

May 01

Tech News: Microsoft has released in .NET Framework 4.7.2

Microsoft has announced the release of the .NET Framework 4.7.2 it is included in windows 10 April 2018 Update. It is also available on windows 7+ and windows server 2008 R2+ You can download .NET Framework 4.7.2 using Web Installer or Offline Installer What’s new in .NET Framework 4.7.2? ASP.NET Changes Support for SameSite cookie in ASP.NET in Page, Custom …

Continue reading »

Apr 30

Microsoft Certification Roadmap for Developers

SQL Server 2012/2014 Development

Using Microsoft Certifications you can get hired, demonstrate clear business impact and advance your skill sets and take your career to the next level. Microsoft has segregated these certifications broadly in six major categories, Today I am going to guide you the Microsoft Certification paths (marked in above figure) for web/database developer who develops web …

Continue reading »

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 »