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.

5. Joins - INNER JOIN, LEFT JOIN, LEFT OUTER JOIN, UNION ALL, UNION, AS, CROSS JOIN, NATURAL JOIN

This workbook covers the many ways you can join one or more tables together for a variety of reasons. It also covers the AS keyword and UNION functions for aliases and combined SELECT queries.

6. Data Types - STRICT, INT, TINYINT, SMALLINT, REAL,FLOAT, DOUBLE, TEXT, CHAR, VARCHAR, BOOLEAN, BIT, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, BLOB, JSON, ARRAY, ENUM, SERIAL

This workbook covers the many data types used in SQL from common ones such as TEXT and INTEGER to more niche ones such as SERIAL and ARRAY.

7. Math Functions - ABS, ROUND, RANDOM, TOTAL, SQRT, SQUARE, CEILING, FLOOR, POWER, EXP, LOG, MOD, COS, SIN, TAN, PI

This workbook covers the most commonly used math functions, as well as many other useful ones, such as the trigonometry trio (Sin, Cos, Tan), Pi, Exp, Log and more.

8. String Functions - CONCAT, CONCAT_WS, LENGTH, CHAR_LENGTH, LEN, SUBSTR, SUBSTRING, RIGHT, LEFT, UPPER, LOWER, INITCAP, TRIM, LTRIM, RTRIM, REPLACE, INSTR, CHARINDEX, POSITION, LOCATE

This workbook covers functions to modify, add, search and measure strings in various ways. Also the use of triple quotations """ """ in writing SQL and the Pandas read_sql function.

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