SQL Server 2016 course: Administration and configuration

CURS-519

Learn how to configure, manage, and audit your databases with SQL Server 2016.

Description


Learn how to configure, manage, and audit your databases with SQL Server 2016. Secure the contents of the database on your servers from the point of view of the users that connect, learn how to manage what data can see and which not thanks to the granularity of SQL, also knows how to prevent disasters and automate processes with your bases D and data. Learn ways to monitor your SQL Server systems and keep abreast of everything that's going on with your databases.

Authentication and roles in SQL Server 2016

    Authentication in SQL Server 2016 02:54
    Enable SQL Server 00:44 mixed-mode authentication
    Manage logon to SQL Server 2016 06:12
    Manage database Users SQL Server 2016 03:14
    Server Roles in SQL server 02:31
    Manage SQL server 02:24 permissions and server roles
    SQL Server database Roles 2016 02:03
    Creating a 01:26 Working database
    Manage permissions and roles in database 02:51

Authorize users access to resources

    Authorizes/denies user access in SQL Server 01:43
    Manage access to SQL Server 02:11 objects
    Row Level Security in SQL Server 03:35

Disaster recovery Plan in SQL Server 2016

    What is a disaster recovery Plan in SQL Server 02:33
    Making different backups in SQL Server 03:12
    Information about our 01:17 backups
    The restore process in SQL Server 02:46
    Restore Backup Process 01:33

SQL Server 2016 encryption

    Transparent Data Encryption in SQL Server 01:31
    Encrypting a database in SQL Server with TDE 02:06
    Dynamic Data masking in SQL Server 03:15

Automate SQL Server Management

    Introduction to Automation in SQL Server 03:44
    SQL Agent 01:20
    Performing jobs with SQL Agent 02:38

Monitoring Alerts and Notifications

    Monitoring SQL Server 02:37 errors
    Set up email 03:04

Audit with triggers, temporary tables and others

    Audit with triggers in SQL Server 01:43
    Working with triggers in database 05:32
    Entering temporary tables in SQL Server 03:12
    Introduction to Extended events in SQL Server 01:56
    SQL Profiler in SQL Server 2016 02:48
    Extended events in SQL Server 2016 04:57

Technical data:

    Format:. MP4
    Resolution: 1280x720p
    Size: 178 MB
    Language: Spanish
    Content: 31 Videos
    Duration: 1:23 hours
    Software: SQL Server, SQL Server 2016
    Base files: If included

See catches


Totally virus free and malicious software, so don't wait any longer on Descargartelo now.

Don't forget to give us an opinion about the course, to improve the content.

Download area


 

Follow us on our social networks


Note: Do not forget to follow us on our social networks of Facebook and Twitter to form part of our community and receive the notification every time we publish something new, so you will not miss anything.

License Freeware
Language Only Spanish
File Size 157 MB
Developer Curso
Grade 
06/27/2018

Excelente

Gran curso

Write your review!

Write a review

SQL Server 2016 course: Administration and configuration

SQL Server 2016 course: Administration and configuration

Learn how to configure, manage, and audit your databases with SQL Server 2016.

Ask a question

NO registration required!

If the question you have has not yet been answered here, use the form below to ask something about this addon.

(optional)
*(Required to be notified when an answer is available)

If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form

RelatedProducts