MS SQL, T-SQL, and SQL Server Interview Questions

Author: William Barden
Publisher: William Barden
Kindle: B00SXNZ94I
Audience: SQL developers
Rating: 3.5

Reviewer: Ian Stirk

This book aims to help you succeed in a SQL developer interview, how does it fare?

This book covers interview questions that relate to the role of a SQL developer, with a bias towards a Microsoft environment.Available only as a low-cost Kindle ebook, it consists of eight short chapters, and two appendices. The book covers both technical and soft skill questions.

Below is a chapter-by-chapter exploration of the topics covered.  

 

Banner

 

Chapter 1 SQL Server Questions

This chapter contains questions largely related to the SQL Server environment. Areas covered include: converting flat files to a relational database, port numbers, SQL Profiler, BCP, SQL injection, storing user names and passwords. Example questions include:

  • What is SQL Server?

  • What is a relational database?

  • What is SQL Profiler?

  • What is BCP?

The answers to the questions are typically quite terse. You will not be able to use this book to learn the subject detail, because the answers are much too short. However, if you know the subject already, the questions (and answers) do provide useful examples/starting points of what to expect at an interview. Additionally, the questions might highlight some of your weaker areas of knowledge that need further attention.

Chapter 2 Basic SQL Questions

This chapter contains questions largely related to basic SQL. Areas covered include: ANSI SQL, semi colon delimiter, data types, normalization, denormalization, primary key, foreign key, unique keys, Data Definition Language(DDL), Data Manipulation Language (DML), Data Control Language (DCL), Transaction Control Language (TCL), constraints, not null, check, view, distinct, in, and or, order by, top, joins, left join, right join, union, union all, truncate, delete, rollback, and IfNull. Example questions include:

  • What is ANSI SQL?

  • Is SQL case sensitive?

  • Give examples of SQL Server data types

  • What is a foreign key?

This is another wide ranging chapter, but again the answers are too short for anything more that starting points. As an example of the brevity, for the question “What is normalization?” the answer is:

“Normalization eliminates redundancy or duplication in table entries by organizing data into smaller tables.”

As well as being an obtuse answer, nothing is said about removing repeating groups, column that depend on only part of a composite primary key, or columns that depend on other non-key columns.

Chapter 3 T-SQL Questions

This chapter contains questions largely related to T-SQL. Areas covered include: T-SQL, declaring variables, printing values, IF/ELSE, break, continue, using cursors, @@fetch_status, triggers (before, after, instead), transactions, commit, and rollback. Example questions include:

  • What is T-SQL?

  • What is a rollback?

  • What does implicit_transactions do?

  • How are trigger created?

  • What is the default value of variables?

This is another short and sharp chapter, covering a wide area but with little depth.

Chapter 4 SQL/T-SQL Query Questions

This chapter contains questions largely related to SQL/T-SQL query. Areas covered here are more practical than previous chapters. Example questions include:

  • How can you selects only records having a null value

  • Write a SQL query to get the current date

  • Write query to find the number of employees by gender, whose birthday is between 01/01/1970 and 12/31/1979

This chapter was more hands-on, providing sample case study questions that you might be asked about at an interview.

Chapter 5 SSRS Questions

This short chapter contains questions largely related to Microsoft’s SQL Server reporting tool, SSRS. Example questions include:

  • What is SSRS?

  • What is report manager?

  • What are ad hoc reports?

This was a very short chapter, consisting of just one page of questions on the Kindle.

Chapter 6 SSIS Questions

This short chapter contains questions largely related to Microsoft’s ETL tool, SSIS. Areas covered include: migration, DTS, BIDS, import/export wizard, transformation, SSIS tasks, global variables, function level variables, control flow, and precedence constraints. Example questions include:

  • What is SSIS?

  • What is BIDS?

  • What is dtutils?

  • What types of containers can be run in SSIS?

  • What is control flow?

MSSQLQA

 

Chapter 7 Appearance, Experience, Personality, and Social Skills

This chapter offers practical advice on softer interview skills. Topics covered include how you look (better to be overdressed than underdressed), tardiness, and team fit. It’s well worth thinking about these questions before you attend the interview. I enjoyed this chapter, it identifies several small (and not so small) attributes that can tip the interview in your favor.

Chapter 8 Behavioral Interview Questions

This chapter asks questions that relate to how you interact with technology and people. Again, you should think about these questions and their answers/consequences before you attend the interview. Example questions include:

  • How do you keep up to date with technology?

  • What’s your worst quality?

  • How do you feel about peer reviews?

  • Where do you see yourself in 5 years time?

These open questions aim to dig deeper into what kind of person you are, how you learn, how you interact with others, how you take criticism, and how ambitious you are. You’ll typically spend plenty of time working with other people, so team fit is an important aspect of most jobs.

 

Appendix 1 SQL command reference

This is a list of SQL commands (e.g. CREATE VIEW), it does not mention where any of them are used in the body of the book. I guess this appendix provides syntax for creating tables etc that you might be asked about, but since this information is readily available on the Internet, I hope it wouldn’t be asked for.

 

Appendix II T-SQL operator, keyword, and function reference

Again this is a standalone list of features that does not cross reference the main body of the book. This might be useful if you understand the features already, and you want to run through their definitions in your mind.

Conclusion

This book aims to help you pass an interview for a SQL Developer. It provides plenty of basic SQL questions, and terse answers, perhaps too terse. If you already know the topics discussed, then the questions and answers are good starting points to expand upon. Most of the questions are relatively basic, but don’t cover all basic areas (e.g. Common Table Expressions are not mentioned).

The book could be improved by including more questions, providing more detailed answers, and by asking and answering more open technical questions (e.g. what troubleshooting techniques have you used? What do you do if a query suddenly runs slowly?).

Overall, I enjoyed this book, but that might be because I like answering questions! The book should be useful for SQL developers who already know the topics, and want to quickly revise some typical questions and answers – but don’t expect to learn too much. If you don’t know all the answers, the book will highlight the topics you should focus on.

 

Banner


Computer Concepts And Management Information Systems

Author:  C.P Gupta and K. K. Goyal
Publisher: Mercury Learning
Pages: 250
ISBN:978-1683925866
Print:1683925866
Kindle: B08CVSHKG3
Audience: General
Rating: 3
Reviewer: Kay Ewbank

This book is an introduction to the basics of what a computer is, what software is, and what management information syste [ ... ]



High Performance SQL Server, 2nd Ed (Apress)

Author: Benjamin Nevarez
Publisher: Apress
Pages: 420
ISBN: 978-1484264904
Print: 1484264908
Kindle: B08TQR3NMF
Audience: SQL Server DBAs and Devs
Rating: 4.5
Reviewer: Ian Stirk

This book aims to improve the performance of your SQL Server, how does it fare?


More Reviews

Last Updated ( Monday, 02 March 2015 )