Provisioning Microsoft SQL Databases (mentor)
- Overview: Provisioning SQL Databases - Overview
- Overview: SQL Server Components
- Lesson 1: Introduction to the SQL Server Platform
- Lesson 2: Overview of SQL Server Architecture
- Lesson 3: SQL Server Services and Configuration Options
- Overview: Installing SQL Server
- Lesson 1: Considerations for Installing SQL Server
- Lesson 2: tempdb Files
- Lesson 3: Installing SQL Server
- Lesson 4: Automating Installation
- 20765c-module02-lab
- Overview: Upgrading SQL Server to SQL Server 2017
- Lesson 1: Upgrade Requirements
- Lesson 2: Upgrade of SQL Server Services
- Lesson 3: Side-by-Side Upgrade: Migrating SQL Server Data and Applications
- Lab 3: Upgrading SQL Server
- Overview: Working with Databases
- Lesson 1: Introduction to Data Storage with SQL Server
- Lesson 2: Managing Storage for System Databases
- Lesson 3: Managing Storage for User Databases
- Lesson 4: Moving and Copying Database Files
- Lesson 5: Configuring the Buffer Pool Extension
- Lab 4: Managing Database Storage
- Overview: Performing Database Maintenance
- Lesson 1: Ensuring Database Integrity
- Lesson 2: Maintaining Indexes
- Lesson 3: Automating Routine Maintenance Tasks
- Lab 5: Performing Ongoing Database Maintenance
- Overview: Database Storage Options
- Lesson 1: SQL Server Storage Performance
- Lesson 2: SMB Fileshare
- Lesson 3: SQL Server Storage in Microsoft Azure
- Lesson 4: Stretch Database
- Lab 6: Implementing Stretch Database
- Overview: Planning to Deploy SQL Server on Microsoft Azure
- Lesson 1: SQL Server on Virtual Machines and Azure SQL Database
- Lesson 2: Azure Storage
- Lesson 3: Azure SQL Server Authentication
- Lesson 4: Deploying Databases in Azure SQL Database
- Lab 7: Plan and Deploy an Azure SQL Database
- Overview: Migrating Databases to Azure SQL Database
- Lesson 1: Database Migration Testing Tools
- Lesson 2: Database Migration Compatibility Issues
- Lesson 3: Migrating an On-Premises Database to an Azure SQL Database
- Lab 8: Migrating SQL Server with Azure
- Overview: Deploying SQL Server on a Microsoft Azure Virtual Machine
- Lesson 1: Deploying SQL Server on Azure Virtual Machines
- Lesson 2: Migrating a Database to a Microsoft Azure Virtual Machine
- Lab 9: Deploying SQL Server on an Azure Virtual Machine
- Overview: Managing Databases in the Cloud
- Lesson 1: Managing Security in Azure SQL Database
- Lesson 2: Configuring Azure Storage
- Lesson 3: Azure Automation
- Lab 10: Managing Databases in the Cloud
Az oktatóról
Fő tématerülete az Adatbáziskezelés az MS Access-től az MS SQL Serveren át az üzleti intelligencia (BI) rendszerekig. Microsoft oktató (MCT) és szakértő (MCSE). Fő hitvallása, hogy nem elég egy témát oktatni, ki is kell a való életben próbálni. Mivel az oktatás és a szoftverfejlesztés nagyon jó szimbiózist alkot, ezért számos MS Access és SQL Server alapú szoftvere működik különféle cégeknél 2021-ben is.