70-461 Session 6 Querying Microsoft SQL Server 2012

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size577.1 MB
  • Uploaded Bygroovymax123
  • Downloads388
  • Last checkedJun. 13th '18
  • Date uploadedJun. 20th '16
  • Seeders 0
  • Leechers0
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : ADDB43F6047B7D982A89C66FF5C67DF925C4EB34

70-461 Session 6 Querying Microsoft SQL Server 2012

================
[COVER:]
================



================
[INFO:]
================

70-461 Session 6: Querying Microsoft SQL Server 2012
MP4 | Video: 1280x720 | 59 kbps | 44 KHz | Duration: 4 Hours | 577 MB
Genre: eLearning | Language: English


Building on Sessions 1-5, we'll look at correlated subqueries, CTEs, Pivots, UDFs, uniqueidentifiers and Sequences.

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.

readmore
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?

Over 31 lectures and 3.5 hours of content!
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.




Please use 7Zip/WinRAR/Universal Extractor to EXTRACT FILES

If You Like This Torrent Support the Authors by Purchasing It!.. Thanx






Files:

09 Conclusion
  • 001 Well done.mp4 (39.1 MB)
01 Introduction
  • 001 Introduction.mp4 (116.0 MB)
  • 002 Objectives.mp4 (3.5 MB)
06 Objective 14 Functions
  • 005 Multi-statement Table Function.mp4 (11.9 MB)
  • 006 APPLY.mp4 (19.0 MB)
  • 004 Inline Table Function.mp4 (11.4 MB)
  • 003 A more complicated scalar function.mp4 (15.7 MB)
  • 001 Introduction.mp4 (8.1 MB)
  • 002 Scalar Functions.mp4 (17.8 MB)
02 Objective 7 Sub-queries
  • 008 Top 5 from various categories.mp4 (14.3 MB)
  • 002 The WHERE clause.mp4 (13.0 MB)
  • 001 Table structure.mp4 (9.2 MB)
  • 007 Correlated subquery - WHERE.mp4 (14.0 MB)
  • 003 WHERE and NOT.mp4 (9.6 MB)
  • 004 ANY, SOME and ALL.mp4 (15.8 MB)
  • 005 The FROM clause.mp4 (22.8 MB)
  • 006 The SELECT clause.mp4 (22.0 MB)
05 Objective 7d CTE statement
  • 001 Self-Join.mp4 (21.0 MB)
  • 002 Recursive CTE.mp4 (28.4 MB)
03 Objective 7e WITH statement
  • 003 Grouping numbers.mp4 (19.7 MB)
  • 001 WITH statement.mp4 (11.2 MB)
  • 002 Generating a list of numbers.mp4 (19.5 MB)
08 Objectives 8c GUIDs and Sequences
  • 002 GUIDs.mp4 (19.2 MB)
  • 003 Creating SEQUENCEs.mp4 (10.1 MB)
  • 001 The problems about IDENTITY.mp4 (5.5 MB)
  • 004 Using SEQUENCEs.mp4 (17.3 MB)
04 Objective 7b PIVOTing and UNPIVOTing
  • 003 UNPIVOT.mp4 (6.3 MB)
  • 001 PIVOT.mp4 (15.8 MB)
  • 002 Replacing NULLs in PIVOTs..mp4 (13.5 MB)
07 Objectives 6b and 6c Synonyms and Dynamics
  • 001 Synonyms.mp4 (13.1 MB)
  • 002 Dynamic SQL.mp4 (13.4 MB)

Code:

  • udp://11.rarbg.com:80/announce
  • udp://11.rarbg.me/announce
  • udp://9.rarbg.com:2710/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://glotorrents.pw:6969
  • udp://11.rarbg.com/announce
  • udp://9.rarbg.to:2710/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://glotorrents.pw:6969/announce
  • http://tracker.aletorrenty.pl:2710/announce
  • http://tracker.pubt.net:2710/announce
  • udp://tracker.xelion.fr:6969/announce
  • udp://9.rarbg.me:2710/announce
  • udp://open.demonii.com:1337/announce
  • udp://tracker.flashtorrents.org:6969/announce