SQL201
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
Latest
career development
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
SQL301
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
career development
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
SQL301
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
microsoft sql
SQL 301-The XML Data Type
We’ve spent the last few posts working on getting relational data out of our tables and into XML format. Most of the time, that’s what I’ve used XML
career development
What Interests You About This Opening?
We're back to my series on tough interview questions. It's my hope that by covering these questions, you're able to put together a plan on how you'll respond
SQL301
SQL301-Nesting For XML Queries
Given the 4 options I've shown you for creating XML output from SQL, you should be able to create nearly any structure you'd want (especially considering FOR
SQL301
SQL 301–FOR XML PATH
OK, I've covered FOR XML RAW for simple quick XML outputs. Then I covered FOR XML AUTO, while it automatically handles simple hierarchical data, it's still
Certification
I’ve Passed the 70-433!
I wanted to write up a post about passing my exam, and share everything I learned during this process. I had considered drawing parallels between the
career development
What Do You Know About Our Company?
Continuing my series on tough interview questions, I'd like to cover one that can really set you apart from the crowd. This one is testing you on how much
SQL301
SQL 301-FOR XML EXPLICIT
OK, so far I've covered FOR XML RAW. It's a pretty simple way to crank out some XML when you need to. FOR XML AUTO has better support for hierarchies, but it