Administering a SQL Database Infrastructure Certification Exam Course (70-764)

Download Course Contents

Administering a SQL Database Infrastructure Course Overview

At a time where data management could be what stands between business success and being overtaken by competitors, businesses are quick to recruit professionals with the capabilities to introduce a new, more desirable system into their organization. This Administering a SQL Database Infrastructure course equips professionals with the ability to do the same. Check out the dates below to enroll for this course today.

The 1-on-1 Advantage

Methodology

Flexible Dates

  • • Choose Start Date
  • • Reschedule After Booking
  • • Weekend / Evening Option

4-Hour Sessions

Destination Training
(Dubai/London/Sydney
New York/Goa)

Flexi
(Video Recording of Live Online)

You will learn:

Module 1: SQL Server Security
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
  • Plan a Backup Strategy
  • Configure Database Recovery Models
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job
  • Monitoring SOL Server Errors
  • Getting Started with Windows PowerShell
  • Configure SOL Server using PowerShell
  • Administer and Maintain SOL Server with PowerShell
  • Managing Azure SOL Databases using PowerShell
  • Getting Started with PowerShell
  • Using PowerShell to Change SOL Server settings
  • Extended Events Core Concepts
  • Working with Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application
Live Online Training (Duration : 40 Hours)
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

1950 + If you accept merging of other students.
4 Hours
8 Hours
Ultra-Fast Track
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
1700 Per Participant
Dubai
11 - 15 Dec GTR Co-Students 09:00 AM - 05:00 PM GST Gulf
(8 Hours/Day)
Online
12 - 23 Dec GTR Co-Students 09:00 AM - 01:00 PM CST
(4 Hours/Day)
Online
16 - 20 Jan 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Can’t Attend Live Online? Click to Buy Flexi For Only $99 (Video Recording of Live Online)
Course Prerequisites

In order to sit this Administering a SQL Database Infrastructure course, candidates must have;

  • Foundational knowledge of the Microsoft Windows OS and its core functionality
  • Should have a working knowledge of Transact-SQL
  • Should have an understanding of relational databases
  • Experience in creating database designs

The Administering a SQL Database Infrastructure (M20764) course teaches professionals that administer and maintain SQL Server databases or develop applications that deliver content from SQL Server databases the knowledge and skills needed to administer a SQL server database infrastructure.

Additionally, professionals that develop applications that deliver content from SQL Server databases would benefit from completing the course.

Key Features Of Administering a SQL Database Infrastructure Training Course

  • 5-Day instructor-led Administering a SQL Database Infrastructure Certification Training
  • Get access to the Administering a SQL Database Infrastructure course preview to begin your preparation
  • Expert Microsoft SQL Database trainers across the globe with real-world expertise
  • Approved Administering a SQL Database Infrastructure course material prepared by SMEs
  • Administering a SQL Database Infrastructure key resources provided to participants from Koenig Solutions
  • Administering a SQL Database Infrastructure course completion certificate provided
  • Administering a SQL Database Infrastructure training provided across 100+ locations globally

Who can take up Administering a SQL Database Infrastructure Certification Training?

Job roles that can benefit from Administering a SQL Database Infrastructure training include:

  • IT Administrators
  • Database Administrators
  • Application Developers
  • Cloud Computing Professionals
  • Configuration Specialists
  • Migration & Deployment Specialists
  • Data Migration Specialists
  • Deployment Specialists
  • Infrastructure Specialists
  • IT Security Professionals
  • Professionals looking to gain a complete understanding of Administering a SQL Database Infrastructure
  • Individuals looking to take up the 70-764: Administering a SQL Database Infrastructure certification exam

Learning Objectives of Administering a SQL Database Infrastructure Training

The course consists of fifteen modules with practical labs allocated to each module. The modules range from “SQL Server Security” to “Importing and Exporting Data.” The labs allow students to showcase the information learned across the course in a practical manner to ensure the skills learned can be applied correctly.

Upon course completion, students are able to;

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Manage SQL Servers using PowerShell
  • Trace access to SQL Servers
  • Monitor a SQL Server’s infrastructure
  • Troubleshoot for a SQL Server infrastructure
  • Import and export data

Benefits of taking up Administering a SQL Database Infrastructure Training

