Microsoft SQL Server 2016
Overview
Microsoft SQL Server 2016
Teams will learn to build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in-from in-memory performance and advances security to in-database analytics.
Study time: Full time – 4 days| Part time – 2 weeks
Vendor: Microsoft
Business support: Our customer success team measures and ensures engagement
Prerequisites: Developers with two+ years experience and good working knowledge of relational databases
Assessment: Exam based – MCSA 70-761, 70-762, 70-764, 70-765
Ideal for: Database developer, database analyst ETL and data warehouse developers
Meet the Trainer
Aaron Sampson is a seasoned and experienced IT professional who started in the industry in 1995. Aaron has been involved with extensive practical implementations in a variety of technical and operational capacities. Most of his experience has been in environments using Windows/Active Directory systems, SQL databases, and Exchange messaging environments. He holds multiple certifications as a Microsoft Certified Professional and pursues upgrades, new versions, and new technologies.
“Data is growing at a rapid pace. By 2020 the new information generated per second for every human being will approximate amount to 1.7 megabytes.”
Content overview
70-761, 70-762: MCSA SQL Server 2016 Database Development
- T-SQL Querying
- Querying and Manipulating Data
- Filter and Modify Data in SQL Server 2016
- Using Functions in SQL Server 2016
- Aggregating Data in SQL Server 2016
- Subqueries and Predicate
- Operators and Expressions in SQL Server 2016
- Database Programmability Objects and Non-Relational Data
- SQL Server 2016 Database Objects
- SQL Server 2016 Indexes and Views
- Colu0mnstore Indexes
- Programmability Objects
- Triggers and Functions
- Transactions and Isolation Levels
- Managing Database Concurrency
- Optimize SQL Database Objects and Infrastructure
- Database Instances
- Performance Tuning
70-764, 70-765: MCSA SQL Server 2016 Database Administration
- Microsoft SQL Server 2016: Encryption
- Microsoft SQL Server 2016: Data Access and Permissions
- Microsoft SQL Server 2016: Auditing
- Microsoft SQL Server 2016: Backing Up Databases
- Microsoft SQL Server 2016: Restoring Databases
- Microsoft SQL Server 2016: Managing Database Integrity
- Microsoft SQL Server 2016: Monitoring Database Activity and Queries
- Microsoft SQL Server 2016: Monitoring SQL Server Instances
- Microsoft SQL Server 2016: Managing Indexes and Statistics
- Microsoft SQL Server 2016: High Availability and Disaster Recovery
- Components of a SQL Server 2016 Installation
- Installing and Upgrading SQL Server 2016
- SQL Server Virtual Machines on Azure
- SQL Server Instances and Storage Considerations
- Microsoft Azure SQL Database Security
- Azure SQL Database Encryption
- SQL Server Performance Settings
- Deploying Applications to Microsoft Azure SQL Databases
- Azure Virtual Machines
Our Promise
Trusted by…
