MCSA SQL 2016 Database Administration
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
Audience
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.
Prerequisites
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
Duration:
Total duration – 60 Hrs.
Part time - 30 days, 2hours/day.
Full time - 8 days, 8hrs/day
Key Benefits:
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.
Course Outline:
70 764- administering a SQL database infrastructure
- SQL Server Security
- Assigning Server and Database Roles
- Authorising Users to Access Resources
- Protecting Data with Encryption and Auditing
- Recovery Models and Backup Strategies
- Backing Up SQL Server Databases
- Restoring SQL Server 2016 Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server with Extended events
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data
70-765: provisioning SQL databases
- SQL Server Components
- Installing SQL Server
- Upgrading SQL Server to SQL Server 2017
- Working with Databases
- Performing Database Maintenance
- Database Storage Options
- Planning to Deploy SQL Server on Microsoft Azure
- Migrating Databases to Azure SQL Database
- Deploying SQL Server on a Microsoft Azure Virtual Machine
- Managing databases in the Cloud
Career Prospects:
- Data Analyst
- SQL Data base Administrator