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

excel template downloadssql query interview questions and answers for freshers pdfexcel shortcut for insert rowexcel vba formsvlookup vba examplehow to adjust column width in excelweekly task report template excelhow do i get rid of duplicates in excelhow to do drop down in excel 2007ms excel 2007 formulas with examplesinsert comment excel shortcutexcel offset vbavba activex controlstrim function in excel 2010vba sortingdynamic pivot table in sql server 2008worksheet copy vbaeliminate duplicates in excelproject management excel spreadsheetexcel vba errorvba application.worksheetfunctionvlookup excel example 2010ms access msgboxexcel vba countif functionsample excel macro programsmicrosoft office invoice templates for excelexcel unlock password protected filesumif function in excel 2007delete empty cells exceltcs business analyst interview questionsbeginners sqlworkbooks open filename vbanested if else in excelwhat is the default column width in excelscreenupdating vbawhat is iserror in exceldefinition of row and column in ms excelformula to find duplicates in excelmacro programing in excelexcel how to identify duplicatesexplain macros in excelexcel check for nullcopy to clipboard vbaunprotect excel vbahow to open xlsm file in excel 2003vba datevaluecombobox vbahow to protect a excel sheetddl commands sqlexcel vlookup example downloadactivesheet range autofilterhow to copy cells in excel to another sheetvba alertexcel 2007 shortcut keyscountif function on excelisna excel formulaexcel sheet hiddendeclaring arrays in vbaexcel vba cells offsetexcel unhide sheetssample dashboard reportsexcel macro password removerexcel hyperlink to cellexcel enable macrovb interview questionsdashboard creation toolsworking with graphs in excelconvert excel to csvhr interview questions for freshers with answers pdfexcel vba with selectionsql sasaccess vba msgbox yes noapplication workbookshow to use concatenate function in excel 2010