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
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.
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