Cert Kit 70-761: Querying Data with Transact-SQL

Cert Toolkit
In-depth e-learning content includes 365-day online access to exam quizzes, tips and information, and online coaching/mentoring from certified professionals who know how to pass the exam. Includes Microsoft Official MeasureUp practice test!

$319


Description:

This CertKit covers the best practices for implementing and querying data using SQL Server 2016 T-SQL. It’s aimed at database administrators, database developers, and BI professionals, and covers querying data, working with data types, built-in functions, aggregating data, subqueries, and set operators. This CertKit covers the objectives for the 70-761: Querying Data with Transact-SQL exam.

Prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.

Course outcome:

  • Describe key capabilities and components of SQL Server.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Who should attend:

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by 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.

Module overview:

  • E-learning courses:
    • T-SQL Querying
    • Querying and Manipulating Data
    • Filter and Modify Data in SQL Server 2016
    • Using Functions in SQL Server 2016
    • Aggregating Data in SQL Server 2016
    • Subqueries and Predicate
    • Operators and Expressions in SQL Server 2016
    • Database Programmability Objects and Non-Relational Data
  • MeasureUp Exam simulation
    • 150+ questions
  • Online Mentor
  • Tips & Tricks
PlatformOperating SystemBrowser
Chrome 39 Firefox 34 Internet Explorer 10 and 11 Safari 8
PC W7 x86 X X X
W7 x64 X X X
W8.1 x86 X X X
W8.1 x64 X X X
MAC OSX 10.9 X X X
OSX 10.10 X X X
LINUX Linux x86 X X
Linux x64 X X
Surface Pro Windows 8 X X X
PlatformOperating SystemBrowser
Safari 8 Android Chrome 39 Internet Explorer RT Internet Explorer 11
iPad* IOS 8 X X
iPhone 5 or higher* IOS 8 X X
iPhone 4* IOS 7 X X
Android Tablet* 4.0 or higher X X
Android Phone* 4.0 or higher X X
Lumia 920 or higher* Windows Phone 8.1 X
Surface Windows RT X

*Online use only with these devices


Download System Requeriments

  • Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
  • We no longer support XP