SQL Basics

Home/Tag:SQL Basics

Learn SQL Basic to perform Data Analysis. SQL basics helps to understand the basic concepts of SQL which are required for Analyst.

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

easy excel macrosvba msgboxdim as workbookisna in excelsql sort syntaxcreate pie chart in excel 2013planner format for excelexcel vba programming ebookword template meeting agendavba application vlookupexcel vba shortcutdaily task tracker on excel formatif statement examples in excelhow do you hide rows in excelddl commands in dbmsexcel vba savecopyasprogram vbahelpful excel macrosexcel dashboard templates xlsexcel instr functionexcel vba userform code examplesms access vba msgboxexcel row widthhow to unlock a password protected excel workbookexcel 2007 drop down list multiple selectionunlock excel workbook passwordexcel implementation plan templatehow to use vlookup excel 2010excel hyperlink to folderunprotect excel vba codesumifs examplesunmerge vbahow do i unhide column a in excel 2010vba selection.copyautofiltermode vbavba code wordsumif function on excelexcel averageif formulahow to autofit in exceladding checkbox in excelvba internetexplorer.applicationisna with vlookupexcel combine tabsjob costing template freevba subroutinestimeline spreadsheet template excelexcel unhide first columnexcel macro delete blank rowsvba excel programsvbscript programs examplesvbscript query sql databasevba eraseconnect excel to sqlinsert checkbox in powerpoint 2010show hidden columns in excelddl sqlbasic excel worksheetvba copy sheet to new workbookcreate a checkbox in excelexcel formulas and examplesexcel vba formulasexcel vba countif functionfresher interview questions and answersconvert excel sheet to xmlvba chart objectvlookup formula in excelunprotect excel spreadsheet with passwordhow to unhide hidden rows in excelexample of vlookup in excel 2010explain formula in exceluserform closeexcel vba sqladd the developer tab to the ribbon in wordexcel insert checkboxexcel downloaderexcel vba count cells in rangevlookup dynamic table array