This post will show you how to remove a database and collections from MongoDB. Bring the database into use using the “Use databaseName” command to
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.
Creating a DataFrame in SparkSQL
A DataFrame in Spark is a distributed collection of data with named columns. It’s similar to a table in a relational database or a data
MongoDB – Create and Insert Collection
This post aims to let you know how to add a record into a collection in MongoDB. Let’s create a “emp” collection (table) first. >
SparkSQL – Inserting and Loading Data
This post will cover how to work with tables, including how to create them, load data or insert values into them, and show the contents
SparkSQL – Creating and Dropping Tables
This tutorial will show you how to use sqlContext in Spark SQL to create and drop tables. Please review the previous sessions on “Spark” to
EMP and DEPT datasets for MongoDB
Since Oracle’s “EMP” and “DEPT” datasets are useful for practice, I’ve provided converted scripts for SQL Server and MySQL in previous articles. This tutorial will
Big Data & SQL 