Srini

SQL Count Vs Count Distinct With Group By

Explained how to get records using COUNT and COUNT Distinct with Group By clause in SQL

How to Create AWS IAM User-Profile in Terraform

Here are commands to configure the profile in AWS CLI and make it available to Terraform.

How to Convert List to Table in Python

Here is a logic to convert List data to a Table of Sqlite database. It is helpful for data-analytics engineers.

How to Understand Data Streaming in Terms of Python

Here is an example of how data streaming works shown with python logic.

How to Write Logic in Python Equals to Linux [Tail -1]

You can write a program in python equal to Linux’s tail command. Here are the steps explained for your quick reading.

2 Exceptional SQL Queries Demonstrating Usage of AND and OR in WHERE Clause

SQL AND and OR logical operators how to use in WHERE clause explained with examples.

How to Get Array Dimension in Python [NumPy]

Here’s how to get Python array dimensions. Created the array in NumPy and explained the logic.

5 Must-read Professional Success Tips Now

Here are helpful professional success tips helpful for your career.

The True Difference Between Discrete and Continuous data

Here is the true difference between discrete and continuous data

DB2 DATE and Time Conversion: Top SQL Queries

SQL queries to convert DB2 date format using to_char and to_date functions. Also, given how to get the current date and time.

Your Absolute Guide to Hard link Vs Soft link in Linux

Here are examples to create hard links and symbolic links in Linux and the differences between these two.

How to Intersect Sets in Python: Best Example

Intersecting sets in python will result in common values present in those. Here’s an example of an intersection method that helps data science engineers.