The SQL server basics section shows you how to use the Transact-SQL (T-SQL) to interact with SQL Server databases. You will learn how to manipulate data from the database such as querying, inserting, updating, and deleting data.

This tutorial shows you how to create a new database in SQL Server using CREATE DATABASE statement or SQL Server Management Studio.

The SQL server basics section shows you how to use the Transact-SQL (T-SQL) statements to interact with SQL Server databases.

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 Developer Edition for practicing.

This SQL Server administration tutorial provides you with the knowledge and skills you need to administer SQL Server database servers effectively. This tutorial is for database administrators and developers, who want to administer SQL Server successfully.

This tutorial provides you with a SQL Server Sample Database called BikeStores, which allows you to start practicing with SQL Server quickly and effectively.

Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases. SQL Server is tied to Transact-SQL, or T-SQL, Microsoft’s implementation of SQL, which includes a set of proprietary programming constructs.

SQL Server provides four system databases including master, msdb, model, and tempdb. The master system database stores system-level information of the SQL server instance. The msdb database is used by SQL Server Agent for jobs & alerts.

This tutorial shows you step by step how to load a sample database BikeStores into the SQL Server for practicing.

In this tutorial, you will learn how to connect to the SQL Server from the SQL Server Management Studio and execute a query.