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

word vba userformms access trim functionapplication.wait excel vbaexcel vba save as pdfvba cell interior colorlookup exelexcel agenda templatehow to multiply a column in excelwhat is the sumif function in excelvba delete rowcode vbavba oleobjectsvlookup limitationscopy excel cell to another sheetadd developer tab to the ribbonbuilding a graph in excelvlookup for dummies excel 2010excel cell mergedelete vbaexcel vba select cellsexample excel macroupdate hyperlinks in excelvba sortexcel vba sheetshow to record a macro in excel 2007word vbahow to protect file in excel with passwordhow to create macro button in exceldcl tclvba nested ifvba excel form controlsvba excel delete sheetvlookup formula for excelvb6 create text filevba excel read text filevlookup explained simplyvba select rangehow to learn excel vba programmingloop vba accessvba is emptyadodb connection stringms excel project management templatedelete row vbahow to insert a row in microsoft excelwhat is a hyperlink in excelexcel vba hyperlinkexcel vba unprotect sheet without passwordopen excel from access vbavba excel copy worksheetvba data validationfree excel formulas with examples in excel sheetvba vs macrominutes template excelvlookup excel sheet downloaduse excel to find duplicatesexcel vba formulaapplication getopenfilenamewhere is the pivot table in excel 2010vlookup examplestable pivot excelopen dialog box vbanested vlookup functionvba commentingexcel vba copy destinationexcel nested if and statementsautofiltermode vbahow to use sumifspss sqlhow to convert xls to xml formatcase excel vbaexcel vba queryexcel macro activate workbooklocation of personal xlsbnutshell tabsshortcut excelhow to unlock a password protected excel workbookproject management spreadsheet templates