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

Online Course

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

What is the course about?

70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
The course 70-461 Session 4: Querying Microsoft SQL Server (T-SQL) is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761

Course description
  • 70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
  • 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.
  • You need to know all about data types and functions.
  • You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements.
  • It would be helpful if you knew about views, triggers and triggers
  • If you don’t, then please take my Sessions 1-3 courses first.
  • There is a 30-day money back guarantee of this Udemy course.
  • 3.5 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • Phillip Burton

Prerequisites & Facts

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

Course Topic

Business, Data Analytics, Decision Making

University, College, Institution

Udemy

Course Skill Level

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Degree & Cost

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

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.
Udemy
70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
provided by Udemy

Reviews

[display-frm-data id=”8278″ filter=”1″]

Please select a valid form
Here you can find information, reviews and user experiences for the course “70-461 Session 4: Querying Microsoft SQL Server (T-SQL)“. The provider of the course – “Udemy” – will be glad to answer any questions you may have about the class, click here to use the offical support channels. It would be great if you could share your experience of participating in the course – Your honest review will surely help others to choose the right class!
School: Udemy
Topic: IT & Software, IT Certification, Microsoft 70-461