FLEXI - SELF PACED TRAINING RE-IMAGINED

Do you Need Live Online Training? Do you not have Time for Live Online? Do you Want to Start Immediately? Koenig's Flexi can help You.

Flexi is a Video Recording of Live Online + Official Courseware + Hands-On-Labs + Qubits Test

Flexi is a Unique Union of Live Online and On-Demand Learning Options.
Live Online
+
On Demand
=
Flexi

Administering a SQL Database Infrastructure

Includes 270+ Tests Questions (Qubits42)
Module 1: SQL Server Security
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases
  • 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
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers
  • 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 SOL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SOL Database
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications
  • Getting Started with Windows PowerShell
  • Configure SOL Server using PowerShell
  • Administer and Maintain SOL Server with PowerShell
  • Managing Azure SOL Databases using PowerShell
  • Getting Started with PowerShell
  • Using PowerShell to Change SOL Server settings
  • Extended Events Core Concepts
  • Working with Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
  • 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
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
  • 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

We do not have a fresh Live Online Recording for the course. It can take 4-5 days to edit a recording. If your need is urgent, request for an un-edited version.


Flexi Video

USD 99

Official Courseware

USD 49

Hands-On-Labs

USD 59

Total

USD 99

100% Secure Transaction

Learn more about Koenig. Download Presentation

FAQ's

Q1. How long do you have access to Flexi after purchase?

A. 3 months from date of delivery.

Q2. Can the content be shared or is it only available for one user?

A. It is only for the self-use of the purchaser.

Q3. Do you have business packages that you offer to companies that would make use of these packages on a regular basis?

A. Yes, contact us for corporate packages.

Q4. What is the pass rate of students that used Flexi as their method of preparation?

A. We do not track the pass rate of Flexi students. We, however suspect that it will be lower than for Live Online.

Q5. If we buy Flexi today, and there are any updates in the course, do we get the updated recordings as well or do we need to repurchase Flexi?

A. If the latest update comes within 3 months after the sale we can give the updated version.

Q6. Can we download the videos or we stream them online?

A. Videos can only be streamed and not downloaded.

Q7. Do you have courses in languages other than English?

A. Presently Flexi is only available in English.

Feedbacks from Clients