What Is Data Science| Data Science for Beginners | Introduction to Data Science

Data Science can be simplified in definition as a broad term for methodologies of collecting, processing, visualizing data and making use of information for various purposes. It is Multi-disciplinary and cover a wide range of interest areas. Also known as a uniform concept of statistics, data analysis, machine learning and other methods to analyze, understand …

Machine Learning Basics | What Is Machine Learning? | Introduction to Machine Learning

Humans learn from past experiences, while Machines follow instructions. So, humans train machines to learn from past data and that’s what Machine Learning is all about. Machine learning is a subset of Artificial Intelligence. Machine learning enhance machines with the ability to learn autonomously based on observation and analysis within a given data set without specific …

SQL SELECT DISTINCT

SQL DISTINCT clause is used to remove duplicate records. SELECT DISTINCT returns distinct(different) values. DISTINCT can be used with aggregate functions: COUNT, AVG, MAX, MIN. Syntax: SQL SELECT DISTINCT based on one column You can SELECT DISTINCT values from one column in a table. Below is the syntax. SQL SELECT DISTINCT based on multiple columns …

SQL SELECT Statement

The SELECT statement in SQL is used to retrieve data from a database. Mostly used to retrieve all data in a table and data from desired table columns (fields). SELECT Syntax In the above syntax, you are selecting data from exact columns or fields indicated as column1, column2, column3 and so on. To select all …

What is a Database?

A Database is a collection of unknown figures known as data. Databases are usually organized and un-organized data. Databases also contain rows(record) and columns(field). Company’s both large and small rely heavily on databases to power their applications. Databases store large amounts of data such as:  user id’s, usernames, email addresses, healthcare data, product information, sales …

What is SQL?

SQL stands for Structured Query Language. SQL is used to store, query, modify, manipulate and retrieve data stored in a relational database. Usually pronounced as “ess-que-ell”. According to ANSI (American National Standards Institute), it is the language for relational database management systems. All relational database systems (RDBMS) accept the use of SQL (MS Access, MySQL, …