SQL-SVR-2019.AP1
SQL Server 2019
Improve your database management skills with our SQL Server 2019 training course to handle complex data tasks comfortably.
- Practice in 21 Laboratorios prácticos — nothing to install
- 21 Lecciones interactivas y 114 topics mapped to the official exam objectives
- 135 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso 4.2/5 (68 Revisar)
21 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
21Lecciones interactivas
114Topics
21Laboratorio en vivo
135Preguntas del examen de práctica
100Tarjetas didácticas
100Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
This SQL Server 2019 course will help you understand database management techniques and their real-world applications. You’ll gain hands-on experience with SQL Server Management Studio and Azure Data Studio – learn to set up and configure SQL Server, manage data, ensure high availability, secure your databases, and automate administrative tasks. With immersive labs of our SQL server course, you’ll also practice designing, implementing, and maintaining both on-premises and cloud-based databases.
- Set up and configure SQL Server environments for optimal performance
- Manage databases on both on-premises and cloud infrastructures
- Monitor and ensure high availability and disaster recovery of SQL Server instances
- Secure databases with encryption, auditing, and advanced security features
- Optimize database performance using indexing and performance-tuning techniques
- Automate routine administrative tasks with SQL Server Maintenance Plans and PowerShell
- Design database architectures that support scalability and reliability
- Implement data recovery strategies to safeguard data against data loss
- Migrate databases to Azure with minimal disruption and enhanced resilience
- Leverage big data and machine learning to enhance analytics capabilities
Course Highlights
-
21 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
21 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
135 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
21 Lecciones interactivas · 114 topics01 Introduction 1 topics +
- Acknowledgments
02 Getting started with SQL Server tools 8 topics · 1 Laboratorio en vivo +
- SQL Server setup
- Tools and services installed with the SQL Server Database Engine
- Performance and reliability monitoring tools
- SQL Server Reporting Services
- SQL Server Management Studio (SSMS)
- Azure Data Studio
- SQL Server Data Tools
- A note on discontinued and deprecated features
1 Laboratorio en vivo in this lesson — see the labs panel →
03 Introducing database server components 7 topics · 1 Laboratorio en vivo +
- Memory
- Central Processing Unit
- Storing your data
- Connecting to SQL Server over the network
- High availability concepts
- Securing SQL Server
- Understanding virtualization and containers
1 Laboratorio en vivo in this lesson — see the labs panel →
04 Designing and implementing an on-premises database infrastructure 8 topics · 1 Laboratorio en vivo +
- Introduction to SQL Server database architecture
- Data files and filegroups
- Recording changes in the transaction log
- Table partitioning
- Compressing data
- Managing the temporary database
- Configuration settings
- Container orchestration with Kubernetes
1 Laboratorio en vivo in this lesson — see the labs panel →
05 Installing and configuring SQL Server instances and features 4 topics · 2 Laboratorio en vivo +
- What to do before installing SQL Server
- Installing a new instance
- Post-installation server configuration
- Post-installation configuration of other features
2 Laboratorio en vivo in this lesson — see the labs panel →
06 Installing and configuring SQL Server on Linux 5 topics · 1 Laboratorio en vivo +
- What is Linux?
- Considerations for installing SQL Server on Linux
- Installing SQL Server on Linux
- Configuring SQL Server for Linux
- Caveats of SQL Server on Linux
1 Laboratorio en vivo in this lesson — see the labs panel →
07 Provisioning and configuring SQL Server databases 2 topics · 2 Laboratorio en vivo +
- Adding databases to a SQL Server instance
- Moving and removing databases
2 Laboratorio en vivo in this lesson — see the labs panel →
08 Understanding table features 5 topics · 1 Laboratorio en vivo +
- Reviewing table design
- Special table types
- Storing BLOBs
- Table partitioning
- Capturing modifications to data
1 Laboratorio en vivo in this lesson — see the labs panel →
09 Maintaining and monitoring SQL Server 9 topics · 2 Laboratorio en vivo +
- Detecting, preventing, and responding to database corruption
- Maintaining indexes and statistics
- Managing database file sizes
- Monitoring activity by using DMOs
- Monitoring with the SQL Assessment API
- Utilizing extended events
- Capturing performance metrics with DMOs and Data Collectors
- Protecting important workloads by using Resource Governor
- Understanding the new servicing model
2 Laboratorio en vivo in this lesson — see the labs panel →
10 Automating SQL Server administration 5 topics · 1 Laboratorio en vivo +
- Components of SQL Server automated administration
- Maintaining SQL Server
- Using SQL Server Maintenance Plans
- Strategies for administering multiple SQL Servers
- Using PowerShell to automate SQL Server administration
1 Laboratorio en vivo in this lesson — see the labs panel →
11 Developing, deploying, and managing data recovery 6 topics · 2 Laboratorio en vivo +
- Preparing for data recovery
- Understanding different types of backups
- Understanding backup devices
- Creating and verifying backups
- Restoring a database
- Defining a recovery strategy
2 Laboratorio en vivo in this lesson — see the labs panel →
12 Implementing high availability and disaster recovery 5 topics +
- Overview of high availability and disaster recovery technologies in SQL Server
- Configuring failover cluster instances
- Designing availability groups solutions
- Configuring availability groups in SQL Server on Linux
- Administering availability groups
13 Administering security and permissions 4 topics · 1 Laboratorio en vivo +
- Authentication modes
- Security principals
- Permissions
- Common security administration tasks
1 Laboratorio en vivo in this lesson — see the labs panel →
14 Protecting data through encryption, privacy and auditing 5 topics · 1 Laboratorio en vivo +
- Privacy in the modern era
- Introducing security principles and protocols
- Protecting the data platform
- Auditing with SQL Server and Azure SQL Database
- Securing Azure infrastructure as a service
1 Laboratorio en vivo in this lesson — see the labs panel →
15 Performance tuning SQL Server 4 topics · 1 Laboratorio en vivo +
- Understanding isolation levels and concurrency
- Understanding durability settings for performance
- Understanding how SQL Server executes your query
- Understanding advanced engine features for tuning queries
1 Laboratorio en vivo in this lesson — see the labs panel →
16 Understanding and designing indexes 6 topics · 3 Laboratorio en vivo +
- Designing clustered indexes
- Designing rowstore nonclustered indexes
- Understanding columnstore indexes
- Understanding indexing in memory-optimized tables
- Understanding index statistics
- Understanding other types of indexes
3 Laboratorio en vivo in this lesson — see the labs panel →
17 Designing and implementing hybrid and Azure database infrastructure 4 topics · 1 Laboratorio en vivo +
- Cloud computing and Microsoft Azure
- Cloud models and SQL Server
- Cloud security
- Other data services in Azure
1 Laboratorio en vivo in this lesson — see the labs panel →
18 Provisioning Azure SQL Database 6 topics +
- Provisioning a logical SQL server
- Provisioning a database in Azure SQL Database
- Provisioning an elastic pool
- Managing database space
- Security in Azure SQL Database
- Preparing Azure SQL Database for disaster recovery
19 Provisioning Azure SQL Database managed instance 10 topics +
- What is a Managed Instance?
- Creating a managed instance
- Establishing a connection
- Migrating data to managed instance
- Deleting a managed instance
- Network requirements for managed instances
- Managed Instance administration features
- Azure SQL Analytics
- Security of Managed Instance
- Data protection features
20 Migrating to SQL Server solutions in Azure 4 topics +
- Migration Services Options
- Common causes for migration failures
- Integration Runtime options for Migration Services
- Best Practices for security and resiliency during migration
21 Leveraging big data and machine learning 6 topics +
- A big data primer
- Introducing Big Data Clusters
- Deploying Big Data Clusters
- Benefits of PolyBase
- Operationalizing analytics with Machine Learning Server
- Launchpad service
Laboratorios prácticos Our edge
21 Laboratorio en vivos- Exporting Data with the Import/Export Wizard
- Installing the Failover Cluster Feature
- Designing Multiple Filegroups
- Installing SQL Server Analysis Services
- Installing SQL Server Integration Services
- Configuring SQL Server
- Creating a SQL Login
- Using the ALTER Command with the ROLLBACK IMMEDIATE Command
- Creating a Table
- Using CHECKDB
- Managing Resource Utilization Using Resource Governor
- Configuring Database Mail
- Creating a Differential Backup
- Creating a Full Database Backup
- Granting Permissions to Create Tables
- Creating a New Server Audit and Configuring a Server Audit Specification
- Optimizing Queries
- Creating a Non-Clustered Index
- Creating a Columnstore Index
- Configuring Full-Text Indexing
- Creating a Virtual Machine in Azure
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
Do I need prior knowledge of SQL or database management to take this course? +
No prior knowledge is required! This course covers everything from the basics, making it ideal for beginners and professionals who want to upskill. However, if you have already some experience, you’ll find plenty of advanced topics to deepen your skills.
Do I need prior knowledge of SQL to take this course? +
You’ll learn to work with both on-premises and cloud-based databases, including SQL Server databases, Azure SQL Database, and hybrid cloud solutions.
Is this course updated with the latest features of SQL Server 2019? +
Yes, the course includes all the latest features of SQL Server 2019, ensuring you’re learning the most up-to-date tools and technologies.
How can I continue improving my SQL Server skills after this course? +
After completing the course, you can further improve by exploring advanced topics like performance tuning, database security, and big data integration, or by taking specialized certifications to improve your expertise.
Improve Your Database Management Skills
From setting up database infrastructure to performance automation, you’ll learn to use SQL Server 2019 advanced features.
- 1 año de acceso completo
- 21 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito