Training Video Course

70-764: Administering a SQL Database Infrastructure

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The 70-764 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 70-764 test with flying colors.

Rating
4.61rating
Students
123
Duration
09:11:40 h
$16.49
$14.99

Curriculum for 70-764 Video Course

Name of Video Time
Play Video: Introduction
1. Introduction
02:31
Name of Video Time
Play Video: Introduction
1. Introduction
07:05
Play Video: Microsoft's SQL Server
2. Microsoft's SQL Server
08:11
Play Video: SQL Server 2016 Certifications
3. SQL Server 2016 Certifications
07:54
Play Video: Examples
4. Examples
03:17
Name of Video Time
Play Video: Introduction
1. Introduction
07:20
Play Video: SQL Server Editions
2. SQL Server Editions
06:15
Play Video: Understanding Databases
3. Understanding Databases
08:18
Play Video: Database Structures
4. Database Structures
08:21
Play Video: Transact-SQL
5. Transact-SQL
05:37
Name of Video Time
Play Video: Introduction
1. Introduction
08:15
Play Video: Installing SQL Server 2016
2. Installing SQL Server 2016
10:26
Play Video: Installing SQL Server Management Studio
3. Installing SQL Server Management Studio
04:47
Play Video: Attaching The Sample Database
4. Attaching The Sample Database
07:35
Play Video: Verifying The Installation
5. Verifying The Installation
05:07
Name of Video Time
Play Video: Introduction
1. Introduction
07:29
Play Video: Server Level Security
2. Server Level Security
08:50
Play Video: Restarting SQL Server
3. Restarting SQL Server
05:14
Play Video: Creating Logins
4. Creating Logins
07:55
Play Video: Database Level Security
5. Database Level Security
06:49
Play Video: Database User Account Types
6. Database User Account Types
08:27
Play Video: Cross Server Authorization
7. Cross Server Authorization
07:51
Play Video: Partially Contained Databases
8. Partially Contained Databases
06:25
Play Video: Dynamic Data Masking
9. Dynamic Data Masking
06:47
Play Video: DDM Example - 1
10. DDM Example - 1
05:43
Play Video: DDM Example - 2
11. DDM Example - 2
08:04
Name of Video Time
Play Video: Introduction
1. Introduction
07:33
Play Video: Fixed Server Roles
2. Fixed Server Roles
06:25
Play Video: Fixed Database Roles
3. Fixed Database Roles
05:30
Play Video: User-Defined Roles
4. User-Defined Roles
06:04
Play Video: Grant, Revoke, And Deny
5. Grant, Revoke, And Deny
04:37
Play Video: Schema Level Permissions
6. Schema Level Permissions
05:52
Name of Video Time
Play Video: Introduction
1. Introduction
10:00
Play Video: SQL Server Encryption Basics
2. SQL Server Encryption Basics
08:25
Play Video: Dark Side Of Encryption
3. Dark Side Of Encryption
07:00
Play Video: Asymmetric Vs. Symmetric
4. Asymmetric Vs. Symmetric
06:25
Play Video: Encryption Options
5. Encryption Options
06:15
Play Video: Encrypting Backups - 1
6. Encrypting Backups - 1
07:13
Play Video: Encrypting Backups - 2
7. Encrypting Backups - 2
06:18
Play Video: Transparent Data Encryption
8. Transparent Data Encryption
07:31
Play Video: Implementing TDE
9. Implementing TDE
08:26
Play Video: Always Encrypted
10. Always Encrypted
09:47
Play Video: Implementing Always Encrypted
11. Implementing Always Encrypted
05:49
Name of Video Time
Play Video: Introduction
1. Introduction
10:17
Play Video: Index Management Basics
2. Index Management Basics
04:16
Play Video: Identifying Fragmentation
3. Identifying Fragmentation
06:45
Play Video: Repairing Fragmentation
4. Repairing Fragmentation
06:20
Play Video: Database Engine Tuning Advisor - 1
5. Database Engine Tuning Advisor - 1
10:44
Play Video: Database Engine Tuning Advisor - 2
6. Database Engine Tuning Advisor - 2
05:15
Name of Video Time
Play Video: Introduction
1. Introduction
09:50
Play Video: Backup Types
2. Backup Types
07:40
Play Video: Understanding Recovery Models
3. Understanding Recovery Models
09:49
Play Video: Copy-Only Backups
4. Copy-Only Backups
10:12
Play Video: Backup Terminology
5. Backup Terminology
05:42
Play Video: System Database Backups
6. System Database Backups
06:47
Play Video: Transaction Log Basics
7. Transaction Log Basics
09:22
Play Video: Transaction Log Backups
8. Transaction Log Backups
08:58
Play Video: Tail-Log Backups
9. Tail-Log Backups
04:38
Play Video: Restoring Databases
10. Restoring Databases
10:52
Play Video: Restoring With SSMS
11. Restoring With SSMS
05:00
Play Video: Recovering The Master DB
12. Recovering The Master DB
07:39
Play Video: Point In Time Recovery
13. Point In Time Recovery
06:25
Play Video: Understanding Log Shipping
14. Understanding Log Shipping
05:36
Name of Video Time
Play Video: Introduction
1. Introduction
10:10
Play Video: Performance And Monitoring
2. Performance And Monitoring
05:48
Play Video: Session Identification Overview
3. Session Identification Overview
07:38
Play Video: Identifying Blocking Sessions - 1
4. Identifying Blocking Sessions - 1
09:34
Play Video: Identifying Blocking Sessions - 2
5. Identifying Blocking Sessions - 2
05:51
Play Video: Understanding UCPs
6. Understanding UCPs
07:49
Play Video: Data Collector Basics
7. Data Collector Basics
05:26
Play Video: Data Collector Configuration
8. Data Collector Configuration
07:40
Play Video: Query Store Basics
9. Query Store Basics
08:25
Play Video: Understanding Extended Events
10. Understanding Extended Events
06:46
Play Video: Creating An Extended Event - 1
11. Creating An Extended Event - 1
08:52
Play Video: Creating An Extended Event - 2
12. Creating An Extended Event - 2
02:43
Play Video: Editing An Extended Event
13. Editing An Extended Event
07:11
Name of Video Time
Play Video: Summary
1. Summary
06:02

