You're reading from Data Science with .NET and Polyglot Notebooks Programmer's guide to data science using ML.NET, OpenAI, and Semantic Kernel

Product type Paperback

Published in Aug 2024

Publisher Packt

ISBN-13 9781835882962

Length 404 pages

Edition 1st Edition

Languages

Tools

Codespaces

Concepts

Artificial Intelligence

Author (1):

Matt Eland

View More author details

Table of Contents (22) Chapters

Preface

1. Part 1: Data Analysis in Polyglot Notebooks

2. Chapter 1: Data Science, Notebooks, and Kernels FREE CHAPTER

3. Chapter 2: Exploring Polyglot Notebooks

4. Chapter 3: Getting Data and Code into Your Notebooks

5. Chapter 4: Working with Tabular Data and DataFrames

6. Chapter 5: Visualizing Data

7. Chapter 6: Variable Correlations

8. Part 2: Machine Learning with Polyglot Notebooks and ML.NET

9. Chapter 7: Classification Experiments with ML.NET AutoML

10. Chapter 8: Regression Experiments with ML.NET AutoML

11. Chapter 9: Beyond AutoML: Pipelines, Trainers, and Transforms

12. Chapter 10: Deploying Machine Learning Models

13. Part 3: Exploring Generative AI with Polyglot Notebooks

14. Chapter 11: Generative AI in Polyglot Notebooks

15. Chapter 12: AI Orchestration with Semantic Kernel

16. Part 4: Polyglot Notebooks in the Enterprise

17. Chapter 13: Enriching Documentation with Mermaid Diagrams

18. Chapter 14: Extending Polyglot Notebooks

19. Chapter 15: Adopting and Deploying Polyglot Notebooks

20. Index

Why subscribe?

21. Other Books You May Enjoy

Connecting to databases with SQL

Relational databases such as SQL Server, Postgres, and Maria DB have been the lifeblood of businesses for over 50 years at the time of writing. This is due to their ability to store normalized data about various entities in an easily queryable manner, while ensuring that data follows a specific schema.

Recently, non-relational databases such as MongoDB, Apache HBase, Cassandra, Cosmos DB, and Couchbase have become popular with enterprises. Despite this, the fact remains that, in most organizations, if you need data, you probably need it from a relational database.

Polyglot Notebooks understands this and provides support to query relational databases, through a series of connectors for specific databases and a common connection architecture.

In this section, I’ll explore this by connecting to an Azure SQL database that I’ve set up for this chapter. Azure SQL is a variant of SQL Server, hosted on Microsoft Azure, but the concepts...