Udemy_70-461_Session_6_Querying_Microsoft_SQL_Server_2012

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

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

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

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

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

  • مقدمه
  • Sub-queries
  • ساختار جدول ها
  • WHERE و NOT
  • ANY, SOME و ALL
  • شرط FROM
  • شرط SELECT
  • دستور WITH
  • PIVOTing و UNPIVOTing
  • Sub-queries هم بسته
  • توابع
  • توابع اسکالر
  • توابع عددی پیچیده
  • ایجاد یک لیست از اعداد
  • تعداد گروه بندی
  • PIVOTing و UNPIVOTing
  • دستور CTE
  • Self-Join
  • مترادف ها و دینامیک
  • Dynamic SQL
  • GUIDs; و Sequences
  • مشکلات IDENTITY
  • ساخت SEQUENCEs
  • GUID ها
  • نتیجه گیری

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

سطح: مقدماتی

نویسنده: Phillip Burton

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

 توضیحات:

Udemy 70-461 Session 6: Querying Microsoft SQL Server 2012
Building on Sessions 1-5, we'll look at correlated subqueries, CTEs, Pivots, UDFs, uniqueidentifiers and Sequences.

Phillip Burton
3.5 hours
Intermediate Level

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

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets, and in session 5 we learned about ranking and aggregate functions.

We'll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We'll also look at sequences.

No prior knowledge other than what we covered in Sessions 1 to 5 is required. This course builds on the knowledge previously gained in those previous sessions.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write subqueries, functions, sequences and more, and we'll have expanded on our current knowledge of T-SQL.

What are the requirements?
You need to know about data types and functions, SELECT queries, and ranking functions.
If you don't, then you should take my earlier Sessions 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?
Learn all about subqueries, using them in the SELECT, FROM and WHERE clauses.
Learn about correlated subqueries, where the results of the subquery depends on the main query.
Learn about Common Table Expressions (CTE), using the WITH statement.
Use ROW_NUMBER, LAG and CTEs to group consecutive numbers.
Learn about PIVOT and UNPIVOT to spread data across columns.
Find out all about functions, including UDFs (user defined functions): scalar, inline table and multi-statement table functions
"Join" the functions into tables using the CROSS APPLY and OUTER APPLY.
Learn about synonyms, dynamic SQL and SQL injection.
Find out about uniqueidentifiers (NEWID and NEWSEQUENTIALID functions), and create and use Sequences.
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 sessions 1 to 5 courses before taking this session 6.
If you want more advanced topics, then please look at my other sessions.

Section 1: Introduction
Lecture 1
Introduction

02:57
Lecture 2
Objectives

02:33
Lecture 3
Resources
Article
Section 2: Objective 7: Sub-queries
Lecture 4
Table structure
04:25
Lecture 5
The WHERE clause
06:26
Lecture 6
WHERE and NOT
05:21
Lecture 7
ANY, SOME and ALL
08:54
Lecture 8
The FROM clause

10:58
Lecture 9
The SELECT clause
10:38
Lecture 10
Correlated subquery - WHERE
06:54
Lecture 11
Top 5 from various categories
07:03
Section 3: Objective 7e: WITH statement
Lecture 12
WITH statement
05:23
Lecture 13
Generating a list of numbers
09:29
Lecture 14
Grouping numbers
10:01
Section 4: Objective 7b: PIVOTing and UNPIVOTing
Lecture 15
PIVOT
07:50
Lecture 16
Replacing NULLs in PIVOTs.
06:40
Lecture 17
UNPIVOT
03:14
Section 5: Objective 7d: CTE statement
Lecture 18
Self-Join

09:04
Lecture 19
Recursive CTE
12:56
Section 6: Objective 14: Functions
Lecture 20
Introduction
05:12
Lecture 21
Scalar Functions
08:58
Lecture 22
A more complicated scalar function
07:30
Lecture 23
Inline Table Function
05:33
Lecture 24
Multi-statement Table Function
05:34
Lecture 25
APPLY
08:31
Section 7: Objectives 6b and 6c: Synonyms and Dynamics
Lecture 26
Synonyms

07:26
Lecture 27
Dynamic SQL
06:49
Section 8: Objectives 8c: GUIDs; and Sequences
Lecture 28
The problems about IDENTITY

03:06
Lecture 29
GUIDs
08:26
Lecture 30
Creating SEQUENCEs
05:47
Lecture 31
Using SEQUENCEs
07:42
Section 9: Conclusion
Lecture 32
Well done!
01:08