SQLite_Lab_Activities.pptxvc vcvccvcvccvvcvcvc

vcvccvvc

1. Getting Started with SQLite Guided Installation, Schema Creation & VS Code Integration Duration: 150 Minutes

2. Activity 1: Guided Installation and First Database (60 mins) Objective: ✅ Ensure every student has a working SQLite environment. Outcome: 💡 Students will install SQLite and create their first database file.

3. Step-by-Step Installation Guide 1. Visit https://www.sqlite.org/download.html 2. Download the precompiled binaries for your OS 3. Add SQLite to your system PATH (if required) 4. Verify installation using: sqlite3 --version

4. Setting Up in VS Code Recommended Extension: SQLite (by alexcvzz) Features: - Graphical table explorer - Query editor with syntax highlighting - Data grid view for results

5. Creating the First Database Commands in Terminal: cd <your project folder> sqlite3 my_first_database.db Explanation: - Creates a new database file - Opens the SQLite command-line shell - Prompt appears as: sqlite>

6. Exploring the SQLite Shell Try these dot commands: .help -- view available commands .tables -- list all tables .quit -- exit the shell Note: Commands beginning with '.' are specific to SQLite, not SQL.

7. Activity 2: Interactive Schema Creation (60 mins) Objective: ✏️ Practice DDL commands in SQLite Outcome: 📋 Students will create and inspect a table schema

8. Creating a Table CREATE TABLE Contacts ( ContactID INTEGER PRIMARY KEY, FirstName TEXT, LastName TEXT, Email TEXT UNIQUE ); Key Points: - INTEGER PRIMARY KEY = auto-increment field - UNIQUE = prevents duplicate entries

9. Inspecting the Schema Commands: .schema Contacts Result: Shows table creation SQL Insert Sample Data: INSERT INTO Contacts (FirstName, LastName, Email) VALUES ('Alice', 'Jones', ' [email protected] ');

10. Common Tips for Students 💡 End every SQL command with a semicolon (;) ⬆ Use the up arrow to recall previous commands 🧩 Share your screen if you face installation issues

11. Activity 3: Using the VS Code Extension (30 mins) Objective: 🎨 Learn to manage SQLite databases visually in VS Code Outcome: 👀 Browse schema and data using GUI tools

12. Explore the Database in VS Code Steps: 1. Open VS Code and your project folder 2. Press Ctrl + Shift + P → choose “SQLite: Open Database” 3. Locate my_first_database.db 4. Use the SQLITE EXPLORER sidebar to view tables 5. Right-click → Show Table to see data

13. Run Queries from VS Code Right-click database → “New Query” Example: SELECT * FROM Contacts; Displays results in a grid view.

14. Summary ✅ Installed SQLite successfully ✅ Created and viewed a database ✅ Practiced table creation and data insertion ✅ Explored the database with a VS Code extension

15. Next Steps 🚀 Upcoming topics: - DML Commands (INSERT, UPDATE, DELETE) - Querying data using SELECT - Constraints and Relationships