70-461 Session 4: Querying Microsoft SQL Server (T-SQL) (Udemy.com)

Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761

( 33 Reviews )

Created by: Phillip Burton

Produced in 2018

What you will learn

Combine and compare datasets using UNION, UNION ALL, INTERSECT and EXCEPT
Understand the difference between and use of CASE, ISNULL and COALESCE
MERGE two tables together, taking different actions if similar rows exist in both tables than if they don't.
Create parameterised PROCEDUREs, allowing you to store multiple commands together for later use.
EXECUTE those procedures, and add OUTPUT parameters to obtain RESULTs.
Introduce error checking with TRY, CATCH, THROW and more!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course Description

If you are in UfB, welcome.
If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".
In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries, JOINed multiple tables together and used DML commands, and in Session 3 we created views, constraints and triggers to encapsulate language and improve security.
We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW. We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.
No prior knowledge other than what we covered in Sessions 1 to 3 is required. However, prior experience with Excel or Access would be beneficial.
There are regular quizzes to help you remember the information.
Once finished, you will know what how to write procedures, add error handling, and combine datasets together, and we'll have expanded on our current knowledge of T-SQL.
Who this course is for:
This course is for you if want a refresher course in SQL, or are learning SQL for the first time.
This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL.
If you are starting from the beginning, then you should look at my session 1-3 courses before taking this session 4.
If you want more advanced topics, then please look at my later sessions.

Time: 3.5h

Instructor Details

Phillip Burton

4.5 Rating
33 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

SQL Server Integration Services (SSIS) - An Introduction

SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

All courses by Phillip Burton

More sql courses

SQL Server - zapytania. Querying. Exam 70-761

SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)

- Provider: Udemy
- Time: 20h

$11.99

Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)

- Provider: Coursera
- Time: 3h

Free

Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

The Ultimate Oracle SQL Course (2021)
4.7 (237 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

All sql courses

Reviews

4.5

33 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Jason Prull on 9/15/2020

The instructor provides the information in an easy to understand manner.

By Xianqing huang on 9/11/2020

great

By Dan Direen on 8/10/2020

Well explained concepts and examples. Thank you!

By shane Kearley on 5/2/2020

The amount this guy knows about sql, slightly turns on me :P

By John Mansfield on 3/11/2020

Really good pace and thorough coverage. Thanks Phil

By Eric H Simmons on 3/9/2020

Very good course

By Thomas on 11/17/2018

I am enjoying these courses.

By Gerald Weightman on 11/2/2018

This course is a good match for my skill level and my experience. I am reviewing subjects I have used in my professional career. It is sometimes very helpful to review and learn new things. This course is helping me to expand my existing knowledge and fill in gaps in my experience working with SQL Server and T-SQL.

By ABEN-HAMET PINEDA ANTUNEZ on 10/26/2018

Good explanation!!

By Greg on 8/7/2018

Learning any programming or database languages can be very boring. This course is not that. I am enjoying the course very much. Money well spent.

By Demetria Manning on 8/2/2018

I have now successfully completed 70-461 Sessions 1-4 and I am pleased with the collection. I feel confident that i can successfully utilize SQL Server with ease and without feeling overwhelmed. I would recommend these sessions to consumers who have at least viewed MicroSoft SQL Server which I believe will help when watching the instructor create statements in the videos.

By Robert S Wilbanks on 6/10/2018