Udemyintermediatept

Banco de Dados SQLite com Python 3

Learn SQLite3: database theory & practical application. Master data management with this hands-on course. Perfect for beginners!

4.7(19)
114students
4h 46m
Certificate
Rafael F. V. C. Santos, Ph.D.
Rafael F. V. C. Santos, Ph.D.Cientista de dados e Gestor Estratégico de Riscos

Course Content

Banco de Dados SQLite com Python 3 is an intermediate-level Udemy course taught by Rafael F. V. C. Santos, Ph.D.. It runs 4h 46m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 19 reviews, with 114 students enrolled. It is a paid course, first published January 2024.

Python SQLite3: A Complete Guide to Database Management

Unlock the power of local databases with Python SQLite3! This course provides a comprehensive, step-by-step guide to using the SQLite database system with Python.

What is Python SQLite3?

SQLite is a lightweight, file-based database system that requires no separate server. It’s perfect for projects where a full-fledged database server isn't necessary. The SQLite3 library is a built-in Python module that allows you to interact with SQLite databases directly from your Python code.

Why Use Python SQLite3?

  • Simplicity: Easy to learn and use, even for beginners.
  • Portability: Works on virtually any platform.
  • Embeddable: No need for a separate database server – everything is contained within a single file.
  • Ideal for: Small projects, embedded applications, and situations where a robust database system is overkill.

Key Concepts Covered:

  • Connecting to a Database: Learn how to establish a connection to your SQLite database.
  • Creating Tables: Master the art of defining and structuring your database tables.
  • Executing SQL Queries: Write and run SQL commands to retrieve, insert, update, and delete data.
  • Data Manipulation: Efficiently manage data within your SQLite database.
  • Filtering Data: Learn to use SQL WHERE clauses to retrieve specific data sets.
  • Updating Data: Modify existing data in your database.
  • Deleting Data: Remove unwanted data from your database.

What You'll Learn in This Course:

This course covers both beginner-friendly and advanced techniques for manipulating data using SQL within the Python SQLite3 environment. You'll gain practical skills in creating, reading, filtering, updating, and deleting data.

Ready to start working with local databases in Python? Watch the demonstration lessons and begin your journey to mastering Python SQLite3 today!

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

Databricks Delta Lake + METABASE: visualização e dados

by MSc Grimaldo Lopes | + 60.000 alunos de Oliveira

5.0(19)
5h
beginner
5.0(42)
12h 46m
beginner
5.0(139)
3h 33m
beginner
5.0(4)
59m
all