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. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
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.
At the end of the program, the participants will be able to :
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.
This program is 5 days of intensive training class.
This course requires that you meet the following prerequisites:
At the end of the program, the participants will be assessed with 2 hours of Querying Microsoft® SQL Server® 2014Exam.
-
Lab : Working with SQL Server 2014 Tools
Lab : Introduction to Transact-SQL Querying
Lab : Writing Basic SELECT Statements
Lab : Querying Multiple Tables
Lab : Sorting and Filtering Data
Lab : Working with SQL Server 2014 Data Types
Lab : Using DML to Modify Data
Lab : Using Built-In Functions
Lab : Grouping and Aggregating Data
Lab : Using Subqueries
Lab : Using Table Expressions
Lab : Using Set Operators
Lab : Using Window Ranking, Offset and Aggregate Functions
Lab : Pivoting and Grouping Sets
Lab : Executing Stored Procedures
Lab : Programming with T-SQL
Lab : Implementing Error Handling
Lab : Implementing Transactions
Lab : Improving Query Performance
Lab : Querying SQL Server Metadata