This repository contains my SQL projects.
- DML - INSERT, CREATE TABLE, UPDATE, RENAME, ALTER, DROP/DELETE
- QUERIES - SELECT/FROM, WHERE/ORDER BY : IN/NOT IN, BETWEEN, LIKE, IS NULL, ORDER BY, TOP N
- DATETIME, SORT, NESTING QUERIES
- GROUP BY/HAVING
- REGULAR EXPRESSION, TRANSACTION
- JOINS/UNIONS - JOIN, INNER/LEFT/RIGHT/OUTHER JOIN, UNION
In this folder I will present a project that I did during my degree, in which we constructed a table showing a restaurant, and then analyzed the data using queries.
This file is a collection of scripts and notes while I was learning SQL. I used with SQLITE