# sweta3197/365-data-science-sql architecture

> Architecture diagram of the GitHub repository sweta3197/365-data-science-sql, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-12). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sweta3197/365-data-science-sql
- Repository: https://github.com/sweta3197/365-data-science-sql

## Overview

This repository is a SQL learning collection: users study and run topic-specific SQL scripts covering schema and data changes, temporal and specialized types, query techniques, data modeling, and database programming. The files are organized by numbered sections, but the available evidence does not establish a required sequence or calls between scripts. The graph therefore maps the curriculum’s distinct topics without inventing runtime relationships; no README or source excerpts were provided.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_intro["SQL Foundations"]
  node_dql_ddl["SQL Command Categories"]
end

subgraph group_changes["Schema and Data Changes"]
  node_create["Create Objects"]
  node_alter["Alter Objects"]
  node_insert["Insert Data"]
  node_update["Update Data"]
  node_delete_truncate["Delete and Truncate"]
  node_merge["Merge Data"]
  node_drop["Drop Objects"]
end

subgraph group_temporal["Temporal Data"]
  node_datetime_intro["Date-Time Basics"]
  node_datetime_types["Date-Time Types"]
  node_timezones["Time Zones"]
  node_intervals["Intervals"]
end

subgraph group_types["Specialized Types"]
  node_enumerated["Enumerated Types"]
  node_arrays["Arrays"]
  node_ranges["Range Types"]
  node_type_intervals["Interval Types"]
end

subgraph group_queries["Query Techniques"]
  node_window["Window Functions"]
  node_cross_join["Cross Joins"]
  node_lateral["Lateral Joins"]
  node_cross_lateral["Cross Lateral Joins"]
  node_coalesce["COALESCE"]
  node_case["CASE Expressions"]
  node_concat["Concatenation"]
  node_recursive_ctes["Recursive CTEs"]
  node_questions["Practice Questions"]
end

subgraph group_modeling["Modeling and Programming"]
  node_normalization["Normalization"]
  node_schemas["Star and Snowflake Schemas"]
  node_procedures_functions["Procedures and Functions"]
  node_temporary["Temporary Tables"]
  node_views["Views and Materialization"]
  node_transactions["Transactions"]
  node_control["Control Structures"]
end

