Machine Learning with SQL Server - From the Edge to the Cloud

Overview

Join us as we explore the various machine learning options available within the SQL Server ecosystem. Whether dealing with edge devices or cloud-based solutions, this event covers the entire spectrum of activities, from training to testing and operationalizing models.

Gain insights into handling various workloads and design patterns, perfect for professionals eager to leverage SQL Server's robust capabilities in artificial intelligence. Tune in to this comprehensive session available on YouTube under the categories of Artificial Intelligence Courses and Conference Talks.

Syllabus

• Introduction to Machine Learning and SQL Server
Overview of SQL Server Ecosystem
Introduction to Machine Learning Concepts
• Installation and Configuration
Setting Up SQL Server for Machine Learning
Installing Required Extensions and Tools
• Machine Learning with SQL Server on Edge Devices
Overview of Edge Computing
Implementing ML Models on Edge Devices
Case Studies and Use Cases
• Data Preparation in SQL Server
Data Extraction Techniques
Data Cleaning and Transformation with T-SQL
Feature Selection and Engineering
• Model Training and Testing
Training ML Models Using SQL Server Machine Learning Services
Testing and Validating Models within SQL Server
Cross-Validation and Hyperparameter Tuning
• Operationalizing Machine Learning Models
Deploying Models to SQL Server
Automation and Scheduling of ML Workflows
Integrating with SQL Server Agent for MLOps
• Machine Learning in the Cloud with Azure
Overview of Azure Machine Learning
Integrating SQL Server with Azure Services
Building and Deploying Models in the Cloud
• Design Patterns for Machine Learning Workloads
Identifying Suitable ML Design Patterns
Implementation of Common ML Patterns in SQL Server
Case Studies and Practical Applications
• Monitoring and Managing ML Models
Performance Monitoring Using SQL Server Tools
Model Management and Lifecycle
• Security and Compliance
Understanding Security in SQL Server for ML
Data Privacy and Compliance Considerations
• Capstone Project
Designing an End-to-End Machine Learning Solution
Presentation and Review of Projects
• Recap and Future Directions
Summary of Key Concepts
Emerging Trends in SQL Server and Machine Learning

---

Subjects

Conference Talks