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

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

70-461 Session 4: Querying Microsoft SQL Server 2012 (T-SQL). With the help of this course you can Using TSQL code, merge databasets together, create procedures and incorporate error handling. SQL 2012-2016, inc. 70-761.

This course was created by Phillip Burton. It was rated 4.7 out of 5 by approx 1544 ratings. There are approx 80476 users enrolled with this course, so don’t wait to download yours now. This course also includes 3.5 hours on-demand video, 2 Articles, 2 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What Will You Learn?

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

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.

Rating:
4.6

Download Links

Get Download Link

Related Courses

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da…

Querying Microsoft SQL Server Databases using T-SQL

Administering Microsoft SQL Server 2012 Databases – 70-462

Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft SQL Server 2012 Certification Training Exam 70-462

Microsoft SQL Server 2012 Certification Training Exam 70-463

Writing Advanced SQL Queries on Microsoft SQL Server

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Sub Query Magic: Write T-SQL Subqueries Using SQL Server

T-SQL For Beginners: Learn to Query SQL Server Databases

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

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

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

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

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

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

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

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

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

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

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft SQL Server 2012 Certification Training Exam 70-461

Microsoft SQL Server 2012 Certification Training Exam 70-461
Go To Top