MCSA: SQL 2016 Database Administration
Deal of the Month: 20% Discount on this Course. Limited Availability.
Training Square
Summary
Finance Available @ 0% Interest, Spread The Cost of Your Training Across 12 Months.
- Exam(s) / assessment(s) not included in price, and must be purchased separately
- Tutor is available to students
Location & dates
Overview
Training Square is the UK’s only digital media learning and development provider. we are a MICROSOFT Authorized Training Center with Industry Certified Expert Trainers.
MCSA SQL Server 2016 Database (Administration)Training Include's: Classroom-based, Tutor Led, hands-on training giving you real-life experience, Lab Exercises, Project work, Unlimited Lab Access, Books, Materials, Course Completion Certificate, Free Re-training, and free refreshment.
Training Options: (Flexible Time & Start Dates)
- Fast Track
- Weekend Track
- Evening Track
Detail 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
- (This Topic covers many sub-topics)
Server Roles and Database Roles
- (This Topic covers many sub-topics)
Authorizing Users to Access Resources
- (This Topic covers many sub-topics)
Protecting Data with Encryption and Auditing
- (This Topic covers many sub-topics)
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 Databases
- 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
- (This Topic covers many sub-topics)
Configuring Security for SQL Server Agent
- (This Topic covers many sub-topics)
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
- (This Topic covers many sub-topics)
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
- (This Topic covers many sub-topics)
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
Certification
Microsoft Certified Solutions Associate (MCSA) SQL Server
Course media
Description
Get trained in Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2016 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.
MCSA SQL Server 2016 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2016 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.
Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2016 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.
SQL Server 2016 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2016 also provides higher productivity for DBAs, System Admins, and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large-scale data warehousing capabilities, make SQL Server 2016 stands out in the market.
-----------------------------------------------------------------------------------
Finance Available:
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
----------------------------------------------------------------------------------
Who is this course for?
Whether you are a novice in database technology or a basic user, we have a well structured classroom-based, hands-on, tutor-led training on SQL courses in London, delivered by our expert, certified and industry experienced trainers.
We would like to warmly welcome you to our SQL server 2016 course where you would be well equipped with SQL Server industrial skills and eventually be fully prepared for MCSA SQL 2016 Certification.
Requirements
Basic knowledge of Database / Web Design
Career path
Plan a career in a technical Database field as SQL Server Database Administrator (DBA), SQL Server Developer, SQL Server Business Intelligence (BI) Developer.
Enhance your skills by joining our Career packages.
Professional Package > £4200 Save £550 [Package Includes: MCSA SQL Server +Oracle 11g OCP]
* Call us to find out more about career packages.
Join us Now 100% satisfaction guarantee.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.