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

sumif formula in excel with examplevba call procedurecheckbox vba excelvba programming courseexcel match function examplesproject management templates in excelvba query tablewhat is a worksheet in excel definitionuse vlookup in vbavba create text fileduplicate worksheet excelfind duplicates in excel 2003sql sassql for beginnersunprotect macrohow to use hlookup in excel 2007 with examplebasic excel macrosselection vbaexcel vba syntaxworkbooks.close vbahow to change row height in excelexcel and macrosmicrosoft excel lookup functionset password for excel 2007how to delete duplicate rowsproject management timeline templatewhat is the meaning of vlookupexcel macro rename fileexcel function iserrorsql basics interview questionsgoto visual basicbcg interview questionsexcel lookup syntaxredim array vbastacked clustered chart excel 2013paste special formulacompile data from multiple excel worksheetsinsert carriage return in text fileproject tracking template excelsimple excel spreadsheet examplescheckbox en excelembed forms combobox 1excel formulas shortcutsvlookup codeusedrange vbavba move filewhat is vlookup function in excelsort excel spreadsheetcell functions worksheetexcel cost analysis templatevba sortexcel proposal templateexcel loopingchart types in excel 2010excel tutorial for dummiesexcel resource planner templatecell merge in excelunprotect excel with passwordvlookup for beginnersmicrosoft excel countifvba clear entire sheeteliminate duplicate rows in excelexcel hyperlink to pdfconstruction budget template excelvba unprotect sheetvba end xluphow to do vlookup on excel 2010vba active workbookvlookup for beginnerscopy excel cell to another sheetremoving duplicates excelhow to check duplicate values in excelmerging worksheets in excelvba substitutevba for outlook