Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge 2: Creation | CRUD
SQL in Python Projects
course content

Conteúdo do Curso

SQL in Python Projects

SQL in Python Projects

1. Development Environment on Your PC
2. Introduction to SQLite
3. CRUD
4. More About SQLite

Challenge 2: Creation

Complete all parts of the task in sequence

  • 📁 Create a new project in PyCharm;
  • 📝 Create a new python file;
  • 📚 Import the sqlite3 library;
  • 🗄 Connect or create to the database;
  • 🤚 Create a cursor;
  • 📄 Create a table named users with the following fields:
  • 📼 Insert a new record (with values from example below) into the users table
  • 🪖 Save the changes;
  • 🔑 Close the database connection.

Tudo estava claro?

Seção 3. Capítulo 3
We're sorry to hear that something went wrong. What happened?
some-alt