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

Зміст курсу

SQL in Python Projects

SQL in Python Projects

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

bookChallenge 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.

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 3. Розділ 3
some-alt