Explore

70-461 Session 6: Querying Microsoft SQL Server (SQL code)

5.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2017 (inc. 70-761).

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

Requirements

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?

Recommended for you

70-461 Session 3: Querying Microsoft SQL Server (T-SQL)

Using T-SQL in SSMS, add constraints, store queries in views, add triggers. SQL Server 2012, 2014, 2016, 2017 (70-761) If you are in UfB, welcome....

Save Course

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

Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761 If you are in UfB, welcome....

Save Course

70-461 Session 5: Querying Microsoft SQL Server (write SQL)

Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761) If you are in UfB, welcome....

Save Course