SQL helps Analysts to perform ETL transactions on required data set in data analysis tasks.We can extract the data from data base, format the data, summarize and analyse it.

SQL Commands for Data Analysis

SQL Commands will help Analyst to create database,creating new tables and views, update or deleting the existing data. SQL commands help to fetch the data from the database and format it to required standards and summarize to perform analysis.

By |February 13th, 2013|SQL|1 Comment

SQL Operators

SQL Operators helps us to write expressions in SQL queries, We use Arithmetic Operators, Comparison Operators, Logical Operators and Wildcard Operators while extracting and summarizing the data for analysis.

By |January 13th, 2013|SQL|1 Comment

SQL Statements

SQL use the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database.

By |December 25th, 2012|SQL|1 Comment

Basics of Database

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

By |December 24th, 2012|SQL|1 Comment

SQL for Data Analysis – An Introduction for beginners

SQL plays an important role in data analysis. When we are analyzing more number of records, we summarize the data and then analyse it. We do lot of ETL tasks to extract the data from data base and clean and format the data. Once we are created a clean data set, we go for analyzing the data to get more insights from the data.

By |December 20th, 2012|SQL|0 Comments

Related pages

how to use vlookup functionuse of activex controlvb program for calculatorimportant interview questions in sqlwhere is autofit in excel 2013excel macro create buttonreturn value vbaif statement vbavba hide columnexcel vba format cellexcel macro merge cellsvba if elseifgantt chart template powerpoint free downloadmeeting minutes template microsoft wordhow to create a named range in excel 2010how to duplicate a cell in excelvb nested ifexcel concatinationvba writervba variant typeexcel 2010 macro securitybusiness analyst interview questions and answers pdfvba selection.deletemacro insert rowunprotect sheet commandmacro excel exampleslookup function in excel 2007excel macro developmentshortcut exceladvance excel tipshow to lock an excel sheet with passwordtexfiletick boxes excelschedule template for excelfor each in vba excelexcel simple macroembed forms combobox 1excel vba combobox control sourceexcel delete blank rowunlocking password protected excel filems excel programming tutorialremove duplicate entries from excelvba macrosunload me vba excelsurface charts in excelexcel vba hlookupexcel formula not blankexcel 2007 if statementsql basic interview questions and answersvba declarationexcel if cell containscombobox multiselectshow developer tab in word 2010excel formula for difference between two datesexcel vba range selectmultiple pivot chartsrun macro without opening workbookhow to create check boxes in excelexample for vlookupexcel color index valuessort highest to lowest excelediting macros in exceldeveloper ribbonvba sql wherevba refresh pivot tablepassword worksheetvba statusbarvisual basic checkboxexcel insert multiple columnsmacro to find duplicates in excelmerging cell in excelhow to turn on macro in exceldownloadable excel templatesexcel hyperlinkexcel combo box propertiestrending analysis excel