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

autofit row height excel 2010excel convert to lower caseproject reporting template excelhow to create check box in excelscrum call formathow to hyperlink in excelpmo interview questions and answers pdfhow to delete excel sheet shortcutexcel tutorial macrosunhide a sheet in excelvb interview questionslearn to write macros in excelif statement excel examplespyramid powerpoint templatesql vbaexcel 2007 insert rowsample excel data for pivot tablevba code to open a folderconsolidate function excelvba dim asvba excel tutorialsexcel vba forms advancedinput message box vbachanging rows to columns in excelexcel macro close excelexcel columnwidthiferror vlookup excelexcel template for project timelineidentify duplicates excelexcel macro to open a filespecialcells vbapublic sub vbadeduplicate excelexcel 2007 formulas with examplesdml ddl dcl and tcl in sqlcombine data from multiple sheets in excelfso deletevba vbokcancelexcel tutorial torrentsql compare operatorsinterview aptitude questions and answers with explanationexcel expert tutorial pdfsql server 2008 pivot table examplehide cells excelvisual basic check boxexcel sheet shortcut keysshot keys of excelminutes proformadml queriesexcel how to hide columnshow to create stacked bar chart in excel 2010what is hlookup in excel with exampleexcel spreadsheet password protectvba worksheet nameduplicate function in exceltesting interview questions and answers for freshershyperlink on excelvba save worksheetexcel cell function colormatching cells in excelexcel vba selected cellsexcel vba chartvba range propertiescolor formula in excel 2007sqlconnection exampleunlock password protected excelvba remove duplicatesuseful formulas in excelvba connect to databasevba excel booksumif formula in excel with exampleexcel vlookup examplespassword unprotect excelproject tracking excel template