Description
Udemy – 70-461, 761: Querying Microsoft SQL Server with Transact-SQL, the training IP from the database ( Querying ) in Server Microsoft the SQL plug-in plus Transact-SQL suitable for the test, 461-70 and 761-70 of the test set, the Microsoft certifications is . This period, regardless of a person completely unfamiliar with this system, for professional mastering, he must provide the names. from tables and jQuery, SELECT to advanced SQL which includes versions of 2012, 2014, etc. 2016., the 2017 and 2019 are . This 7-chapter course prepares you for tests 461-70 which is querying Microsoft SQL Server 2012 and 761-70 which is querying data by Transact-SQL.
Chapter 1 of this volume, to teach the basics like how to install SQL Server and build, or drop the table and Chapter 2 to import data into these tables and get data summary with jQuery, SELECT etc. FROM ETC. GROUP BY, ETC. and also combine the table and change them pays. Then, in chapter 3, an automatic execution command when entering or modifying data to help the young and the future, in season 4, the realization of procedures and the composition of the dataset by UNION, etc., EXCEPT, etc. ISNULL, etc., and in Chapter 5, the construction of jQuery is cumulative, and the use of functions such as ROW_NUMBER, etc., RANK, as well as functions such as LAG, etc., LEAD, etc. Chapter 6 this course for building subqueries, including correlated jQuery, defining numeric functions, etc. inline, and multi-conditional, the use of GUID and sequence are allocated and chapter 7 is also related to the transaction is .
What things to learn
Build a table in the database and modify the columns
Use the right type of data in different situations and apply corresponding functions to manipulate them
Get data by SELECT FROM WHERE GROUP BY etc
Combine multiple tables together
Insert new data, update or delete previous data
Classification and analysis functions and groupings
Make subqueries
And …
This training is suitable for people who
People who don’t use SQL servers much or at all and tend to learn it
People who need to modernize their knowledge of SQL
Udemy Profile – 70-461, 761: Querying Microsoft SQL Server with Transact-SQL
Publisher: Udemy
Speaker: Philip Burton
French language
Level of training: Beginner
Number of courses: 277
Duration: 29h 47m
Main seasons
Preconditions
- 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 Mac OS. If you want to install it on a Mac, you’ll either need to dual boot into Windows or run Parallel Desktop.
- You don’t even need to install SQL Server – I’ll show you that you need to install it for free on your computer!
Pictures
sample movie
Installation guide
After extracting with the player, your custom view.
Subtitles: English
Quality: 720p
Changes:
The 2020/10 version increased by at least 1 lesson and 3 minutes compared to 2019/5.
The 2020/11 version did not change the total number of lessons and time compared to 10/2020, but increased by about 20 MB.
Download link
Password file(s): ngaur.com
File size
14.5 GB