MCSA: SQL Server 2016 Database Administration

London Training Group LTD
4.8
9 reviews
  • Fast is an excellent teacher and he explained everything so well and in detail which helped me in passing the exam.
    ← | →
  • Saif and Kash are so supportive and highly qualified. They made learning so enjoyable.
    ← | →
  • Sana and Kash both are amazing trainers. Sana is so experienced. They are always present for the help I need. They explain things nicely and make it easy to follow. I would highly recommend it to the people.
    ← | →

Course

In City of London

£ 1,200 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Intensive workshop

  • Level

    Intermediate

  • Location

    City of london

  • Class hours

    32h

  • Duration

    4 Days

  • Start date

    Different dates available

"Virtual LIVE" training is available

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.

Facilities

Location

Start date

City of London (London)
See map
4th Floor Bowman House,29 Wilson Street, EC2M 2SJ

Start date

Different dates availableEnrolment now open

About this course

Synopsis
Fast Track (4 Days) – Mon to Thurs (10:00-18:00)
Weekend Track (7 Weeks) – Every Saturday (15:00–19:00)
Course Fee: £1200 + VAT
Industry Expert and Certified Instructors
Training Venue: Central London Location
Tutor Led Classroom Training

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.

Basic computer knowledge

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

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

Our experts will contact you to speak about the MCSA: SQL Server 2016 Database Administration training in London.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.8
excellent
  • Fast is an excellent teacher and he explained everything so well and in detail which helped me in passing the exam.
    ← | →
  • Saif and Kash are so supportive and highly qualified. They made learning so enjoyable.
    ← | →
  • Sana and Kash both are amazing trainers. Sana is so experienced. They are always present for the help I need. They explain things nicely and make it easy to follow. I would highly recommend it to the people.
    ← | →
100%
4.7
excellent

Course rating

Recommended

Centre rating

Shaik

5.0
29/11/2019
About the course: Fast is an excellent teacher and he explained everything so well and in detail which helped me in passing the exam.
Would you recommend this course?: Yes

Samantha

5.0
29/11/2019
About the course: Saif and Kash are so supportive and highly qualified. They made learning so enjoyable.
Would you recommend this course?: Yes

Kalocsai Zoltan

5.0
28/11/2019
About the course: Sana and Kash both are amazing trainers. Sana is so experienced. They are always present for the help I need. They explain things nicely and make it easy to follow. I would highly recommend it to the people.
Would you recommend this course?: Yes

SB

5.0
28/11/2019
About the course: It is a great place for such exceptional teaching.
Would you recommend this course?: Yes

Gavin Gong

5.0
27/11/2019
About the course: Kash, my trainer was amazing and offer his support throughout my course which is a great help for any DBA.
Would you recommend this course?: Yes

Adisu Genbez

4.5
27/11/2019
About the course: The London training group is excellent and all the people have been so supportive to me. The instructor was so knowledgeable and the services like free WiFi, refreshment was good.
Would you recommend this course?: Yes

Cecil

4.5
27/11/2019
About the course: My tutors are so polite and supportive. They are always so friendly in guiding me from the start. I have enjoyed my course.
Would you recommend this course?: Yes

Merick

5.0
27/11/2019
About the course: My experience has been amazing while learning the SQL databases course. My tutors were great and so supportive.
Would you recommend this course?: Yes

Kate

4.5
20/05/2017
What I would highlight: Good examples and explanations of topics, teaches at good pace and easy to follow.
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • Access
  • Transactions
  • Server
  • Database
  • Database training
  • Technology
  • Design
  • MCSA
  • MCSA training
  • Microsoft Database Engineer
  • Microsoft SQL DBA
  • DatMicrosoftabase Administrator
  • Microsoft Database Consultant
  • Freelancer Microsoft SQL DBA
  • Microsoft Database Designer

Teachers and trainers (1)

Teaching Staff

Teaching Staff

Teachers

Course programme

Course SyllabusMCSA 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

Additional information

*Installment option available


0% interest available .Pay Monthly.Interest Free Installments Upto 1 Year.

Duration

Fast Track (1 Week) – Mon to Thu (10:00-18:00) 
Weekend Track (7 Weeks) – Every Saturday (15:00–19:00)

See related categories

MCSA: SQL Server 2016 Database Administration

£ 1,200 + VAT

The best SQL Server courses

See all

See all