SQL for Data Science Tutorial | Data Science Tutorial | Edureka

SQL for Data Science Tutorial | Data Science Tutorial | Edureka

• 1.
  Copyright © 2017,edureka and/or its affiliates. All rights reserved.
• 2.
  WHY IS SQLNEEDED FOR DATA SCIENCE? WHAT IS SQL? BASICS OF SQL www.edureka.co HANDS-ON INTRODUCTION TO DATA SCIENCE
• 3.
  INTRODUCTION TO DATASCIENCE www.edureka.co
• 4.
  Did you knowthat we're generating more than 2.5 quintillion bytes of data each day? This pace of data generation is the reason behind the popularity of high-end technologies such as Data Science, Artificial Intelligence, Machine Learning and so on. Introduction To Data Science www.edureka.co Data Science is the process deriving useful insights from data in order to solve real-world problems.
• 5.
  WHY IS SQLNEEDED FOR DATA SCIENCE? www.edureka.co
• 6.
  SQL can beused to store, access and extract massive amounts of data in order to carry out the whole Data Science process more smoothly. Why Is SQL Needed For Data Science? www.edureka.co Data Science involves extracting, processing, and analysing tons of data. At present what we need are tools that can be used to store and manage this vast amount of data.
• 7.
  WHAT IS SQL? www.edureka.co
• 8.
  SQL stands forStructured Query Language is a querying language aimed to manage Relational Databases. What Is SQL? www.edureka.co SQL programming can be used to perform multiple actions on data such as: Querying Inserting Updating Deleting Extracting RDMS is a data management system where data is stored into different tables (columns and rows) and relations are established among the different data variables by using primary keys and so on.
• 9.
  www.edureka.co Open Source Supports large databases Customizable Supportsmultiple programming interfaces
• 10.
  www.edureka.co
• 11.
  BASICS OF SQL www.edureka.co
• 12.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE CREATE DATABASE name; USE name; Syntax Function: Creates a new database • CREATE DATABASE: This command creates a database • USE: Activate the database
• 13.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE CREATE TABLE name (variable1 data_type1, variable2 data_type2); Syntax Function: Creates a new table • CREATE DATABASE: This command creates a table containing the data variables. • Each variable must be defined w.r.t its data type
• 14.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE INSERT INTO name VALUES (value1, value2, value3, vlaue4..); Syntax Function: Inserts new data into a database • INSERT INTO: This command inserts values into the table. • Remember the values inserted must align with the defined data types.
• 15.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE SELECT * FROM table_name; Syntax Function: Extracts data from a database • SELECT * FROM: This command selects a specified table/column and extracts it. • The command can be modified to extract specific data.
• 16.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE Syntax Function: Updates data in a database • UPDATE: This command allows you to modify any values/variables stored in the table. • WHERE: Selects the variable/ value that you want to change UPDATE table_name SET variable1=‘ ’ WHERE condition;
• 17.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE Syntax Function: Deletes data from a database • UPDATE: This command allows you to delete values/ variables from a table. • WHERE: Allows you to pose a condition to delete a specific value. DELETE FROM table WHERE condition;
• 18.
  www.edureka.co CREATE DATABASE CREATE TABLE INSERTINTO SELECT UPDATE DROP TABLE DELETE Syntax Function: Deletes a table • DROP TABLE: This command is used to delete a table and all rows in the table DROP TABLE table_name;
• 19.
  DEMO www.edureka.co
• 20.
  Copyright © 2017,edureka and/or its affiliates. All rights reserved. www.edureka.co
• 21.
  www.edureka.co