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

Online Course

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

What is the course about?

70-461 Session 6: Querying Microsoft SQL Server (SQL code)
The course 70-461 Session 6: Querying Microsoft SQL Server (SQL code) 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 SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2017 (inc. 70-761).

Course description
  • 70-461 Session 6: Querying Microsoft SQL Server (SQL code)
  • 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.
  • 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?
  • 5.5 hours on-demand video
  • 2 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • Phillip Burton

Prerequisites & Facts

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

Course Topic

IT & Software, IT Certification, Microsoft 70-461

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 6: Querying Microsoft SQL Server (SQL code)

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 6: Querying Microsoft SQL Server (SQL code)
provided by Udemy

Reviews

Share your experience

70-461 Session 6: Querying Microsoft SQL Server (SQL code)
Udemy Udemy
Rate the course

Do you recommend the course? *
Here you can find information, reviews and user experiences for the course “70-461 Session 6: Querying Microsoft SQL Server (SQL code)“. 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