About Microsoft 70-764 Training Course

This training course is designed to help with Microsoft 70-764 (70-764: Administering a SQL Database Infrastructure) exam preparation Read More.

The Administering a SQL Database Infrastructure video course intended to help all database professionals with all the foundational information needed to prepare for the Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure examination, which is part of the MCSA: SQL 2016 Administration certification track. This professional level examination is ideal for database professionals working essentially with installation, maintenance, and configuration tasks.

Description Of The Course

The examination for Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure being a part of the MCSA: SQL 2016 Administration certification track, passing this exam along with the Provisioning SQL Databases (70-765) exam, will successfully achieve you the MCSA certification.

This preparation guide is going to take aspiring examinees on a step by step curriculum, explaining the various SQL Server 2016 technologies and their core functionalities making it simple and easy to follow.

The tutorial is designed with the assumption that, not all the students who will use it may be as well conversant with all the aspects of the SQL Database platform, or those that don’t have extensive hands-on working experience in it. Since Microsoft hasn’t indicated any mandatory professional experience criteria for applying for this exam, it is expected that this course will be accessed by a number of examinees, with varying knowledge sets on the subject. Therefore, the curriculum is specially designed to live up to greater number of students, by including plenty of animations, photos and interactive content throughout the videos, explaining every one of the functionalities of Administering a SQL Database Infrastructure, so that everyone can knowledgeably grasp the complete technology.

In addition to the theoretic explanation, you will also get the opportunity to try out hands-on assignments on real interfaces, to demo the technologies and functionalities with practical application.

Knowledge And Skills Students Will Develop
  • Understand how the various functions of the SQL Server work together from an administrative standpoint
  • Learn about the types of databases, understand different database structures and SQL Server: Transact-SQL
  • Learn about the installation process of SQL Server and Management Studio
  • Learn about SQL Server security protocols
  • Learn about the various SQL Server roles
  • Configure auditing, encryption and data access & permissions
  • How to manage various indexes, identifying and repairing fragmentation
  • Manage backup and restore of databases, and develop back up strategies for large databases
  • Manage and monitor SQL server instances
