Tutor profile: Karthiga R.
Subject: SQL Programming
Define SQL Programming. Define its role and importance.
SQL Programming is the standard language for Relational Database Management System.SQL has it own functions and it is used to modify the structure of the data stored inside the database. DDL and DML functions like Insert ,Update ,Delete,Select ,Create ,Drop,Truncate,Alter commands are used to restructure the data present in Database.It manages data efficiently and used to retrieve large amount of data.It is important because of its storage nature and ease of access.It is not a programming language.Learning SQL help us to work in any databases.Only few things and syntax changes present in different databases.
Define Database and its role in data storage.
Database is used to store ,define,manage and retrieve information.It is used to store large amount of information in single application.Data stored across table has meaningful data in it.It will give better understanding about the particular area in business.Data stored is used for analysis purpose and establishing relationship between tables help Business Analyst to make better business decision.
Subject: Data Engineering
Define ETL Process and explain any one of leading Datawarehousing tool ?
ETL is defined as Extract ,Transform and Load Process. Data stored in different databases in an Enterprise needs to be extracted and transformed as per business logic and Load in to Datawarehouse for analytical purpose.ETL concept is achieved using Data warehousing Tools.One of the leaders in Data Integration tool is Informatica Powercenter.It has
needs and Karthiga will reply soon.