Software Company Database

Description

This repository contains SQL queries for creating and managing a software company database.

Table of contents

1. Creating Table
2. Inserting Values into Tables
3. Displaying columns
4. Retrieving Specific Columns for All Companies
5. Filtering Companies by Country
6. Counting the Number of Companies in Each Country
7. Updating Company Email Address
8. Deleting a Company
9. Finding Companies with Email Addresses Containing 'tech'
10. Ordering Companies by Name
11. Concatenating Address Fields
12. Finding Companies starting with T
13. Retrieving Companies with Null Email Addresses
14. Calculating Total Number of Companies
15. Finding Companies located in various cities

Installation

1. Microsoft SQL Server: Obtain the installer from the official Microsoft SQL Server downloads page and execute it to begin installation. https://www.microsoft.com/en-us/sql-server/sql-server-downloads
2. PostgreSQL: Access the installer from the official PostgreSQL downloads page and execute it to initiate the installation process. https://www.postgresql.org/download/
3. Oracle: Retrieve the installer from the official Oracle Database downloads page and execute it to start the installation procedure. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

Usage

1. Create the database with a suitable name.
2. Implement Use [database_name] command.
3. Write appropriate Sql commands to manage the database.

Contact

For any questions or feedback, feel free to reach out to swapnildas742@gmail.com.