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

range property vbahiding in excelunlock microsoft excelexcel macro write to text filelookup excel 2007add developer tab in excel 2007vba databaseexcel vba securityvlookup multiple conditionsvba clear cellms access msgboxsort alphabetically excelexcel vba sheet namedelete activex controlvlookup applicationunhide workbookexcel insert row macrodo until loop vbaexcel xml file formatexcel chart typesexcel 2013 developer tabhow do you delete a sheet in excelcopy sheet to another sheet vbaremoving cells in excelnested if vbasheet activate vbadebug vbahow to convert excel to xml in excel 2007access vba connection stringvba for continuesql written interview questionsiserror formulaexcel 2007 macro tutorialmerge columns excelexcel duplicate entriesremove duplicate data in excelhow to insert a title in excelexcel macro workbookremove a hyperlink in excelworkbooks.open filenameresidential construction schedule template excelunhide worksheet excel 2013change font color vbahide rowsuse of hlookup in excelchange width of column in excel 2010how to unhide top rows in excelcreate a dropdown list in excel 2007excel vba with rangeredim in vbalearn vba in excelexcel estimate template constructionvba code open fileprotect excel sheet with passwordvba import data from another workbookexcel vba reference cellddl and dml querieslock excel sheet for editingexcel vba current worksheetms excel shortcut keys formulaslookup function excel 2007paste function in excelhow to protect excel sheet 2007 with passwordvariable types in vbaproject timelines templatescomment excel vbavba msgbox syntaxvba delete entire rowexcel vba on cell changeestimation excel sheetshow hidden tabs in excelsample dashboard reports in excelexcel vba manualexcel vba clearcontentsexcel bar chart examplesfor loop vba excel