- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Core Tech
SQL Server Administration
This learning path is actively in production. More content will be added to this page as it gets published and becomes available in the library. Planned content includes:
**SQL Server Administration** - Getting Started with SQL Server Administration (video course) - Database Management and Design Principles (video course) - Implementing SQL Server Security (video course) - Performance Monitoring, Optimization, and Automation (video course) - High Availability, Disaster Recovery, and Cloud Integration (video course)
**SQL Server Labs** - Foundational Tools and T-SQL Interaction (lab) - Database Object Management and Data Loading (lab) - Performance Tuning and Automated Maintenance (lab)
SQL Server Administration path progresses you through foundational concepts to advanced administrative techniques, ensuring a robust skill set for managing modern data infrastructures. The path emphasizes a dual focus on traditional on-premises SQL Server deployments and the increasingly vital Azure SQL services, reflecting the hybrid nature of contemporary data environments.
Content in this path
SQL Server Administration
SQL Server Administration path progresses you through foundational concepts to advanced administrative techniques, ensuring a robust skill set for managing modern data infrastructures. The path emphasizes a dual focus on traditional on-premises SQL Server deployments and the increasingly vital Azure SQL services, reflecting the hybrid nature of contemporary data environments.
SQL Server Labs
Practice what you have learned with these hands-on SQL Server labs.
Try this learning path for free
What You'll Learn
- How to connect to and interact with SQL Server using tools like SQL Server Management Studio (SSMS) and Azure Data Studio.
- Understand foundational SQL Server architecture, including the Database Engine, SQL Server Agent, and other key services.
- You'll be able to execute Transact-SQL (T-SQL) commands, including both Data Definition Language (DDL) for creating databases and Data Manipulation Language (DML) for modifying data.
- Learn to use system catalog views and dynamic management views (DMVs) to inspect and monitor database activity.
- To create and manage databases, specifying file locations and auto-growth settings.
- To work with database objects like tables, views, stored procedures, and indexes, understanding their roles in data organization and retrieval.
- How to implement strategies for data loading and migration, using tools like the Import and Export Wizard and the Bulk Copy Program (BCP) utility.
- How to detach and attach databases for tasks such as migration or troubleshooting.
- How to secure SQL Server at both the server level and database level by managing logins, users, and permissions.
- Be able to implement advanced data protection features, such as Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking.
- Monitor performance using tools like SSMS Activity Monitor and Extended Events to identify and resolve bottlenecks.
- Optimize database performance by analyzing query execution plans and managing indexes and statistics.
- How to automate routine tasks by creating and scheduling SQL Server Agent jobs for things like backups and index maintenance.
- How to set up alerts and operators to receive notifications about critical events or job failures.
- How to perform maintenance tasks, including diagnosing and repairing database corruption with DBCC CHECKDB.
- Implement comprehensive backup and restore strategies, including understanding different recovery models.
- How to configure Always On Availability Groups for high availability and perform failovers.
- You'll learn about other solutions like Always On Failover Cluster Instances (FCIs) and Log Shipping.
- You'll also gain skills in administering Azure SQL Database and Azure SQL Managed Instance.
- A learner should have a foundational understanding of computer systems and basic database concepts.
- SQLServerAdministration
- DatabaseManagement
- SQLServerSecurity
- PerformanceTuning
- HighAvailability
- DisasterRecovery
- AzureSQL
- T-SQL