The Ultimate Microsoft SQL Server Course All In One

Explore cloud computing basics and Microsoft Azure SQL, and learn the five defining characteristics—provider management, resource flexibility, network accessibility, sustainability, and on-demand self-service management.

Explore virtualization fundamentals that power cloud computing and Azure SQL provisioning, showing how virtual hard disks and hypervisors enable multi tenancy, VM mobility, and hardware efficiency.

Discover how cloud-based applications implement distributed application design with front end, web, and database components. Leverage scalable virtual machines, APIs, and industry-wide standards to interconnect services across providers.

Aria, for resource management automation, shows how cloud computing automatically adds disk space, processing power, and memory to meet service levels, reducing hardware costs by charging for actual demand.

Explore how cloud computing cuts IT costs with elastic scaling and global redundancy for SQL Server. Understand how Windows Azure supports pay-as-you-go services and data that cloud administrators cannot access.

Explore cloud deployment modes: private, public, hybrid, and community. Examine the three service models and governance under Nest standards.

Explore the three standard cloud service models—IaaS, PaaS, and SaaS—and how admins, developers, and users use them, explained through a pyramid diagram and real-world app mapping.

Explore infrastructure as a service, where cloud providers supply on-demand hardware, virtual machines, storage, and networking, handle maintenance and resiliency, and you pay for what you use.

Learn platform as a service (paas) as a cloud model that provides a complete development and deployment platform, covering infrastructure, middleware, licensing, and tools to develop, test, and manage applications.

Explore how software as a service delivers cloud-based applications over the internet, with examples like Gmail and Office 365, and how cloud providers enable pay-as-you-go, scalable IaaS and PaaS foundations.

Understand how cloud technologies reshape IT roles and user needs. Compare providers, manage costs, ensure service levels, and plan interoperability for reliable, user-friendly cloud deployments.

Explore how cloud computing reshapes the standard data operation model, shifting security, governance, and skill sets to the cloud while expanding education, commerce, and environmental efficiencies.

Discover how Azure's cloud platform enables provisioning SQL Server databases and cloud-based data services, in a pay-as-you-go model across global data centers.

Learn key Azure terminology and cloud acronyms, including as-a-service models, SLA, SSL, API, VLAN, CRM, OpEx versus CapEx, and Microsoft’s cloud infrastructure and operations.

Understand how Azure subscriptions work, from a Microsoft account to creating an Azure subscription and subscribing to services like virtual machines. Learn about free trials, a $200 credit, and billing.

Navigate the Azure sign-up process from starting a free account to activating a $200 credit, including Microsoft account setup, identity verification, and accessing the Azure portal.

Navigate the Azure portal to create and manage Azure cloud services, including SQL databases, and connect them to SQL Server Management Studio while exploring the dashboard and blades.

Discover Azure SQL Database as a platform as a service, with V-12 improvements, basic premier tiers, and how to create and manage a single database with SQL Server Management Studio.

Understand database transaction units (DTUs) and how cpu, memory, and I/O combine to determine azure single-database performance and cost, with benchmarking insights for real-world workloads.

Learn how a logical server serves as a cloud-based administrative hub for Azure SQL databases. It offers server-level logins, a central endpoint, and controls like firewall and auditing across databases.

Open the Azure portal to create a sequel database, configure a new logical server and resource group, set a server admin login, and review pricing and connection strings.

Learn how to connect SQL Server Management Studio to an Azure SQL database from your local machine, configure firewall rules, and manage databases and tables using SSMS.

Discover how elastic pools manage unpredictable resource requirements across multiple databases on a single server by pooling resources at the pool level, with min and max controls.

Learn how to create and configure an elastic pool in the Azure portal, choosing between basic and standard pools and adding databases to the pool.

Learn how to create and configure Azure virtual machines, select images and regions, and balance size, cost, and performance for SQL Server workloads.

Explore Azure resource groups, a Resource Manager container for related resources with a common lifecycle that simplifies deployment and security, and learn JSON templates for consistent, reproducible deployments.

Discover how to create an Azure virtual machine with Windows Server 2016 and SQL Server 2016 editions in the Azure portal, configuring disks, networking, and security groups.

Configure a virtual machine with SQL Server 2016 Standard on Windows Server 2016, enable SQL authentication, open port 1433, and deploy via templates for quick replication.

Access an Azure virtual machine via desktop or rdp, use SQL Server Management Studio, and connect with the public IP to manage the SQL Server on VM one.

Explore Azure VM storage planning by comparing unmanaged and managed disks, standard and premium storage, IOPS limits, and upgrade paths for development and test workloads.

Explore Azure virtual networking to connect and manage communication between Azure resources, using a custom private IP address space, subnets, DNS options, and site-to-site VPNs.

Move on-premises SQL Server workloads to an Azure VM to leverage bundled licensing, bring-your-own-license options, and cloud-based deployment that improves performance, scalability, and disaster recovery with geo-redundancy.

This lecture guides provisioning a SQL Server VM in Azure, selecting an image with SQL Server, configuring VM basics, storage, networking, authentication, backups, and security integrations.

Learn how to move an on-premise SQL Server to Azure using a BYOL license and install via an Azure VM, including copying installation media with RDP.

Learn to manually configure SQL Server memory by setting minimum and maximum values, avoiding dynamic memory, and using SSMS to adjust memory in the server properties of a VM.

Explore how SQL Server agent enables automation and alerts for on-premises and Azure instances, with scheduled jobs and log backups triggered by threshold-based actions, stored in the MSD-based system database.

