TebasMartinez / CS50SQL Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

This repository includes links, resources, my notes, and my solved problem sets for Harvard University's CS50 SQL: Introduction to Databases with SQL

cs50.harvard.edu/sql/

1 star 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
Week 0 - Querying		Week 0 - Querying
Week 1 - Relating		Week 1 - Relating
.gitignore		.gitignore
README.md		README.md

Repository files navigation

CS50 SQL

Index

Week 0 - Querying

SELECT
LIMIT
WHERE
- =, >, <, >=, <=, != <>, NOT
- AND
- OR
- ()
- IS NULL, IS NOT NULL
- LIKE, %, _
- BETWEEN ... AND ...
ORDER BY ... ASC / DESC
Aggregate functions:
- COUNT
- AVG
- MIN
- MAX
- SUM
DISTINCT

Week 1 - Relating

Relationships:
- One to one.
- One to many.
- Many to many.
Subqueries.
Joins.
- INNER, LEFT, RIGHT, FULL
- NATURAL JOIN
Sets.
- UNION
- INTERESCT
- EXCEPT
Groups.
- GROUP BY
- HAVING

About

This repository includes links, resources, my notes, and my solved problem sets for Harvard University's CS50 SQL: Introduction to Databases with SQL

cs50.harvard.edu/sql/

Report repository