Exclusion of certain topics from ITSM Syllabus for November,2012 Attempt & Onwards

Certain topics from ITSM syllabus have been excluded for the purpose of November,2012 attempt and onwards, relevant announcement regarding the same can be read on BOS portal

 HERE

Some Important SAP FI T-Codes (Financial Accounting)

Here are some important T-Codes of SAP including those related to General Ledger, Accounts Receivable, Accounts Payable, Assets and Bank -

OSI Model

OSI Model consists of 7 layers in total, respective names of which are depicted in diagram given below along with their respective positions as Outward and Inward Layers

OSI Model is a Linkage Framework of these seven layers each of which has a distinct role and authority area e.g. Network, Data Linking, User Interface etc. 

Significance of each of these seven Layers has been explained below--

Query Language, SQL and its parts

A Query Language is a set of commands to create, update, access data from database allowing users to raise adhoc queries/questions interactively without the help of programmers

There Exists Different set of Commands under each Language component of SQL

These Components/Commands are made clear and can be understood by the hierarchical chart given below :

Benefits of using DBMS

Data Base Management System acts as a route map to a distributed bunch of Database(s)

• Reduced Data redundancy and inconsistency
  
• Enhanced data integrity and security
  
• Provide logical and physical data independence
  
• Provide application Data Independence

Data Base and Data Base Management System[DBMS]

Data Base is a COMPUTER FILE SYSTEM that uses particular file organization to facilitate rapid updating of individual records, simultaneous updating of related records, easy access to all records, by all applications, programs, and rapid access to all stored data which must be bought together for a particular routine report or inquiry or a special purpose report or inquiry. As far as pats of DBMS are concerned, it consists of Data, Hardware, Software & User.