All Posts

Submitted byheartin
onSat, 02/04/2017 - 23:10
0 comments

DDL stands for Data Definition Language, and these queries are used to create or manipulate the structure of the database and schemas. 

 

CREATE DATABASE

To create a database

CREATE DATABASE myDB;

 

CREATE TABLE

To create a table mytable in a DB mydb, with two columns col1 of VARCHAR(20), col2 of INT, where col2 is the Primary Key.

CREATE TABLE mydb.mytable(

col1 VARCHAR(20), col2 INT PRIMARY KEY);

or

Submitted byheartin
onSat, 02/04/2017 - 23:03
0 comments

You need to install and set up a relational database as mentioned in previous notes, for trying out the examples here. 

 

Submitted byheartin
onSat, 02/04/2017 - 22:59
0 comments

The WHERE clause lets you add further conditions on your query. 

SELECT * FROM Employees WHERE firstname = ‘Heartin’;

 

IN, AND/OR and BETWEEN and AND

Use IN to specify a set of acceptable values in where clause.

SELECT * FROM mytable WHERE col1 IN(“value1”,”value2”);

 

Use AND/OR to combine clauses, and NOT to negate conditions - AND insist all clauses to be true. OR insist any clause to be true.

Submitted byheartin
onSat, 02/04/2017 - 21:50
0 comments

Now that we know what is Big Data and data science, let us see how is related to the Big Data. 

Data that scale to Big Data are of particular interest in data science, although the discipline is not generally considered to be restricted to such data. Data science actually employs techniques and theories drawn from many fields such as nanotechnologies, physics, robotics, mathematics, statistics, information theory and information technology.

 

Submitted byheartin
onSat, 02/04/2017 - 21:48
0 comments

Any discussion about Big Data will not be complete without discussing about Data Science and its relation with Big Data.

Data Science can be considered as the extraction of knowledge from large volumes of data that are structured (e.g. RDBMS, Excel) or unstructured (e.g. emails, videos, photos, social media, and other user-generated content). Data Science may be considered as a continuation of the field of data mining and predictive analytics.

Pages

 

Contact

We learn together, do innovations and then document them.

Offline Contact
We connect physically only in Bengaluru currently, but most of our activities happen online. Please follow us here or in social media for more details.
WhatsApp (Primary): (+91) 7411174113
WhatsApp (Secondary): (+91) 7411174114

Business newsletter

Complete the form below, and we'll send you an e-mail every now and again with all the latest news.

About Cloudericks

Team Cloudericks is a community to learn about and master cloud computing. Current learning focus is on AWS cloud.

We believe that knowledge is useless unless you share it; the more you share, the more you learn. Visit Cloudericks.

Recent comments

Photo Stream