70-764: Administering a SQL Database Infrastructure

70-764: Administering a SQL Database Infrastructure

Online Training Course

Best Seller!

$27.49 $24.99

4.6 82 votes 123 students enrolled
Total Lectures: 77
Course Time: 09:11:40

Curriculum For This Course

About This Course

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.

Read More

Free 70-764 Exam Questions & Microsoft 70-764 Dumps

File Votes Size Last comment
1 5.56 MB  
3 7.75 MB  
2 1.78 MB  
1 4.25 MB  
3 13.32 MB May 07, 2018

Student Feedback

Reviews

May 24, 2018
_ferdinand
 
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.
May 15, 2018
Kabir D
 
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.
May 13, 2018
parker
 
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.
May 13, 2018
Hunter
 
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!
May 06, 2018
Rémi Rem
 
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
Read More

Add Comment

Name:
E-mail: (This e-mail will not be published)
Comment:
Rate Course:
Verification: Insert Code
Close
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.
Please provide a correct E-mail address
Email Address:

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Close
Log into your ExamSnap Account

Please Log In to view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

E-mail:
*  
Password:
* Forgot password?
 

Only registered ExamSnap.com members can view Training Courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Similar Courses

Administering Microsoft System Center Configuration Manager and Cloud Services Integration
70-703: Administering Microsoft System Center Configuration Manager and Cloud Services Integration
Students: 142
4.5/5 2 hours
Administering Windows Server 2012
70-411: Administering Windows Server 2012
Students: 451
4.6/5 8 hours
Analyzing and Visualizing Data with Microsoft Excel
70-779: Analyzing and Visualizing Data with Microsoft Excel
Students: 93
4.5/5 5 hours
Analyzing and Visualizing Data with Microsoft Power BI
70-778: Analyzing and Visualizing Data with Microsoft Power BI
Students: 134
4.5/5 11 hours
Architecting Microsoft Azure Solutions
70-535: Architecting Microsoft Azure Solutions
Students: 127
4.6/5 9 hours
Architecting Microsoft Azure Solutions (70-534)
70-534: Architecting Microsoft Azure Solutions (70-534)
Students: 516
4.6/5 10 hours
Cloud Fundamentals
98-369: Cloud Fundamentals
Students: 118
4.6/5 5 hours
Configuring Advanced Windows Server 2012 Services
70-412: Configuring Advanced Windows Server 2012 Services
Students: 198
4.6/5 8 hours
Configuring Windows Devices
70-697: Configuring Windows Devices
Students: 285
4.7/5 16 hours
Core Solutions of Microsoft Exchange Server 2013
70-341: Core Solutions of Microsoft Exchange Server 2013
Students: 135
4.7/5 7 hours
Core Solutions of Microsoft SharePoint Server 2013
70-331: Core Solutions of Microsoft SharePoint Server 2013
Students: 126
4.6/5 6 hours
Designing and Deploying Microsoft Exchange Server 2016
70-345: Designing and Deploying Microsoft Exchange Server 2016
Students: 95
4.6/5 2 hours
Designing and Implementing Cloud Data Platform Solutions
70-473: Designing and Implementing Cloud Data Platform Solutions
Students: 128
4.5/5 4 hours
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Students: 136
4.6/5 4 hours
Developing Microsoft Azure Solutions
70-532: Developing Microsoft Azure Solutions
Students: 367
4.6/5 8 hours
Developing Microsoft SharePoint Server 2013 Core Solutions
70-488: Developing Microsoft SharePoint Server 2013 Core Solutions
Students: 108
4.5/5 17 hours
Developing Microsoft SQL Server 2012/2014 Databases
70-464: Developing Microsoft SQL Server 2012/2014 Databases
Students: 144
4.6/5 4 hours
Developing SQL Data Models
70-768: Developing SQL Data Models
Students: 86
4.6/5 7 hours
Developing SQL Databases
70-762: Developing SQL Databases
Students: 185
4.7/5 8 hours
Enabling Office 365 Services
70-347: Enabling Office 365 Services
Students: 484
4.6/5 7 hours
Identity with Windows Server 2016
70-742: Identity with Windows Server 2016
Students: 143
4.6/5 20 hours
Implementing a SQL Data Warehouse
70-767: Implementing a SQL Data Warehouse
Students: 113
4.0/5 6 hours
Implementing Microsoft Azure Infrastructure Solutions
70-533: Implementing Microsoft Azure Infrastructure Solutions
Students: 296
4.6/5 8 hours
Installation, Storage, and Compute with Windows Server 2016
70-740: Installation, Storage, and Compute with Windows Server 2016
Students: 439
4.6/5 8 hours
Installing and Configuring Windows Server 2012
70-410: Installing and Configuring Windows Server 2012
Students: 315
4.6/5 10 hours
Managing Microsoft SharePoint Server 2016
70-339: Managing Microsoft SharePoint Server 2016
Students: 105
4.5/5 1 hour
Managing Office 365 Identities and Requirements
70-346: Managing Office 365 Identities and Requirements
Students: 212
4.5/5 6 hours
Managing Projects with Microsoft Project 2013
74-343: Managing Projects with Microsoft Project 2013
Students: 142
4.5/5 1 hour
MCSA Administering Microsoft SQL Server 2012/2014 Databases
70-462: MCSA Administering Microsoft SQL Server 2012/2014 Databases
Students: 477
4.6/5 11 hours
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Students: 105
4.7/5 6 hours
MCSA Networking with Windows Server 2016
70-741: MCSA Networking with Windows Server 2016
Students: 194
4.7/5 5 hours
MCSA Querying Microsoft SQL Server 2012/2014
70-461: MCSA Querying Microsoft SQL Server 2012/2014
Students: 546
4.6/5 12 hours
MCSD Developing ASP.NET MVC 4 Web Applications
70-486: MCSD Developing ASP.NET MVC 4 Web Applications
Students: 201
4.5/5 18 hours
MCSD Developing Windows Azure and Web Services
70-487: MCSD Developing Windows Azure and Web Services
Students: 134
4.6/5 14 hours
MCSD Programming in C#
70-483: MCSD Programming in C#
Students: 370
4.7/5 8 hours
MCSD Programming in HTML5 with JavaScript and CSS3
70-480: MCSD Programming in HTML5 with JavaScript and CSS3
Students: 156
4.7/5 7 hours
MCSE Designing and Implementing a Server Infrastructure
70-413: MCSE Designing and Implementing a Server Infrastructure
Students: 683
4.6/5 9 hours
MCSE Implementing an Advanced Server Infrastructure
70-414: MCSE Implementing an Advanced Server Infrastructure
Students: 220
4.6/5 8 hours
Microsoft Azure Administrator Certification Transition
AZ-102: Microsoft Azure Administrator Certification Transition
Students: 96
5.0/5 4 hours
Microsoft Azure Infrastructure and Deployment
AZ-100: Microsoft Azure Infrastructure and Deployment
Students: 97
4.4/5 6 hours
Microsoft Azure Integration and Security
AZ-101: Microsoft Azure Integration and Security
Students: 132
4.4/5 3 hours
Microsoft Dynamics 365 customer engagement Online Deployment
MB2-715: Microsoft Dynamics 365 customer engagement Online Deployment
Students: 107
4.6/5 3 hours
Microsoft Dynamics 365 Customization and Configuration
MB2-716: Microsoft Dynamics 365 Customization and Configuration
Students: 121
4.6/5 12 hours
Microsoft Dynamics 365 for Customer Service
MB2-718: Microsoft Dynamics 365 for Customer Service
Students: 139
4.1/5 2 hours
Microsoft Dynamics 365 for Sales
MB2-717: Microsoft Dynamics 365 for Sales
Students: 107
4.5/5 8 hours
Networking Fundamentals
98-366: Networking Fundamentals
Students: 128
4.6/5 4 hours
Perform Cloud Data Science with Azure Machine Learning
70-774: Perform Cloud Data Science with Azure Machine Learning
Students: 115
4.0/5 9 hours
Provisioning SQL Databases
70-765: Provisioning SQL Databases
Students: 117
4.6/5 8 hours
Querying Data with Transact-SQL
70-761: Querying Data with Transact-SQL
Students: 141
4.6/5 6 hours
Securing Windows Server 2016
70-744: Securing Windows Server 2016
Students: 130
4.6/5 13 hours
Security Fundamentals
98-367: Security Fundamentals
Students: 144
4.5/5 6 hours
SharePoint 2010
77-886: SharePoint 2010
Students: 96
4.1/5 2 hours
Upgrading Your Skills to MCSA Windows Server 2012
70-417: Upgrading Your Skills to MCSA Windows Server 2012
Students: 132
4.5/5 5 hours
Upgrading Your Skills to MCSA: Windows Server 2016
70-743: Upgrading Your Skills to MCSA: Windows Server 2016
Students: 94
4.5/5 2 hours
Windows Operating System Fundamentals
98-349: Windows Operating System Fundamentals
Students: 144
4.6/5 4 hours
Windows Server Administration Fundamentals
98-365: Windows Server Administration Fundamentals
Students: 105
4.7/5 6 hours

Close

Close
LIMITED OFFER: GET 30% Discount

ExamSnap PREMIUM

Get Unlimited Access to all ExamSnap's PREMIUM files!



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

Close
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.


Enter Your Email Address

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