Using Aggregate Functions
How to use the COUNT, MAX, AVG, and SUM Aggregate Functions in a T-SQL statement.
T-SQL
DML Triggers
Working with Triggers in SQL Server. How to use triggers for data manipulation statements (DML) like INSERT, UPDATE, and DELETE.
Writing a Stored Procedure
Learn the basics of writing a stored procedure and make your SQL Server code more efficient and reusable with parameters.