SQL Server Tutorials

This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .

You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.

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.

Displaying line numbers in Query Editor Window

we can enable line numbers to be displayed in Sql Server Query Editor Window.

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 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()