Monthly Archives: December 2012


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 beginners tutorialmerging sheets in excelvba word application objectexcel 2007 index functionhide shortcut excelautofit in excel vbabase sas tutorial for beginnersvba blank cellexcel shortcut hidevba format stringfso filevba excel tutorialsvbscript copy folderinterview questions and answers for freshermultiple if statements in excelassign macro to data validation listalphabetical ascending order examplevba powerpointexcel 2010 unprotect workbook without passworddelete rows in excelvlookup excel column index numbervlookup exampleshow many columns and rows in excel 2007msgbox examplesexcel remove non duplicatesexcel macro combo boxexcel macro copy pastedml ddldefine excel macroshortcut key for insert row in excelms excel 2007 shortcut keyssimple gantt chart excel templatecool excel macroshow do you delete duplicates in excelwindows.activate vbashading cells in excelexcel password protect vbahow to hide rows in excelexcel sumifexcel highlight duplicate rowsvb exit loopadvanced vbaexcel shortkeyconvert excel 2003 to 2013add combo box excel 2010replace in excel formulaexcel macro password recoveryxml to xlsx converterlock worksheet excelexcel vba color cellexcel interactive dashboardexcel macro countifpivot table advancesample project plan template excelexcel vba access queryvba update status barexcel merging cellsexamples of vlookup in excelhow to insert check mark in excel 2007useful vbs scriptsfile exists vbscriptactivity plan template excelsql server pivot table exampleexcel isemptyexample of sumifs in excel 2010vba application.getopenfilenameschedule excel templatesmicrosoft excel construction scheduleexcel vba filefilterhow to delete multiple cells in excelbasic sql interview questions and answersfind duplicates excel 2010sheets excel vba