MSBI

Hello Everyone, Since, I started off my career, I was hearing about classes, Methods, publics, private, objects blab blab and I tried a lot to understand it but somehow I couldn’t get a chance to learn it properly. (I am Electronics and Communication Engineer, LOL) However, now I made one sincere attempt and learnt a bit of it, which I would like to share with you guys who are having trouble in understanding it, as it was with me. Let us get into some story how an organization works and from there, we will try to relate the classes, objects, methods. We all have come across how a Multi-National Company works. Consider for instance, Microsoft Inc. Microsoft is one of the top MNC, anyone would dream to work with. We also know that there are many departments in Microsoft. As example, Data Management team, Licensing Team, Marketing team, Development team, testing team etc. Everyone has their own functionality and work they do is different from each other though all are work...

 In continuation with my previous blog,  here , we will discuss further more. Table Columns and Rows Usually the table is represented by “Fields” and “Records” which is wrong terminology. Just to improve our standard on SQL, we should refer as “Columns” and “Rows”. “Fields” are interfaces what we have on client applications and “Records” are what we have in files and cursors. Tables are logical and they are represented by Columns and Rows. There is nothing called “NULL Value” as mentioned above, null represents missing value. So we should rather call just NULL instead of saying it “NULL Value”. SQL Engine This is an interesting part of SQL. How the query is processed? Let us answer that in some time. SQL is English like language which uses common terms we use in English but converts into a code later stage. SEQUEL is original format (Structured English Query Language) was coined first but due to trademark dispute with Airline company, it is renamed as ...

Hello Everybody!!! This time, it is about Microsoft Exam. When I decided to take up Microsoft certification (MCSA) on Business Intelligence 2012 (I was planning from 3 years but was never that serious to write, Lol!! But now I am ready), I came up with training kit by Itzik-Ben-Gan. This book was very helpful for understanding the fundamentals of T-SQL and its architectures. However, for my preparation standpoint view, I am summarizing the tips and points from the book which I believe, going through main points, will help lot of them to get small tips instead of reading entire book before day of exam. So let’s start with SQL….!!! Standard SQL is based on the relational model , which is a mathematical model for data management and manipulations. The word relational is not about 2 tables related but it is from mathematical concept of Set Relation from “Set theory”. Relation in the relational model is called a “Table”. (T-SQL is based on multiset theory than on set th...