As well as learning skills specific to SQL databases, you’ll learn how to install, configure and manage SQL Server 2016 itself. This will teach you to setup SQL Server 2016 and prove you know how it functions within your business. This will include managing and authorising user access, assigning and creating different types of database roles and learning to automate SQL Server management. You’ll learn to administer, develop and manage SQL Server 2016 databases
This course is best suited to Database Administrators, Specifically those who work closely with Microsoft SQL Server 2016.It is also relevant application developers who deliver content from SQL server Database.
IT professional, you must have the following technical knowledge:
1. Basic knowledge of the Microsoft Windows operating system and its core functionality
2. Working knowledge of Transact-SQL
3. Working knowledge of relational databases
4. Experience with database design
Total duration – 60 Hrs.
Part time - 30 days, 2hours/day.
Full time - 8 days, 8hrs/day
SQL Server Security, Protecting Data with Encryption and Auditing, Backing Up SQL Server Databases ,Restoring SQL Server 2016 Databases, Upgrading SQL Server to SQL Server 2017,Working with Databases, Performing Database Maintenance, Introduction to Managing SQL Server by using PowerShell, Tracing Access to SQL Server with Extended events.
70 764- administering a SQL database infrastructure
70-765: provisioning SQL databases