What You Need to Know Before
You Start
Starts 2 June 2025 14:34
Ends 2 June 2025
00
days
00
hours
00
minutes
00
seconds
Mission Critical Apps with SQL Server 2017 - Cross-Platform SQL Server Management
Learn to build mission-critical apps using SQL Server 2017's advanced features like In-Memory performance, Automatic Tuning, and Always Encrypted for enhanced security and efficiency.
PASS Data Community Summit
via YouTube
PASS Data Community Summit
2408 Courses
59 minutes
Optional upgrade avallable
Not Specified
Progress at your own speed
Conference Talk
Optional upgrade avallable
Overview
Learn to build mission-critical apps using SQL Server 2017's advanced features like In-Memory performance, Automatic Tuning, and Always Encrypted for enhanced security and efficiency.
Syllabus
- Course Introduction
- SQL Server 2017 Architecture and Core Concepts
- In-Memory Performance Enhancements
- Automatic Tuning
- Enhanced Security with SQL Server 2017
- Building Mission-Critical Applications
- SQL Server on Linux and Docker
- Monitoring and Performance Tuning
- Real-world Application Design
- Project: Develop a Cross-Platform Mission-Critical Application
- Course Review and Q&A
Overview of SQL Server 2017
Course objectives and outcomes
Cross-platform capabilities
High availability and disaster recovery
Memory-optimized tables
Native stored procedures
Query performance optimization
Automatic plan correction
Always Encrypted
Dynamic data masking
Row-level security
Scalability and reliability strategies
Utilizing SQL Server features for robust applications
Installation and configuration
Cross-platform management tools
Query Store
Performance monitoring tools
Designing for performance and security
Best practices for mission-critical apps
Project overview and guidelines
Implementation and presentation
Recap of key concepts
Open floor for questions and feedback
Subjects
Conference Talks
