How You Can Ace the Technical SQL Server Interview

A Pragmatic Approach to the Technical SQL Server Interview

4.40 (95 reviews)
Udemy
platform
English
language
Other
category
instructor
How You Can Ace the Technical SQL Server Interview
487
students
1 hour
content
Apr 2016
last update
$49.99
regular price

What you will learn

Be able to answer many real world SQL Server interview questions.

Understand how the buffer pool works and answer many questions around the storage engine.

Feel more confident heading into the Technical SQL Server Interview.

Description

Reviews from other courses: 

"Honestly Mike your classes speak for themselves. They're informative, concise and just really well put together. They're exactly the kind of courses I look for." -Alex El

This is a great course so far. Mike explains the content very well. - Doug

Course Summary

All videos filmed in 1080 and audio is crystal clear.

In this course we will move beyond the simplistic responses given by most SQL Server DBA candidates

We are going to give the answer the interviewer is looking for while adding a sentence or two more to reinforce to the interviewer our solid understanding of the concept. 

In the course we will be word smithing our way to an offer by adding additional pieces of information to every one of our interview questions. 

Here’s an example: What is SQL Server Profiler? We could simply say… it’s a tool that allows us to capture data about events. 

While that would be correct we are going to add to it and communicate to the interviewer that while it’s a great tool we know of and have used other options. 

Here the new response. Profiler is graphical tool for capturing the transactions running on an instance. However, it’s a very heavy tool and I’ll often use Adam Machanics's sp_whoisactive’s quick debug feature to capture data on live boxes because it’s much less resource intensive. 

With our new answer we’ve gone far beyond answering a question about profiler. We have indeed answered the question however we’ve let the interviewer know we use sp_whoisactive and why we use it. We’ve also communicated to them we know one of the greatest limitations to profiler and we have a way around that for troubleshooting live boxes. We’ve done this is one sentence. 

Thank you for your interest in How You Can Ace the Technical SQL Server Interview. 

The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you. 

See you in the course!!

Content

An Introduction to Technical Interviewing

Course Introduction
Is this course right for you?
What We Are Going to be Doing in this Course
Types of Authentication Modes
What is the default port number?
Local Temp Table Vs Global Temp Table
What is Log Shipping?
Should You Index Foreign Keys?
Summary
Quiz

How to Handle the Most Common Questions

What is a clustered index?
Difference Between a Primary Key and Unique Key
TRUNCATE vs DELETE. Some MYTH busting here.
How are Table Stats Different from Index Stats?
What are the Advantages of Stored Procedures?
What is the Buffer Pool?
Page Questions. What's a Page? What's Flushes a Page to Disk?
GUIDS as Primary Keys. More Myth Busting.
Is a Non-Clustered Primary Key Possible?
How DBAs Measure Subsystem Performance
What's the Difference Between OLTP and a data warehouse?
What's an Execution Plan?
Are Multiple Log Files a Good Idea?
The ACID Properties. Bonus Points on this Definition
What is Performance Tuning?
Performance Tuning Example
High Availability Options in SQL Server
Summary
Quiz

Conclusion

Final Thoughts. Thank you.

Reviews

Nancy
October 2, 2018
He hit most of the highlight of an interview although not all by any means. Easy to understand and work with explanations.
SJJB
January 25, 2018
SMART WAY TO LEARN AS WELL. YOU ACTUALLY KINDA SORTA INTTERVIEWING YOURSELF. IF GET. GOOD WAY TO LEARN
Sultan
August 29, 2017
This course covers some basic to intermediate level interview questions but the explanations are brief and to the point. It's a 1hr course that packs lots of information. Worth my time :)
Patrick
April 26, 2017
As usual, Mike presents information in a clear, precise manner. I liked that he made sure to summarize each section and provided a way to say the same information in your own words.
John
April 25, 2017
Mike does a great job of explaining the why behind answers, the why makes for a great review of concepts that I already know that I can then focus on to review more in depth. Thanks Mike!
Cisco
August 25, 2016
This is real world Valuable. Along with my credentials this interview guide helped me get an excellent new position!!

Charts

Price

How You Can Ace the Technical SQL Server Interview - Price chart

Rating

How You Can Ace the Technical SQL Server Interview - Ratings chart

Enrollment distribution

How You Can Ace the Technical SQL Server Interview - Distribution chart
822330
udemy ID
4/15/2016
course created date
11/20/2019
course indexed date
Bot
course submited by