Microsoft SQL Server Free Course
Learn essential SQL Server database management skills to troubleshoot, optimize, and migrate databases effectively in real-world scenarios with this comprehensive free course
If you have ever been handed a SQL Server problem at 4:55 p.m. on a Friday, you already know why this matters. A database is slow, a backup failed, a migration is stuck, or someone wants the whole thing moved into Azure without breaking the application. That is exactly the kind of work this complete microsoft sql server database administration course free download is built to prepare you for. I wrote this course to teach you how to manage SQL Server environments in the real world, not just recite terminology from a slide deck.
This Microsoft® SQL Server course focuses on the skills you need to provision, configure, secure, monitor, and maintain databases in cloud and hybrid environments. You will work through both Platform as a Service and Infrastructure as a Service approaches, which is important because not every workload belongs in the same model. Some databases should be managed as a service. Others need full instance control. Knowing the difference is what separates a person who can click through a wizard from a person who can actually run a production environment.
If you are searching for free database training, this course is designed to give you practical depth, not trivia. It is also a strong fit if you have been looking for a database administrator course free option that still teaches the operational decisions that matter: storage, scalability, security, backup strategy, restore planning, and troubleshooting. By the end, you should feel much more comfortable handling SQL Server in Microsoft Azure and making sound administrative choices instead of guessing your way through them.
Why this complete microsoft sql server database administration course free download matters
SQL Server administration is not just about keeping a database online. It is about understanding what kind of workload you are supporting, what kind of service model fits that workload, and what tradeoffs come with each choice. That is why I structured this course around deployment and administration in cloud settings. In the field, you will not always get a neat checklist. You will get competing requirements: performance, cost, security, availability, and migration deadlines. You need judgment, and that judgment comes from practice.
We spend time on Microsoft SQL Server 2016 concepts and on modern Azure-based deployment scenarios because both still show up in business environments. Many organizations are in transition. They may have older on-premises systems, partially migrated databases, and new cloud-hosted applications all at once. A good administrator has to understand how those pieces fit together. This course helps you build that broader operational view so you can support existing systems while moving them forward.
That is also why this course is useful for people who keep searching for free database training courses and course sql server material online. There is plenty of surface-level content out there. What is missing is a guided explanation of how to actually administer SQL databases once they are deployed. Here, you will work through the mechanics of provisioning, storage choices, backup and recovery, and cloud management in a way that reflects real job responsibilities.
In database administration, the expensive mistake is rarely the obvious one. It is the quiet one: the backup you thought was working, the storage tier you chose too quickly, or the security setting you never revisited after deployment.
What you will learn inside the course
This course is built to make you operationally useful. You will not just learn what Azure SQL Database is; you will learn how to decide when to use it, how to configure it, and how to manage it after deployment. You will also learn how SQL Server instances behave in cloud environments and what changes when the platform is no longer sitting in your own server room. That distinction is critical. Cloud administration is still administration, but the responsibilities are distributed differently.
The training covers the full life cycle of cloud database administration. You will see how to create and configure SQL Server databases, manage instances, work with storage, and apply security controls that make sense in a cloud architecture. You will also learn about monitoring and troubleshooting, which is where many administrators get tested in the real world. A database that looks fine during deployment can become a problem under load, after a restore, or during a migration. This course teaches you to think ahead.
Here is the kind of skill development you can expect:
- Implementing SQL Server databases in Azure and understanding deployment options
- Creating and configuring SQL Server instances for specific workload requirements
- Managing database backups, restores, and operational maintenance tasks
- Planning storage for performance, resilience, and cost control
- Deploying SQL Server in PaaS and IaaS models
- Monitoring performance and resolving common cloud database issues
- Handling migration and upgrade scenarios without losing control of the environment
- Applying security best practices to cloud-hosted SQL databases
- Using Azure portal tools and command-line methods for administration
- Thinking through scaling decisions and performance tuning in practical terms
If you have been looking for a database administrator course free that still addresses the work you will do on the job, this is that course. The emphasis is on repeatable skills, not memorizing definitions.
Understanding SQL Server in Azure: PaaS versus IaaS
One of the most important decisions you will make in cloud database administration is whether to use Platform as a Service or Infrastructure as a Service. This is not a minor technical detail. It affects how much control you retain, how much maintenance you own, and how much responsibility the cloud provider assumes. If you get this wrong, you can create unnecessary complexity or leave yourself without needed flexibility.
In this course, you will learn how Microsoft Azure supports both models and why each one exists. PaaS is attractive when you want managed services, easier patching, and reduced operational overhead. IaaS makes sense when you need deeper instance control, custom configurations, or compatibility with legacy applications. A lot of administrators come in thinking one model is universally better. It is not. The right choice depends on the application, the compliance requirements, and the operational maturity of your team.
This section of the course helps you compare those models with the kind of discipline a database administrator actually needs. You will look at deployment choices, instance management, and how storage and security differ depending on the architecture. You will also see why cloud convenience should never replace deliberate design. If you are the person responsible for the environment, you need to be able to explain why you picked a model, not just say it seemed easier.
Managing databases, storage, backup, and recovery the right way
Every SQL Server administrator eventually learns that the database itself is only part of the job. Storage, backup, restore, and maintenance are what keep the environment viable over time. That is why I spend real time in this course on the practical side of management. If the data is slow to read, poorly protected, or impossible to restore cleanly, then the platform is not doing its job no matter how elegant the deployment looked on paper.
You will work through database management tasks that show you how to support ongoing operations rather than just initial setup. That includes backup and restore planning, which is one of the most important responsibilities you can own. Many people say they have backups until the first serious restore test. The difference between “we probably have a copy” and “we can actually recover” is enormous. This course teaches you to approach recovery as a discipline, not an afterthought.
Storage is another major topic. In cloud environments, the wrong storage decision can hurt both performance and budget. You need to understand how storage configuration affects throughput, latency, and resilience. You also need to understand that SQL Server workloads are not all alike. Some are read-heavy, some are write-heavy, and some are unpredictable. This course helps you connect workload behavior to storage planning so you can make informed choices instead of defaulting to whatever option is cheapest.
- Plan backups with recovery objectives in mind
- Validate restores instead of assuming backups are enough
- Choose storage options that support workload performance
- Balance cost and availability in cloud database design
- Understand how maintenance tasks affect uptime and user experience
Security, monitoring, and performance tuning for production environments
Security and performance are not separate conversations in database administration. They affect each other constantly. A secure configuration that blocks access at the wrong layer can break applications. A permissive configuration can expose sensitive data. Likewise, a performance fix that ignores resource isolation can create a security or stability concern later. This course gives you the practical foundation to think about those issues together.
You will learn how to implement security best practices for cloud-based SQL Server environments. That includes access control concepts, sensible administrative boundaries, and the mindset required to protect data without overcomplicating the platform. In real deployments, security needs to be usable. If nobody can manage the system cleanly, they will work around it. That is how bad habits enter production.
Monitoring and troubleshooting are just as important. A database administrator is expected to notice patterns: response time changes, resource pressure, storage growth, or unexpected behavior after a migration. You will learn how to use Azure portal tools and command-line methods to manage SQL Server services and to identify issues before they become outages. Performance tuning is covered from the perspective of the administrator who needs to make sound operational decisions, not the developer who only sees one query.
This is where many learners realize the value of structured free database training. It is one thing to know a feature exists. It is another to know when to use it, what side effects it has, and how to prove that it helped.
Who should take this course
This training is intended for people who are responsible for SQL Server environments or who want to become the person others rely on when those environments misbehave. That includes database administrators, cloud engineers, infrastructure specialists, senior developers, solution architects, and technical support staff who are stepping into more infrastructure responsibility. If your work touches database deployment, security, migration, or maintenance, this course will make sense to you.
The course is especially valuable if you are already familiar with on-premises SQL Server and need to move that knowledge into Azure. That transition is where a lot of professionals feel the gap. The terminology is familiar, but the operating model changes. You are no longer managing everything the same way, and that can be disorienting at first. This course helps bridge that gap deliberately.
It also works well for learners who have been searching for free database training courses but want more than an intro-level overview. If you need a course sql server resource that goes beyond basic installation and into operational administration, you are in the right place. I would especially recommend it to people who want a practical foundation before moving into more advanced cloud or certification study.
- Database administrators supporting production SQL Server systems
- Cloud engineers responsible for Azure-hosted data workloads
- Infrastructure professionals modernizing legacy database platforms
- Developers who need to understand deployment and administration
- Architects who design database hosting strategies
Prerequisites and the best way to approach the material
You do not need to be an expert before starting this course, but you should come in with a working understanding of basic IT concepts. If you know what a database is, have some familiarity with cloud service models, and understand the difference between application work and infrastructure work, you will be fine. Experience with SQL Server or Azure is helpful, but the course is structured to build the cloud database administration side step by step.
The best way to approach this training is to treat it like a job simulation. Do not just watch and move on. Pause when a design decision is being made and ask yourself why that choice matters. If a backup strategy is discussed, think about what recovery point objective and recovery time objective would make sense for the business. If a storage tier is selected, ask whether that matches the workload. That habit of questioning assumptions is what turns information into skill.
Because this is an on-demand course, you can move at your own pace and revisit sections as needed. That matters more than people realize. Database administration is one of those disciplines where a second pass often reveals the real lesson. The first time you see a configuration, you understand the steps. The second time, you understand the reason behind the steps. That is where competence starts to stick.
Career value and practical outcomes
Learning SQL Server administration in cloud contexts can open doors to roles that pay well because they carry real operational responsibility. Employers want people who can keep data available, secure, and performant. That is not a small ask. It is the backbone of business continuity. Roles that often benefit from this training include SQL Server administrator, cloud database administrator, database engineer, cloud support specialist, infrastructure administrator, and solution architect. In many markets, experienced database administrators and cloud database specialists often see salary ranges roughly from the low six figures into the mid-six figures depending on region, industry, and seniority.
More important than the title is the usefulness. If you can walk into a conversation about Azure SQL deployment, instance management, storage strategy, security controls, and recovery planning without hand-waving, you become valuable quickly. That is the practical outcome of this course. You are not just learning a tool. You are learning how to own a class of problems that organizations cannot ignore.
For some learners, this course is a stepping stone toward broader cloud administration. For others, it is the piece that finally makes database operations feel manageable instead of overwhelming. Either way, it is built to give you the confidence to make decisions, defend them, and support them in production. That is the real point of a database administrator course free offering done properly: it should help you work better on Monday, not just sound smarter on a quiz.
If you have been looking for a complete microsoft sql server database administration course free download that is practical, focused, and grounded in real administrative work, this course was built for you.
Microsoft® and SQL Server are trademarks of Microsoft Corporation. This content is for educational purposes.
Module 1 – Query Tools
- 1.1 Course Introduction
- 1.2 Intro to Management Studio
- 1.3 Intro to command-line query tools
Module 2 – Introduction to T-SQL Querying
- 2.1 Introducing T-SQL
- 2.2 Understanding Sets
- 2.3 Understanding the Logical Order of Operations in SELECT statements
Module 3 – Basic SELECT Queries
- 3.1 Writing Simple SELECT Statements
- 3.2 Eliminate Duplicates with DISTINCT
- 3.3 Using Column and Table Aliases
- 3.4 Write Simple CASE Expressions
Module 4 – Querying Multiple Tables
- 4.1 Understanding Joins
- 4.2 Querying with Inner Joins
- 4.3 Querying with Outer Joins
- 4.4 Querying with Cross Joins and Self Joins
Module 5 – Sorting and Filtering Data
- 5.1 Sorting Data
- 5.2 Filtering Data with Predicates
- 5.3 Filtering with the TOP and OFFSET-FETCH
- 5.4 Working with Unknown Values
Module 6 – Introduction to Business Intelligence and Data Modeling
- 6.1 Introduction to Business Intelligence
- 6.2 The Microsoft Business Intelligence Platform
- 6.3 Exploring a Data Warehouse
- 6.4 Exploring a Data Model
Module 7 – Prepare Data
- 7.1 Introduction to Power BI
- 7.2 Get data from various data sources
- 7.3 Preview source data
Module 8 – Clean, Transform, and Load Data
- 8.1 Data Transformation Intro
- 8.2 Transformation Example 1
- 8.3 Transformation Example 2
- 8.4 Transformation Example 3
- 8.5 Transformation Example 4
- 8.6 Transformation Example 5
- 8.7 Transformation Example 6
Module 9 – Design a Data Model
- 9.1 Introduction to Data Modeling
- 9.2 Model Relationships
- 9.3 Table Configuration
- 9.4 Model interface
- 9.5 Quick Measures
- 9.6 Many-to-many relationships
- 9.7 Row-level security
Module 10 – Create Model Calculations using DAX
- 10.1 DAX context
- 10.2 Calculated Tables
- 10.3 Calculated Columns
- 10.4 Managing Date Tables
- 10.5 Measures
- 10.6 Filter Manipulation
- 10.7 Time Intelligence
Module 11 – Create Reports
- 11.1 Basic Report Creation
- 11.2 Example Page 1
- 11.3 Example Page 2
- 11.4 Example Page 3
- 11.5 Report Publishing
- 11.6 Enhancing Reports
- 11.7 Drill-Through Pages
- 11.8 Conditional Formatting
- 11.9 Buttons and Bookmarks
Module 12 – Create Dashboards
- 12.1 Dashboard Basics
- 12.2 Real Time Dashboards
- 12.3 Enhanced Dashboards
Module 13 – Create Paginated Reports
- 13.1 Introduction to Power BI Report Builder
- 13.2 Report Layouts
- 13.3 Report Data
- 13.4 Report Tables
Module 14 – Perform Advanced Analytics
- 14.1 Introduction to Advanced Analytics
- 14.2 Scatter Chart
- 14.3 Forecast
- 14.4 Decomposition Tree
- 14.5 Key Influencers
Module 15 – Create and Manage Workspaces
- 15.1 Introduction to Workspaces
- 15.2 Working with Workspaces and the Portal
Module 16 – Create Power App Visuals
- 16.1 Introduction to Power Apps Visual
- 16.2 Creating the App
- 16.3 Basic Power Apps Concepts
- 16.4 Refreshing the Report
Module 17 – Analysis Services and Power BI
- 17.1 Introduction to Analysis Services
- 17.2 Connecting with Multidimensional Models
- 17.3 Premium Workspaces and Analysis Services
- 17.4 Course Wrap Up
Module 1 – Query Tools
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Intro to Management Studio
- 1.4 Intro to command-line query tools
Module 2 – Introduction to T-SQL Querying
- 2.1 Module 2 Introduction
- 2.2 Introducing T-SQL
- 2.3 Understanding Sets
- 2.4 Understanding the Logical Order of Operations in SELECT statements
Module 3 – Basic SELECT Queries
- 3.1 Module 3 Introduction
- 3.2 Writing Simple SELECT Statements
- 3.3 Eliminate Duplicates with DISTINCT
- 3.4 Using Column and Table Aliases
- 3.5 Write Simple CASE Expressions
Module 4 – Querying Multiple Tables
- 4.1 Module 4 Introduction
- 4.2 Understanding Joins
- 4.3 Querying with Inner Joins
- 4.4 Querying with Outer Joins
- 4.5 Querying with Cross Joins and Self Joins
Module 5 – Sorting and Filtering Data
- 5.1 Module 5 Introduction
- 5.2 Sorting Data
- 5.3 Filtering Data with Predicates
- 5.4 Filtering with the TOP and OFFSET-FETCH
- 5.5 Working with Unknown Values
Module 6 – Working with SQL Server Data Types
- 6.1 Module 6 Introduction
- 6.2 Writing Queries that return Date and Time Data
- 6.3 Writing Queries that use Date and Time Functions
- 6.4 Writing Queries that return Character Data
- 6.5 Writing Queries that use Character Functions
Module 7 – Using DML to Modify Data
- 7.1 Module 7 Introduction
- 7.2 Inserting Records with DML
- 7.3 Updating Records Using DML
- 7.4 Deleting Records Using DML
Module 8 – Using Built-In Functions
- 8.1 Module 8 Introduction
- 8.2 Writing Queries with Built-In Functions
- 8.3 Using Conversion Functions
- 8.4 Using Logical Functions
- 8.5 Using Functions to Work with NULL
Module 9 – Grouping and Aggregating Data
- 9.1 Module 9 Introduction
- 9.2 Using Aggregate Functions
- 9.3 Using the GROUP BY Clause
- 9.4 Filtering Groups with HAVING
Module 10 – Using Subqueries
- 10.1 Module 10 Introduction
- 10.2 Writing Self-Contained Subqueries
- 10.3 Writing Correlated Subqueries
- 10.4 Using the EXISTS Predicate with Subqueries
Module 11 – Using Table Expressions
- 11.1 Module 11 Introduction
- 11.2 Using Views
- 11.3 Using Inline Table-Valued Functions
- 11.4 Using Derived Tables
- 11.5 Using Common Table Expressions
Module 12 – Using Set Operators
- 12.1 Module 12 Introduction
- 12.2 Writing Queries with the UNION operator
- 12.3 Using EXCEPT and INTERSECT
- 12.4 Using APPLY
Module 13 – Using Window Ranking, Offset, and Aggregate Functions
- 13.1 Module 13 Introduction
- 13.2 Creating Windows with OVER
- 13.3 Exploring Window Functions
Module 14 – Pivoting and Grouping Sets
- 14.1 Module 14 Introduction
- 14.2 Writing Queries with PIVOT and UNPIVOT
- 14.3 Working with Grouping Sets
Module 15 – Implementing Error Handling
- 15.1 Module Introduction
- 15.2 Implementing T-SQL error handling
- 15.3 Implementing structured exception handling
Module 16 – Managing Transactions
- 16.1 Module 16 Introduction
- 16.2 Transactions and the Database Engine
- 16.3 Controlling Transactions
- 16.4 Course Wrap Up
Module 1 – Designing and Building Tables
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Database Design
- 1.4 Creating Tables
- 1.5 Data Types
- 1.6 Schemas
- 1.7 Altering Tables
Module 2 – Enforcing Data Integrity
- 2.1 Module 2 Introduction
- 2.2 Introduction to Data Integrity
- 2.3 Data Domain Integrity
- 2.4 Implementing Data Domain Integrity
- 2.5 Implementing Entity and Referential Integrity
Module 3 – Indexing
- 3.1 Module 3 Introduction
- 3.2 Core Indexing Concepts
- 3.3 Heaps, Clustered, and Nonclustered Indexes
- 3.4 Data Types and Indexes
- 3.5 Single Column and Composite Indexes
Module 4 – Stored Procedures, Functions, and Triggers
- 4.1 Module 4 Introduction
- 4.2 Introduction to Database Programming
- 4.3 Creating Stored Procedures
- 4.4 Creating User-Defined Functions
- 4.5 Creating Triggers
Module 5 – Blob and Filestream Data
- 5.1 Module 5 Introduction
- 5.2 Introduction to Binary Data
- 5.3 Considerations for BLOB data
- 5.4 FILESTREAM Example
- 5.5 File Table Example
Module 6 – Full-Text Search
- 6.1 Module 6 Introduction
- 6.2 Introduction to Full-Text Search
- 6.3 Full-Text Catalogs
- 6.4 Full-Text Indexes
- 6.5 Full-Text Queries
Module 7 – Azure vs On-Prem
- 7.1 Module 7 Introduction
- 7.2 SQL Server on Azure VM
- 7.3 Azure Managed SQL Instance
- 7.4 Azure SQL Database
- 7.5 Course Wrap Up
Module 1 – Introduction to Business Intelligence and Data Modeling
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Business Intelligence
- 1.4 The Microsoft Business Intelligence Platform
- 1.5 Exploring a Data Warehouse
- 1.6 Exploring a Data Model
Module 2 – Multidimensional Databases
- 2.1 Module 2 Introduction
- 2.2 Introduction to Multidimensional Analysis
- 2.3 Overview of Cube Security
- 2.4 Creating and Configuring a Cube
- 2.5 Data Sources
- 2.6 Data Source Views
- 2.7 Adding a Dimension to a Cube
Module 3 – Cubes and Dimensions
- 3.1 Module 3 Introduction
- 3.2 Dimensions
- 3.3 Attribute Hierarchies and Relationships
- 3.4 Sorting and Grouping Attributes
- 3.5 Slowly Changing Dimensions
Module 4 – Measures and Measure Groups
- 4.1 Module 4 Introduction
- 4.2 Measures
- 4.3 Measure Groups and Relationships
- 4.4 Measure Group Storage
Module 5 – Introduction to MDX
- 5.1 Module 5 Introduction
- 5.2 MDX Fundamentals
- 5.3 Adding Calculations to a Cube
- 5.4 Querying a cube using MDX
Module 6 – Customizing Cube Functionality
- 6.1 Module 6 Introduction
- 6.2 Key Performance Indicators
- 6.3 Actions
- 6.4 Perspectives
- 6.5 Translations
Module 7 – Tabular Data Models
- 7.1 Module 7 Introduction
- 7.2 Introduction to Tabular Data Models
- 7.3 Creating a Tabular Data Model
- 7.4 Configure Relationships and Attributes
- 7.5 Configuring Data Model for an Enterprise BI Solution
Module 8 – Data Analysis Expressions (DAX)
- 8.1 Module 8 Introduction
- 8.2 DAX Fundamentals
- 8.3 Calculated Columns
- 8.4 Relationships
- 8.5 Measures
- 8.6 Time Intelligence
- 8.7 KPI
- 8.8 Parent – Child Hierarchies
Module 9 – Data Mining
- 9.1 Module 9 Introduction
- 9.2 Overview of Data Mining
- 9.3 Custom Data Mining Solutions
- 9.4 Validating a Data Mining Model
- 9.5 Consuming a Data Mining Model
- 9.6 Course Wrap Up
Module 1: What are Big Data Clusters?
- 1.1 Introduction
- 1.2 Linux, PolyBase, and Active Directory
- 1.3 Scenarios
Module 2: Big Data Cluster Architecture
- 2.1 Introduction
- 2.2 Docker
- 2.3 Kubernetes
- 2.4 Hadoop and Spark
- 2.5 Components
- 2.6 Endpoints
Module 3: Deployment of Big Data Clusters
- 3.1 Introduction
- 3.2 Install Prerequisites
- 3.3 Deploy Kubernetes
- 3.4 Deploy BDC
- 3.5 Monitor and Verify Deployment
Module 4: Loading and Querying Data in Big Data Clusters
- 4.1 Introduction
- 4.2 HDFS with Curl
- 4.3 Loading Data with T-SQL
- 4.4 Virtualizing Data
- 4.5 Restoring a Database
Module 5: Working with Spark in Big Data Clusters
- 5.1 Introduction
- 5.2 What is Spark
- 5.3 Submitting Spark Jobs
- 5.4 Running Spark Jobs via Notebooks
- 5.5 Transforming CSV
- 5.6 Spark-SQL
- 5.7 Spark to SQL ETL
Module 6: Machine Learning on Big Data Clusters
- 6.1 Introduction
- 6.2 Machine Learning Services
- 6.3 Using MLeap
- 6.4 Using Python
- 6.5 Using R
Module 7: Create and Consume Big Data Cluster Apps
- 7.1 Introduction
- 7.2 Deploying, Running, Consuming, and Monitoring an App
- 7.3 Python Example – Deploy with azdata and Monitoring
- 7.4 R Example – Deploy with VS Code and Consume with Postman
- 7.5 MLeap Example – Create a yaml file
- 7.6 SSIS Example – Implement scheduled execution of a DB backup
Module 8: Maintenance of Big Data Clusters
- 8.1 Introduction
- 8.2 Monitoring
- 8.3 Managing and Automation
- 8.4 Course Wrap Up
Module 1: Installation
- SQL Admin Intro
- Installation
Module 2: Data Storage
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
Module 3: Data Recover
- Intro to Data Recovery
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using SSMS For Backup
- Understanding the Restore Process
- How to Restore a Database
- Using SSMS For Restore
- T-SQL Backup and Restore
- Advanced Restore Scenarios
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Module 4: Monitoring
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Server Reports
- System Performance Monitor
- Tracing SQL Server Workload Activity
- Extended Events
- Database Tuning Advisor
Module 5: Security
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Security
- Row Level Security (RLS) Using Policies
- Database Security Tools
- Contained Database
- Auditing Data Access in SQL Server
- Implementing Transparent Data Encryption
Module 6: Maintenance
- Introduction to Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server Errors
- Configuring Database Mai
Module 1: Deploy a Microsoft Azure SQL Database
- Introduction
- Introducing the Azure SQL Database Part 1
- Introducing the Azure SQL Database Part 2
- Setting Up Azure Lab
- Chose a Service Tier Part 1
- Chose a Service Tier Part 2
- Create Servers and Databases Part 1
- Creating a Azure SQL Server and Database Lab
- Create Servers and Databases Part 2
- Create Servers and Databases Part 3
- Connecting SSMS to Azure SQL Lab Part 1
- Connecting SSMS to Azure SQL Lab Part 2
- Create a Sysadmin Account
- Creating Azure SQL Logins and Users Lab
- Congure Elastic Pools
- Creating and Conguring an Elastic Pool Lab
Module 2: Plan for SQL Server Installation
- Plan for an IaaS or On-Premises Deployment Part 1
- Plan for an IaaS or On-Premises Deployment Part 2
- Select the Appropriate Size for a Virtual Machine
- Plan Storage Pools Based on Performance Requirements Part 1
- Plan Storage Pools Based on Performance Requirements Part 2
- Evaluate Best Practices for Installation
- Design a Storage Layout for a SQL Server Virtual Machine
Module 3: Deploy SQL Server Instances
- Deploy a SQL Server Instance in IaaS and On-Premises
- Restoring AdventureWorks 2016 Database Lab
- Provision an Azure Virtual Machine to Host a SQL Server Instance
- Provisioning an Azure Virtual Machine to Host a SQL Server Lab
- Manually Install SQL Server on an Azure Virtual Machine
- Installing SQL 2016 Lab Part 1
- Installing SQL 2016 Lab Part 2
- Automate the Deployment of SQL Server Databases
- Exploring Azure SQL Database Automation Lab
- Deploy SQL Server by Using Templates
- Managing JSON Templates Lab
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
- Generate Benchmark Data for Performance Needs
- Generating Benchmark Data Lab Part 1
- Generating Benchmark Data Lab Part 2
- Perform Performance Tuning on Azure IaaS
- Perform Performance Tuning on Azure IaaS Lab Part 1
- Perform Performance Tuning on Azure IaaS Lab Part 2
- Support Availability Sets in Azure Part 1
- Support Availability Sets in Azure Part 2
- Manage High Availability Lab Part 1
- Manage High Availability Lab Part 2
- Manage High Availability Lab Part 3
- Manage High Availability Lab Part 4
- Manage High Availability Lab Part 5
Module 5: Configure Secure Access to Microsoft Azure SQL Databases
- Configure Firewall Rules
- Creating Firewall Rules Lab
- Configure Always Encrypted for Azure SQL Database
- Implementing Always Encrypted Lab
- Configure Cell-Level Encryption
- Cell-Level Encryption Lab
- Configure Dynamic Data Masking
- Dynamic Data Masking Lab
- Configure Transparent Data Encryption (TDE)
- Transparent Data Encryption (TDE) Lab
Module 6: Configure SQL Server performance settings
- Configure SQL Performance Settings
- Configuring SQL Performance Settings Lab
- Configure Max Server Memory
- Configuring SQL Memory Lab
- Configure Database Performance Settings
- Configure Database Performance Settings Lab
- Configure Operators and Alerts
- Configure alerts in Azure and On-Premise SQL Server Lab
Module 7: Manage SQL Server instances
- Create Databases
- Creating Databases Lab
- Manage Files and File Groups
- Managing Files and File Groups Lab
- Manage System Database Files
- Manage System Database Files Lab
- Configure tempdb
- Configure tempdb Lab
Module 8: Manage SQL Storage
- Manage SMB File Shares
- Manage SMB File Shares Lab
- Manage Stretch Databases
- Configure Azure Storage
- Change Service Tiers
- Change Service Tiers Lab Part 1
- Review Wait Statistics
- Manage Storage Pools
- Recover from Failed Storage
- Managing Storage Lab Part 1
- Managing Storage Lab Part 2
Module 9: Perform Database Maintenance
- Monitoring Tools
- Using Monitoring Tools Lab Part 1
- Using Monitoring Tools Lab Part 2
- Azure Performance Tuning
- Automate Maintenance Tasks
- Update Statistics and Indexes
- Update Statistics and Indexes Lab Part 1
- Update Statistics and Indexes Lab Part 2
- Verify Database Integrity
- Verify Database Integrity Lab
- Recover from Database Corruption
- Recover from Database Corruption Lab
- Conclusion
Frequently Asked Questions.
What are the key topics covered in the Microsoft SQL Server Free Course?
This course covers a broad range of essential SQL Server topics, including database installation, configuration, and management. You will learn how to optimize database performance, implement security measures, and perform backups and restores effectively.
Additionally, the course delves into advanced topics such as troubleshooting common issues, migrating databases to Azure, and automating routine tasks. It provides practical, real-world scenarios to help you apply your knowledge directly to workplace challenges.
Is this Microsoft SQL Server Free Course suitable for beginners?
Yes, this course is designed to cater to both beginners and experienced professionals. It starts with foundational concepts to ensure newcomers can follow along comfortably.
For those with some prior database experience, the course offers advanced insights and practical techniques to enhance your existing skills. It emphasizes real-world application, making it a valuable resource regardless of your starting point.
Will I receive a certification after completing the Microsoft SQL Server Free Course?
While this specific course is offered for free and may not include a formal certification, completing it provides valuable knowledge and practical skills that can enhance your resume.
Some courses may offer a certificate of completion or digital badge, which can be added to your professional profiles. Check the course platform details for specific certification options or accreditation related to Microsoft SQL Server training.
How does this course prepare me for managing SQL Server in real-world scenarios?
This course emphasizes practical skills by simulating real-world situations like troubleshooting performance issues, restoring databases, or migrating to Azure cloud environments.
It teaches best practices for daily database administration, including backup strategies, security protocols, and automation techniques. The focus is on applying knowledge to solve urgent problems efficiently, much like you would encounter on the job.
Can I learn about SQL Server certifications through this course?
This course provides foundational and advanced knowledge aligned with skills needed for SQL Server certifications. However, it may not directly prepare you for specific exam requirements.
For certification preparation, consider supplementing this course with official Microsoft training or exam guides. The skills gained here can serve as a strong base for certifications like Microsoft Certified: Azure Database Administrator Associate or similar credentials.