Requirements
  • Personal Computer
  • Internet Connection
  • Any professional background, or basic knowledge and skill set about SQL Server 2016
Examination Paper Design
  • Duration : 120minutes
  • Cost: $164.00 USD
  • Number Of Questions: 40-60 questions
  • Types Of Questions: Innovative questions and testing technologies
The Target Audience
  • Database professionals, working with configuration tasks, installation and maintenance
  • Individuals looking to achieve the Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure
  • IT professionals looking to integrate their skill set in SQL Server platform, in order to integrate their career in the industry
Job Opportunities
  • SQL Database Administrator
  • Web Developers
  • Software Developers
  • Database Developers
  • SQL Server Writer
  • ETL Developer
  • Microsoft certified SQL Server Database Infrastructure Trainer/Instructor
Conclusion

The Administering a SQL Database Infrastructure video tutorial course, adheres with all the recommendations that Microsoft has stated in their website, to apply for the Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure examination. The course provides foundational information about the core topics covered in the examination, ideally for individuals with basic level understanding and minimum hands-on experience working with SQL servers. With the use of photos, animated visuals and interactive explanations, the course connects students of varying concepts.

Download Microsoft MCSA 70-764 Exam Questions & Answers

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

Microsoft 70-764 Premium Bundle
$59.97
$39.97

70-764 Premium Bundle

  • Premium File: 447 Questions & Answers. Last update: May 22, 2020
  • Training Course: 77 Video Lectures
  • Study Guide: 659 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
Get Unlimited Access to ALL Premium Files

70-764 Premium Bundle

Microsoft 70-764 Premium Bundle
  • Premium File: 447 Questions & Answers. Last update: May 22, 2020
  • Training Course: 77 Video Lectures
  • Study Guide: 659 Pages
  • Real Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$59.97
$39.97
Get Unlimited Access to ALL Premium Files

Free 70-764 Exam Questions & 70-764 Dumps

File Name Size Votes
File Name
microsoft.real-exams.70-764.v2020-05-26.by.jenson.260q.vce
Size
4.38 MB
Votes
1
File Name
microsoft.certkiller.70-764.v2020-02-11.by.theo.252q.vce
Size
5.1 MB
Votes
1
File Name
microsoft.testkings.70-764.v2020-01-27.by.joshua.268q.vce
Size
5.93 MB
Votes
2
File Name
microsoft.test-inside.70-764.v2019-12-24.by.khalid.267q.vce
Size
6.35 MB
Votes
2
File Name
microsoft.selftestengine.70-764.v2019-09-24.by.ellie.269q.vce
Size
6.15 MB
Votes
3
File Name
microsoft.test4prep.70-764.v2019-08-01.by.zachary.265q.vce
Size
6.53 MB
Votes
4
File Name
microsoft.passcertification.70-764.v2019-05-09.by.ivan.240q.vce
Size
5.63 MB
Votes
3
File Name
microsoft.real-exams.70-764.v2019-03-24.by.hazard.232q.vce
Size
5.56 MB
Votes
2
File Name
microsoft.selftesttraining.70-764.v2018-12-25.by.hyun.218q.vce
Size
7.75 MB
Votes
3
File Name
microsoft.mcsa.administering.sql.database.pass4sure.70-764.v2018-10-29.by.donald.204q.vce
Size
1.78 MB
Votes
2
File Name
microsoft.mcsa.administering.sql.database.train4sure.70-764.v2018-08-23.by.lina.202q.vce
Size
4.25 MB
Votes
1
File Name
microsoft.mcsa.pass4sureexam.70-764.v2018-04-14.by.omar.326q.vce
Size
13.32 MB
Votes
3

Comments (5)

Add Comment

Please post your comments about 70-764 Exams. Don't share your email address asking for 70-764 braindumps or 70-764 exam pdf files.

  • _ferdinand
  • Belgium
  • Feb 08, 2020

