1-Structured Query Language Notes

• These are my personal study notes recorded in Obsidian for future reference!
• Please note that the syntax utilized in these notes is MySQL.

2- Repository Structure

2.1. Introduction

Topics covered in this section are:
• What is SQL.
• SQL vs Other Dialects.
• Relation Database Management Systems (RDBMS relational schema, relationships, constraints, data types)

2.2. Data Definition Language - DDL

Topics covered in this section are:
• What is DDL.
• Show Statement.
• Create Statement.
• Alter Statement (add, drop, truncate, rename).

2.3. Data Manipulation Language - DML

Topics covered in this section are:
• What is DDL and CRUD Operations.
• What is SQL.
• DML Conditions.
• DML Mathematical Operators.
• DML Operators.
• String, Date and Aggregate Functions.
• DML Query Organization.
• DML Join Relationships.
• Subqueries, CTE's, Views & Stored Routines.
• Indexes, Variables and Triggers.
• DML Window Functions.

2.3. Data Control Language - DCL

Topics covered in this section are:
• What is DCL (grant, revoke, commit, rollback).

2.4. SQL Interview Prep

• The notes is currently in progress.

3- Contributing

If you find flaws and or misinformation in topic notes you'd like me to correct, feel free to make a branch with your changes and submit a pull request so I can review them! I want these notes to be accurate and because I'm learning so much so quickly, I'm sure ther are notes which need fixing!

4- Resources

• I've utilized various resources, including:

4.1. Courses

4.1. 365datascience

• Udemy course link: https://www.udemy.com/course/sql-mysql-for-data-analytics-and-business-intelligence/

4.2. Colt Steele

• Udemy course link: https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/

4.2. Books

• SQL for data analysis.

• Grokking the SQL interview.