click node_dql_ddl "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_0-Introductions/DQL%20vs.%20DDL%20vs.%20DML%20vs.%20DCL.md"
click node_create "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_1_create.sql"
click node_alter "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_2_alter.sql"
click node_insert "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_3_insert.sql"
click node_update "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_4_update.sql"
click node_delete_truncate "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_5_delete_and_truncate.sql"
click node_merge "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_6_merge.sql"
click node_drop "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_7_drop.sql"
click node_datetime_intro "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_1_datetime_intro.sql"
click node_datetime_types "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_2_different_datetime_types.sql"
click node_timezones "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_3_timezones.sql"
click node_intervals "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_4_intervals.sql"
click node_enumerated "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_1_enumerated_type.sql"
click node_arrays "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_2_array.sql"
click node_ranges "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_3_range.sql"
click node_type_intervals "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_4_intervals.sql"
click node_window "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_1_over.sql"
click node_cross_join "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_2_cross_join.sql"
click node_lateral "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_3_lateral_join.sql"
click node_cross_lateral "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_4_cross_lateral_join.sql"
click node_coalesce "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_5_coalesce.sql"
click node_case "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_6_case.sql"
click node_concat "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_7_concatenation.sql"
click node_recursive_ctes "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_8_recursive_ctes_and_hierarchical_data.sql"
click node_normalization "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_5/section_5_1_data_normalization.sql"
click node_schemas "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_5/section_5_2_star_schema_snowflake_schame.sql"
click node_procedures_functions "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_1_stored_procedures_and_user_defined_functions.sql"
click node_temporary "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_2_temporary_table.sql"
click node_views "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_3_view_and_materialized_table.sql"
click node_transactions "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_4_transactions.sql"
click node_control "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_5_sql_control_structures_and_variables.sql"
click node_questions "https://github.com/sweta3197/365-data-science-sql/blob/master/Section_7-Questions/section_7_4_question_4.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dql_ddl toneBlue
class node_create,node_alter,node_insert,node_update,node_delete_truncate,node_merge,node_drop toneAmber
class node_datetime_intro,node_datetime_types,node_timezones,node_intervals toneMint
class node_enumerated,node_arrays,node_ranges,node_type_intervals toneRose
class node_window,node_cross_join,node_lateral,node_cross_lateral,node_coalesce,node_case,node_concat,node_recursive_ctes,node_questions toneIndigo
class node_normalization,node_schemas,node_procedures_functions,node_temporary,node_views,node_transactions,node_control toneTeal
```

## Components

### SQL Foundations

- [SQL Command Categories](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_0-Introductions/DQL%20vs.%20DDL%20vs.%20DML%20vs.%20DCL.md): `Section_0-Introductions/DQL vs. DDL vs. DML vs. DCL.md`

### Schema and Data Changes

- [Create Objects](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_1_create.sql): `Section_1/section_1_1_create.sql`
- [Alter Objects](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_2_alter.sql): `Section_1/section_1_2_alter.sql`
- [Insert Data](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_3_insert.sql): `Section_1/section_1_3_insert.sql`
- [Update Data](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_4_update.sql): `Section_1/section_1_4_update.sql`
- [Delete and Truncate](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_5_delete_and_truncate.sql): `Section_1/section_1_5_delete_and_truncate.sql`
- [Merge Data](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_6_merge.sql): `Section_1/section_1_6_merge.sql`
- [Drop Objects](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_1/section_1_7_drop.sql): `Section_1/section_1_7_drop.sql`

### Temporal Data

- [Date-Time Basics](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_1_datetime_intro.sql): `Section_2/section_2_1_datetime_intro.sql`
- [Date-Time Types](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_2_different_datetime_types.sql): `Section_2/section_2_2_different_datetime_types.sql`
- [Time Zones](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_3_timezones.sql): `Section_2/section_2_3_timezones.sql`
- [Intervals](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_2/section_2_4_intervals.sql): `Section_2/section_2_4_intervals.sql`

### Specialized Types

- [Enumerated Types](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_1_enumerated_type.sql): `Section_3/section_3_1_enumerated_type.sql`
- [Arrays](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_2_array.sql): `Section_3/section_3_2_array.sql`
- [Range Types](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_3_range.sql): `Section_3/section_3_3_range.sql`
- [Interval Types](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_3/section_3_4_intervals.sql): `Section_3/section_3_4_intervals.sql`

### Query Techniques

- [Window Functions](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_1_over.sql): `Section_4/section_4_1_over.sql`
- [Cross Joins](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_2_cross_join.sql): `Section_4/section_4_2_cross_join.sql`
- [Lateral Joins](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_3_lateral_join.sql): `Section_4/section_4_3_lateral_join.sql`
- [Cross Lateral Joins](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_4_cross_lateral_join.sql): `Section_4/section_4_4_cross_lateral_join.sql`
- [COALESCE](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_5_coalesce.sql): `Section_4/section_4_5_coalesce.sql`
- [CASE Expressions](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_6_case.sql): `Section_4/section_4_6_case.sql`
- [Concatenation](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_7_concatenation.sql): `Section_4/section_4_7_concatenation.sql`
- [Recursive CTEs](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_4/section_4_8_recursive_ctes_and_hierarchical_data.sql): `Section_4/section_4_8_recursive_ctes_and_hierarchical_data.sql`
- [Practice Questions](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_7-Questions/section_7_4_question_4.sql): `Section_7-Questions/section_7_4_question_4.sql`

### Modeling and Programming

- [Normalization](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_5/section_5_1_data_normalization.sql): `Section_5/section_5_1_data_normalization.sql`
- [Star and Snowflake Schemas](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_5/section_5_2_star_schema_snowflake_schame.sql): `Section_5/section_5_2_star_schema_snowflake_schame.sql`
- [Procedures and Functions](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_1_stored_procedures_and_user_defined_functions.sql): `Section_6/section_6_1_stored_procedures_and_user_defined_functions.sql`
- [Temporary Tables](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_2_temporary_table.sql): `Section_6/section_6_2_temporary_table.sql`
- [Views and Materialization](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_3_view_and_materialized_table.sql): `Section_6/section_6_3_view_and_materialized_table.sql`
- [Transactions](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_4_transactions.sql): `Section_6/section_6_4_transactions.sql`
- [Control Structures](https://github.com/sweta3197/365-data-science-sql/blob/master/Section_6/section_6_5_sql_control_structures_and_variables.sql): `Section_6/section_6_5_sql_control_structures_and_variables.sql`