Course not currently available
MCSA: SQL Server 2016 - Database Administration
-
The course was fantastic and I have enjoyed there a lot. Training Square is a great and so professional company and I have had the time of my life there.
← | →
-
Lately I completed SQL 2016 Database development course and everything about the course was superb and I enjoyed being a part of training. Saif is an excellent trainer and I enjoyed learning from him every aspect of the training helped me a lot in enhancing my skill set. I had a nice time overall, thanks!
← | →
-
Trainer was knowledgeable and delivered in good pace.
← | →
Course
In City Of London ()
Gain the essential skills needed in all aspects of the Microsoft's premier database system!
-
Type
Course
-
Level
Intermediate
-
Duration
4 Weeks
Are you ready to go one step beyond in Microsoft? With the MCSA (Microsoft Certified Solutions Associate) certification – SQL Server 2016 offered by Emagister, you will enhance your abilities in database aspects of the Microsoft systems.
If you’re looking to boost your career, the MCSA SQUL Server 2016 is will allow you to improve your technical skills in order to build a sustainable work, in which you can surprise your clients with innovative solutions using multiple technologies. You’ll become an expert in database!
As you may be aware of, Microsoft SQL Server is nowadays the most reliable platform when it comes to manage databases, so with this certification you’ll be ready to expand your employability in the IT sob market.
This platform is such a complete platform that can execute one million commands in a second, its fastness and accuracy is the best solution for every client’s needs, and also, it’s prepared to avoid mission critical outages and loss of information.
The MCSA: SQL Server 2016 - Database Administration is applicable to everyone! Novice or advanced, this course will prepare you to help you become and expert!
If you want to learn more about this programme please contact Training Square through Emagister.co.uk
About this course
Novice/Mediocre/Expert.
Computer Illiterate.
Diploma/Corporate Training/Hands-On Practical Training/Exam Preparation.
Expert, Industry Experienced and Certified Trainers.
State of the Art Facilities.
Maximum 5-6 Delegates Per Class. Quality that matters.
100% Practical Hands-on Training, Classroom Based and Instructor Led.
Flexible Starting Dates: Weekdays, Weekends and Evenings
Location: Central London.
Our Course Advicer will contact him/her and explain further about the Course.
Reviews
-
The course was fantastic and I have enjoyed there a lot. Training Square is a great and so professional company and I have had the time of my life there.
← | →
-
Lately I completed SQL 2016 Database development course and everything about the course was superb and I enjoyed being a part of training. Saif is an excellent trainer and I enjoyed learning from him every aspect of the training helped me a lot in enhancing my skill set. I had a nice time overall, thanks!
← | →
-
Trainer was knowledgeable and delivered in good pace.
← | →
Course rating
Recommended
Centre rating
Tom
Google Reviewer
Tim
Edwin Jackson
This centre's achievements
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 10 years
Subjects
- Monitoring
- Access
- Market
- Audit
- Server
- Database
- SQL
- Database Administration
- Database training
- MCSA training
- MCSA
- Import
- SQL Database
- Industry
Teachers and trainers (1)
Teaching Staff
Teacher
Course programme
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
- Overview of SQL Azure
- Features of SQL Azure.
- Provision a SQL Azure server and configure its security.
- T-SQL Scripts, Sets, Predicate Logic
- Logical Order of Operations in SELECT statements
- SELECT Statements, filter data, sort data using ORDER BY
- SELECT statement, focusing on queries against a single table.
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- CASE Expressions, DISTINCT clause
- 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
- 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 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
- 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
- Understanding Backup Strategies
- SQL Server Transaction Logs
- Planning Backup Strategies
- Plan a Backup Strategy
- Configure Database Recovery Models
- 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
- 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 Current Sessions
- Configuring the Data Collector
- Extended Events
- Trace Events
- Identifying Index Fragmentation
- Repairing Index Fragmentation
- Creating and Managing Operators
- Creating and Managing SQL Agent Alerts
- Configuring Database Mail
- Receiving Email Notifications on Job Execution
- 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
- 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 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
- 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
- Using the System_Health Extended Events Session
- Tracking Page Splits Using Extended Events
- Monitor current activity
- Capture and manage performance data
- Analyze collected performance data
- Configure SQL Server Utility
- 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
- 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
Opitimizing and Enchancing the Performance
- SQL Server Profiler
- Database Engine Tuning Advisor
- Trace Files
- Introduction
- Architecture
- Services
- Tools
- Installing
- Configuring
- Storage
- Authentication Modes
- Configuring TempDB
- Default
- Named
- Creating Databases
- Managing Files and Filegroups
- Creating Secondary Files
- Adding Files and Filegroups
- Introduction
- Creating Databases
- Migrating
- Configuring and Managing Database Mirroring
- Configuring and Managing Transaction Log Shipping
- Configuring and Managing Replication
- Configuring and Managing Failover Clustering
Additional information
Discounted Price
£1350.00 (Actual Price £1450.00)
Or Choose from one of the following Finance Options @ 0% interest:
3 months - £145 Upfront and monthly payments of £435.00
6 months - £145 Upfront and monthly payments of £217.00
12 months - £145 Upfront and monthly payments of £108.00
Duration
4 Weeks or Fast Track 4 Days
MCSA: SQL Server 2016 - Database Administration