ELK Stack Tutorial

In publishing and graphic design, lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document without relying on meaningful content.

SAS Tutorial for Beginners

Introduction to SAS SAS Tutorial is designed for Data Scientist, Data Analyst, and all the readers who want to readSAS and need to transform raw data to produce insights for business development using SAS. What is SAS? SAS (Statistical Analysis System) …

Read moreSAS Tutorial for Beginners

Docker Tutorial

Docker Introduction Docker tutorial is designed for the developers and those who are interested in learning Docker as a container service. This is the explanation of a newly aged Software Containerization Technology. What is Docker? Docker is a new technology …

Read moreDocker Tutorial

R Tutorial for Beginners

Introduction to R Programming R is nothing but a programming language, also a free software environment. This software used for predictive analysis, statistical analysis, graphical representation, data modeling, and reporting.     R Programming Language R is interpreted programming language. …

Read moreR Tutorial for Beginners

Tableau Tutorial for Beginners

Introduction to Tableau: Intellectual, strategic, smart and real-time decision making is a must for the development of any organization. Previous years, all those decisions made by revising, analyzing documented reports also by comprising all the data. It becomes a tedious …

Read moreTableau Tutorial for Beginners

SQL Truncate

This command deletes all records from table. Truncate is a DDL command. Syntax:

Example:

ORDER BY The ORDER BY clause arranges the table or column in ascending or descending orders. By default, it is ascending order. ‘ASC’ used …

Read moreSQL Truncate

SQL Operators

Arithmetic Operators Arithmetic operators are +, -, *, /, % performs addition, subtraction, multiplication, division, modulo respectively. Example:   Select 100+222; Select salary+100 From teacher Where teacher_id=1; Following output screen shows different arithmetic operations. We can perform single operation at …

Read moreSQL Operators

SQL Scalar Functions

TEACHER Table LCASE() Function The LCASE() function is used to return lower case values of specified column. Syntax: Select Lcase(column_name) from table_name; Example: Select Lcase(teacher_name) from teacher; Syntax: Select Lcase(column_name) from table_name [where condition]; Example: Select Lcase(teacher_name) from teacher where …

Read moreSQL Scalar Functions

SQL Aggregate Functions

Max() Function The Max() function returns the maximum value of specified column. Syntax: Select Max(column_name) From table_name; Example: Select Max(salary) From teacher; Min() Function The Min() function returns the minimum value of specified column. Syntax: Select Min(column_name) From table_name; Example: …

Read moreSQL Aggregate Functions

SQL CONSTRAINTS

SQL Constraints specifies the rules/limitations/restrictions for data present in table. SQL Constraints are specified at the time of table creation or after table creation using ALTER command. There are two types of constraints column-level constraint and table-level constraint. As the …

Read moreSQL CONSTRAINTS

SQL Data Control Language

Data Control Language decides to whom should (which user) permit access privileges. GRANT and REVOKE are the commands of DCL. GRANT: It gives privileges to user. REVOKE: It takes back privileges from granted user. Data Query Language Data Query Language …

Read moreSQL Data Control Language

SQL Commands

SQL commands are classified into four groups on the basis of their nature. DDL (Data Definition Language) DML (Data Manipulation Language) DCL (Data Control Language) DQL (Data Query Language) NOTE: This symbol ‘[ ] ‘indicates optional. SQL is not a …

Read moreSQL Commands