42 Questions on SQL for all aspiring Data Scientists
Introduction SQL is a universal tool in data science. Irrespective of which language you use as your main tool – you need to know …
Database
Top 28 Cheat Sheets for Machine Learning, Data Science, Probability, SQL & Big Data
Overview Data Science is constantly evolving with new tools, frameworks and technologies Each tool/technique has its own unique use case along with features and …
Complete Guide on DataFrame Operations in PySpark
Overview Learn about DataFrames on the PySpark API DataFrames are a handy data structure for storing petabytes of data PySpark dataframes can run on …
SQL commands for Commonly Used Excel Operations
Introduction Learning SQL after Excel couldn’t be simpler! I’ve spent more than a decade working on Excel. Yet, there is so much to learn. …
Getting Mongo-ed in NoSQL manager, R & Python
Introduction I started my journey on Analytics Vidhya (AV) as a follower. AV, and now especially the discussion portal, always stay open in one …
All out beginner’s guide to MongoDB
Introduction Necessity is the mother of innovation! This is an old proverb, but it still holds damn good! Last decade has pushed the boundaries …
Basics of SQL and RDBMS – must have skills for data science professionals
If you meet 10 people who have been in data science for more than 5 years, chances are that all of them would know …
Data Science trends 2015 to help you plan your learning!
2014 is coming to an end shortly. What a glorious year it has been for technology and data science! Constant change, better products, faster …
NoSQL Databases : Simplified
My father always hesitates while making big ticket transaction online. He is always scared of machine making an error. Just imagine that you transfer …
Types of database management system and their evolution
Various researches have revealed that whenever we hear an object, we retrieve it using an image from our brain. For instance, if I ask …
