70-764 Administering A SQL Database Infrastructure




SQL ServerIT Training


Graduates and Technology Aspirants


Regular Offline and Online Live Training


Week Days and Week Ends

Duration :

1.5  hrs in weekdays and 3hrs during Weekend

SQL Server Objectives

•How To resolve errors in SQL Server .
•SQL Server Script How to apply and use it.
•Learn how to build an app in SQL Server .
•learn How to use Test driven Development in SQL Server .
•You will know how to configure a SQL Server jobs.
•Learn SQL Server from Scratch, Start from basic to advanced level
•Learn all about SQL Server from basic to advanced with interactive tutorials.
•Understand SQL Server and how to use it to write styles programmatically in SQL Server .
•This course is designed for any graduates as well as Software Professionals who are willing to learn SQL Server .

70-764 Administering a SQL Database Infrastructure Course Features

•You Get Real Time Project to practice
•Certificate after completion of the course
•Real time live project training and Guidance
•Create hands-on projects at the end of the course
•Fast track and Sunday Batches available on request
•Collaboration With 500+ Clients for Placements and Knowledge Sessions
•Live project based on any of the selected use cases, involving implementation of the concepts
• Our dedicated HR department will help you search jobs as per your module & skill set, thus, drastically reducing the job search time

Who are eligible for SQL Server

•.net software engineer, Team Lead, Senior Soft ware engineer, Technical Architect, Program Manager, .net Developer, Biztalk Developer, others
•Db2 Dba, SQL Dba, Java Developers, Java Lead, Firmware Developer, asp.net developer, Device Driver Developer, Hybris Developer, e Commerce Architect, ATG, WCS
•Java tech lead,Java Programming, Java / J2Ee Spring, Java Server Pages, Android, IOS Developer, hibernate, Spring, Core Java
•React.Js, Javascript, Ui Development, Css, Jquery, Web Development, User Interface Designing, Cloud, AWS, Java, Spring Framework, Cassandra, Docker, Python
•Websphere Message Broker, Ibm Bpm, Odm, Cognos Bi, Filenet, Tivoli, Datapower, Redhat Linux, Cloud Computing, Mobile Testing, Devops, Java, .Net, Python


70-764:Administering a SQL Database Infrastructure Practice Tests: Real Exam Questions Who should take this exam: This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. Course Details Configure data access and auditing (20–25%) Configure encryption Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors Configure data access and permissions Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking Configure auditing Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database Manage backup and restore of databases (20–25%) Develop a backup strategy Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation Restore databases Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores Manage database integrity Implement database consistency checks, identify database corruption, recover from database corruption Manage and monitor SQL Server instances (35–40%) Monitor database activity Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector Monitor queries Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events Manage indexes Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes Manage statistics Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables Monitor SQL Server instances Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation Manage high availability and disaster recovery (20–25%) Implement log shipping Configure log shipping, monitor log shipping Implement AlwaysOn Availability Groups Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups Implement failover cluster instances Manage shared disks, configure cluster shared volumes

Eligiblity for Certification :

Web DevelopersSoftware DevelopersProgrammersAnyone who wants to pass Exam 70-764: Administering a SQL Database InfrastructureIT professionals