The course has successfully got me through the Administering a SQL Database Infrastructure (70-764) exam. Though this can’t be a standalone resource for it, but I think the areas that this tutorial covers, will make you stronger for grasping other topics more diligently.

  • Kabir D
  • United States
  • Jan 20, 2020

Very impressive and detailed course material for passing the exam. The course really elaborates on many fundamental topics that make the advanced topics more easy to understand. I will definitely recommend this to anyone applying for the exam.

  • parker
  • Chile
  • Jan 02, 2020

if you have a good set of knowledge in the technology, you may find this tutorial rather repetitive and basic. I’ve found it well designed material for those who have limited knowledge and skill in it. The rather “advanced” topics come way later, so those who already know most of the things can feel a bit of dragged in certain areas in the first several videos.

  • Hunter
  • Canada
  • Dec 17, 2019

The hands on trainings are really a great idea to help you get to the bottom of many complexities of the SQL server platform. This is a very useful material to prepare for the exam, most importantly because of its simplistic nature. I like this video course. Recommend!

  • Rémi Rem
  • Netherlands
  • Nov 28, 2019

the key points of this course revolve a lot around conceptualizing the user with the things that SQL can do, and doesn’t really go by the sequence of learning as per the Microsoft’s recommendations. it’s pretty much independent in its approach. this is good for getting a more personalized perspective about the whole thing, than think that it’s too difficult and technical

Add Comment

Purchase Individually

70-764  Premium File
70-764
Premium File
447 Q&A
$32.99 $29.99
70-764  Training Course
70-764
Training Course
447 Lectures
$16.49 $14.99
70-764  Study Guide
70-764
Study Guide
447 Pages
$16.49 $14.99

Microsoft Training Courses

