In this article, we learn about the installation of the Power BI Desktop.

https://powerbi.microsoft.com/en/downloads/


In this article, we learn about SQL Server Snapshot.

SNAPSHOT

SYNTAX OF CREATING SNAPSHOT

CREATE SNAPSHOT <list of options> AS <select query>

Example:-

CREATE SNAPSHOT emp_snap

AS SELECT * FROM employee WHERE id=4

SYNTAX OF ALTERING SNAPSHOT

ALTER SNAPSHOTS<snapshot_name><option list>

SYNTAX OF DROPPING SNAPSHOT

DROP SNAPSHOTS<snapshot_name>

Example:- DROP SNAPSHOTS emp_snap

If you are a newbie to database learning — SQL Server recommended is the following must-watch video: -


In this article, we learn about the SQL Server synonym.

SYNONYM

There are two types of synonym:

SYNTAX OF CREATING SYNONYM

CREATE SYNONYM <synonym_name > FOR <object name>

Example:- CREATE SYNONYM orders1 FOR orders

SYNTAX OF DROPPING SYNONYM

DROP SYNONYM <synonym_name >

Example:- DROP SYNONYM orders1

RETRIEVING SYNONYM

SELECT * FROM sys.synonyms

If you are a newbie to database learning — SQL Server recommended is the following must-watch video: -


In this article, we learn about the sequence.

SEQUENCE

SYNTAX OF CREATING SEQUENCE

CREATE SEQUENCE [schema_name . ] sequence_name
[ AS…


In this article, we learn about the difference between triggers and stored procedures.

TRIGGER

CREATE TRIGGER trigger_name

ON table_name

AFTER {[INSERT],[UPDATE],[DELETE]}

AS

BEGIN

{sql_statement}

END

STORED PROCEDURE


In this article, we learn about Math Functions in SQL Server.

ABS

AVG

CEILING


In this article, we learn about Date Time Function in SQL Server.

CURRENT_TIMESTAMP

DATEADD


In this article, we discuss conversion and configuration functions in SQL Server.

CONVERSION FUNCTIONS

CAST() and CONVERT()


In this article, we learn about string function in SQL Server.

SQL Server string functions process on an input string and return a string or numeric value.

ASCII


In this article, we discuss the difference between Inner Join, Cross Join, and Full Outer Join.

Vaishali Goilkar

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store