Microsoft SQL Server Development

This lesson introduces SQL Server and the fundamental concepts of databases.

This lesson guides the user through downloading and installing SQL Server Express E7.

This lesson demonstrates how to connect to a database instance and create a new database.

This lesson explains the process of dropping or removing a database.

This lesson defines what a database table is and its role in SQL Server.

This lesson covers the steps to create a database table in SQL Server.

This lesson shows how to insert data into a table using an SQL script.

This lesson explains how to insert data into a table using Management Studio.

This lesson demonstrates how to select data from a table using an SQL script.

This lesson covers advanced select queries in SQL for data retrieval.

This lesson explains how to update existing data in a table.

This lesson shows how to update data in a table using the Management Studio GUI.

This lesson demonstrates how to delete data from a table using an SQL script.

This lesson explains how to delete data from a table using Management Studio.

This lesson defines relationships, foreign keys, and the concept of normalization.

This lesson covers the process of creating a relationship in SQL Server.

This lesson demonstrates how to insert records into related tables.

This lesson explains how to run queries on related tables using inner joins.

This lesson covers left, right, and full joins in SQL for querying related data.

This lesson demonstrates how to group data using the SQL GROUP BY clause.

This lesson explains the use of the SQL AVG aggregate function for calculating averages.

This lesson covers the SQL COUNT aggregate function for counting records.

This lesson demonstrates the use of SQL MAX and MIN aggregate functions for finding extremes.

This lesson explains how to use the SQL SUM function to calculate total values from selected columns.

This lesson covers the creation and management of views in SQL Server to simplify data access.

This lesson introduces scalar valued functions and their usage in SQL Server for returning single values.

This lesson explains inline table valued functions and how they can return a table result set.

This lesson covers multi statement table valued functions and their implementation for complex data processing.

This lesson discusses stored procedures, including their creation, execution, and advantages in SQL Server.

This lesson explains table triggers, their purpose, and how to implement them in SQL Server.

This lesson covers the scripting process for database backup and restore operations in SQL Server.