Microsoft SQL Server 2025 Tutorial

Learn how to install Microsoft SQL Server on Windows 11. With that, we will also install SQL Server Management Studio.

Download SQL Server: https://www.microsoft.com/en-in/sql-server/sql-server-downloads

Learn how to create a new database in SQL Server. The CREATE DATABASE statement is used to create a new database in SQL Server.

Learn how to create a new table with SQL Server. The CREATE TABLE statement is used to create a new table in SQL Server.

Learn how to insert records in a table using the INSERT INTO statement in SQL.

Learn how to select records in SQL using the SELECT statement. We will also see how to select multiple columns in a single query.

Learn how to select and return only distinct values from a table using the SQL SELECT DISTINCT statement.

Learn how to work with the WHERE clause in SQL. WHERE clause filter records based on condition(s).

Learn how to order records in SQL using the ORDER BY keyword. The default sorts in Ascending order. We will see examples of both ASC and DESC keywords as well.

Learn how to work with the AND Operator in SQL to display records only if both the conditions are TRUE. These two conditions should be separated by the AND operator.

Learn how to work with the OR Operator in SQL to display records only if any one of the conditions is TRUE. These two conditions should be separated by the OR operator.

Learn how to work with the NOT Operator in SQL to display records only if the condition isn't met i.e. FALSE.

Learn how to implement the IN operator in SQL. We will check whether a specific value match.

Learn how to implement the BETWEEN and NOT BETWEEN operator in SQL. We will find values in a range.

Learn how to implement the LIKE operator in SQL. We will find values on the basis of a specific pattern using percentage and underscore.

Learn how to implement the MAX() function in SQL. We will find the maximum of column values.

Learn how to implement the MIN() function in SQL. We will find the minimum of column values.

Learn how to implement the SUM() function in SQL. We will find the sum of column values.

Learn how to implement the AVG() function in SQL. We will find the average of column values.

Learn how to implement the COUNT() function in SQL. We will find the count of the number of rows.

Learn how to work with the NOT NULL Constraint in SQL, to enforce a column to have values i.e. not null. Remember, since columns can have NULL by default, to enforce a column to NOT accept values, we use the NOT NULL constraint.

Learn how to work with the UNIQUE Constraint in SQL to uniquely identifies each record in a database table. It enforces the uniqueness of column values.

Learn how to work with the PRIMARY KEY Constraint in SQL. A PRIMARY KEY uniquely identifies each record. Note, that a Primary Key column can never have NULL values.

Learn how to work with the FOREIGN KEY Constraint in SQL. A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another table. A child table is a table with a foreign key.

Learn how to work with the CHECK Constraint in SQL to allow only specific values for a column. You can limit the value range set in a column, for example, Age > 18, Marks > 75, etc.

Learn how to work with ASC Command in SQL to sort the data in ascending order. The ASC is used with the ORDER BY in SQL. The ORDER BY sorts records in ascending or descending order.

Learn how to work with DESC Command in SQL to sort the data in descending order. The DESC is used with the ORDER BY in SQL. The ORDER BY sorts records in ascending or descending order.

Learn how to work with the ALTER TABLE in SQL to add or delete columns in the existing table. To add a column to an existing table, use the ALTER TABLE with ADD command.  To delete a column from an existing table, use the ALTER TABLE with DROP COLUMN.

Learn how to work with the UPDATE Statement in SQL to update existing records in a table. Note, use the WHERE clause with the UPDATE statement to avoid updating all records in the table.

Learn how to work with Aliases in SQL to give a temporary name to a table or a column. The AS keyword is used to create an alias, making column names more readable. Remember that the existence of the alias expires when the duration of that query ends.