Skip to content

Instantly share code, notes, and snippets.

@mgramin

mgramin/sql_educational_plan.md

Last active September 27, 2022 16:43
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mgramin/ef19e4a68106b18ea10af7506b8126e8 to your computer and use it in GitHub Desktop.
Save mgramin/ef19e4a68106b18ea10af7506b8126e8 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Educational Plan
Raw
sql_educational_plan.md

SQL educational plan

0. Setup environment

Topics:

  • What is DBeaver (GUI tool for working with databases)?

Tasks:

Links

1. Create Table

2. Insert Data

3. Select Data

4. Data modeling

Topics:

  • What is data modeling?
  • Types of data model
  • What is ER diagram?

Tasks:

  • Create simple ER diagram for study project

Example:

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE-ITEM : contains
    CUSTOMER }|..|{ DELIVERY-ADDRESS : uses

3. Create a database

Topics:

Tasks:

4. Create a schema

Topics:

Tasks:

5. Create tables

Topics:

  • What is a table?

Tasks:

  • Create tables based on our ER diagram

6. Import/Export data

Topics:

Tasks:

Links

7. Simple queries

8. Queries with joins

Links

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment