SQL project to create, analyze and extract data
This projects is about working with variety of SQL such as PostgreSQL, MYSQL server or MySQL. Projects contain creating or restoring databases, creating schemas and making analysis on datasets. Analysis codes are from beginner level to advanced level codes such as window funcitons, CTEs, working with views etc. You can examine the dataset with SQL and help the store understand its business growth by answering simple questions.
- Postgre SQL
- PgAdmin4
- MS SQL server
- MS SQL server management studio
- MySQL