OEM Office Elearning Menu

Querying Data with Transact-SQL exam 70-761 OEM Certkit

Algemene informatie over de cursus

The Training Querying Data with Transact-SQL exam 70-761 through a Special Certification Package. 1 Year access to revolutionary E-learning to pass the exam Easily. Get Introduced by Learning through 1 Learning Portal (LMS) with Certified Teachers. Exclusive 24/7 Online Mentor and Challenging Course Testing and View behind the scenes all Tips & Tricks.
Always guaranteed the Official Test Exam and after the Training an Official Certificate of Participation. Optional Livelabs (extra charge).

Availabilty: 25 hours
Language: English
Certificate of participation: Yes
Online access: 90 days
Progress monitoring: Yes
Award Winning E-learning: Yes
Suitable for mobile: Yes

Inhoud van de cursus

T-SQL Querying
Course: 2 Hours, 9 Minutes

Course Introduction
SQL Server 2016 Architecture Overview
SQL Server 2016 Editions and Components
SQL Server 2016 Functions and Capabilities
SQL Server Management Studio

Filter and Modify Data in SQL Server 2016
Course: 2 Hours, 21 Minutes

Course Introduction
SELECT Statements Overview
Writing SELECT Statements in SQL Server 2016
Calculated Expressions

Microsoft SQL Server 2016: Querying
Course: 2 Hours, 14 Minutes

Course Introduction
ORDER BY Clause
Sorting Data
Filtering Data
WHERE Clause
Predicates and Operators

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 36 Minutes

Course Introduction
ORDER BY Clause
Sorting Data
Filtering Data
WHERE Clause
Predicates and Operators

Microsoft SQL Server 2016: Querying
Course: 2 Hours, 20 Minutes

Course Introduction
Aggregate Functions Overview
SUM Aggregate Function
AVG Aggregate Function
MIN Aggregate Function
MAX Aggregate Function
COUNT Aggregate Fuction
Aggregating Distinct Valuesnction
NULL and Aggregate Functions

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 36 Minutes

Course Introduction
Subqueries Overview
Scalar Subqueries
Writing Effective Scalar Subqueries
Multi-valued Subqueries

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 35 Minutes

Course Introduction
UNION vs. UNION ALL Operators
Writing Queries That Use the UNION Operator
Writing Queries That Use the UNION ALL Operator
Mixed UNION and UNION ALL Operators

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 57 Minutes

Course Introduction
Understanding Stored Procedures
Using Stored Procedures
Input parameters
Output parameters
Table-valued Functions
Scalar-valued User-defined Functions
TRY...CATCH Error Handling
RAISERROR Statements

TestPrep 70-761 Querying Data with Transact SQL
  • Test your knowledge on the skills and competencies measured by the vendor certification exam. TestPrep can be taken in either StudyCertification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

variabel

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Gratis informatie aanvragen

Vul hieronder jouw gegevens in, dan krijg je gratis informatie toegestuurd.

  • De ingevoerde (persoons)gegevens worden door de geselecteerde opleidingsaanbieder(s) gebruikt om de gestelde vraag te beantwoorden;
  • Indien gewenst mag de onderwijsinstelling waar ik mijn aanvraag naar stuur mijn gegevens bewaren om mij van advies te voorzien;
  • Ik ben tenminste 16 jaar oud, of heb toestemming van mijn ouders of voogd om deze informatieaanvraag te verzenden;
  • De privacy statement en algemene voorwaarden van Stichting ROC.nl zijn van toepassing.