Tag: SQL
Getting Started with SQL Using SQLite Studio
Knowing how to code and manage related databases and database-driven applications is an important skill for any technology career. This article is designed to...
How to Carry Out Exploratory Data Analysis with MySQL
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
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
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
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
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
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
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
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
Websites are no longer merely about having an "Internet presence" today, but are also used for commercial transactions and to transfer sensitive data. Such...
