Skip to content
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
The Glit Experience A website where I can show my knowledge and understandings.
The Glit Experience A website where I can show my knowledge and understandings.
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
news, daily newspaper, press-1172463.jpg
Database Design

HackerNews – Database Design

A star schema is commonly used...
glithanDec 26, 2023Dec 26, 2023
Python

SQLAlchemy

Unlike ODBC and DSN, SQLAlchemy is...
glithanNov 24, 2023Nov 25, 2023
Python

What is .env file?

A .env, or environment file, is...
glithanNov 24, 2023Nov 25, 2023
Python

Calling Basic API with Python

An Application Programming Interface (API) is...
glithanNov 24, 2023Nov 25, 2023
Python

Printing and Declaring Variables in Python

Python! One of the most used...
glithanAug 26, 2023Aug 26, 2023
businessman, boxes, transport-2108029.jpg
SQL

SQL in Business!

By using different SQL elements such...
glithanAug 9, 2023Mar 4, 2024
hands, friendship, friends-2847508.jpg
SQL

Grouping the Counts in SQL

There are a ton of different...
glithanJul 29, 2023Jul 31, 2023
SQL

Entering the Inner Join

Now, just as what is said,...
glithanJul 28, 2023Jul 31, 2023
app, application, arrow-1646213.jpg
SQL

What is a Left-Join in SQL?

As SQL is a programming language...
glithanJul 10, 2023Jul 31, 2023
12
  • Home
  • About this Site
  • SQL
  • Python
  • Project – HackerNews
Copyright © 2025 - Yuki Blogger Theme By WP Moose