Course Content
SQL in Python Projects
SQL in Python Projects
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.
Thanks for your feedback!