Category: Tutorials

May 06

A reference guide to access data in .Net

Data access layer is one one of important aspect in any application. I have written many posts on data access later using ADO.NET, DBProviderFactories, generic repository and Entity Framework. So in this post I am consolidating all  posts in one place. I will update this section whenever I publish new post related to data access. …

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 »

Sep 26

SQL Server Database Tutorial – Developers Guide

Introduction   MS SQL is a relational database management system developed by Microsoft. This database is used to store and retrieve data.   This tutorial explains basic and advanced concepts on MS SQL server like installation, working with database, step by step approaches, permissions, SQL.   This tutorial useful for Freshers ,Mid Level SQL Developers …

Continue reading »