Jump to content


2
[Offer]

MOC 20761B - Querying Data with Transact-SQL (torrent)



10 replies to this topic

#1 romank44

romank44

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 3939 thanks

Posted 20 April 2017 - 09:11 PM


Posted Image

Microsoft 20761B Part 1 and 2 Virtual Machines + Bases



About this course
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring
the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
Audience profile

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.

At course completion

After completing this course, students will be able to:
Describe key capabilities and components of SQL Server 2016.
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.

Includes:

Base14A-WS12R2.vhd
MT16-SQL-MIA-DC.vhd
MT16-SQL-MIA-SQL.vhd
20761B-MIA-DC.vhd
20761B-MIA-SQL.vhd
20761B-MIA-SQL-Allfiles.vhd


Hidden Content
You'll be able to see the hidden content once you press the thanks button.


Thanked by 154 Members:

#2 fabioteles

fabioteles

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 556 thanks

Posted 23 April 2017 - 10:02 AM

THank you but I can't download the torrent

#3 romank44

romank44

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 3939 thanks

Posted 23 April 2017 - 12:38 PM

View Postfabioteles, on 23 April 2017 - 10:02 AM, said:

THank you but I can't download the torrent

I can upload files to cloud.mail.ru, if you want.

Thanked by 1 Member:
jahkool

#4 apmittal

apmittal

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 47 thanks

Posted 23 April 2017 - 04:48 PM

Can you please tell me how to use them because I have not use the Microsoft VHD before.

Thanks

#5 romank44

romank44

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 3939 thanks

Posted 23 April 2017 - 05:32 PM

View Postapmittal, on 23 April 2017 - 04:48 PM, said:

Can you please tell me how to use them because I have not use the Microsoft VHD before.

Thanks

Open 20761B-ENU-SetupGuide.pdf file and follow section 1, 2, 3, 6, 7,8.

Probably there is no need in the MSL-TMG1 Virtual Machine, I'm not shure. In this case you need to create Private network instead of section 2:

1.  On the host machine, click Start, point to Administrative Tools, and click Hyper-V.  
2.  In the Hyper-V Manager console, click Virtual Network Manager.
3.  In the center pane, click Private, and click Add.
4.  In the Name field, type Private Network, click OK.

Edited by romank44, 23 April 2017 - 05:34 PM.


Thanked by 1 Member:
goater12345

#6 gslb86

gslb86

    Junior Member

  • Members
  • PipPip
  • 7 posts
  • 913 thanks

Posted 24 April 2017 - 09:25 AM

View Postfabioteles, on 23 April 2017 - 10:02 AM, said:

THank you but I can't download the torrent

Alternative link:
Hidden Content
You'll be able to see the hidden content once you press the thanks button.


Thanked by 92 Members:

#7 miamikk

miamikk

    Member

  • Members
  • PipPip
  • 12 posts
  • 71 thanks

Posted 10 May 2017 - 10:31 AM

Can you please post only the pdf files (Trainer or Student handbook etc.) and any other exercise files.

#8 romank44

romank44

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 3939 thanks

Posted 10 May 2017 - 05:19 PM

View Postmiamikk, on 10 May 2017 - 10:31 AM, said:

Can you please post only the pdf files (Trainer or Student handbook etc.) and any other exercise files.

Here they are.
Hidden Content
You'll be able to see the hidden content once you press the thanks button.


Thanked by 75 Members:

#9 kalevi530

kalevi530

    Newbie

  • Members
  • Pip
  • 0 posts
  • 0 thanks

Posted 09 February 2019 - 01:09 AM

How can I get  these vhds

#10 whakamaru

whakamaru

    Junior Member

  • Members
  • PipPip
  • 8 posts
  • 318 thanks

Posted 11 February 2019 - 11:07 AM

View Postromank44, on 20 April 2017 - 09:11 PM, said:


Posted Image

Microsoft 20761B Part 1 and 2 Virtual Machines + Bases



About this course
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring
the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
Audience profile

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.

At course completion
After completing this course, students will be able to:
Describe key capabilities and components of SQL Server 2016.
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.

Includes:
Base14A-WS12R2.vhd
MT16-SQL-MIA-DC.vhd
MT16-SQL-MIA-SQL.vhd
20761B-MIA-DC.vhd
20761B-MIA-SQL.vhd
20761B-MIA-SQL-Allfiles.vhd

Cant download the torrent

Thanked by 2 Members:
aaghaian , itvictor21

#11 romank44

romank44

    Junior Member

  • Members
  • PipPip
  • 1 posts
  • 3939 thanks

Posted 11 February 2019 - 03:00 PM

View Postwhakamaru, on 11 February 2019 - 11:07 AM, said:

Cant download the torrent

https://certcollection.org/forum/topic/315032-10747d-10748c-20345a-20410d-20411d-20412d-20740b-20741b-20742b-20761b-20762b/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Organization

Community

Downloads

Test Providers

Site Info


Go to top