My Study notes
- 31 Jan 2023 » Snowflake - Time Dimension
- 17 Jan 2023 » Snowflake - Date Dimension
- 16 Jan 2023 » Snowflake - Create Snowflake Objects
- 24 Oct 2022 » Snowflake - Create Database Objects using Python
- 20 Oct 2022 » Snowflake - Python connectivty check
- 17 Oct 2022 » Snowflake - Architecture and Key Concepts
- 17 Sep 2021 » SingleStore - Architecture
- 16 Sep 2021 » SingleStore - Introduction
- 22 Mar 2019 » PY - To identify "Thursday" after second week "Tuesday" of a month
- 12 Nov 2018 » UNIX - Script to send status of Informatica workflows
- 24 Jun 2018 » UNIX - Commands
- 23 May 2018 » UNIX - Commands
- 13 May 2018 » UNIX - Commands
- 24 Apr 2018 » UNIX - Commands
- 15 Apr 2018 » UNIX - Commands
- 03 Apr 2018 » UNIX - Commands
- 28 Mar 2018 » UNIX - Commands - Files, kernel Interact, Env Variables, Work with vi
- 17 Mar 2018 » UNIX - Commands - Permissions, root, users, shutdown, docs, man pages
- 05 Mar 2018 » UNIX - Commands - dmesg, less, cp, sudo, vi, Permissions
- 12 Oct 2017 » SQL - Regular Expression
- 11 Oct 2017 » SQL - Retrieving Data Using Subqueries
- 09 Oct 2017 » SQL - Managing Data in Different Time Zones
- 05 Oct 2017 » SQL - Manipulating Large Data Sets
- 04 Oct 2017 » SQL - Managing Objects with Data Dictionary Views
- 03 Oct 2017 » SQL - Managing Schema Objects
- 28 Sep 2017 » SQL - Controlling User Access
- 27 Sep 2017 » SQL - Creating Other Schema Objects
- 25 Sep 2017 » SQL - Using DDL Statements to Create and Manage Tables
- 21 Sep 2017 » SQL - Manipulating Data
- 27 Jul 2017 » SQL - Set Operators
- 26 Jul 2017 » SQL - Subqueries
- 20 Jul 2017 » SQL - Displaying Data from multiple tables
- 19 Jul 2017 » SQL - Aggregated Data Using Group Functions
- 17 Jul 2017 » SQL - Conversion Functions
- 13 Jul 2017 » SQL - Single Row Functions
- 10 Jul 2017 » SQL - Restricting Data
- 05 Jul 2017 » SQL - SELECT Statement for retrieving data
- 29 Jun 2017 » SQL - Introduction
- 19 Apr 2017 » DW - Fact Table Design
- 18 Apr 2017 » DW - Physical Dimension Objects
- 24 Mar 2017 » DW - Dimension Design Consideration
- 11 Mar 2017 » DW - Dimension Design
- 09 Mar 2017 » DW - Dimensional Modeling Design
- 06 Mar 2017 » DW - OLTP vs OLAP