sweta3197/365-data-science-sql

How sweta3197/365-data-science-sql works

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.

Components 32

SQL Foundations

SQL Command Categories Section_0-Introductions/DQL vs. DDL vs. DML vs. DCL.md

Schema and Data Changes

Create Objects Section_1/section_1_1_create.sql
Alter Objects Section_1/section_1_2_alter.sql
Insert Data Section_1/section_1_3_insert.sql
Update Data Section_1/section_1_4_update.sql
Delete and Truncate Section_1/section_1_5_delete_and_truncate.sql
Merge Data Section_1/section_1_6_merge.sql
Drop Objects Section_1/section_1_7_drop.sql

Temporal Data

Date-Time Basics Section_2/section_2_1_datetime_intro.sql
Date-Time Types Section_2/section_2_2_different_datetime_types.sql
Time Zones Section_2/section_2_3_timezones.sql
Intervals Section_2/section_2_4_intervals.sql

Specialized Types

Enumerated Types Section_3/section_3_1_enumerated_type.sql
Arrays Section_3/section_3_2_array.sql
Range Types Section_3/section_3_3_range.sql
Interval Types Section_3/section_3_4_intervals.sql

Query Techniques

Window Functions Section_4/section_4_1_over.sql
Cross Joins Section_4/section_4_2_cross_join.sql
Lateral Joins Section_4/section_4_3_lateral_join.sql
Cross Lateral Joins Section_4/section_4_4_cross_lateral_join.sql
COALESCE Section_4/section_4_5_coalesce.sql
CASE Expressions Section_4/section_4_6_case.sql
Concatenation Section_4/section_4_7_concatenation.sql
Recursive CTEs Section_4/section_4_8_recursive_ctes_and_hierarchical_data.sql
Practice Questions Section_7-Questions/section_7_4_question_4.sql

Modeling and Programming

Normalization Section_5/section_5_1_data_normalization.sql
Star and Snowflake Schemas Section_5/section_5_2_star_schema_snowflake_schame.sql
Procedures and Functions Section_6/section_6_1_stored_procedures_and_user_defined_functions.sql
Temporary Tables Section_6/section_6_2_temporary_table.sql
Views and Materialization Section_6/section_6_3_view_and_materialized_table.sql
Transactions Section_6/section_6_4_transactions.sql
Control Structures Section_6/section_6_5_sql_control_structures_and_variables.sql

Drawn by GitDiagram on November 12, 2026 from the repository's file tree, README and source files. Read as Markdown ·