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

Course Content

SQL in Python Projects

SQL in Python Projects

1. Development Environment on Your PC
Python Interpreter PyCharm InstallingCode Analysis ToolsCreating a ProjectFile System
2. Introduction to SQLite
What is SQLite ?What is sqlite3 Library?Connect and cursor Create a Simple TableChallenge 1: First table
3. CRUD
What is CRUD?Creation OperationsChallenge 2: CreationRead OperationsChallenge 3: Read Update OperationsChallenge 4: UpdateDelete OperationsChallenge 5: Delete
4. More About SQLite
PRIMARY KEYData TypesChallenge 6: Table Design

bookChallenge 4: Update

Complete all parts of the task in sequence

  • 🔖 Use your code from Challenge 3: Creation;
  • 📼 Add a few more records to the users table;
  • 🔄 Update email in record from the users table where id = 1;
  • 📃 Get all entries from the users table;
  • 🎞 Output all records from users tables;
  • 🪖 Save the changes;
  • 🔑 Close the database connection.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 7
some-alt