Microsoft MCSA: SQL 2016 Database Administration

£275.00

The database is key to any business, storing vital information about the business, employees, customers, market research and more data which helps your company to run day-to-day. The MCSA SQL 2016 Database Administration course is for IT professionals who work in an environment where databases play a key role in their primary responsibilities.

Report Abuse

Description

SQL (Structured Query Language) is used in programming and designed for managing data held in a relational database management system. The 70-764 and 70-765 modules are designed to teach you how to provision SQL Server databases both on premise and in SQL Azure, so managing a database from the cloud becomes an efficient and smooth process. You will also learn how to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

In this package, you will receive training for the two modules required, fully preparing you for the exams you need to gain certification and showcase your skills as a Database Administrator:

  • Microsoft 70-764: Administering a SQL Database Infrastructure
  • Microsoft 70-765: Provisioning SQL Databases

The database is key to any business, storing vital information about the business, employees, customers, market research and more data which helps your company to run day-to-day. The MCSA SQL 2016 Database Administration course is for IT professionals who work in an environment where databases play a key role in their primary responsibilities.

The MCSA SQL Server 2016 course will enable you to establish your technical skills in administering and managing databases to build a rewarding and sustainable career in IT.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry, with businesses of all sizes utilising these data platform solutions.

KEY LEARNING POINTS

  • 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
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud

ADVANTAGES OF THIS COURSE

  • Learn how to administer and manage databases using the SQL database platform
  • Expert instructor-led training from subject matter experts with a minimum of 15 years’ industry experience
  • Exam simulations to help you prepare for the real thing
  • 24/7 access to the course content for 12 months, so you can study anywhere, anytime!
  • Learn how to administer and manage databases in the cloud
  • Work your way towards coveted MCSA status
  • Self-paced training program that is designed to allow flexibility
  • Demonstrations and visual representations that allow students to develop their skills
  • Quizzes and exam simulators
  • World class Learning Management System (LMS) which allows you to interact with other students

Additional information

Exams Included

No

Course Type

Online Course

Expiry Date After Purchase

1 year

Device Processor

1 gigahertz (GHz)

RAM Required

1 GB

Operating System

iOS, Mac OS, Windows 10, Windows 7, Windows 8

Browsers

Google Chrome, Internet Explorer 8 or above, Mozilla Firefox, Safari 6 or above

Compatibility

Android, iPad, iPhone, Mac, Windows

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Vendor Information

We want you to be satisfied, so all eligible courses purchased on Vogate can be refunded within 14 days. For whatever reason, if you are unhappy with a course, you can request a refund, provided the request meets the guidelines in our refund policy.

Certain restrictions may apply and some purchases may only be eligible for credit refunds. For more information regarding our refund policy, please see below.

How to submit a refund request

If you’re looking for instructions on how to submit a refund request, please visit our support and help section

Our 14-day policy

While our 14-day refund policy is to allow customers to learn risk free, we must also protect our vendors from fraud and provide them a reasonable payment schedule. Payments are sent to vendor after 30 days, so we will not process refund requests received after 14 days of purchase.

Additional reasons for denied refunds

We reserve the right, in our sole discretion, to limit or deny refund requests in cases where we believe there is refund abuse, including but not limited to the following:

  • A significant portion of the course has been consumed or downloaded by a customer before the refund was requested.
  • Multiple refunds have been requested by a customer for the same course or other courses
  • Excessive refunds have been requested by a customer.
  • Users who have their account reported, banned or course access disabled due to a violation of our Terms or Trust & Safety Guidelines. 
  • We do not grant refunds for any subscription services.

These refund restrictions will be enforced to the extent permitted by applicable law. 

Credit only refunds

In cases where a transaction is not eligible for a cash refund, the refund will be granted using Vogate creditsprovided it otherwise meets our 14-day refund policy. 

If your course purchase is only eligible for a credit refund, this will be indicated on the refund page.

Types of purchases that are only eligible for credit refunds

iOS (Apple): iOS payments are processed through Apple and not Vogate, and so we are unable to offer cash refunds for in-app purchases made in the Apple App Store. You can read more about Apple’s refund policy here.

Bank & cash transfers: certain bank and cash transfer methods are only eligible for credit refunds.

Boleto Bancário: courses purchased through Boleto Bancário are only eligible for credit refunds.

Udemy credits: for more information regarding Vogate credits and refunds involving them, contact us.

Refunds for bundles purchased through a third party

Since the payment for the bundle was processed by the third-party vendor, we do not have the transaction on file and cannot initiate a refund for you. Please contact the third-party vendor directly to request a refund.

Product Enquiry

You may also like…