It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be comfortable with all the material in my SQL101 series. Specifically you’re going to need to know SELECT, INSERT, UPDATE, and DELETE. With those skills in hand, I’ll…
Month: March 2011
Tell me about your strengths
The next tough interview question I’ve often received is “What are your strengths?” As a knowledge worker you’ve got two ways to go here. You can go with the technical skills, or you can go with soft skills. Knowing which way to go can be tough. If you’re just starting out, or you’re applying for…
SQL301–XML VALUE Method
Last time, I covered the EXIST Method. This time around I wanted to show you how to pull out values from XML stored in SQL. Let’s start with what should have been a simple example. I wanted to pull the first and last name for a job applicant along with their resume in XML format….
Why Did You Leave Your Last Job?
Continuing with my series on tough interview questions, I’m going to take on one of the tougher ones. I’ve gotten a variation of this question at least once during each transition from one job to the next. The interviewer is looking for warning signs. He or she is trying to make sure you’re not a…
SQL 301-XML EXIST Method
And now it’s time to wrap up the XML in SQL posts. At least, this is the last of the information you’re required to know for the 70-433. Anything above and beyond this is great…just not required. Let’s dive right in! Exist This first method I want to cover is EXIST. With this method you…