GitHub - wonkycode/sql4datascience: Code for my YouTube course on SQL for Data Science

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
01 Introduction to Databases.ipynb		01 Introduction to Databases.ipynb
02 Relational Database Model.ipynb		02 Relational Database Model.ipynb
03 What is SQL.ipynb		03 What is SQL.ipynb
04 Installing MySQL.ipynb		04 Installing MySQL.ipynb
05 SELECT Statement.ipynb		05 SELECT Statement.ipynb
06 LIMIT and OFFSET.ipynb		06 LIMIT and OFFSET.ipynb
07 ORDER BY.ipynb		07 ORDER BY.ipynb
08 DISTINCT.ipynb		08 DISTINCT.ipynb
09 WHERE Clause.ipynb		09 WHERE Clause.ipynb
10 Logical Operators.ipynb		10 Logical Operators.ipynb
11 Aggregate Functions.ipynb		11 Aggregate Functions.ipynb
12 GROUP BY Clause.ipynb		12 GROUP BY Clause.ipynb
13 HAVING Clause.ipynb		13 HAVING Clause.ipynb
14 What are JOINS.ipynb		14 What are JOINS.ipynb
15 Inner Join.ipynb		15 Inner Join.ipynb
16 LEFT JOIN.ipynb		16 LEFT JOIN.ipynb
17 RIGHT JOIN.ipynb		17 RIGHT JOIN.ipynb
18 FULL OUTER JOIN.ipynb		18 FULL OUTER JOIN.ipynb
19 CROSS JOIN.ipynb		19 CROSS JOIN.ipynb
20 SubQueries.ipynb		20 SubQueries.ipynb
21 What is Data Manipulation Language.ipynb		21 What is Data Manipulation Language.ipynb
22 INSERT Statement.ipynb		22 INSERT Statement.ipynb
23 UPDATE Statement.ipynb		23 UPDATE Statement.ipynb
24 DELETE Statement.ipynb		24 DELETE Statement.ipynb
25 Data Definition Language.ipynb		25 Data Definition Language.ipynb
26 CREATE Statement.ipynb		26 CREATE Statement.ipynb
27 ALTER Statement.ipynb		27 ALTER Statement.ipynb
28 DROP Statement.ipynb		28 DROP Statement.ipynb
29 TRUNCATE Statement.ipynb		29 TRUNCATE Statement.ipynb
30 Data Control Language.ipynb		30 Data Control Language.ipynb
31 Transaction Control Language.ipynb		31 Transaction Control Language.ipynb
all commands.sql		all commands.sql
er1.png		er1.png
er2.png		er2.png
highlevel.png		highlevel.png
index.png		index.png
table.png		table.png
types.JPG		types.JPG
types.png		types.png