Welcome to the SQL Server Practice Interview for Performance Tuning. I’m Kendra Little from SQLWorkbooks.com.
Sometimes you get to a point in your career where you want to take on more. You’ve been doing a little bit of work with performance tuning and you’d like to have more of that as part of your job. You want to help make sure that SQL Server runs fast, and tune queries to get the very best performance from them.
To get that job you usually you have to go through an interview process.
When it comes to interviews, practice can help you a lot
I no longer think that the goal is to have the perfect answer for every question in terms of factual knowledge because the truth is, interviews are designed to test your knowledge in a variety of ways, to see how you think about things and how you solve problems.
There isn’t always a perfect factual answer to every question.
A great interview is an interview where you don’t necessarily have all the answers but you show what your skills are, you show how you learn, you interact with the team that’s interviewing you and show how you work with other people, as well as demonstrate some of your knowledge and some of your skills.
Practicing for an interview can help get you into the right mindset to do this and get you into an area where you can handle questions where you know maybe *some* of the information.
Or maybe it’s a really complex answer and you’ve practiced at thinking about how to distill that down into the key points.
When you’re practicing answering questions for an interview, practice answering the questions out loud
You’ll have videos in this course where I just ask the question.
Watch the question video first, and then don’t watch the answer video right away. Wait. Answer the question on your own out loud.
You may want to find time by yourself where you can do this, if you’re embarrassed to have someone hear you. Just scope out some time when you can do it out loud, and then watch my sample answer.
After you listen to my answer, think about your answer and think, okay, is there a way I’d like to redo that? Then watch the question again and iterate until you feel really, really happy with your answer and just more comfortable with it.
I do this myself when explaining concepts
The first time that I explain a concept never goes quite as smooth as after I’ve done it a couple of times. The truth is, once you get into a pattern of, okay, here’s how I can explain these things, handling a new concept that you want to explain or thinking through a new problem comes more naturally with this practice.
In this session…
I’ll give you tips on handling questions when you don’t know an answer, as well as how to cover special situations.
I’ve got a cheat sheet for interview candidates to download. It’s all of those things where— things that we might forget to do along the way, lots of little reminders to help make sure that you prepare as well as you can and arrive at the interview in the best mindset, ready to just knock it out of the park.
Let’s get going and get on to some practice questions!