Home Tags SQL

Tag: SQL

How to Carry Out Exploratory Data Analysis with MySQL

0
Exploratory data analysis (EDA) reveals the internal pattern of data. It is often used to validate hypotheses, verify certain theories and explore data sets...

Simplifying Statistics with SQL for Data Analysis

0
This is the second article in the series on data analysis. The previous article dealt with pivot tables. This article explores ways to find...

Why SQL Should Be Used for Data Analysis

0
A basic knowledge of SQL and its query language is essential for any aspiring data analyst and data scientist. This article discusses SQL and...

Database Programming in Python

5
For database programming, the Python DB API is a widely used module that provides a database application programming interface.

Apache Spark and Developing Applications Using Spark Streaming

0
Apache Spark is a unified analytics engine for Big Data processing, with built-in modules for streaming, SQL, machine learning and graph processing. This article...

A List of Developer-friendly Android Libraries

9
Android, by virtue of being open source, makes it easy for others to create useful libraries. This article lists twelve developer-friendly open source libraries. The...

Installing and Using PostgreSQL Modules

3
In this article, we will learn how to install and use the PostgreSQL modules chkpass, fuzzystrmatch, isn and hstore. Modules add different capabilities to...

Taming the Big Data Beast with Hadoop and Alternatives

5
Turn the clock back to 1970 -- the year in which Edgar Codd published the paper "A Relational Model of Data for Large Shared...

Cyber Attacks Explained: Web Exploitation

2
Websites are no longer merely about having an "Internet presence" today, but are also used for commercial transactions and to transfer sensitive data. Such...

Cyber Attacks Explained: Network Sniffing

5
In earlier articles in this series, we have explored denial of service attacks and packet spoofing. This month, let us focus on a wider...