Building on the success of Morelan's previous series, this volume will help anyone transform themselves from a beginner "Joe" into a SQL 2012 "Pro."

As companies grow and do more business, the data they store in databases similarly grows. If you want to be a go-to person on the inner workings of SQL Server, then this book will be your partner in achieving that goal. If you have completed the "SQL Queries 2012 Joes 2 Pros(r) Volume 2" book you have written some advanced queries. This book builds on that knowledge and will show you more about the parts of SQL Server at work behind the scenes when you are running queries and creating new database objects. Most importantly, you will learn how to make the essential queries for your business run most efficiently and at the fastest speed possible. For those of you who have read the 2008 series for the 70-433 Exam you will find a lot of the same material from the SQL 2008 book in this SQL 2012 book. This is because much of the 70-461 test covers the same material as the 70-433. I have added material that is new to the test and removed material that is no longer relevant. If you have already read this series or have already passed the 70-433 exam you may choose to read my book which covers only the changes from 70-433 to 70-461 entitled "Joes 2 Pros SQL 2012 Queries 70-461 Exam for SQL 2008 Pros"

Once you know the basics of the SQL language, it's time to take the next step toward specialization: query writing! All objects in SQL support the need to get data in and out of databases, and writing queries is the key to capturing the data you want. "SQL Queries 2012 Joes 2 Pros Volume 2" shows you a proven roadmap that has helped many beginning SQL students get their certifications and launch their careers. If you want to get ready for MCTS certification, this is the second book of the Joes 2 Pros series. This book is totally focused on providing a fun, hands-on experience as it evolves your basic SQL skills and amps up your level of query writing expertise. This is Volume II of the Joes 2 Pros certification track designed to prepare you for the 70-461 SQL 2012 exam. If you are a total beginner, we recommend you first become familiar with the material in the "Beginning SQL Joes 2 Pros." For those of you who have read the 2008 series for the 70-433 Exam you will find a lot of the same material from the SQL 2008 book in this SQL 2012 book. This is because much of the 70-461 test covers the same material as the 70-433. I have added material that is new to the test and removed material that is no longer relevant. If you have already read this series or have already passed the 70-433 exam you may choose to read my book which covers only the changes from 70-433 to 70-461 entitled "SQL 2012 Querying, what's new and Cool."

Finally a book for the true SQL Server beginner! Whether you are brand new to data bases and are thinking of getting your 70-461 certification or already a semi-pro working in the field and need some fingertip support, this is this is the book for you. Joes 2 Pros does not assume you already know anything about data bases or SQL server. The Author, Rick Morelan, started out as a true beginner after he decided he had had enough of working on a fishing boat in Alaska. Rick struggled for years to acquire the knowledge necessary just to get his foot in the door. Many years later as an instructor, who was not happy with the instructional material available for his SQL students, he began the process of creating his own material. In 2009 Rick released his first book, "Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners" for SQL 2008. Due to its clear writing style, easy to follow images and free downloadable labs it quickly became a top seller on Amazon. This book builds on the success of the previous series and will help anyone transform themselves from a beginner "Joe" into a SQL 2012 "Pro." For those of you who have read the 2008 series for the 70-433 Exam you will find a lot of the same material from the SQL 2008 book in this SQL 2012 book. This is because much of the 70-461 test covers the same material as the 70-433. I have added material that is new to the test and removed material that is no longer relevant. If you have already read this series or have already passed the 70-433 exam you may choose to read my book which covers only the changes from 70-433 to 70-461 entitled "Joes 2 Pros SQL 2012 Queries 70-461 Exam for SQL 2008 Pros."

Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important — in the database world — SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales of such books as Learning SQL (O'Reilly) and SQL Queries for Mere Mortals (Pearson). Beginning Queries with SQL is written by the author of Beginning Database Design, an author who is garnering great reviews on Amazon due to the clarity and succinctness of her writing.

A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

As representatives from the IT community, all of us have had our own experiences of attending interviews - clearing or close to clearing and sometimes with tons of questions and doubts failing miserably. These stories are in the most pleasant or not so pleasant memories of our mind and we will assure you this book will kindle those memories for sure. We have taken tons of interviews and most of the interviews are not revolving around how deep technical and internals you know about the subject - but it revolves around how good you are with the basics.To clear an interview, one doesn't need to know inside-out of a subject, and subjects like "SQL Server" so vast that every single day we learn something new with this product, and even a complete lifetime will fly off if we keep doing this. Again, the various roles one can get into for products like SQL Server are from Database Developer, Database Modelers, Database Architect, Database Administrator and many more. Hence, this book is geared towards demystifying and a refresher for memories on the fundamentals which sometimes are the most important things to clear any type of interview for any role. Some of the concepts discussed are generic and are not tied to any specific version of SQL Server, but most of it the new features introduced with SQL Server have been included in this book.This book is not a shortcut or a sure to crack interview guide but this book gets you prepared in an organized manner. Let us also assure you this is neither a completely comprehensive guide but surely is a great starter nevertheless. Use this to guide you and be mentally prepared for the big day. When faced with this big day, we get overwhelmed and confused about where to start our preparation. And this book is just that secret recipe in your arsenal to get geared up. Sometimes these basics will help you narrow to a solution quickly when given a scenario.Now this book's flow is "Question & Answer" mode from start till the end to help you grasp the concepts faster and to the point. Once you get an understanding of concepts, then if we are twisted with the concept in a scenario it becomes easy to solve them. Most companies have a typical way to do interviews which are based on the scenario as per their environment and these are just combinations of the concepts to fit their need and SLA.Though each of these chapters is bucketed for convenience we highly recommend reading each of the sections nevertheless irrespective of the roles you might be doing as each of the sections have some interesting trivia's working with SQL Server. In the industry, the role of accidental DBA's especially with SQL Server is so common. Hence if you have performed the role of DBA for a short stink and want to brush-up your fundamentals then the respective sections will be a great skim.