Microsoft Programming Training | Querying Microsoft SQL Server

Microsoft Programming

This 5-day video on demand course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Audience Profile

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. For SQL power users who aren't necessarily database-focused or plan on taking the exam, such as report writers.

Benefits From Attending The Training:

	Write SELECT queries.
	Query multiple tables.
	Sort and filter data.
	Describe the use of data types in SQL Server.
	Modify data using Transact-SQL.
	Use built-in functions.
	Group and aggregate data.
	Use subqueries.
	Use table expressions.
	Use set operators.
	Use window ranking, offset and aggregate functions.
	Implement pivoting and grouping sets.
	Execute stored procedures.
	Program with T-SQL.
	Implement error handling.
	Implement transactions.

	Training: Home
	Learning Hub
	IT: MOS
	IT: Server
	IT: Programming
	IT: ACA
	Business Skills
	Health & Safety
	Learning Hub Brochure