MCSE 70-761:Querying Data with Transact-SQL Part 1
3.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,575 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MCSE 70-761:Querying Data with Transact-SQL Part 1 to your Wishlist.

Add to Wishlist

MCSE 70-761:Querying Data with Transact-SQL Part 1

Microsoft SQL Server 2016
3.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,575 students enrolled
Created by Mr. Lesly Revenge
Last updated 3/2017
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Will be set and ready to take the second part of the course and get closer to passing your Microsoft SQL Server 2016 70-761 exam.
View Curriculum
Requirements
  • Have MS SQL Server Install
  • Stay motivated, finish the course, and do all of the work.
Description

Hello, and welcome to one awesome course that I put together.

T-SQL can be a challenging language to learn but not to master. Once you understand T-SQL, you will have no limit of what you can do. All you have to do is put some deep thinking into it.

This course is 1 of 3 courses that will prepare you for the exam 70-761.  The reason I broke this course into three courses is simply because some people are more advance than others. Nevertheless, learning the material in this course is essential to taken the other two courses. 

I will also suggest you purchase the next two courses right now. It build commitment. You will be commited to take the course. Remember, there are many reasons that you may not finish a course but no matter the excuse, it is all in your head. I need you to finish the course. It is important for me as it is for you.

This is the first part, where we will focus on Manage data with Transact-SQL which is about 40-45% of the exam.

  • I will walk the line on the exam requirements that has been set by Microsoft themselves.
  • Somethings you will learn by osmosis and others I will take my sweet time to actually teach you.
  • When you done learning, we will dive into the experience section. Where I will give you real world examples of SQL Server.

Here's how this course is structures:

  1. Lessons
  2. Labs
  3. Homework
  4. Homework Solution.
  5. Common Errors
  6. Did you get it?

Lessons: I will tell you about the section we are working on. I will show you visuals. And sometimes, we will convert human language to SQL. 

Labs: We will see some examples using SQL Server Management Studio. You will get hands on experience by following along. 

Homework: the homework is meant for you to do it yourself and please do it yourself. It is very important. The homework will set your brain to learn to think and work with SQL Server. 

Homework Solution: here, I will show you the solution for the homework. 

Common Errors: I don't want you to get frustrated, so I will show common errors so you can learn to deal with them. 

Did you get it? if you still did not get the section after we are done with lessons, labs, homework, solution, and common errors. Than, I will give you additional information so you can get it. If you get it, you can go right on to the next section. 

Good luck. I am excited. And so should you. Just remember, no matter what: FINISH WHAT YOU STARTED.

Who is the target audience?
  • This course is 1 of 3 courses designed for students who wish to pass MS SQL Server Exam: 70-761 Querying Data with Transact-SQL
  • Students who love repetition and want to learn by first watching through lessons, then practice through labs, then apply through homeworks, then self though through additional challenges.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
01:13:40
+
Introduction
2 Lectures 02:41

In this course, you will install the sample database AdventureWorks2014 and Wide World Import 2016.

PLEASE NOTE
00:05

Introduction
02:36
+
Create Transact-SQL SELECT queries
16 Lectures 28:59
SELECT CLAUSE: Lessons
00:47

SELECT CLAUSE: Lab
02:32

This homework focus on using select clause, choosing TOP, Using Alias, and concatenating fields. 

NOTE: Part of your learning require you do outside research to find answers on your own. This is very important on passing the exam. Going out to find answers on your own helps you remember a certain situation. 

SELECT CLAUSE: Homework
00:31

WHERE CLAUSE: Lesson
01:03

WHERE CLAUSE: Lab
02:00

Today's Homework is a little bit challenging so I salute you for trying to complete it. Please see the solution video. 

WHERE CLAUSE: Homework
00:28

Introduction to GROUP BY CLAUSE
01:57

Lab: GROUP BY CLAUSE
02:56

Introduction to HAVING CLAUSE
01:54

Lab: HAVING CLAUSE
02:52

Introduction to ORDER BY CLAUSE
01:59

Lab: ORDER BY CLAUSE
01:48

Introduction to UNION and Union All
02:00

Lab: Union and Union All
02:10

Introduction to EXCEPT and INTERSECT
02:00

Lab: EXC EPT and INTERSECT
02:01
+
Query multiple tables by using joins
9 Lectures 24:04
Lesson INNER JOIN
01:43

Lab 1: INNER JOIN
03:46

Lab 2: INNER JOIN
03:59

Lesson LEFT AND RIGHT OUTER JOIN
01:59

Lab: LEFT AND RIGHT OUTER JOIN
01:37

Lesson FULL OUTER JOIN
01:45

Lab: FULL OUTER JOIN
02:06

Lesson CROSS JOIN
01:38

Lab: CROSS JOIN
05:31
+
Implement Functions and Aggregate Data
7 Lectures 12:57
Lesson: User Defined Functions
01:58

Lesson: Function Usage on Where Clause
00:46

Lesson: Deterministic and Non-Deterministic Functions
01:39

Lab: Deterministic and Non Deterministic Functions
02:40

Lesson: Min and Max
01:08

Lesson: Count, AVG, Count_big, and Sum
01:51

Lesson: Standard Deviation and Variance
02:55
+
Modify Data
3 Lectures 04:59
Lesson: Insert, Update, and Delete
01:34

Lesson: Table Structure and Constraints
01:58

Lesson: DML and DDL
01:27
About the Instructor
Mr. Lesly Revenge
3.4 Average rating
47 Reviews
4,129 Students
3 Courses
SQL Server Instructor

Hello Friends,

My name is Lesly Revenge but I go by the name Mr. Lesly and I am here to instruct you. There are many ways to learn and teach. My goal is to teach you as if I was a student. Many instructors think like an experience instructor. If you can excuse my Haitian accent, you will be able to master my courses because I do not quit. I will focus on teaching you the best way possible. 

Good luck. And I cannot wait to hear some feedback from you. 


Mr. Lesly