Description
Udemy – 70-461, 761: Querying Microsoft SQL Server with Transact-SQL querying training course in the database Microsoft SQL Server With the plugin Transact-SQL It is suitable for exams 461-70 and 761-70 from Microsoft Certifications exams. This course provides you with everything a person completely unfamiliar with this system needs to master it professionally; From SELECT tables and queries to advanced SQL, which include 2012, 2014, 2016, 2017 and 2019 versions. This course in 7 chapters prepares you for exams 461-70, which is querying Microsoft SQL Server 2012, and 761-70, which is querying data using Transact-SQL.
Chapter 1 of this course teaches the basics such as how to install SQL server and create or delete tables and Chapter 2 to enter data into these tables and get a summary of the data with SELECT, FROM, GROUP BY, etc. queries and also table composition and their changes. 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 using UNION, EXCEPT, ISNULL, etc. and in chapter 5 creating cumulative queries and using functions Such as ROW_NUMBER, RANK, as well as analytical functions such as LAG, LEAD, etc. Chapter 6 of this course is dedicated to building sub-queries including correlated queries, defining numerical, inline and multi-conditional functions, using GUID and sequences, and Chapter 7 is related to transactions.
What do you learn:
- Creating a table in the database and changing the columns
- Using the right data type in different situations and using the relevant functions to manipulate them
- Get data with SELECT, FROM, WHERE, GROUP BY, etc
- Combine several tables together
- Insert new data, update or delete previous data
- Applying ranking and analytical functions and groupings
- Creating subqueries
- And …
This training is suitable for people who:
- People who have not used SQL Server much or at all and want to learn it
- People who need to refresh their knowledge of SQL
Udemy Profile – 70-461, 761: Querying Microsoft SQL Server with Transact-SQL:
- Publisher: Udemy
- Lecturer: Phillip Burton
- English language
- Training level: beginner
- Number of lessons: 277 lessons in 53 sections
- Duration: 29h 47m
Headlines
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!
Pictures
Sample video
Installation guide
After extracting, watch with your favorite player.
English subtitle
Quality: 720p
Changes:
The version of 10/2020 has increased by at least 1 lesson and 3 minutes compared to 2019/5.
The 2020/11 version has not changed compared to 2020/10 in the number of lessons and total time, but it has increased in size by about 20 MB.
download link
Password file(s): www.downloadly.ir
Size
14.5 GB
Be the first to comment