Job Guarantee Program: Digital Marketing | CAD | Database | Networking
We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSA: SQL Server 2016 Database Administration

Synopsis

  • Fast Track (4 Days) – Mon to Thurs (10:00-18:00)
    Weekend Track (7 Weeks) – Every Saturday (14:30–18:30)
    Regular Track (7 Weeks) – Every Friday (09:30–13:30)
    Evening Track (5 Weeks) – Every Tue & Thurs (18:30–21:30)
  • Course Fee: £1200 + VAT
  • Industry Expert and Certified Instructors
  • Training Venue: Central London Location
  • Tutor Led Classroom Training

Request Brochure


Attend Instructor Led Training From Anywhere

Course Information

Early age of Information Technology has experienced an unimaginable growth, e.g. comparing the early invention of colossus computer to hand held computers of today is just unbelievable! . These tiny hand held computer can perform thousand times better and are much more reliable than those colossus computers. The development of the modern technology has enabled us to store data in very compact form where millions and trillions of data are stored and finding the information will just take fraction of a second.

The growing amount of data in every organization has to be stored in the Database; which is an organized form of data stored digitally. These data will grow gradually and can be really big and difficult to maintain and manage without proper infrastructure. Take an example of a bank which has over 30 million customers' records, making transactions every second which might be colossal records a day. It would be absolutely impossible to track the information without having database in a reliable, easy accessible and secure platform. Here comes the Microsoft SQL Server 2016 database server which has the capacity to manage huge amount of data. Microsoft SQL Server 2016 is very reliable, robust and secure platform used by many organizations to store their growing data.

Microsoft SQL Server 2016 is capable of providing unlimited amount of tables, Terabytes of data, relational data capabilities, database mirroring capabilities, automatic recovery, easy backup and restore, server cluster, database replications, data warehouse, jobs and alerts, monitoring tools, analysing tools and many more.

Why not prove your abilities and add value to your employer or to your business, by learning the core database technologies, features and implementation of Microsoft SQL Server 2016 with London Training. Microsoft have introduced IT Professional certification called Microsoft Certified Solutions Expert (MCSA): Data Platform certification which validates your skills needed to run a highly efficient Database infrastructure in this innovative SQL Server 2016 platform.

Career Prospect

Microsoft SQL Server 2016 is widely used by many organizations both small and large and this has created lots of opportunities for database administrators, software developers, system analysts, project managers, business entrepreneurs etc. Why not start your MS SQL Server 2016 training with London Training and get certified or enhance your career and knowledge to next level and find your dream job.

How we deliver this course?

Our MCSA: Data Platform course is delivered by certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies. We provide hands-on, tutor led and classroom based training in Central London.

Career Prospect

Microsoft Database Engineer, Microsoft SQL DBA, DatMicrosoftabase Administrator, Microsoft Database Consultant, Freelancer Microsoft SQL DBA, Microsoft Database Designer

Learning Facilities

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

General Facilities

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

Registration Process

Speak with course advisor about SQL training in London. Call us: 0207 256 7722

Course Fee: £1200 + VAT

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Project Work
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • The course fee excludes VAT
Interest Free Credit for IT course

Pay Monthly.

Interest Free Installments Upto 1 Year.

Contact


MCSA: SQL Server 2016 Database Administration

  • EXAM 70-764 - Administering a SQL Database Infrastructure 2016
  • EXAM 70-765 - Provisioning SQL Databases

Course Syllabus

MCSA SQL Exam 70-764: Administering a SQL Database Infrastructure 2016

Microsoft SQL Server 2016 and Tools

  • Overview Microsoft SQL Server 2016
  • MS SQL Server Management Studio
  • Creating and Managing T-SQL scripts
  • Microsoft SQL Server 2016 architecture

SQL Azure

  • Overview of SQL Azure
  • Features of SQL Azure.
  • Provision a SQL Azure server and configure its security.

T-SQL Querying

  • T-SQL Scripts, Sets, Predicate Logic
  • Logical Order of Operations in SELECT statements
  • SELECT Statements, filter data, sort data using ORDER BY

SELECT Queries

  • SELECT statement, focusing on queries against a single table.
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • CASE Expressions, DISTINCT clause

Configuring Database Security - Logins, Users, and Roles

  • SQL Server basic concepts
  • Explain the use of Logins
  • Explain the use of Users
  • Understanding of Logins and Users
  • Create Logins
  • Create Database Users
  • Creating Logins and Mapping to Users
  • SQL Server connection authentication
  • Authorizing Logins to Access Databases
  • Creating and Maintaining Users
  • Authorizing Users to Access Database Objects
  • Granting Permissions to Users
  • Managing Database Object Permissions
  • Creating and Maintaining Custom Roles
  • Granting Permissions to Roles
  • Configuring Contained & Non-Contained Databases
  • Correct Application Login Issues

