Udemy – 70-461, 761: Querying Microsoft SQL Server with Transact-SQL 2020-10

Description

Udemy - 70-461, 761: Querying Microsoft SQL Server with Transact-SQL, Querying Database Query on Microsoft SQL Server with Transact-SQL Plugin Suitable for 461-70 and 761-70 Exams Microsoft Certifications. This course gives you everything a person who is completely unfamiliar with the system needs to master it professionally; From SELECT tables and queries to advanced SQL, which includes 2012, 2014, 2016, 2017 and 2019 versions. This 7-chapter course prepares you for the 461-70 exams, which are inquiries from Microsoft SQL 2012 Server, and the 761-70 exams, which are data inquiries by Transact-SQL.

Chapter 1 of this course teaches basics such as how to install a SQL server and build or delete a table, and Chapter 2 introduces data into these tables and receives a summary of the data with SELECT, FROM, GROUP BY queries, etc., as well as combining the table. And change them. Then in Chapter 3, automatic execution of commands when entering or modifying data with the help of views, in Chapter 4 creating procedures and combining datasets by UNION, EXCEPT, ISNULL, etc. and in Chapter 5 creating cumulative queries and using functions Like ROW_NUMBER, RANK and also analytics functions like LAG, LEAD and so on. Chapter 6 This course deals with the construction of sub-queries including correlated queries, definition of numerical, inline and multi-conditional functions, use of GUIDs and sequences, and Chapter 7 deals with transactions.

What do you learn?

Build tables in the database and change columns

Use the correct data type in different situations and use the corresponding functions to manipulate them

Receive data with SELECT, FROM, WHERE, GROUP BY and so on

Combine several tables together

Insert new data, update or delete previous data

Apply ranking and analysis functions and groupings

Build subqueries

And

This training is suitable for people who

People who have not used SQL Server much or not at all and want to learn it

People who need to upgrade their knowledge of SQL

Profile Udemy - 70-461, 761: Querying Microsoft SQL Server with Transact-SQL

Publisher: Udemy

Instructor: Phillip Burton

English language

Level of training: Beginner

Number of lessons: 277 lessons in 53 sections

Duration: 29h 47m

Prerequisites

You need to know how to use a computer, and hopefully know how to use a spreadsheet.

No prior knowledge of SQL Server required.

SSMS cannot be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.

You don’t even need SQL Server installed – I’ll show you have to install it on your computer for free!

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Changes:

The 2020/10 version has increased by at least 1 lesson and 3 minutes compared to 2019/5.

The 2020/11 version did not have a total number of lessons and time compared to the 10/2020, but increased by about 20 MB.