INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Add New Line in MySQL with Concat
We know what to retrieve when changing data into a different format or performing data analysis, but we may get stuck on how to access
Apache Impala – Introduction
Apache Impala allows you to run SQL queries on data stored in major Apache Hadoop file formats with high performance and low latency. Rather than
HUE GUI
Hue (Hadoop User Experience) is a open source and web-based interactive query editor with the most intelligent auto-completes and query editor components that enables users
Complete Courses – Big Data
“Big Data & SQL” published a number of articles over the year about big data and its ecosystem components. It’s time to make them as
HDFS Tutorial
Here are all of the HDFS articles that have been published on this website so far. It’s basically a collection of information organized in a
Big Data & SQL 