Course 20461: Querying Microsoft SQL Server

This course is already delivered, please contact us for the next available session tel:+357 22 44 14 92Course Outline in PDF

Overview:

This 5-day instructor led course provides students 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.

Who Should Attend:

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Lessons
•Sorting Data
•Filtering Data with a WHERE Clause
•Filtering with the TOP and OFFSET-FETCH Options
•Working with Unknown and Missing Values
Lab : Sorting and Filtering Data
•Writing Queries That Filter Data Using a WHERE Clause
•Writing Queries That Filter Data Using an ORDER BY Clause
•Writing Queries That Filter Data Using the TOP Option
•Writing Queries That Filter Data Using the OFFSET-FETCH Clause

Module 6: Working with SQL Server 2014 Data Types

Lessons
•Introducing SQL Server 2014 Data Types
•Working with Character Data
•Working with Date and Time Data
Lab : Working with SQL Server 2014 Data Types
•Writing Queries That Return Date and Time Data
•Writing Queries That Use Date and Time Functions
•Writing Queries That Return Character Data
•Writing Queries That Use Character Functions

Lessons
•Using Aggregate Functions
•Using the GROUP BY Clause
•Filtering Groups with HAVING
Lab : Grouping and Aggregating Data
•Write queries which use the GROUP BY clause
•Write queries which use aggregate functions
•Write queries which use distinct aggregate functions
•Write queries which filter groups with the HAVING clause

Lessons
•Writing Queries with the UNION Operator
•Using EXCEPT and INTERSECT
•Using APPLY
Lab : Using Set Operators
•Write queries which use UNION set operators and UNION ALL multi-set operators
•Write queries which use CROSS APPLY and OUTER APPLY operators
•Write queries which use EXCEPT and INTERSECT operators

Lessons
•Writing Queries with PIVOT and UNPIVOT
•Working with Grouping Sets
Lab : Pivoting and Grouping Sets
•Write queries which use the PIVOT operator
•Write queries which use the UNPIVOT operator
•Write queries which use the GROUPING SETS subclause