This note is a Nexus-style note. It has other names like _index_ or _Map of Content (MOC)_ but I like _Nexus_ # Master SQL Course ## Course Portal Link [Roadmap.sh](https://course.roadmap.sh/sql/introduction/basics-of-databases) [[Nexus - DataX]] | [[SQL]] ## Course Glossary ## Course Topics The contents of the course ### 1. [[Master SQL - Introduction]] >[! info] Introduction key takeaways > >- DB's are a way to organize data while DBMS's are what is used to CRUD the data within a DB >- SQL is used to CRUD data in a relational DBMS >- SQL is declarative and is not a dbms in and of itself. >- SQL keywords build into SQL Clauses which then build into SQL Statements >- There are 5 types of queries. Each type is designed to accomplish specific things. >- Top three query types: DQL, DDL, DML ### 2. [[Master SQL - SQL Basics|SQL Basics]] >[! info] SQL Basics key takeaways >- [[COALESCE]], [[BETWEEN]], [[LIKE]], and [[WHERE]] ... [[IN]] are some of the best new keywords to know. ### 3. [[Master SQL - Manipulating Data| Manipulating Data]] ### 4. Defining Tables ### 5. Multi-Table Queries ### 6. Aggregate Functions ### 7. Scalar Functions ### 8. Subqueries and CTE's ### 9. Window Functions