SQL Basics Archives - Analysistabs

Sorting and Grouping the Data in SQL – ORDER BY GROUP BY

PNRao2013-07-01T00:00:00+00:00

When we are dealing with huge data, we can not analyse the data by looking into each record. We sort and group the data based on certain variables and understand the data. We use Order By, Group by,Where and Having Clauses to Sort and group the data in SQL.

Sorting and Grouping the Data in SQL – ORDER BY GROUP BYPNRao2013-07-01T00:00:00+00:00

SQL Functions for Data Analysis

PNRao2013-06-15T00:00:00+00:00

SQL functions help to aggregate the data while extracting the data from Data base. There are many functions available in SQL to aggregate the data to analyse it.

SQL Functions for Data AnalysisPNRao2013-06-15T00:00:00+00:00

SQL Commands for Data Analysis

PNRao2013-02-13T00:00:00+00:00

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.

SQL Commands for Data AnalysisPNRao2013-02-13T00:00:00+00:00

SQL Operators

PNRao2013-01-13T00:00:00+00:00

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.

SQL OperatorsPNRao2013-01-13T00:00:00+00:00

SQL Statements

PNRao2012-12-25T00:00:00+00:00

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.

SQL StatementsPNRao2012-12-25T00:00:00+00:00

Basics of Database
Gallery
Basics of Database

SQL

Basics of Database

PNRao2022-06-17T03:56:03+00:00

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.

Basics of DatabasePNRao2022-06-17T03:56:03+00:00

SQL for Data Analysis – An Introduction for beginners

PNRao2012-12-20T00:00:00+00:00

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.

SQL for Data Analysis – An Introduction for beginnersPNRao2012-12-20T00:00:00+00:00