SQL 101

Welcome to SQL 101. From beginner to advanced, to interview questions, this repository aims to be your complete guide to learning and mastering SQL.

So please, let your journey into SQL database programming begin!

Sylabus

1. Querying Data - SELECT, FROM, PRAGMA, WHERE, AND, ORDER BY, ASC, DESC

This workbook covers the basics of querying data with examples for each of the keywords listed as well as the three diffent types of fetch functions used in SQLite and how to connect to a database.

2. More Querying Data - COUNT, DISTINCT, GROUP BY, MAX, MIN SUM, AVG

This workbook covers counting rows and unique values and also grouping data. Also finding the minimum, maximum, sum and average of columns or groups of data.

3. Create, Read, Update, Delete - CREATE, UPDATE, DELETE, NOT LIKE, LIKE, NOT NULL, NULL, IS, INSERT, DROP TABLE

This workbook covers the CRUD database staples. How to create data, read data, update that data and how to delete it.

4. More on Tables: PRIMARY KEY, AUTOINCREMENT, INT, INTEGER, BIGINT, CONSTRAINT, UNIQUE, VARCHAR, TIMESTAMP, DEFAULT CURRENT_TIMESTAMP

This workbook covers primary keys and why they are important along with a few more useful things to know when creating tables, including tracking the date and time a row was added.

Enjoy and please suggest any improvements to the curriculum you can think of.

All words are my own. No LLMs were used to write any of the explantions.