0% found this document useful (0 votes)

5 views42 pages

SQL For Data Science

The document is a tutorial on SQL, covering key concepts such as aliases, joins, group by, having clauses, order by, and subqueries. It explains different types of joins (INNER, LEFT, RIGHT, FULL, SELF) and how to use them, alongside the importance of grouping and filtering data with aggregate functions. Additionally, it discusses the differences between subqueries and joins, and introduces the integration of SQL with Python.

Uploaded by

nj555523

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

5 views42 pages

SQL For Data Science

Uploaded by

nj555523

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 42

shivamprajapati1734@gmail.

com
7OPHDBMN8E

SQL Tutorial

Sampriti Chatterjee (Great Learning)

Proprietary
This file content. © Great
is meant Learning. Alluse
for personal Rights
byReserved. Unauthorized use or distribution prohibited.
[email protected] only.
Sharing or publishing the contents in part or full is liable for legal action.
Alias in SQL

Alias concept is used in SQL to give temporary name to the table or the column of the

table

SQL For Data Science

Uploaded by

SQL For Data Science

Uploaded by

shivamprajapati1734@gmail.

Sampriti Chatterjee (Great Learning)

SELF JOIN 05 03 RIGHT JOIN

Demo for Inner join In SQL

from the right table

Demo for LEFT join In SQL

from the left table

Demo for RIGHT join In SQL

Demo for FULL join In SQL

A self helps to join with itself

Table join with itself

Demo for SELF join In SQL

Group by and Having concept in SQL

Group by statement helps to groups rows which has similar properties

Most of the time

Demo for Group by statement

Demo for Having Clause

Order by command is used to sort the data in an ascending order or in a descending

 And to sort the data into descending order need to

use desc keyword

Demo for Order by statement

Inner Query Outer Query

First inner query get executed

Get the result from inner query

Output of inner query added to the outer query

Outer query will get executed to get the final

 Nested subquery: Nested subquery first executes the

the outer query

 Correlated subquery: A correlated subquery reads every row

in a table and comparing values in each row against related data

Demo for Subqueries

Topic Subquery Join

A Subquery or Inner query or Nested

Subqueries break the complex query

Subqueries help or allow to use the As we have different types of joins so it

Subquery is easier to work with but

SQL with Python

Python is a popular high level, object oriented and interpreted language

But, why the Important Facts

[email protected] • He needed a short, unique, and slightly

Python is simple and beginner

1 Web development using

5 Graphical user interface

2 Length of the program is

1 Largest community for Learners and Collaborators 2 Open source

Easy to learn and usable flexibility

5 Supports Big Data, Machine Learning 6

This is the site to install Python -> https://www.python.org/downloads/

Site to install Python ->

Anaconda installation site->

Google collaboratory link->

SQL with Python

You might also like