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 create a clustered column chart in excelauto fit row heightproject management spreadsheet template excelconversion of xml file to excelexcel macro recordingcolorindex excel 2013dashboard reports in excelhow to use the sumif function in microsoft excel 2010ms word vba tutorialcreating a stock chart in excelvlookup formula in excel 2007adodb.connection vbaconvert excel to csv comma delimitedcreating pivot tables in excel 2007excel sumifvba excel loopsfso create folderediting macros in excelexcel 2007 practice test for employmentexcel vba open excel filehyperlink not working in excel 2007insert macro in excelvba multiselect listboxexcel vba chooseexcel 2007 dashboardsopen xlsx files in excel 2003unhide multiple sheetsvb questions and answerssum if vbaconcatenate functionapplication.workbooksvba hello worldinsert radio button in excelexcel color cell formulaexport from access to excel vbaexcel merge macrodefine merging cellssql ddl dml dcl commandsexcel dimexecutive dashboard excelforgot unprotect sheet passwordwhere is the pivot table in excel 2010excel vba subtract datesddl languagevba code vlookupremove blank from pivot tableabout excel formulas with examplevba unhide all rowssorting cells in excelaccess vba formatexcel vba save as pdfexcel isna ifaccess vba run sqli forgot my excel sheet protection passwordexcel if statement blankexcel lookup function exampleexcel delete blank columnsvba examples for excel 2007macro visual basic excelexcel 2010 sumif examplevariables vbavba excel macro tutorialjob costing templatems excel macro tutorialinterior color vbaexcel vba eventsvba excel pasteinsert button vbavlookup excel 2007excel 2013 pivot table calculated fieldhow to open excel workbookfso delete fileprotecting an excel spreadsheetexcel financial dashboard templatesexcel forgot password to unprotect sheetvba excel do while loophow to change cell width in excellookup function excel 2010password protect excel 2010microsoft word project plan template