Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
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
Managing SQL Server using PowerShell. Trace access to SQL Server
Monitor a SQL Server infrastructure. Troubleshoot a SQL Server infrastructure
Import and export data. Provision a Database Server. Upgrade SQL Server
Part-1 Exam 70-764 Administering a SQL Database Infrastructure
Lecture 1: SQL Server Security
Lecture 2: Assigning Server and Database Roles
Lecture 3: Authorizing Users to Access Resources
Lecture 4: Protecting Data with Encryption and Auditing
Lecture 5: Recovery Models and Backup Strategies
Lecture 6: Backing Up SQL Server Databases
Lecture 7: Restoring SQL Server 2016 Databases
Lecture 6: Backing Up SQL Server Databases
Lecture 7: Restoring SQL Server 2016 Databases
Lecture 8: Automating SQL Server Management
Lecture 9: Configuring Security for SQL Server Agent
Lecture 10: Monitoring SQL Server with Alerts and Notifications
Lecture 11: Managing SQL Server by using PowerShell
Lecture 12: Tracing Access to SQL Server with Extended events
Lecture 13: Monitoring SQL Server
Lecture 14: Troubleshooting SQL Server
Lecture 15: Importing and Exporting Data
Part-2 Exam 70-765: Provisioning SQL Databases
Lecture 16: SQL Server Components
Lecture 17: Installing SQL Server
Lecture 18: Upgrading SQL Server to SQL Server 2017
Lecture 19: Working with Databases
Lecture 20: Performing Database Maintenance
Lecture 21: Database Storage Options
Lecture 22: Planning to Deploy SQL Server on Microsoft Azure
Lecture 23: Migrating Databases to Azure SQL Database
Lecture 24: Deploying SQL Server on a Microsoft Azure VM
Lecture 25: Managing databases in the Cloud