Getting started with SQL Server. Create basic queries to the AdventureWorks2012 database. Working with the HumanResources schema.
INNER JOIN operations. Creation and modification of tables, primary keys, constraints. INSERT statement.
Updating data using the UPDATE statement. Deleting data DELETE. Dropping objects using the DROP operator. Using temporary tables and table variables. Merge operator. Using CTE expressions.
Working with view VIEW. Indexed view. Changing data in a table through a view. Create an AFTER DML trigger for a table. Logging changes to the history table. Create an INSTEAD OF DML trigger for a view.
User-defined functions: scalar-valued, inline table-valued, multistatement table-valued. CROSS APPLY and OUTER APPLY operators.
Creation of stored procedures. Using dynamic SQL. PIVOT operator for forming a pivot table.
Working with XML.