Skip to content

Latest commit

 

History

History
28 lines (25 loc) · 1.77 KB

File metadata and controls

28 lines (25 loc) · 1.77 KB

SQL Operations

This repository contains all the basic SQL queries.

  • SQL technologies used:
    • SQLite3
    • MS SQL
    • PostgreSQL

CONTENTS

  • Datasets: Datasets used in the database
  • SQLite3: This file contains JupyterLab and SQLite3 connection settings and basic sql queries
  • Covid Analysis: Exploratory Covid-19 analysis with SQLite3 queries
  • SQL in 50 questions: This file contains 50 sample questions to better understand SQLite3
  • MS SQL Basic: This file contains the basic query structures of Microsoft SQL
  • P-SQL Basic: This file contains the basic query structures of PostgreSQL
  • P-SQL Intermediate: This file contains the intermediate query structures of PostgreSQL
  • P-SQL Terminal Commands: This file contains the command query structures in PostgreSQL in terminal
  • P-SQL in Python: This folder contains the operations to write PostgreSQL queries via Python.