Udemy_70-461_Session_4_Querying_Microsoft_SQL_Server_2012

در این آموزش تصویری با کوئری نویسی در SQL Server 2012 آشنا می شوید.

مباحث این دوره شش جلسه ای مخصوص آزمون 70-461 است.

در این قسمت جلسه 4 را می توانید دانلود نمایید.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های این دوره آموزشی:

  • مقدمه
  • ترکیب دیتابیس
  • UNION و UNION ALL
  • Intercept و Except
  • دستور CASE
  • IsNull و ادغام
  • دستور MERGE
  • ایجاد و تغییر روش های ذخیره سازی
  • استدلال ها
  • While
  • Return
  • پیاده سازی try/catch/throw
  • TRY/CATCH
  • THROW و RAISERROR
  • چاپ

عنوان دوره: Udemy 70-461 Session 4: Querying Microsoft SQL Server 2012

سطح: مقدماتی

نویسنده: Phillip Burton

مدت دوره: 3.5 ساعت

 توضیحات:

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

Phillip Burton
3.5 hours
Intermediate Level

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.

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?
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.
If you want more advanced topics, then please look at my later sessions.

Section 1: Introduction
Lecture 1
Introduction

02:09
Lecture 2
Resources
Article
Section 2: Objective 13: Combine database
Lecture 3
UNION and UNION ALL
12:30
Lecture 4
Intercept and Except
11:28
Lecture 5
CASE statement
13:58
Lecture 6
IsNull and Coalesce
13:33
Lecture 7
MERGE statement - in theory
13:26
Lecture 8
Let's Build our MERGE statement
11:12
Lecture 9
Let's expand our MERGE statement

09:22
Lecture 10
Merge with additional columns
11:21
Lecture 11
Summary
02:01
Section 3: Objective 11 - Create and alter stored procedures (simple statements)
Lecture 12
Let's create our first procedure
09:58
Lecture 13
Ask for a specific employee
11:57
Lecture 14
Exercise with IF

05:14
Lecture 15
Multiple arguments
04:59
Lecture 16
While
12:10
Lecture 17
Return
13:06
Lecture 18
Summary
03:00
Section 4: Objective 18a - Implement try/catch/throw
Lecture 19
Procedure Exercise
11:18
Lecture 20
TRY/CATCH
09:46
Lecture 21
THROW and RAISERROR
10:12
Lecture 22
PRINT

08:46
Lecture 23
Summary
01:19
Section 5: End of Session 4!
Lecture 24
BONUS - Recap, Look ahead and Voucher Code
03:14
Lecture 25
Well done!
02:29