Microsoft SQL Server

Learn SQL Server 2017 and Azure SQL database management


Share:

In this training course, your trainer Manoj gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Server 2017, including running SQL Server in Azure. You will learn how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL. The course wraps up by showing you how to manage data recovery and implement high-availability databases.

Best Microsoft SQL Server training in Pune, Pimpri Chinchwad

This course is based on Exam 70-764: Administering a SQL Database Infrastructure and Exam 70-765: Provisioning SQL Databases exam objectives. After passing these two exams you will get MCSA: SQL Database Administration certificate from Microsoft.

We are covering following topics in this training:
Sr. Details
1 Planning and Installing SQL Server 2017
  • Planning Your Installation
  • Edition comparison
  • Installing SQL Server
2 Introducing Database Server Components
  • Understand SQL Server Management Studio
  • Configure SQL Server instances
  • Setup database files
  • Create SQL Server databases
  • Manage and configure databases
3 Provisioning Azure SQL Databases
  • Understand Microsoft Azure and database-as-a-service concepts
  • Starting with Azure portal
  • Provision Azure SQL Server
  • Creating the Azure SQL database
  • Using Azure SQL Server
  • Using management tools to connect to Azure SQL database
  • Using Azure database backups and replication
4 Implementing and Managing SQL Server User Security and Permissions
  • Understanding Sql authentication
  • Understand logins and users
  • Setup permissions in SQL Server
5 Securing the Server and Data
    Handle encryption in SQL Server
  • Setup row level security
  • Understand data masking
  • Configure SQL Server audits
6 Understanding and Designing SQL Server Tables
  • Review table design
  • Understand special table types
  • Create views
  • Use change tracking
7 Performance Tuning and Optimizing SQL
  • Understand isolation levels
  • Use execution plans
  • Configure clustered indexes
  • Configure non-clustered indexes
  • Use index statistics
  • Understand parallelism
8 Developing, Deploying, and Managing Data Recovery
  • Understand data recovery fundamentals
  • Understand backup devices
  • Understand different types of backups
  • Create and verify backups
  • Restore a database
  • Define a backup and recovery strategy
9 Implementing SQL Server High Availability and Disaster Recovery
  • Review high availability and disaster recovery technologies
  • Setup SQL Server log shipping
  • Use SQL replication for high availability
  • Read secondary database copies
10 Managing and Monitoring SQL Server Databases
  • Monitor database backups
  • Deal with database corruption
  • Setup index maintenance
  • Configure statistics updates
  • Cleanup history
  • Shrink databases
  • Monitor database activity
  • Use performance monitor
  • Monitor database logs
  • Use resource governor
We are covering the some of the exam objectives required to pass the Microsoft Exam 70-764: Administering a SQL Database Infrastructure and Exam 70-765: Provisioning SQL Databases for earning MCSA: SQL Database Administration certificate.

Exam details:

  • All Microsoft exams are online and available at Pearson VUE exam centers.
  • Exam pricing is $165 per exam. In India current Microsoft exam fee is Rs. 4800/- per exam. Worldwide it may vary.
  • Total exam is of 1000 marks and you need to earn 700 marks to pass the exam.
  • You will get 45 to 55 questions in an approximate 2-2½ hours of duration and may change per exam basis.
  • Exam formats and question types: Mostly single or multiple choice, drag and drop, repeated answer choices, etc. To understand and view video demos, please » visit http://microsoft.com/learning
» Click here to view current exam offers if available!

Student Testimonials

Questions?

Send inquiry: