Deep Neural Network as SQL+Python

Date: 2025.01.19
Time: 18:00
Location: Online
Part of PyWeb
register

Schedule

Deep Neural Network as SQL+Python by Netanel Stern
Language: Hebrew
Length: 20 min

Short Outline: DNN with SQL + Python using Built-in SQL Functions

  1. Data Preprocessing in SQL:
    • Use SQL's built-in functions (SUM(), AVG(), ROUND(), etc.) to perform calculations directly in the database.
  2. Fetch Processed Data in Python:
    • Execute SQL queries with processed results using libraries like pandas and sqlalchemy.
  3. Feature Preparation in Python:
    • Split the SQL output into features (X) and targets (y), normalize data, and handle missing values.
  4. Build and Train DNN Model:
    • Create a neural network with libraries like TensorFlow/PyTorch.
    • Train using preprocessed features as input.
  5. Store Results in SQL:
    • Save predictions or results back into the database for further analysis.
video (in Hebrew)

Schedule to copy

* Start time: 18:00

* Deep Neural Network as SQL+Python by Netanel Stern

Language: Hebrew

Length: 20 min

Short Outline: DNN with SQL + Python using Built-in SQL Functions

  1. Data Preprocessing in SQL:
    • Use SQL's built-in functions (SUM(), AVG(), ROUND(), etc.) to perform calculations directly in the database.
  2. Fetch Processed Data in Python:
    • Execute SQL queries with processed results using libraries like pandas and sqlalchemy.
  3. Feature Preparation in Python:
    • Split the SQL output into features (X) and targets (y), normalize data, and handle missing values.
  4. Build and Train DNN Model:
    • Create a neural network with libraries like TensorFlow/PyTorch.
    • Train using preprocessed features as input.
  5. Store Results in SQL:
    • Save predictions or results back into the database for further analysis.
register