SQL Portfolio: Nasdaq Baltic Shares Database

Overview

This repository showcases my SQL skills through the creation and manipulation of a database for Nasdaq Baltic shares. It includes schema definitions, data insertion, and complex views.

Database Structure

• Database: NasdaqBaltic_shares
• Tables:
  • shares: Stores detailed information about each share, including prices and trading volumes.
  • stock_info: Contains additional information about each stock, such as industry and market placement.
• View:
  • CombinedStockData: A view that combines data from both tables to provide a comprehensive overview of stock performance and details.

SQL Features Demonstrated

• Database and table creation.
• Data insertion with transaction handling.
• View creation for data analysis.
• Complex SQL queries combining multiple tables.