Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
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.
This comprehensive 70-461 Session 4: Querying Microsoft SQL Server (T-SQL) curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
What you need before starting this 70-461 Session 4: Querying Microsoft SQL Server (T-SQL) course:
This course is perfect for:
Everything you need to know about this online course, from duration to certification
Course Instructor
Phillip Burton
Expert instructor with industry experience
Course Language
English
All materials in English
This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.
Budget-Friendly Course
Typically around $49.99
Pricing may vary. Check the course provider for current promotions and exact pricing.
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
70-461 Session 4: Querying Microsoft SQL Server (T-SQL) isn't for you? Don't worry, explore these courses and advance your skills or learn something totally new.
