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

meeting minute template worddelete a row in excel vbamicrosoft excel how to merge cellsbuild macro in excelvlookup based on multiple criteriamessagebox in vbasql excel vbapivot tables in excel 2003excel templates project managementexcel vba forecolorto merge cells in excelexcel macro protect sheet with passwordms excel name manageruse average function in excel 2010vba application calculationexcel vba activeworkbook.saveashow to learn excel vbahow to de dupe in exceldata type in vbadelete column vbamacro programing in excelconcatenate excel 2007vba open access database from excelunhide excel sheetif statement examples in excelexcel pivot table advancedvba promptlookup excel exampleexcel compound if statementconcatenate using vbaformula for vlookup in excel 2007excel vba databaseexcel dashboards and reports for dummiesexcel vba select rowspivotfields vbacreate userform in excelexcel resource planner templatescreen macro recorderexcel vba programming examples pdfdelete duplicates from excelhow to draw pie chart in excel 2010word vba userformexcel visual basic macroexcel macro open fileexcel 2007 remove hyperlinksclose workbook vbaexcel formula protectionsql database for beginnersfree download gantt chart excelexcel vba transfer data from one workbook to anotherexcel macro combo boxproject schedule template powerpointdelete duplicate data in excelexcel macros vba examplesexcel vba write filehow to merge excel cellsexcel most useful formulasexcel macro dimexcel formula for alphabetical orderconsolidate excel columnsdeleting a pivot tableusing arrays in vbavba rowscells function vbaoutlook meeting minutes templatevba forms controlsfunction excel vbadelete duplicates excel 2010hyperlink function excelmerge cells excel