70-761: Querying Data with Transact-SQL

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The 70-761 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 70-761 test with flying colors.

141 Students Enrolled 66 Lectures 06:45:25 Hours

Curriculum For This Course

Welcome

1Lectures

Time 00:03:14

Getting Started

4Lectures

Time 00:17:11

Databases

5Lectures

Time 00:27:11

SQL Server 2016

5Lectures

Time 00:31:31

Basic Select Statements

7Lectures

Time 00:47:12

Advanced Select Statements

8Lectures

Time 00:54:57

Querying Multiple Tables

6Lectures

Time 00:40:12

Grouping Data

5Lectures

Time 00:35:25

Modifying Data

8Lectures

Time 00:47:48

Programming Objects With T-SQL

9Lectures

Time 00:56:58

User-Defined Functions

3Lectures

Time 00:17:55

Understanding Subqueries

4Lectures

Time 00:20:24

Course Summary

1Lectures

Time 00:05:27

Welcome
	1. Introduction	3:14

Getting Started
	1. Introduction	4:09
	2. Transact-SQL	4:49
	3. SQL Server 2016 Certifications	5:04
	4. Examples	3:09

Databases
	1. Introduction	8:10
	2. Database Structure and Purpose	6:21
	3. Database Terminology	5:55
	4. Understanding Data Types	5:06
	5. Statement Types	1:39

SQL Server 2016
	1. Introduction	4:38
	2. Getting SQL Server 2016	5:01
	3. Installing SQL Server 2016	10:31
	4. Installing SQL Server Management Studio	7:01
	5. Attaching The Sample Database	4:20

Basic Select Statements
	1. Introduction	8:32
	2. Using The Where Clause	6:10
	3. Column Aliasing	4:49
	4. Using Distinct	5:42
	5. Ordering Results	7:17
	6. T-SQL Concatenation	7:32
	7. Multipart Naming	7:10

Advanced Select Statements
	1. Introduction	8:36
	2. Union	7:27
	3. Intersect and Except	7:48
	4. Paging Results	6:25
	5. Understanding Case Expressions - 1	7:42
	6. Understanding Case Expressions - 2	4:37
	7. Using Pivot - 1	7:13
	8. Using Pivot - 2	5:09

Querying Multiple Tables
	1. Introduction	7:38
	2. Table Relationships	8:56
	3. Using The Join Statement	7:04
	4. Table Aliasing	6:25
	5. Join Types	4:00
	6. Join Types Examples	6:09

Grouping Data
	1. Introduction	5:43
	2. Understanding Group By	8:15
	3. Understanding Having	5:39
	4. Understanding Grouping Sets	8:01
	5. Using The Graphical Query Tool	7:47

Modifying Data
	1. Introduction	6:42
	2. Insert Demo	8:05
	3. Insert Select	6:55
	4. Select Into	5:46
	5. Updating Data	4:10
	6. Update Demo	6:45
	7. Deleting Data	3:31
	8. Delete Demo	5:54

Programming Objects With T-SQL
	1. Introduction	8:37
	2. Stored Procedure Demo	6:24
	3. Using Input Parameters	7:33
	4. Using Output Parameters	7:09
	5. Understanding Table Variables	7:23
	6. Understanding CTEs - 1	5:56
	7. Understanding CTEs - 2	4:47
	8. Understanding Masking	5:48
	9. Masking Demo	3:21

User-Defined Functions
	1. Introduction	4:50
	2. Understanding Scalar Functions	6:54
	3. Table-Valued Functions	6:11

Understanding Subqueries
	1. Introduction	2:45
	2. Scalar Subqueries	4:55
	3. Multi-Valued Subqueries	6:20
	4. Correlated Subqueries	6:24

Course Summary
	1. Summary	5:27

Pass Microsoft MCSA 70-761 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

$18.00

Get Unlimited Access to ALL Premium Files Not Convinced?

Free 70-761 Exam Questions & Microsoft 70-761 Dumps
Microsoft.exam.70-761.v2018-10-02.by.curry.108q.ete	Views: 894 Downloads: 515	Size: 11.7 MB Votes: 4
Microsoft.braindumps.70-761.v2018-07-29.by.jarod.100q.ete	Views: 1095 Downloads: 480	Size: 10.76 MB Votes: 5
Microsoft.prep4sure.70-761.v2018-06-16.by.sandro.91q.ete	Views: 993 Downloads: 459	Size: 11.13 MB Votes: 3
Microsoft.mcsa.braindumps.70-761.v2018-05-18.by.charles.75q.ete	Views: 1176 Downloads: 620	Size: 10.84 MB Votes: 3
Microsoft.Selftestengine.70-761.v2018-01-16.by.mate.82q.ete	Views: 2490 Downloads: 1976	Size: 10.27 MB Votes: 16

Student Feedback

4.6

Excellent

69%

26 %

Comments * The most recent comment are at the top

Yves

United States

May 04, 2018

Good Evening, everybody, I'd like to know how to access the working file, please.

Thank you

Kushal Suyal

United Arab Emirates

Apr 28, 2018

Presenter explained each and every thing in a very good manner.
It helped me to pass my exam.

Joseph

Netherlands

Apr 24, 2018

Does anybody have access to the script files following the examples and recommended practices?
Also, is the dump still valid?
Thanks! :)

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Limited Time Discount Offer
40% Off - Ends in 02:00:00

70-761: Querying Data with Transact-SQL

Curriculum For This Course

Pass Microsoft MCSA 70-761 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

70-761 Premium Bundle

Free 70-761 Exam Questions & Microsoft 70-761 Dumps

Student Feedback

Comments * The most recent comment are at the top

Add Comments

Get 40% Discount on All Your Purchases

This is ONE TIME OFFER

Enter your email address to receive your 40% off discount code:

Limited Time Discount Offer 40% Off - Ends in 02:00:00

70-761: Querying Data with Transact-SQL

Curriculum For This Course

Pass Microsoft MCSA 70-761 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!30 Days Free Updates, Instant Download!

70-761 Premium Bundle

Free 70-761 Exam Questions & Microsoft 70-761 Dumps

Student Feedback

Comments * The most recent comment are at the top

Add Comments

Get Premium Membership

Enter your email address to receive your 40% off discount code:

Limited Time Discount Offer
40% Off - Ends in 02:00:00

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!