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

single vbalistbox additemexcel vba usedrangevba vbyesnoadvanced pivot table excel 2007excel exit macrovba excel casevba array tutorialchart wizarddelete range vbavba excel select worksheetyes no msgbox vbaexcel vba copy to clipboardcase statement vbaremove excel sheet protectionexcel auto column widthvba file system objectexcel macro checkboxexcel vba application functionlearning macroshow do i unprotect an excel worksheethow to calculate difference between two dates in excelexcel vba active cellvba recordset fieldsexcel formula to delete blank rowswhile loop vbaworkbook objectexcel programming tutorialcreating excel dashboardseasy way to find duplicates in excelvba cell colorvba program examplesexcel hidden columnif and isblank excel formulaproject update template ppt3d bubble chart excel 2010excel vba rangesexcel enable developer tabexcel macro copy row to another sheetintroduction to vbaexcel vba adodb connection stringvba macro code examplesvba create pdfunprotect excel sheet without passwordexcel programming tutoriallookup excel 2007free construction estimating spreadsheet templateexcel if statement equalsvba screenupdatingmacro code in excelexcel formula is not blank3d column chart excelexcel vba clear rangemerge excel files macroexcel line graph tutorialexcel vlookup formulasexcel sheet cellsexcel timevalueexcel formula if cell contains valuecall worksheet function from vbaexcel shortcut insert rowunhide all sheets macroexcel advanced filter date rangemessage box excel vbaadvanced sas interview questionsvba word application objectms excel dashboard templatesexcel vba languageexcel macro sortsumif excel 2007how to hide columns in excel shortcutexcel sheet delete shortcut keyhow to copy cells in excel with formulasort array vbahow to put a tick box in excelstep vbavlookup applicationlock worksheetvlookup with summs excel macros tutorialexcel populate comboboxcreating a hyperlink in excel