SQL stands for Structured Query Language. SQL is a database management language for relational databases. SQL lets you access and manipulate databases. SQL queries are not case sensitive. (SELECT = select) Division of SQL: Data Manipulation Language (DML) is used to add, update or delete data . Examples: INSERT, DELETE and UPDATE. Data Definition Language (DDL) is used... Continue Reading →
Fashion is other name of confidence and comfort. Whatever your wear, wear as you were born in it.
As a Data Engineer you may come across a project where you need to Decrypt the PGP Encrypted files in order to get the data and apply transformation logic on it
Requirement: The main requirement is to be able to assign and predict House Price in a given location based on age of house, distance from Airport and number of conveniences stores within 5 km radius.
This post is to help you create a new login and password for the users who want to use the data in SQL database or Warehouse for Analysis and Reporting.
How to read .xlsx file: Step 1: In order to read .xlsx file, you need to have the library com.crealytics:spark-excel_2.11:0.12.2 installed in the Databricks cluster. Steps to install library com.crealytics:spark-excel_2.11:0.12.2 to Databircks cluster: Step 1: Select the Databricks cluster where you want to install the library. Step 2: Click on Libraries. Step 3: Click on... Continue Reading →
Cloud Computing refers to the process of making computing services available to users over the internet.
Big Data refers to the data which is nearly impossible to process using a single computer as it is huge in size, generated frequently and is in many different formats.
Reinforcement Learning is an area of Machine Learning which is applied when you don’t have training dataset and want the machine to learn from its experience.
Unsupervised Learning The basic idea of Unsupervised Learning is to feed machine with as much data as possible without providing any label on the data and letting machine group similar data together to form clusters and provide insights on them. In Unsupervised Learning, the learning algorithm tries to understand relationships between various inputs without any... Continue Reading →
In Supervised Machine learning, set of instances are provided to the learning Algorithm, each instance contains an input and an output. The Algorithm learns from these instances and builds a model which can then find output to any new input.
Machine Learning is a branch of Artificial Intelligence which focus on enabling computers to perform tasks based on data and with minimal human interference.
Ization 