Everything I am going to write here is discussed in the book I am reading (actually chapters 1 through 5), it is probably discussed in many other books as well and it is discussed on the internet, on CodeProject and countless other websites. And what better way is there to learn than by writing about the subject? So that's exactly what I decided to do. So I am now, at the time of this writing, studying hard for my exam. The book of my choosing was Querying Microsoft SQL Server 2012. However it seems I need to use SQL Server more and more on a daily basis and as such I decided to at least read a book about it. Whenever stuff gets a little harder I have to ask Google or a coworker for help.

As a result I can find my way around querying tables, applying where clauses, grouping data etc., but I never got really good at it. I've had a couple of years experience with SQL Server (20), but I never really got the chance to really get into it. I am currently studying for my Querying Microsoft SQL Server 2012 exam (70-461) (Update: I passed the exam, whoohoo! :-) ). Converting types CAST and CONVERT, PARSE and FORMAT Set operators UNION, INTERSECT and EXCEPT.Querying from subqueries Derived tables.More filtering options IN, ANY, SOME, ALL and EXISTS Selecting from multiple tables using JOINS.Further limiting results TOP and OFFSET-FETCH.

Download adventureworks 2012 cube