SQL Server video course – Session 4

70-461 Session 4: Querying Microsoft SQL Server 2012

Building on sessions 1 to 3, we’ll merge databasets together, create procedures and incorporate error handling.

Use the coupon code SQLINTRO to save 50%

About This Course

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012”.

Rather than present one huge course, this course takes some of the basics and then goes in depth. 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.

$20  $10
Take This Course

(That’s $3 per hour!)

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.

Lectures: 25
Video: 3.5 hours
Skill Level: Intermediate Level
Languages: English
Includes: Lifetime access
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion

Preview video 13

(Why not view the below video full screen? Click the YouTube logo in the bottom-right hand corner.)

Want to see more preview videos?

What are the requirements?

You need to know all about data types and functions.
You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements.
It would be helpful if you knew about views, triggers and triggers
If you don’t, then please take my Sessions 1-3 courses first.
There is a 30-day money back guarantee of this Udemy course.

Why not have a look at the curriculum below and see what you can learn? If you already know them, please see my later sessions.

What am I going to get from this course?

  • 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!

What is the target audience?

  • 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.

Curriculum

70-461 Session 4: Querying Microsoft SQL Server 2012 | Udemy

Section 1: Introduction
02:09
We’ll recap on sessions 1-3, and find out what we are going to learn in this session 4.
Resources
Article
Section 2: Objective 13: Combine database
12:30
We’ll be looking at UNION and UNION ALL, how to use them, and seeing the difference between them.
11:28
How to compare datasets – we’ll be looking at INTERCEPT and EXCEPT, and comparing it with UNION.
13:58
We’ll be looking both varieties of the CASE statement, and looking at the potential problems.
13:33
We’ll be looking at functions which give non-NULL answers, and comparing and contrasting them.
13:26
We’ll be combining two datasets, with updating original rows in the Target data with the Source data.
11:12
We’ll create our first MERGE statement.
09:22
We’ll build our MERGE statement on a grouped query instead of a table.
11:21
We’ll add a comments column, and expand our MERGE statement further.
02:01
We’ve not only done objective 13, but objective 12 as well!
Section 3: Objective 11 – Create and alter stored procedures (simple statements)
09:58
We’ll get straight into it, creating our first procedure, and using them as an Data Access Layer.
11:57
We’ll revise our procedure, so that instead of returning all the employees, we’ll return just one. We’ll learn how to use arguments.
05:14
A small diversion. We’ll expand our procedure and investigate the IF statement.
04:59
Instead of just one employee, let’s return a range of them. We’ll find out how to pass two values, and how to use named arguments.
12:10
We’ll branch out and make loops, by returning multiple SELECT statements, and find out why you shouldn’t.
13:06
Let’s get data out of a procedure, using OUTPUT and RETURN.
03:00
We’ll review what we have just learned, and link it to the next objective.
Section 4: Objective 18a – Implement try/catch/throw
11:18
We’ll create a new procedure, and find out that errors can happen…
09:46
We’ll implement error trapping, so that errors can be caught without the program execution stopping.
10:12
We’ll re-throw an error previously caught, and raise new errors.
08:46
We’ll add PRINT statements to debug our routines and communicate with the end user.
01:19
We’ll recap what we have learned this objective and this session.
Section 5: End of Session 4!
03:14
We’ll look back at this session, look forward to the next session, and give you a voucher code so that you can save money on your next sessions.
02:29

Do you have a question – why not ask it in the box below?

Take This Course

Comments are closed.