I am not here to teach the basics by books which you will never understand. We must only eat whatever we can digest. Will start off with a quick introduction to Datawarehousing.
What is Data ?
Collection of information. Sales Data, Profit and Loss Statements, HR Data
etc.
What does Data contain ?
It consists of subject area specific information on the performance and measure.
Sales
Data : Consists of Sales information
HR - Human Resource Info about employees , payrolls etc
What are different types of Sales data?
HR - Human Resource Info about employees , payrolls etc
What are different types of Sales data?
Regional Sales , State Sales, City Sales
How is data stored?
Data is stored in Tables.
How are Tables stored?
Tables are stored in Databases.
Data is stored in Tables.
How are Tables stored?
Tables are stored in Databases.
What
are different kinds of Databases?
ORACLE,
MS SQL Server, IBM DB2, Teradata.
Databases
softwares which help to store the data at an organization level.
Stored
in several number of Databases
What is a database?
Collection
of tables in the Database.(mostly subject area related)
How
do we retrieve the data from the Database?
By passing set of commands called as "Query"
No comments:
Post a Comment