SQL Server 2019 - Your Next Modern Data Platform

Overview

Delve into SQL Server 2019 and discover why it's your next modern data platform. This session provides an in-depth examination of its remarkable features.

Learn about its improved performance capabilities, cutting-edge data integration solutions, and strengthened security protocols. See how these advancements position SQL Server 2019 as a leading option for modern data management.

This event is presented by YouTube and falls under the categories of Artificial Intelligence Courses and Conference Talks, appealing to both industry professionals and academic audiences eager to enhance their knowledge of advanced data systems.

Syllabus

• Introduction to SQL Server 2019
Overview of SQL Server and its evolution
Key new features in SQL Server 2019
• Installation and Configuration
System requirements and installation process
Configuration and management tools
• Performance Enhancements
Query performance improvements
Intelligent Query Processing (IQP)
In-Memory Database capabilities
• Data Integration Capabilities
PolyBase enhancements for data integration
Working with Big Data clusters
Integration with Apache Spark
• Advanced Security Features
Always Encrypted with secure enclaves
Data Classification and Auditing
Advanced threat protection tools
• Modern Data Platform Architecture
Kubernetes integration and containerization
Deployment strategies for hybrid environments
Scalability and high availability
• Data Management and Storage
Enhancements in storage performance
Management of diverse data types
• Development and Programming Enhancements
T-SQL enhancements
Developer tools and environments
• Backup, Recovery, and Monitoring
Enhanced backup and recovery options
Performance monitoring and management
• Case Studies and Practical Applications
Real-world use cases of SQL Server 2019
Industry-specific data platform implementations
• Future Trends and Developments
The roadmap for SQL Server
Ongoing developments in data platform technologies
• Course Review and Conclusion
Summary of key takeaways
Discussion of future learning paths in data platforms and SQL Server technology

---

Subjects

Conference Talks