Database Lessons

This repository provides educational materials and practical examples related to SQL and PostgreSQL. It also covers the usage of tools such as SQLite and pgAdmin 4. This repo is designed for those looking to gain knowledge about database management systems and SQL queries.

Contents

SQL Lessons: Basic SQL commands, querying methods, data manipulation, and Data Definition Language (DDL) topics.
PostgreSQL Lessons: Advanced features of PostgreSQL, data types, indexing, functions, and procedures.
SQLite Usage: Basic information and examples related to SQLite, a lightweight and portable database management system.
pgAdmin 4 Usage: A popular graphical interface tool for managing PostgreSQL databases.
JDBC Extension for VSCode: Integration of JDBC within Visual Studio Code for managing and interacting with databases.

Requirements

SQLite: Download SQLite
PostgreSQL: Download PostgreSQL
JDBC Extension for VSCode: Install from the VSCode Marketplace.

Installation and Usage

SQLite

1. Download and install SQLite from here.
2. To create a database with SQLite, use the sqlite3 command in your terminal or command prompt:
   sqlite3 mydatabase.db
3. Write and execute your SQL queries.

pgAdmin

1. Download and install pgAdmin from here.
2. Launch pgAdmin 4 and connect to your PostgreSQL server.
3. Create databases, manage tables, and execute your SQL queries.

JDBC Extension for VSCode

1. Install the JDBC extension for VSCode from the VSCode Marketplace.
2. Configure the extension to connect to your database. Follow these steps:

• Open VSCode and go to the Extensions view by clicking on the Extensions icon in the Activity Bar on the side.
• Search for "JDBC Database Client" and click Install.
• Open the command palette (Ctrl+Shift+P or Cmd+Shift+P) and search for JDBC: Configure Connections.
• Follow the prompts to configure your database connection settings.

3. Use the extension to manage your database, execute queries, and view results directly from within VSCode.

Examples

The repository includes example files and SQL queries covering the following topics:

Basic SQL Queries: SELECT, INSERT, UPDATE, DELETE
Data Definition: CREATE TABLE, ALTER TABLE, DROP TABLE
PostgreSQL Features: ARRAY, JSON, CTE (Common Table Expressions)
Data Management: Transaction management, backup, and restore

Contributing

If you would like to contribute to this project, you can submit pull requests or report issues on this repository.

1. Fork the repository.
2. Make changes in your own fork.
3. Review your changes and submit a pull request.

License

This project is licensed under the MIT License.

Contact

For inquiries, you can also reach out via my GitHub profile.