Some of the key benefits of taking up this Administering a SQL Database Infrastructure course include:

  • Holding a Microsoft SQL database certification opens professionals up to better opportunities.
  • Microsoft stands tall within the IT industry as a pioneer and clear front runner for the best and latest in software.
  • Holding the official Microsoft accreditation validates your skills for you. This creates a stronger likelihood for a better starting salary, better benefits, and heightened responsibilities within the organization.
  • Hiring professionals with the accreditation in hand helps companies avoid costs around upskilling, reskilling, and teething issues.
  • The average salary for SQL Database administrators within the US is USD 131,000. The base pay for this position sits at USD 86,000; a good reason to get your accreditation today.

Administering a SQL Database Infrastructure Exam Format

Upon Administering a SQL Database Infrastructure course completion, candidates are eligible to sit the 70-764 certification exam.

Exam Name Administering a SQL Database Infrastructure
Exam Code 70-764
Exam Cost USD 165
Exam Format Multiple Choice & Multiple Response Questions
Total Questions 40-60 Questions
Passing Score 700 out of 1000 (Equivalent to 70%)
Exam Duration 120 Minutes
Languages English
Testing Center Pearson Vue / Online Proctored Exam

 

When candidates successfully complete the course, they become eligible to sit the 70-764: Administering a SQL Database Infrastructure examination. This exam is ideal for candidates looking to become database professionals that perform installations, maintenance, and configuration tasks.

The examination measures the following skills;

  • Configuring data access and auditing (20-25%)
  • Managing backup and restore of databases (20-25%)
  • Managing and monitor SQL Server instances (35-40%)
  • Managing high availability and disaster recovery (20-25%)

Trending Technologies

 Microsoft Azure
 Cloud Computing
 Technology
 Microsoft Cloud
 Microsoft Dynamics 365
 Microsoft Role-based Certifications
 Fundamentals
 Azure Infrastructure
 Microsoft Dynamics
 IT Support & Help Desk Certifications

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
Yes, course requiring practical include hands-on labs.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes.You can access courseware for most vendors.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Dubai, Goa, Delhi, Bangalore.
Yes you can request your customer experience manager for the same.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You can request a refund if you do not wish to enroll in the course.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen.It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however,it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
No, the published fee includes all applicable taxes.
Yes, we do.
The Fee includes:
  • Courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Microsoft Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1-on-1 you can select your own schedule, other students can be merged but you select the schedule. Choose 1-on-1 if published schedule do not meet your requirement. If you also want a private session, opt for 1-on-1 Public.
Yes.
No, it is not included.

Businesses spend an abundance of time, money, and resources to introduce the best possible systems to manage their data efficiently and effectively. With the large volumes of information that move in and out of the organization, creating an optimized response to database management is critical.

This Microsoft offered Administering a SQL Database Infrastructure course allows professionals to cultivate the skills needed to create bespoke database management systems that can be tailored to specific organizational needs. This includes everything from data fortification to access management and even automation protocols. The average salary of a Database Administrator with Administering a SQL Database Infrastructure will be in the range of USD 86,000 to USD 131,000 per annum.

The primary audience for this Administering a SQL Database Infrastructure online training consists of individuals who administer and maintain SQL Server databases. These individuals are charged with database administration and maintenance as a key area of responsibility or work in environments where databases play a key role within their position.

The cost for both the Administering a SQL Database Infrastructure course and examination are likely to vary. At Koenig Solutions, we offer this course at USD 1000 and may vary depending on your location. However, the 70-764 exam cost remains the same across the globe, which stands at USD 165.

The Administering a SQL Database Infrastructure online course is conducted over five days.

Completing the Administering a SQL Database Infrastructure online course and examination fulfill a part of the requirements for MCSA: Microsoft Dynamics 365 for Operations and MCSA: SQL 2016 Database Administration. Candidates are encouraged to pursue these certification courses to broaden their professional opportunities.

As part of your Administering a SQL Database Infrastructure training, you will receive:

  • A Copy of the Administering a SQL Database Infrastructure course material developed by SMEs
  • Administering a SQL Database Infrastructure pre-reading material to prepare for the actual training
  • Administering a SQL Database Infrastructure course completion certificate
  • 70-764 exam voucher to sit for the exam at Pearson Vue test center or through online mode

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.