Data Science Tutorials

Applying data validation in Excel is simple: Open the 'Data' tab. Go to the 'Data Tools' group. Click on the 'Data Validation' button.

Learn about the Tableau Desktop and Tableau Server Architectures. Understand the core framework and data layers for advanced data management and insightful analytics.

Review three methods to add comments in SQL: single-line comments, multiline comments, and inline comments using the following syntax: --, /*, and */.

Learn about NoSQL databases - why NoSQL, how they differ from relational databases, the different types, and design your own NoSQL database using MongoDB.

Learn the statistical concept of correlation, and follow along in calculating and interpreting correlations for a sample dataset, in a step-by-step tutorial.

We'll fine-tune Llama 3 on a dataset of patient-doctor conversations, creating a model tailored for medical dialogue. After merging, converting, and quantizing the model, it will be ready for private local use via the Jan application.

Cohere offers powerful large language models for various language tasks through their user-friendly Playground or API.

Run LLaMA 3 locally with GPT4ALL and Ollama, and integrate it into VSCode. Then, build a Q&A retrieval system using Langchain and Chroma DB.

Dijkstra's algorithm helps find the shortest route between two points in a network, like finding the quickest path on a map, by checking and updating distances step-by-step.

Learn about SQL DDL commands and how they help define and manage the structure of database objects.

Database normalization is an important process used to organize and structure relational databases. This process ensures that data is stored in a way that minimizes redundancy, simplifies querying, and improves data integrity.

To connect to the Gemini 1.5 Pro API, obtain your API key from Google AI for Developers, install the necessary Python libraries, and send requests and receive responses from the Gemini 1.5 Pro model.