Cena tečaja * 1.550,00 €
Obseg v dneh 5
Število ur 50

Trenutno nimamo razpisanih terminov za ta tečaj. Prijavite se na seznam interesentov in obvestili vas bomo o prvem možnem terminu.
Prijavite se na seznam interesentov

* Cena je brez DDV

Kombo Querying Microsoft SQL Server in Administering Microsoft SQL Server Databases K461-462

About this course

5 days, combined MOC #20461, MOC #20462, and custom presentations.

Custom Module 1: Introducing SQL Server 2016 Temporal Tables

With Always Encrypted SQL Server 2016 finally enables full data encryption, so that no tools or persons regardless their database and server permissions can read encrypted data except the client application with an appropriate key. Row-level security on the other side restricts which data in a table can be seen by specific user. This is very useful in multi-tenant environments where you usually want to avoid data-reading intersection between different customers. Dynamic data masking is a soft feature that limits sensitive data exposure by masking it to non-privileged users.

This module will cover the following points:

  • Data encryption
  • Row-level security
  • Dynamic data masking

Custom Module 2: SQL Server 2016 Security Enhancements

Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for a limited time only. It can be valid from a specific point in time onward, or it can be valid for a specific time interval—from a starting time point to an ending time point. In addition, many times you need to audit all changes in one or more tables. You might also need to be able to show the state in a specific point in time, or all changes made to a table in a specific period of time. From the data integrity perspective, you might need to implement many additional temporal specific constraints.

This module introduces the temporal problems, deals with manual solutions, and shows out-of-the-box solution in SQL Server 2016, including:

  • Defining temporal data
  • Using temporal data in SQL Server before version 2016
  • System versioned tables in SQL Server 2016
  • What kind of temporal support is still missing in SQL Server 2016
  • MOC #20461 Module 1: Introduction to Microsoft SQL Server 2014
  • MOC #20461 Module 2: Introduction to T-SQL Querying
  • MOC #20462 Module 1: Introduction to SQL Server 2014 Database Administration
  • MOC #20462 Module 2: Installing and Configuring SQL Server 2014
  • MOC #20462 Module 3: Working with Databases and Storage
  • MOC #20461 Module 3: Writing SELECT Queries
  • MOC #20461 Module 4: Querying Multiple Tables
  • MOC #20461 Module 5: Sorting and Filtering Data
  • MOC #20461 Module 6: Working with SQL Server 2014 Data Types
  • MOC #20461 Module 7: Using DML to Modify Data
  • MOC #20462 Module 4: Planning and Implementing a Backup Strategy
  • MOC #20462 Module 5: Restoring SQL Server 2014 Databases
  • MOC #20461 Module 8: Using Built-In Functions
  • MOC #20461 Module 9: Grouping and Aggregating Data
  • MOC #20461 Module 10: Using Subqueries
  • MOC #20461 Module 11: Using Table Expressions
  • MOC #20461 Module 12: Using Set Operators
  • MOC #20461 Module 13: Using Window Ranking, Offset, and Aggregate Functions
  • MOC #20461 Module 14: Pivoting and Grouping Sets
  • MOC #20462 Module 6: Importing and Exporting Data
  • MOC #20462 Module 7: Monitoring SQL Server 2014
  • MOC #20462 Module 8: Tracing SQL Server Activity
  • MOC #20461 Module 15: Executing Stored Procedures
  • MOC #20461 Module 16: Programming with T-SQL
  • MOC #20461 Module 17: Implementing Error Handling
  • MOC #20461 Module 18: Implementing Transactions
  • MOC #20461 Module 19: Improving Query Performance
  • MOC #20461 Module 20: Querying SQL Server Metadata Custom Module 1: Introducing SQL Server 2016 Temporal Tables
  • MOC #20462 Module 9: Managing SQL Server Security
  • MOC #20462 Module 10: Auditing Data Access and Encrypting Data
  • Custom Module 2: SQL Server 2016 Security Enhancements
  • MOC #20462 Module 11: Performing Ongoing Database Maintenance
  • MOC #20462 Module 12: Automating SQL Server 2014 Management
  • MOC #20462 Module 13: Monitoring SQL Server 2014 with Notifications and Alerts