In this section, you’ll find the commonly used SQL Server functions, such as aggregate functions, date functions, string functions, system functions, and window functions.

In this section, you will learn how to modify data in the database using Data Manipulation Language (DML), which includes SQL commands such as INSERT, DELETE, and UPDATE.

This section helps you get started with the SQL Server quickly. After completing this section, you will have a good understanding of the SQL Server and know how to install the SQL Server …

This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.

The SQL Server Management Studio is software for querying, designing, and managing SQL Server on your local computer, a remote server, or in the cloud. It provides you with tools to …

In this tutorial, you'll learn how to use the SQL Server BCP utility to bulk copy data between an SQL Server instance and a file.

This tutorial introduces you to the SQL Server aggregate functions and shows you how to use them to calculate aggregates.

The following picture illustrates SQL Server blocking: Typically, the time in which the first session locks the data is very short. When it releases the lock, the second session can acquire its own …

In this tutorial, you will learn about various kinds of SQL Server joins that allow you to combine data from two or more tables.

This section introduces you to the SQL Server views and discusses the advantages and disadvantages of the database views in SQL Server.