Who should attend
- Database Administrators
- Database Developers
- Business Intelligence professionals
- Report Writers
- Business Analysts
- Client Application Developers
Prerequisites
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Course Objectives
- 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
Follow On Courses
Course Content
This course teaches students to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines and helps people prepare for exam 70-461.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.