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 macro open folderexcel color indexddl dclhow to loop in vbaexcel vba hyperlink text to displaydelete duplicate excelpopulate combobox excelexcel shortcuts and formulasexcel developer toolbarquick keys for excelvba performancehow do i unhide in excelhelp with vlookup function in excelextract url from hyperlink excelvba excel workbookunprotect workbook excelvba convert to integerlogical statements in excelinsert macro button excelexcel vba formattingsales trend analysis excelexcel for loopshow to unhide hidden columns in excel 2010autofit vba excelcolor coding in excel 2010excel vba copy and pasteunprotect workbook in excel 2010countif function criteriacalculator program in vbinterview questions on testing for freshers with answershow merge cells in excelexcel advanced filter wildcardunlock xls passwordinfosys interview process for experiencedexcel if statement rangefso delete filevba programming tutorialexcel tips for beginnersexcel print macrosql interview questions and answers pdf for freshershow to remove blank rows exceltask management excel template freelookup table excel 2010chart title excel 2007application calculation xlcalculationautomaticdeveloper tool in excelhow to insert lines in excelvlookup tutorialsexcel vba range sorthow to merge cells in excel with multiple datahow to create a worksheet in excel 2007project dashboard templates excelselect column excel vbaproject progress report template excelwindows.activate vbahow to create a hyperlink in excelmatch formula in excelexcel pivot table macroms excel shortcut keys formulasembed forms combobox 1lookup function vbause of pivot table in excel 2010excel loop macromsgbox in vb6excel remove blank linesmsgbox syntax in vbvba variable rangeexcel 2007 macro securityhow to unlock excel sheetexcel short cut keyword macros examplescheckbox color changehow to create a new worksheet in excelexcel table pivotexcel programing tutorialsendmail syntaxexcel dashboard tutorialmerge cells in excel 2010creating dashboards in excelworksheet copy vbasumif function in excel 2010excel vba check if cell is empty