SQL Basics

SQL Server Basics Concepts includes SQL Database Creation, Tables, SQL DML , and DDL Commands, Joins, Key Constraints, Functions and so on..

SQL SERVER WHERE

SQL WHERE clause is used to specify a condition while fetching the data from a tables.

SQL Server MAX

SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .

SQL Server MIN

SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column

SQL COUNT

SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.

SQL Server SUM

SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.

SQL Server AVG

SQL AVG function is an aggregate function that returns the average of the values.

SQL REPLICATE()

SQL REPLICATE() Repeats a string value a specified number of times.

SQL FULL OUTER JOIN

SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.

SQL RIGHT JOIN

SQL RIGHT JOIN or RIGHT OUTER JOIN returns all rows from the right table and the matching rows from the left table.

SQL LEFT JOIN

SQL LEFT JOIN or LEFT OUTER JOIN returns all rows from the left table and the matching rows from the right table.

SQL INNER JOIN

SQL INNER JOIN returns the rows from the tables that have matching value in columns.

SQL Server JOINS

A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.

SQL DATEPART()

SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.

SQL DATEDIFF()

SQL DATEDIFF() function is used to calculate the difference between two dates.

SQL DATEADD()

SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.

SQL TRIM()

SQL Server TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()