Welcome to this series, where I will try to cover some of the most interesting and problematic topics in relation to this Microsoft Exam. The exam is a exam at the technology specialist exam, but to be honest, then it is an exam the divide people into two groups, where a lot of people tend to find the exam easy, and other people basically never pass.
With the proper preparation, then it should be quite easy to pass, but it requires a lot of hours of hard work.
this introduction is split into three parts:
2) What is required for this exam
3) supplementary reading / material
4) Video material
A lot of the material for this course can used to pass the exam for both SQL server 2008R2 and SQL Server 2008.
To be able to follow this blog, then you should have downloaded the adventureworks from codeplex.
then you should buy the book MCTS Self pased training exam 70-433. This is the core book for the exam, but let me be 100% honest. It will not make sure that you pass the exam.
WHAT IS REQUIRED FOR THIS EXAM
You can read Microsoft Official studyplan by clicking here, but you don’t get any idea about the level of what you are expected to learn. The level is quite technical, but not impossible.
To understand this exam, then we must start understanding why we have an SQL-server, and basically we use it to store data and to retrieve them again. We store information about a customer and we retrieve it again. It sounds simple, and it is. at some point then some guys figured out that we could store things in tables (Imagine a EXCEL-sheet) and that is the basic structure of a microsoft SQL Server.
Later on then someone figured out that it would be nice to store things in multiple tables and to normalize a database. The relational database was born.
Since that, the world has become a much more complex place to live, and that also goes for the Microsoft SQL server. Now we have XML-data, we want to be able to search like you do on Bing or google, and we want to do it faster and more effient.
During this course we will see how the relational database is created and how techniques to fullfill the requirements of today are used.
The book covers 9 chapters, and they are:
|1 – Data Retrieval||This is were we begin, and this is were we start to understand how to retrieve data from a relational database. the most important words are:
|2 – Modifying data||If you only know how to select, then it will be impossible to get data into the database, so you also need to know how to manipulate data. the most important words/techniques are:
|3 – Tables, data types, Integrity||Now you can retrieve data, you can insert,update and delete data, but what if you want to create your own database, then you must be able to create databases and tables. In this module we look at:
|4 – Additional query techniques||Â Basically you now know everything to be a databasedeveloper, but if you want to be a good one, then you should continue with this chapter and the following once:
|5 – Stored Procedures, functions, triggers, views||Not all SQL Statements are run on an Ad-Hoc basis, and the SQL Server is also build to use different techniques to perform better and do different tasks, and therefore this chapter is essential:
|6 – Query Performance||
|7 – XML, SQLCLR, Filestream||
|8 – Spatials, Full-Text Search, service broker||In this chapter you learn how to work with
|9 – Manageability features||This is a fluffy chapter, but there are four important things to learn:
This is the topics we will cover during the modules that I will upload over the next 30 days.