Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on Apr 14, 2022

• 365 sql just exploring

  ptyadana

  committed
  df39adb

Commits on May 17, 2021

• completed till constraints

  ptyadana

  committed
  d5462ca

• completed till Storing Arrays

  ptyadana

  committed
  16c5d76

Commits on May 9, 2021

• completed till Database Organization

  ptyadana

  committed
  3b38cc8

Commits on May 8, 2021

• completed subqueries

  ptyadana

  committed
  f81a6b0

• completed till Indexes

  ptyadana

  committed
  d4978af

Commits on May 7, 2021

• completed till VIEWS

  ptyadana

  committed
  4864658

Commits on May 6, 2021

• completed till Framing window function

  ptyadana

  committed
  c5fcc6a

Commits on May 5, 2021

• completed till GROUPING SETS

  ptyadana

  committed
  8ded6c6

Commits on May 4, 2021

• add Complete SQL & Databases - ZTM

  ptyadana

  committed
  390a952

• SQL Deep Dive module completed

  ptyadana

  committed
  2a5ab85

Commits on May 3, 2021

• Deep Dive - till operator precedence

  ptyadana

  committed
  a8f2e7a

Commits on Mar 4, 2021

• add Tableau profile and learning paths

  ptyadana

  committed
  d34a547

Commits on Jan 20, 2021

• add Advanced SQL for Application Development

  ptyadana

  committed
  bb5460b

• designing for maintainability

  ptyadana

  committed
  8d418da

• database reliability - error trapping

  ptyadana

  committed
  58059db

• designing for scalability - partitioning data

  ptyadana

  committed
  a037694

• Object Relational Mapping with SQL Alchemy

  ptyadana

  committed
  6d8163b

• requirements

  ptyadana

  committed
  cba3938

• Indexing table challenges completed

  ptyadana

  committed
  079e3a1

• add psycopg2

  ptyadana

  committed
  e2900e6

• update readme

  ptyadana

  committed
  3b79523

• advanced querying with sql, setting environment variables, parameterizing

  ptyadana

  committed
  b009e95

• Advanced SQL for Application Development Initail commit

  ptyadana

  committed
  ef0e18d

Commits on Jan 19, 2021

• add Advanced SQL for Data Science - Time Series

  ptyadana

  committed
  67d1c0b

• Exponential Moving Average

  ptyadana

  committed
  2dd6432

• forecasting with linear regression

  ptyadana

  committed
  5ecc760

• Moveing Average and Weighted Moving Average

  ptyadana

  committed
  3516113

• Common Table Expression, aggregrates over windows, comparion with perivous period

  ptyadana

  committed
  b875f25

• Rank() and Percent_Rank()

  ptyadana

  committed
  1efa950

• Windows Function - Lead() and Lag()

  ptyadana

  committed
  1c57927

• modeling time series data completed

  ptyadana

  committed
  9d3a703

• indexing using Utilization dataset

  ptyadana

  committed
  e09a9b3

• partition Data and query Partitioned Table (location-temp dataset)

  ptyadana

  committed
  ecc9e3d

• partition Data and query Partitioned Table (location-temp dataset)

  ptyadana

  committed
  cb79987

Pagination

PreviousNext