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

recordset in vba excelvba sort rangevba code open filecountif formula in excelexcel vba programming pdfexcel for beginners tutorialvba collection excelexcel vba set background colorif statement in vbaado microsofthow to detect duplicate in excelexcel duplicate sheetsurface chart in excelproject timeline excel templateexcel shortcut to insert rowhow to use a lookup function in excelms excel iserrorproject management gantt chart excelworksheets in vbapowerpoint pyramid templateexcel macro countifvba filedialog filterms office 2007 interview questions answers pdfwhat does vba stand forexcel vba remove duplicateshow to use nested if statements in excelcontrols vbaoffset formula in excelnested if vbaprotect workbook in excel 2007excel interactive tutorialdashboarding in excelexcel 2007 autosave locationsumif formulahow to protect formulas in excel 2007find duplicates excel 2007project tracker excel templatefrequently asked technical interview questions and answers pdfexcel activexlookup functions in excelms word meeting minutes templaterows excel vbavba character codesexcel countif rangems excel interview questions and answersvbscript excelmacro excel for dummiesaccess vba tutorialvba excel waitunprotect excel workbook 2010vba cell font colorremove macro excelexcel vba write to access databasefso.movefile overwritecountif formula excel 2007excel match typeadvanced graphing in excelvba multiplicationfind duplicate email addresses in exceldashboard reporting with excel 2010definition of filtering in excelunhidingunique rows in excelcount rows excel vbaexcel vba select cellshow to password protect an excel workbookproject status report ppt templatehow to increase column width in excelcreate a userform in excelwhat is vlookup formulaexcel auto enable macrosvba select worksheetexcel color duplicatesmacro delete row3d plot in excelhow to convert xls to xml formatreverse vlookup in excelintroduction to sas ppt