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

Зміст курсу

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

SQL in Python Projects

Challenge 2: CreationChallenge 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.
1. It is recommended to do ...
2. Some text It is how code looks like text again
3. Use such method. 

import sqlite3

# Connect to the database or create it
conn = sqlite3.connect('mydatabase.db')
    
# Create a cursor object
cursor = conn.cursor()
    
# Create the "users" table with fields
cursor.execute('''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER,
        user_name TEXT,
        email TEXT,
        password TEXT
    )
''')
query = "INSERT INTO users (id, user_name, email, password) VALUES (?, ?, ?, ?)"
# Insert a new record
user_data = (1, 'Alex', 'AlexMain@gmail.com', 'ZXCV2000')
cursor.execute(query, user_data)
    
# Save changes and close the connection
conn.commit()
conn.close()

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

Секція 3. Розділ 3
course content

Зміст курсу

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

SQL in Python Projects

Challenge 2: CreationChallenge 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.
1. It is recommended to do ...
2. Some text It is how code looks like text again
3. Use such method. 

import sqlite3

# Connect to the database or create it
conn = sqlite3.connect('mydatabase.db')
    
# Create a cursor object
cursor = conn.cursor()
    
# Create the "users" table with fields
cursor.execute('''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER,
        user_name TEXT,
        email TEXT,
        password TEXT
    )
''')
query = "INSERT INTO users (id, user_name, email, password) VALUES (?, ?, ?, ?)"
# Insert a new record
user_data = (1, 'Alex', 'AlexMain@gmail.com', 'ZXCV2000')
cursor.execute(query, user_data)
    
# Save changes and close the connection
conn.commit()
conn.close()

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

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