Configure operators in SQL Server Agent to receive alert notifications by email through database mail, including creating an operator, setting contact details, and linking to alerts.

Configure SQL Server Agent alerts to notify operators or run jobs, using SQL Server Management Studio on an Azure VM, and set up Database Mail for email notifications.

Explore how Azure alerts automate monitoring by creating metric and activity log alerts that trigger on thresholds or events, with actions like emails, webhooks, and runbooks via the portal.

Explore Azure SQL Database security fundamentals, including access control, encryption in transit and at rest, always encrypted, dynamic data masking, proactive monitoring, and compliance.

Explore Azure data security across physical, network, and data access in Azure SQL database. Compare authentication options and implement authorization with roles and object-level permissions.

Understand transparent data encryption (TDE) in SQL Server, a real-time, background encryption of data at rest using a database encryption key protected by a built-in server certificate.

Enable transparent data encryption (TDE) to encrypt data in the background with minimal key management. Toggle on or off via alter database, or use Azure portal GUI, Transact-SQL, or PowerShell.

Learn dynamic data masking in SQL Server 2016, protecting sensitive data at query time without altering stored data, using default, credit card, email, random, and custom masks.

Implement dynamic data masking in the Azure portal by creating a customer table, seeding data, and masking the Social Security number and credit card fields; test as Bob and revert.

Always Encrypted protects data at rest and in transit, decrypting only for authorized client applications, with keys kept outside the server and inaccessible to the database engine.

Explore migrating on-premise SQL Server databases to the Azure cloud, addressing compatibility, planning, and metadata needs, and using the Data Migration Assistant to streamline cloud readiness.

Assess compatibility and generate fixes with the data migration assistant as you migrate from on-premises SQL Server to Azure SQL Database, optimizing downtime, performance, and schema movement.

Migrate an on premise SQL Server to Azure SQL Database, with or without downtime, using DMA, SSMS, SQLPackage, and transactional replication.

Learn how to migrate a traditional on-premises SQL Server to a SQL Server instance on an Azure virtual machine, using replication, backups, and the SSMS deploy wizard.

Utilize Azure Monitor, Application Insights, and Log Analytics to monitor and diagnose performance across Azure resources. Build dashboards and gain near real-time visibility to optimize production workloads.

Learn how to use Azure Monitor to create custom dashboards, pin activity log queries, and visualize VM performance with metrics and alerts in the Azure portal.

Understand Azure availability sets, update domains, and fault domains to minimize downtime by automatically distributing VMs and ensuring availability during maintenance.

Explore provisioning sql databases, and master the technologies and hands-on practice needed to pass the Microsoft certification exam for architects, senior developers, and infrastructure specialists.

Explore the SQL Server 2016 certification structure, install and run SQL Server 2016, design tables, enforce data integrity, and work with indexes, views, transactions, stored procedures and triggers.

Discover how SQL Server evolved from a relational database to a comprehensive data platform, covering data stores, data models, integration services, and visualization for business intelligence.

Learn the basics of databases, including how related data is stored, retrieved, and managed in computer-based systems, how indexing and design choices affect performance in SQL Server.

Lay a foundation for database structures by contrasting online transaction processing and online analytical processing, and introducing data warehouses and data marts.

Learn Transact-SQL, the database programming language at the heart of Microsoft SQL Server, and understand its relationship to the SQL standard, cross-flavor differences, and practical database creation, querying, and management.

Create a SQL Server database using create database statement and graphical tools in SQL Server Management Studio, and review options like file groups, initial size, auto growth, and recovery model.

Explore the four core options when creating a SQL Server database: data file locations, initial size and growth, and file groups, with emphasis on separating the transaction log for performance.

Learn how database tables store related data as rows and columns, apply data types for integrity, and prevent duplicates to optimize performance in large SQL Server databases.

Explore the SQL Server data type categories—exact numeric, approximate numeric, date and time, character strings, Unicode characters, binary strings—and how their range and memory affect storage.

Choose a data type for each table column by assessing value types, memory needs, and operations; avoid overflow and wasted space by selecting efficient types.

Learn how normalization structures databases by dividing data into related tables, reducing redundancy, and improving data integrity, with a practical manager and department example and normal forms.

Explore how normalization and normal forms organize data into related tables, preserve referential integrity with foreign key constraints, and prevent orphaned data in relational databases.

Explore how schemas in SQL Server organize and secure database objects as namespaces, enabling logical grouping of tables, stored procedures, and views, with schema-level security and dot notation.

Learn table design basics in SQL Server, treating a table as a database object—a collection of columns defining attributes and rows, with data types and row size limits.

Learn to create tables with the T-SQL create table statement in SQL Server Management Studio, including syntax, conventions, and practical examples.

Create tables graphically in SQL Server Management Studio via Object Explorer and Diagram Tool, defining columns, data types, and nullability without writing code.

Learn how to use identity columns to auto-generate unique sequential values on new rows by configuring seed and increment, and choose numeric data types while considering globally unique identifiers.

Learn how to implement a globally unique identifier column in SQL Server, including table creation, defaults, and inserts. Compare GUIDs with identity columns and note their cross-database use and performance.

Learn to alter tables in SQL Server by adding or dropping columns and adjusting constraints, while understanding schemas and using SQL Server Management Studio responsibly in production.

Learn how altering tables in SQL Server can reorder columns by creating a new table, copying data, and renaming, a costly operation not advised for production; use caution.