Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge 1: First table | Introduction to SQLite
SQL in Python Projects

Challenge 1: First tableChallenge 1: First table

Complete all parts of the task in sequence

  • 📁 Create a new project in PyCharm;
  • 📝 Create a new python file;
  • 📚 Import the sqlite3 library;
  • 🗄 Create a new database;
  • 🤚 Create a cursor;
  • 📄 Create a table named articles with the following fields:
  • 🪖 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 the sqlite3 library
import sqlite3
    
# Create a new database (or connect to an existing one)
connection = sqlite3.connect("my_database.db")
    
# Create a cursor
cursor = connection.cursor()
    
# Create a table named "articles" with the specified fields
    cursor.execute('''
        CREATE TABLE articles (
            id INTEGER,
            title TEXT,
            content TEXT,
            author TEXT
        )
    ''')
# Save the changes and close the database connection
connection.commit()
connection.close()

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

Секція 2. Розділ 5
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 1: First tableChallenge 1: First table

Complete all parts of the task in sequence

  • 📁 Create a new project in PyCharm;
  • 📝 Create a new python file;
  • 📚 Import the sqlite3 library;
  • 🗄 Create a new database;
  • 🤚 Create a cursor;
  • 📄 Create a table named articles with the following fields:
  • 🪖 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 the sqlite3 library
import sqlite3
    
# Create a new database (or connect to an existing one)
connection = sqlite3.connect("my_database.db")
    
# Create a cursor
cursor = connection.cursor()
    
# Create a table named "articles" with the specified fields
    cursor.execute('''
        CREATE TABLE articles (
            id INTEGER,
            title TEXT,
            content TEXT,
            author TEXT
        )
    ''')
# Save the changes and close the database connection
connection.commit()
connection.close()

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

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