Here are the solutions to the homework problems I sent out. Compare my queries with yours. If they’re different, and you’d like some explanation on why they’re different. Let me know. I’ll be happy to explain any differences with you. 1. Give me a list of all the first and last names in both tables. …
SQL Homework–UNION, INTERSECT, EXCEPT
This homework will run from my training server, shaioshin.hopto.org. If you do not currently have access to this server, please let me know and I’ll set up credentials so you can complete the following homework assignment. In the AdventureWorks database on my server I have two tables: example.person and person.contact. Take a look at the…
Tell me about a time when…
During many of the interviews I’ve been in, I’ll be asked a very open ended question. To me this kind of question will give the interviewer some insight into how well you can summarize a larger topic into a brief, but informative comment. This skill can be very important for knowledge workers. Think about how…
Scotland 2011–Day One
I’ve been interested in history for as long as I can remember. About ten years ago, I turned my interest in history into a search to find out where my family comes from. What was our story? In this search I found that among other things the name Lowder has had many spellings. But all…
70-451 Prep–SQL Server Agent
Well, now that I’ve passed the 70-433, I’ve moved on to preparing for the 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008. It’s basically a follow-up to the last exam. The downside to this follow up is there are no books or self-paced study guides to help you get ready…
SQL201-The Syllabus
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…
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…