Course Information
Website Name: Horizons Unlimited
Course Name: Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Online Course
Certification Focus: Microsoft Exam 70-765 – Provisioning SQL Databases
Total Video Hours: 22 Hours 58 Minutes
Total Videos: 102
Skill Level: Intermediate to Advanced
Delivery Mode: Online, On-Demand
Technology Coverage:
Microsoft SQL Server 2016
Microsoft Azure SQL Database
Azure Virtual Machines
SQL Server on IaaS and On-Premises
Target Audience:
Database Administrators
SQL Server Professionals
Cloud Architects
Senior Developers
Infrastructure Specialists
Technical Leads preparing for SQL Server certification
Prerequisites:
Working knowledge of SQL Server fundamentals
Familiarity with database concepts and T-SQL
Basic understanding of Microsoft Azure and virtualization
Included in This Course
22+ hours of structured SQL Server training
102 expert-led instructional videos
Azure SQL Database and SQL Server 2016 labs
Real-world provisioning and deployment scenarios
Performance tuning and storage optimization guidance
Security configuration and encryption demonstrations
Hybrid cloud and on-premises deployment strategies
Microsoft 70-765 exam-aligned content
On-demand access through Horizons Unlimited
Course Outline
Module 1: Deploy a Microsoft Azure SQL Database
Module 2: Plan for SQL Server Installation
Module 3: Deploy SQL Server Instances
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
Module 5: Configure Secure Access to Microsoft Azure SQL Databases
Module 6: Configure SQL Server Performance Settings
Module 7: Manage SQL Server Instances
Module 8: Manage SQL Storage
Module 9: Perform Database Maintenance
Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Online Course
Course Scope and Professional Relevance
Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Online Course addresses the operational and architectural challenges faced by modern database administrators. Organizations increasingly rely on hybrid infrastructures that combine on-premises SQL Server deployments with Microsoft Azure services. This course delivers structured guidance on provisioning SQL databases efficiently while maintaining performance, availability, and security.
The training reflects enterprise expectations for SQL Server professionals who must design, deploy, migrate, and manage databases across multiple environments. Emphasis is placed on repeatable deployment methods, performance benchmarking, automation, and long-term database maintenance.
Azure SQL Database Deployment and Configuration
Provisioning databases in Microsoft Azure forms a foundational component of the Microsoft 70-765 exam objectives. This course provides in-depth coverage of Azure SQL Database architecture, service tiers, and elastic pools. Learners gain practical exposure to selecting appropriate service tiers based on workload requirements and cost considerations.
The course explains how to create Azure SQL servers, configure authentication, establish administrative access, and connect SQL Server Management Studio (SSMS) to Azure-hosted databases. Elastic pool configuration is addressed as a scalable solution for managing multiple databases with variable resource demands, ensuring optimal cost control and performance stability.
Planning SQL Server Installations for Hybrid Environments
Effective SQL Server provisioning begins with proper planning. This SQL Server online course dedicates focused instruction to evaluating infrastructure requirements for both on-premises and IaaS-based deployments. Learners examine deployment models, storage performance considerations, and virtual machine sizing strategies aligned with workload demands.
Storage pool planning is explored in detail, emphasizing throughput, latency, and IOPS requirements. Best practices for SQL Server installation ensure that database environments are designed for reliability, scalability, and maintainability from the outset.
SQL Server Instance Deployment and Automation
Deploying SQL Server instances across Azure and on-premises environments requires consistency and automation. This course provides structured instruction on provisioning SQL Server instances using manual methods and automated deployment techniques. Azure Virtual Machines are configured specifically to host SQL Server workloads, ensuring compatibility and performance optimization.
Automation topics include scripting deployments, using templates, and managing JSON-based configurations. These skills support enterprise-scale deployments where repeatability and standardization are essential. Learners gain practical experience restoring databases and configuring SQL Server instances in real-world scenarios.
Migrating and Managing SQL Databases on Azure Virtual Machines
Database migration remains a critical responsibility for SQL Server professionals. This course explains proven methods for migrating on-premises SQL Server databases to Azure Virtual Machines while minimizing downtime and performance risk. Benchmarking techniques are introduced to assess performance requirements before and after migration.
Performance tuning in Azure IaaS environments is addressed with practical guidance on monitoring resource utilization, adjusting configurations, and validating performance improvements. High availability strategies, including availability sets, are explained in detail to ensure business continuity and fault tolerance.
Security Configuration for Azure SQL Databases
Securing SQL Server databases is a core objective of the Microsoft 70-765 certification. This course delivers comprehensive instruction on configuring secure access to Azure SQL Databases. Firewall rules are implemented to control network access, while encryption technologies are applied to protect sensitive data.
Always Encrypted, cell-level encryption, dynamic data masking, and transparent data encryption (TDE) are covered with practical labs. These security features support regulatory compliance and data protection requirements in enterprise environments.
SQL Server Performance Configuration and Monitoring
Performance tuning remains a continuous process in SQL Server administration. This training focuses on configuring server-level and database-level performance settings to align with workload demands. Memory management, including max server memory configuration, is explained to prevent resource contention and instability.
Operators, alerts, and monitoring configurations ensure proactive identification of performance issues. The course integrates Azure-based monitoring with traditional on-premises tools, supporting hybrid database environments.
SQL Server Instance and Database Management
Managing SQL Server instances involves ongoing administrative tasks that directly impact stability and performance. This course addresses database creation, file and filegroup management, and system database configuration. Special attention is given to tempdb configuration, a critical component for performance optimization.
Learners gain practical experience managing SQL Server components in a controlled lab environment, reinforcing best practices applicable to production systems.
SQL Storage Management and Optimization
Storage management is central to SQL Server provisioning and maintenance. This SQL Server training covers SMB file shares, stretch databases, Azure storage configuration, and service tier adjustments. Wait statistics analysis provides insight into performance bottlenecks related to storage subsystems.
The course explains how to manage storage pools, recover from storage failures, and maintain data availability during infrastructure changes. These skills are essential for supporting high-performance database workloads.
Database Maintenance and Recovery Strategies
Long-term database reliability depends on effective maintenance strategies. This course provides structured instruction on monitoring tools, automated maintenance tasks, index and statistics management, and database integrity verification.
Recovery techniques for database corruption are demonstrated through practical labs, ensuring learners can respond effectively to critical incidents. These maintenance practices align with enterprise operational standards and certification objectives.
Certification Preparation and Career Value
Although Microsoft Exam 70-765 is a legacy certification, the skills developed through this course remain highly relevant. SQL Server 2016 and Azure-based database provisioning continue to support many production environments. The training equips professionals with transferable skills applicable to modern SQL Server and Azure platforms.
Horizons Unlimited delivers this Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Online Course as a structured pathway for building confidence in database provisioning, deployment automation, security configuration, and performance optimization.
Frequently Asked Questions (FAQ)
Who should take the Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Online Course?
This course is intended for database administrators, SQL Server professionals, cloud architects, and technical leads responsible for provisioning and managing SQL Server databases.
Does this course align with the Microsoft 70-765 exam objectives?
Yes. The training follows the official Microsoft 70-765 exam structure and focuses on provisioning SQL databases in Azure and on-premises environments.
Is prior SQL Server experience required?
Working knowledge of SQL Server fundamentals and basic Azure concepts is recommended for effective understanding.
Does the course include hands-on labs?
Yes. The course includes multiple labs covering Azure SQL Database deployment, SQL Server installation, migration, security, and performance tuning.
Is this course relevant for current SQL Server roles?
Yes. The provisioning, security, performance, and maintenance skills remain applicable to modern SQL Server and Azure database environments.
How long is the course?
The course includes 22 hours and 58 minutes of video content across 102 instructional videos.
.jpg)