Managing Microsoft SharePoint Server 2016 Training Course
70-339
Managing Microsoft SharePoint Server 2016
$14.99
Designing and Deploying Microsoft Exchange Server 2016 Training Course
70-345
Designing and Deploying Microsoft Exchange Server 2016
$14.99
Installing and Configuring Windows Server 2012 Training Course
70-410
Installing and Configuring Windows Server 2012
$14.99
Administering Windows Server 2012 Training Course
70-411
Administering Windows Server 2012
$14.99
Configuring Advanced Windows Server 2012 Services Training Course
70-412
Configuring Advanced Windows Server 2012 Services
$14.99
MCSE Designing and Implementing a Server Infrastructure Training Course
70-413
MCSE Designing and Implementing a Server Infrastructure
$14.99
MCSE Implementing an Advanced Server Infrastructure Training Course
70-414
MCSE Implementing an Advanced Server Infrastructure
$14.99
Upgrading Your Skills to MCSA Windows Server 2012 Training Course
70-417
Upgrading Your Skills to MCSA Windows Server 2012
$14.99
MCSA Querying Microsoft SQL Server 2012/2014 Training Course
70-461
MCSA Querying Microsoft SQL Server 2012/2014
$14.99
MCSA Administering Microsoft SQL Server 2012/2014 Databases Training Course
70-462
MCSA Administering Microsoft SQL Server 2012/2014 Databases
$14.99
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Training Course
70-463
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
$14.99
Developing Microsoft SQL Server 2012/2014 Databases Training Course
70-464
Developing Microsoft SQL Server 2012/2014 Databases
$14.99
Designing Database Solutions for Microsoft SQL Server 2012 Training Course
70-465
Designing Database Solutions for Microsoft SQL Server 2012
$14.99
Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Training Course
70-467
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
$14.99
MCSD Programming in HTML5 with JavaScript and CSS3 Training Course
70-480
MCSD Programming in HTML5 with JavaScript and CSS3
$14.99
MCSD Programming in C# Training Course
70-483
MCSD Programming in C#
$14.99
MCSD Developing ASP.NET MVC Web Applications Training Course
70-486
MCSD Developing ASP.NET MVC Web Applications
$14.99
MCSD Developing Windows Azure and Web Services Training Course
70-487
MCSD Developing Windows Azure and Web Services
$14.99
Installation, Storage, and Compute with Windows Server 2016 Training Course
70-740
Installation, Storage, and Compute with Windows Server 2016
$14.99
MCSA Networking with Windows Server 2016 Training Course
70-741
MCSA Networking with Windows Server 2016
$14.99
Identity with Windows Server 2016 Training Course
70-742
Identity with Windows Server 2016
$14.99
Upgrading Your Skills to MCSA: Windows Server 2016 Training Course
70-743
Upgrading Your Skills to MCSA: Windows Server 2016
$14.99
Securing Windows Server 2016 Training Course
70-744
Securing Windows Server 2016
$14.99
Querying Data with Transact-SQL Training Course
70-761
Querying Data with Transact-SQL
$14.99
Developing SQL Databases Training Course
70-762
Developing SQL Databases
$14.99
Administering a SQL Database Infrastructure Training Course
70-764
Administering a SQL Database Infrastructure
$14.99
Provisioning SQL Databases Training Course
70-765
Provisioning SQL Databases
$14.99
Implementing a SQL Data Warehouse Training Course
70-767
Implementing a SQL Data Warehouse
$14.99
Developing SQL Data Models Training Course
70-768
Developing SQL Data Models
$14.99
Analyzing and Visualizing Data with Microsoft Power BI Training Course
70-778
Analyzing and Visualizing Data with Microsoft Power BI
$14.99
Analyzing and Visualizing Data with Microsoft Excel Training Course
70-779
Analyzing and Visualizing Data with Microsoft Excel
$14.99
SharePoint 2010 Training Course
77-886
SharePoint 2010
$14.99
Windows Operating System Fundamentals Training Course
98-349
Windows Operating System Fundamentals
$14.99
Software Development Fundamentals Training Course
98-361
Software Development Fundamentals
$14.99
Windows Server Administration Fundamentals Training Course
98-365
Windows Server Administration Fundamentals
$14.99
Networking Fundamentals Training Course
98-366
Networking Fundamentals
$14.99
Security Fundamentals Training Course
98-367
Security Fundamentals
$14.99
Introduction to Programming Using Python Training Course
98-381
Introduction to Programming Using Python
$14.99
Designing and Implementing an Azure AI Solution Training Course
AI-100
Designing and Implementing an Azure AI Solution
$14.99
Microsoft Azure Administrator Training Course
AZ-103
Microsoft Azure Administrator
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-203
Developing Solutions for Microsoft Azure
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-300
Microsoft Azure Architect Technologies
$14.99
Microsoft Azure Architect Design Training Course
AZ-301
Microsoft Azure Architect Design
$14.99
Microsoft Azure DevOps Solutions Training Course
AZ-400
Microsoft Azure DevOps Solutions
$14.99
Microsoft Azure Security Technologies Training Course
AZ-500
Microsoft Azure Security Technologies
$14.99
Microsoft Azure Fundamentals Training Course
AZ-900
Microsoft Azure Fundamentals
$14.99
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Implementing an Azure Data Solution Training Course
DP-200
Implementing an Azure Data Solution
$14.99
Designing an Azure Data Solution Training Course
DP-201
Designing an Azure Data Solution
$14.99
Microsoft Dynamics 365 for Customer Service Training Course
MB-230
Microsoft Dynamics 365 for Customer Service
$14.99
Microsoft Dynamics CRM 2016 Customization and Configuration Training Course
MB2-712
Microsoft Dynamics CRM 2016 Customization and Configuration
$14.99
Microsoft Dynamics 365 Customization and Configuration Training Course
MB2-716
Microsoft Dynamics 365 Customization and Configuration
$14.99
Windows 10 Training Course
MD-100
Windows 10
$14.99
Managing Modern Desktops Training Course
MD-101
Managing Modern Desktops
$14.99
Microsoft 365 Identity and Services Training Course
MS-100
Microsoft 365 Identity and Services
$14.99
Microsoft 365 Mobility and Security Training Course
MS-101
Microsoft 365 Mobility and Security
$14.99
Deploying Microsoft 365 Teamwork Training Course
MS-300
Deploying Microsoft 365 Teamwork
$14.99
Deploying SharePoint Server Hybrid Training Course
MS-301
Deploying SharePoint Server Hybrid
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 Fundamentals
$14.99

Microsoft Certifications

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.