Server Roles and Database Roles

  • Explain the use of server roles to manage server-level security.
  • Explain the use of fixed database roles
  • Explain the use of custom database roles and application roles to manage database-level security
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security

Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level

Protecting Data with Encryption and Auditing

  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE

Database Recovery Models and Backup Strategies

  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
  • Plan a Backup Strategy
  • Configure Database Recovery Models

Managing Backup of Databases

  • Developing a Backup Strategy
  • Backup Types – Full vs Differential vs Transaction Log Backup
  • Managing Transaction Log Backups
  • Configuring Backup Automation
  • Advanced Database Options
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

Managing Restore of Databses

  • Explain the restore process
  • Recovery States
  • Performing Restores
  • Performing Recovery
  • Performing POINT-IN-TIME Recovery
  • Performing Restore with Recovery, NoRecovery, and Standby
  • Restoring Individual Files
  • Perform advanced restore operations

Monitoring Database Activity

  • Monitoring Current Sessions
  • Configuring the Data Collector

Monitoring Queries

  • Extended Events
  • Trace Events

Managing Indexes

  • Identifying Index Fragmentation
  • Repairing Index Fragmentation

Monitoring SQL Server Instances

  • Creating and Managing Operators
  • Creating and Managing SQL Agent Alerts
  • Configuring Database Mail
  • Receiving Email Notifications on Job Execution

Automating SQL Server Management

  • Explain the methods for automating SQL Server Management
  • Creating SQL Server Agent Jobs
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Scheduling and Automating SQL Server Jobs
  • Multi-server Management
  • Configure a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers

Configuring Security for SQL Server Agent

  • Explain SQL Server Agent security
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job

Monitoring SQL Server with Alerts and Notifications

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications

Overview of Managing SQL Server by using PowerShell

  • PowerShell to Manage SQL Server
  • Getting Started with PowerShell
  • Using PowerShell to Change SQL Server settings
  • Describe the benefits of PowerShell and its fundamental concepts
  • Configure SQL Server by using PowerShell
  • Administer and maintain SQL Server by using PowerShell
  • Manage an Azure SQL Database by using PowerShell

Tracing Access to SQL Server with Extended events

  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events

Monitoring SQL Server

  • Monitor current activity
  • Capture and manage performance data
  • Analyze collected performance data
  • Configure SQL Server Utility

Troubleshooting SQL Server

  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue

Importing and Exporting Data

  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application

Exam 70-765 : Provisioning SQL Databases

Opitimizing and Enchancing the Performance

  • SQL Server Profiler
  • Database Engine Tuning Advisor
  • Trace Files

Components of SQL Server 2016

  • Introduction
  • Architecture
  • Services
  • Tools

Installation of SQL Server 2016

  • Installing
  • Configuring
  • Storage
  • Authentication Modes
  • Configuring TempDB

Managing Instances

  • Default
  • Named

Managing Databases

  • Creating Databases
  • Managing Files and Filegroups
  • Creating Secondary Files
  • Adding Files and Filegroups

Microsoft Azure

  • Introduction
  • Creating Databases
  • Migrating

High Availability, Disaster Recovery, and Always-On

  • Configuring and Managing Database Mirroring
  • Configuring and Managing Transaction Log Shipping
  • Configuring and Managing Replication
  • Configuring and Managing Failover Clustering

What Our Customers says

MCSA: SQL Server 2016 Database Administration Package Offer: Great Savings!!!

Giveaway Price
£2000 +VAT
Silver Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • Total Price £2400
  • Offer Price £2000
  • Savings £400
Giveaway Price
£4000 +VAT
Diamond Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • MCSA MS SQL 2012 Data Platform £1200
  • Total Price £4800
  • Offer Price £4000
  • Savings £800
Giveaway Price
£3000 +VAT
Gold Package
  • Package Includes
  • MCSA: SQL 2016 Database Administration £1200
  • MCSA: SQL 2016 Database Development £1200
  • MCSA SQL 2016 BI Development £1200
  • Total Price £3600
  • Offer Price £3000
  • Savings £600

Time Table and Pricing

This is an On-Demand course. Please call us on 0207 256 7722 to arrange the training as per your requirement.

Training Facilities

Training And Certification

Why Choose London Training ?

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Expert and Certified Trainers
  • Price includes Tuition Fee, Classroom Training and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects