Support our 100% FREE Projects: Donate Now OR Sponsor Now

  

sql server interview questions and answers

In this blog post we present a collection of SQL Server related Questions and Answers.

You may also like to visit How to interview someone for a job

 

Contents:

 

Introduction


This section is dedicated to SQL Server interview questions and answers and because this subject is very broad; we decided to split it into multiple areas and focus of the interview.

 

Core SQL Server interview questions and answers

SQL Interview questions and answers - Here we provide questions to SQL language (query skills) which is the core skill in SQL Server.

Basic Interview questions and answers - Covers the basic questions only that most people should answer in at least 50-60%

Database Interview questions and answers - Understanding of database is KEY and here we published database related question using SQL Server.
 

SQL Server Business Intelligence questions and answers

BI Interview questions and answers In BI we will cover main concepts without going into technical questions which are covered below.

SSRS Interview questions and answers In SQL Server Reporting Services (SSRS) we cover mainly development of reports, using expressions, filters, actions and so on. We also briefly speak about related skill data visualization.

SSIS Interview questions and answers SQL Server Integration Services (SSIS) is very good ETL tool and we cover development, data quality, business rules and briefly data warehouse concepts.

SSAS Interview questions and answers (coming soon) - SQL Server Analysis Services (SSAS) we will ask cover development cycle, which will include dimensions, measure groups, cubes, dsv, calculated members and so on. For query specific questions please see MDX link.

MDX Interview questions and answers (coming soon) - Multi Dimensional Expressions (MDX) is very powerful language and also not so easy sometimes to grasp so we will cover understanding which is important with this language and we will ask how to create certain queries.

 

Jobs

If you are after a new job below we provide several links that you might find useful in your jobs search (we hope to add more soon).

UK Business Analyst Jobs - Business Analyst Jobs is a dedicated jobs portal for Business Analysts. There are thousands of current Business Analyst jobs online now. There is also useful career information to help you secure the perfect role

 

PDF Free Download

 
You can print our this page using our SQL Server Interview Questions PDF Free Download
 
 
 
 



Take care

Emil
Share: Share on FacebookShare on Google PlusTweet it
Comments Add Comment
Name: User
Comment: Excellent
Date Posted: 23/11/2011 5:26:04 AM

Name: Prem
Comment: This is one of the best answer so far, I have read online. No crap, just useful information. Very well presented. I had found another good collection of php interview question and answer over internet. Please check this link... http://www.mindstick.com/Interviewer/QuestionPage.aspx?topicid=17&topic=MSSQL+Server+2000%2f2005%2f2008
Date Posted: 24/11/2011 9:48:46 AM

Name: Rob
Comment:

Another resource for 

SQL Server Interview Questions
Date Posted: 07/04/2012 2:27:45 PM

Name: Sujeet
Comment:

Friends,

           I found this to be very nice and informative, more from the BI side. But if you have any questions related to SQL Server Administration, Maintenance, Configuration or reallife issues, then would suggest to go through http://www.sqldbaguru.com/, and I am sure you will get your answers!

Best of Luck!
Date Posted: 20/06/2012 9:48:19 AM

Name: Yatin
Comment:

hi

 

i'm interested in solution for the sql ssis interview que with , how can i improve ssis 

 

your all the interview question are really a good example of real time interview 

 

yatin
Date Posted: 17/08/2012 8:00:17 PM

Share your thoughts, questions and suggest improvements:
Add Comment

You found us! Below are 50 most popular searched keywords

created at TagCrowd.com

Disclaimer: While every caution has been taken to provide our readers with most accurate information and honest analysis, please use your discretion before taking any decisions based on the information in this blog. Author will not compensate you in any way whatsoever if you ever happen to suffer a loss/inconvenience/damage because of/while making use of information in this blog.