570 results for “database”

Handling SQL Databases With PyQt: The Basics

Dec 02, 2020 intermediatedatabasesgui

In this step-by-step tutorial, you’ll learn how to use PyQt's built-in SQL support to create GUI applications that effectively manage SQL databases.


Enhance Your Flask Web Project With a Database

Dec 18, 2023 intermediatedatabasesflaskweb-dev

Adding a database to your Flask project elevates your web app to the next level. In this tutorial, you'll learn how to connect your Flask app to a database and how to receive and store posts from users.


Python and MongoDB: Connecting to NoSQL Databases

Mar 01, 2021 intermediatedatabases

In this step-by-step tutorial, you'll learn how to use Python to interface with the NoSQL database system MongoDB. You'll get an overview of the differences between SQL and NoSQL, and you'll also learn about related tools, including PyMongo and MongoEngine.


Python and MySQL Database: A Practical Introduction

Dec 28, 2020 intermediatedatabasesdata-science

In this tutorial, you'll learn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices and tips to prevent SQL injection attacks.


Embeddings and Vector Databases With ChromaDB

Nov 15, 2023 advanceddatabasesdata-sciencemachine-learning

Vector databases are a crucial component of many NLP applications. This tutorial will give you hands-on experience with ChromaDB, an open-source vector database that's quickly gaining traction. Along the way, you'll learn what's needed to understand vector databases with practical examples.


Build a Command-Line To-Do App With Python and Typer

Nov 08, 2021 intermediateprojectstestingtools

In this step-by-step project, you'll create a to-do application for your command line using Python and Typer. While you build this app, you'll learn the basics of Typer, a modern and versatile library for building command-line interfaces (CLI).


Introduction to Python SQL Libraries

Feb 24, 2020 basicsdatabasestools

In this step-by-step tutorial, you'll learn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases and perform common database queries using a Python application.


Data Management With Python, SQLite, and SQLAlchemy

Oct 14, 2020 intermediatedatabasesweb-dev

In this tutorial, you'll learn how to store and retrieve data using Python, SQLite, and SQLAlchemy as well as with flat files. Using SQLite with Python brings with it the additional benefit of accessing data with SQL. By adding SQLAlchemy, you can work with data in terms of objects and methods.


Data Engineer Interview Questions With Python

Dec 11, 2019 intermediatedatabasesdevops

This tutorial will prepare you for some common questions you'll encounter during your data engineer interview. You'll learn how to answer questions about databases, ETL pipelines, and big data workflows. You'll also take a look at SQL, NoSQL, and Redis use cases and query examples.


Build a Contact Book With Python, PyQt, and SQLite

Mar 10, 2021 intermediatedatabasesguiprojects

In this step-by-step project, you'll build a minimal contact book application using Python, with PyQt to build the application's GUI and SQLite to handle the database.


Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 2

Nov 16, 2022 intermediateapidatabasesflaskweb-dev

In this three-part tutorial series, you'll create a RESTful API from scratch to keep track of people and notes using the Flask web framework. You'll also test your API with Swagger UI API documentation. In part two, you'll implement a SQLite database to store your data permanently.


Build a URL Shortener With FastAPI and Python

May 18, 2022 intermediateapidatabasesprojectsweb-dev

In this step-by-step project, you'll build an app to create and manage shortened URLs. Your Python URL shortener can receive a full target URL and return a shortened URL. You'll also use the automatically created documentation of FastAPI to try out your API endpoints.


Build a Contact Book App With Python, Textual, and SQLite

Oct 09, 2024 intermediateprojects

In this tutorial, you'll be guided step by step through the process of building a basic contact book application. You'll use Python and Textual to build the application's text-based user interface (TUI), and then use SQLite to manage the database.


What Are CRUD Operations?

May 29, 2024 intermediateapidatabasesweb-dev

CRUD operations are the cornerstone of application functionality. Whether you access a database or interact with a REST API, you usually want to create, retrieve, update, and delete data. In this tutorial, you'll explore how CRUD operations work in practice.


Django Migrations: A Primer

Jan 09, 2019 basicsdatabasesdjangoweb-dev

In this tutorial, you’ll get comfortable with Django migrations and learn how to create database tables without writing any SQL, how to automatically modify your database after you changed your models, and how to revert changes made to your database.


Build an LLM RAG Chatbot With LangChain

Mar 06, 2024 intermediatedatabasesdata-science

Large language models (LLMs) have taken the world by storm, demonstrating unprecedented capabilities in natural language tasks. In this step-by-step tutorial, you'll leverage LLMs to build your own retrieval-augmented generation (RAG) chatbot using synthetic data with LangChain and Neo4j.


Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 3

Nov 21, 2022 intermediateapidatabasesflaskweb-dev

In this three-part tutorial series, you'll create a RESTful API from scratch to keep track of people and notes using the Flask web framework. You'll also test your API with Swagger UI API documentation. In part three, you'll use SQLAlchemy to provide the functionality to add notes to a person.


How to Move a Django Model to Another App

May 06, 2020 advanceddjangoweb-dev

In this step-by-step tutorial, you'll learn how to move a Django model from one app to another using Django migrations. You'll explore three different techniques and learn some helpful guidelines for choosing the best approach for your situation and needs.


Preventing SQL Injection Attacks With Python

Sep 30, 2019 intermediatebest-practicesdatabases

SQL injection attacks are one of the most common web application security risks. In this step-by-step tutorial, you'll learn how you can prevent Python SQL injection. You'll learn how to compose SQL queries with parameters, as well as how to safely execute those queries in your database.


How to Create an Index in Django Without Downtime

Apr 10, 2019 advanceddatabasesdjango

In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime.