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

vba list boxproject tracking dashboard templateexcel vba cell fill coloraccess msgboxcreate activex controlhidden cells in excelvb color indexsql excel tablemicrosoft excel insert rowvba excel colorhow to cut and paste in excelexecute sql query from excelexcel vba select workbookunprotect vbaexcel syntaxmacros vba excelcreating a hyperlink in excelremove duplicates from list excelexcel vba select rowsvba application pathsumif in vbaexcel 2010 if statementsexcel unprotect without passworddeduplication excelworkbook unprotect vbaexcel vba rowsvlook functionhow to multiple columns in excelhow to unhide first column in excelexcel advanced tutorialsproject management timeline excel templatehow to unhide excel sheetunprotect an excel sheet without passwordlcase vbavba access tutorial pdfvba 2007userform closeuserform in excel 2007how to convert xlsx to xmlsort vba exceldashboards in excelcreating dashboards in excelmicrosoft word meeting minutes templatems excel formulas vlookupconvert excel table to normal rangesql interview questions and answers pdfvbscript delete a fileexcel vba dynamic arraypivot table macroformula excel countifexcel vba getopenfilenamevendor management excel templatevba datesvba sleepworkbook definition excelvlookup in vbasplit function in excel vbatick boxes excelsql interview questions and answers for freshers pdfexcel macro enabled workbookexcel macro case statementcreateobject scripting filesystemobject vbavba excel last rowexcel formulas for financial analysiscreate object vbavba column rangeexcel 2010 combo boxdisplay developer tabunprotect excel spreadsheet 2010vba columns selectmicros and macros in excelconstruction project management templates excelreplace excel formula