Limited Time Discount Offer
40% Off - Ends in 02:00:00
Best seller!
70-764: Administering a SQL Database Infrastructure Training Course
Best seller!
star star star star star

70-764: Administering a SQL Database Infrastructure Certification Video Training Course

The complete solution to prepare for for your exam with 70-764: Administering a SQL Database Infrastructure certification video training course. The 70-764: Administering a SQL Database Infrastructure certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft MCSA 70-764 exam dumps, study guide & practice test questions and answers.

123 Students Enrolled
10 Lectures
01:04:49 Hours

70-764: Administering a SQL Database Infrastructure Certification Video Training Course Exam Curriculum



1 Lectures
Time 00:02:31

Getting Started

4 Lectures
Time 00:26:27

SQL Server Basics

5 Lectures
Time 00:35:51


  • 02:31

Getting Started

  • 07:05
  • 08:11
  • 07:54
  • 03:17

SQL Server Basics

  • 07:20
  • 06:15
  • 08:18
  • 08:21
  • 05:37

About 70-764: Administering a SQL Database Infrastructure Certification Video Training Course

70-764: Administering a SQL Database Infrastructure certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.

This Microsoft course is intended for the experts who regulate and keep up SQL Server databases and create applications that convey content from SQL Server databases will pick up the information and abilities to manage a SQL server database framework. Obtaining the MCSA: SQL 2016 Database Administration certification approves your abilities with database establishment, designing, and provisioning errands, and will qualify you for a position of an infrastructure specialist or a database administrator.


Those who have SQL Server abilities are sought-after all over the world. This course is intended for the individuals who need to administer SQL Server. The training prepares you to take the Microsoft 70-764 exam, the first of two tests you should take in order to obtain the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration credential.

  • Fundamental knowledge of a Microsoft Windows working framework and its center usefulness
  • Working knowledge of Transact-SQL
  • Working knowledge of social databases
  • Some involvement with database structure
Course objectives
  • Verifying associations with SQL Server 
  • Approving logins to interface with databases 
  • Approving crosswise over servers 
  • Partially contained databases 
  • Working with server jobs 
  • Working with settled database jobs 
  • Doling out user-defined database roles 
  • Approving client access to objects 
  • Approving clients to execute code 
  • Arranging authorizations at the pattern level 
  • Choices for inspecting information access in SQL Server 
  • Executing SQL Server review 
  • Overseeing SQL Server review 
  • Ensuring information with encryption 
  • Understanding backup methodologies 
  • SQL Server exchange login 
  • Arranging a reinforcement methodology 
  • Support up databases and exchange logs 
  • Overseeing database reinforcements 
  • Working with reinforcement choices 
  • Understanding the restore process 
  • Reestablishing databases 
  • Point-in-time recuperation 
  • Progressed restore scenarios 
  • Playing out a piecemeal restore 
  • Mechanizing SQL Server the board 
  • Working with SQL Server specialist 
  • Overseeing SQL Server specialist employments 
  • Multi-server the board 
  • Understanding SQL Server Agent Security 
  • Designing accreditations 
  • Designing intermediary accounts
The course helps you learn the following skills
  • Confirm and approve clients 
  • Allot server and database jobs 
  • Approve clients to get to assets 
  • Secure information with encryption and evaluating 
  • Portray recuperation models and reinforcement techniques 
  • Reinforce SQL Server databases 
  • Reestablish SQL Server databases 
  • Arrange security for the SQL Server specialist 
  • Oversee alarms and notices 
  • Oversee SQL Server utilizing PowerShell 
  • Follow access to SQL Server 
  • Screen a SQL Server foundation 
  • Investigate a SQL Server foundation 
  • Import and fare information
Exam details
  • There are from 40 to 60 questions in the exam.
  • It can take from 90 to 120 minutes to complete this test.
  • The passing mark is 700/1000.
  • The test takers can take the exam in English only.
Exam topics
  • Configuration of data access and auditing 
  • Management of backup and restoring of databases 
  • Management and monitoring of SQL server instances 
  • Management of high availability and disaster recovery
Target audience
  • Programmers
  • Web Developers
  • Software Developers
  • Anyone who wants to pass the Microsoft 70-764 exam

The course comes with different topics, and learning them, you will be prepared for the Microsoft 70-764 exam in order to get the MCSA certification.

Career path:
  • Senior Database Administrators
  • Windows Server Administrators
  • Network Engineers
  • Systems Analysts

The 70-764: Administering a SQL Database Infrastructure exam leads to the Microsoft MCSA certificate that gives the holder an opportunity to earn from $89,000 to $125,870 averagely on an annual basis.

Prepaway's 70-764: Administering a SQL Database Infrastructure video training course for passing certification exams is the only solution which you need.

Free 70-764 Exam Questions & Microsoft 70-764 Dumps
Views: 3303
Downloads: 3458
Size: 7.75 MB

Student Feedback

star star star star star
star star star star star
star star star star star
star star star star star
star star star star star

Comments * The most recent comment are at the top

South Africa
Jan 23, 2021
can i be able to download the course videos from this side?
Jan 18, 2021
This course is informative except can't explore more detail in working file folder.
United States
Jan 12, 2021
Great explanation and demonstration. I learned a lot more in the class. The only thing I would like to see is the AlwaysOn availability groups course in the package since clustering is a critical topic in organizations these days and the test will certainly have a question or questions on it.
but overall, the course package is worth the price.

Thank you
Jan 08, 2021
Much obliged to you for your courses!!! I have learned numerous new things!!! I am happy that I got the opportunity to learn with the best teacher!!!
Jan 04, 2021
It has a good structure and organization; the speaker realizes that it is so important to clarify everything. Thus, this is great, particularly for those who are still new to the subject or segment.
Dec 27, 2020
I have adapted some decent new highlights. However, I am certain that after this course alone I won't be able to pass the test. Extra exam or hands-on experience are required to receive the credential.
brent grimes
Saudi Arabia
Dec 22, 2020
Incredible and valuable asset. There are a lot of additional details that the teacher presents and explains to you. In any case, I suggest it without a doubt.
Dec 18, 2020
This course is exceptionally useful, the process and clarifications are well-ordered, which makes comprehension of the theme good for the new/non-IT individual. At the moment, I am sure that, I will keep learning the SQL Platform. A debt of gratitude is in order for making the incredible course. I’m searching for additional one.
chandler jones
United Arab Emirates
Dec 07, 2020
I’ve just finished this course. I saw all the recordings, and I like the way how key purposes of MS SQL 2016 are composed into parts of this course. The training made adapting so natural, which helped in getting the scores I needed. It is an astonishing course.
jordan reed
Dec 04, 2020
I preferred the breakdown with clarifications and live models. I also like the tutor’s straightforward American pronunciation. Much appreciated.
Nov 27, 2020
The course has guaranteed a great deal of materials that you should definitely know. Now, we are up to things that are unfamiliar to me, the information is being presented and explained well. Without any doubts, I can suggest the course.
United States
Nov 23, 2020
I cannot locate working file folder, please advise.

Thank you,
New Zealand
Nov 11, 2020
Where can the working files be downloaded from?
Many thanks!
detho decaho ange arnauld
Cote D'Ivoire (Ivory Coast)
Nov 08, 2020
i like this course but i want to know ifi can get my course in french

Add Comments

Post your comments about 70-764: Administering a SQL Database Infrastructure certification video training course, exam dumps, practice test questions and answers.

Comment will be moderated and published within 1-4 hours

insert code
Type the characters from the picture.