SQL for Data Analysis – An Introduction for beginners

Home/SQL/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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is SQL?

SQL stands for Structured Query Language which is a computer language for storing, manipulating and retrieving data stored in relational database. SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, SQL Server, Oracle, Sybase, Informix, DB2 and other database systems uses SQL as standard database language.

Also they are using different dialects, Such as:

  • MS SQL Server using T-SQL
  • Oracle using PL/SQL
  • MS Access version of SQL is called JET SQL (native format ), etc…

However, they all support at least the major commands (like SELECT, UPDATE, DELETE, INSERT, WHERE) to be compliant with the ANSI standard.

Why SQL?

  • Allow users to access data in relational database management systems
  • Allow users to describe the data
  • Allow users to define the data in database and manipulate that data. For example, inserting records,updating or deleting records
  • Allow users to create and drop databases and tables
  • Allow users to create view, stored procedure, functions in a database
  • Allow users to set permissions on tables, procedures, and views
Topics
  • Basics of Database:
    RDBMS stands for Relational Database Management System. A Relational database management system (RDBMS) is a database management system (DBMS).
  • 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.
  • SQL Arithmetic Operators:
    Arithmetic Operators, Comparison Operators, Logical Operators and Wildcard Operators helps Analysts while extracting and summarizing the data for analysis.
  • SQL Commands(dml, ddl, dcl, tcl) for Data Analysis:
    SQL Commands(dml, ddl, dcl, tcl) help Analyst to create database,tables, views, update data. Also help to fetch the data and summarize to perform analysis.
  • SQL Functions for Data Analysis:
    SQL functions help to aggregate the data while extracting the data from Data base. There are many functions available in SQL to aggregate the data.
  • Sorting and Grouping in SQL or ORDER BY and GROUP BY Clauses:
    We can sort and group the data based on certain variables/ columns and understand the data., we use Order By, Group by helps to Sort and Ggroup data in SQL.
LIMITED TIME OFFER
By |December 20th, 2012|SQL|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment


Related pages


excel vba password recovery codesimple pie chart worksheetmacro security excel 2007vba open files in folderhow to place a tick in excelsimple excel gantt chart templatevba selection.findsave vba excelhow to convert excel to xml in excel 2007copy data from protected excel sheetexcel function vbavba coding tutorialexcel macro autofilterworking with graphs in excelproject schedule template excelshortcut key for hide in excelmonthly gantt chart excel templatewhat is the formula for adding a column in excelvba inputbox cancelexcel vba ribboncheckboxes in excel 2007steps in creating a chart in excelmeaning of vlookup and hlookupddl dml dcl tcl commandsexcel fix columnsvba remove passwordhow to unhide cells in excel 2010buttons vbavb interview questions and answers for experiencedcosting spreadsheet templateexcel macro range cellsexcel vba open files in folderrecordset vba accessvba for continueexamples of vlookup in excelexcel pivotchartsumif excel vbamacro to combine worksheetsexcel vba sort rangenested if and statements in excel 2010dml commands in sqlexcel macro delete columncool macrosmerge and center cells excel 2007vba variablesshortcut key for change sheet in excelexcel vba chartcase statement vbaactivate developer tab in excel 2010if statement in ms excelhlookup examplesiif in exceldml commands sqlvba excel codevba programming for excelhow to record a macro in excelembedded chart in excelvba insert multiple rowsdml and ddl commandsremove hyperlink in excelexcel macro checkboxvba userformtick excelwhat does vba mean in excelexcel vba break for loopexcel vba sort rangeconcatenate function excelaverageif in excelvba to unprotect sheet with passwordvba uppercaseshortcut key to insert a row in excelexcel nested if statement examplesvba excel close fileexcel dashboards and reports for dummiesworkbook objectbackground color vbavba excel sqlexcel undo macrohow to protect specific cells in excel 2007