Samenvatting

Summary Basics for data analysts

0 keer verkocht

Vak
Data Analysts

Instelling
Data Analysts

Basics to start with SQL for a data analyst

[Meer zien]

Voorbeeld 4 van de 37 pagina's

Bekijk voorbeeld

Geupload op 3 februari 2022
Aantal pagina's 37
Geschreven in 2021/2022
Type Samenvatting

€5,49

Ook beschikbaar in voordeelbundel v.a. €15,49

In winkelwagen

Opslaan

100% tevredenheidsgarantie
Direct beschikbaar na je betaling
Lees online óf als PDF
Geen vaste maandelijkse kosten

Ook beschikbaar in voordeelbundel (1)

Data analytics for beginners

€ 17,86 € 15,49 4 items

1. Samenvatting - Basics for data analysts
2. Samenvatting - Setting up a conda environment
3. Samenvatting - Python for data analysts
4. Samenvatting - Excel for data analysts
Meer zien

SQL for Data Analysts
What is SQL
Setting up the Environment
Files to Download
Installation
Dataset
Structure of an SQL environment
Servers
Databases
Schemas
Tables
Different Database Types
SQL Data Types
Basic Querying
Obtaining Data
SELECT
LIMIT
DISTINCT
WHERE
ORDER BY
Aliasing
Comments
Aggregations
GROUP BY
AVG
COUNT
COUNT (DISTINCT)
SUM
MIN
MAX
HAVING
Combining Data
Joins and Unions

SQL for Data Analysts 1

, UNION
JOIN (LEFT, INNER, OUTER, RIGHT)
Advanced Querying
Subquerying
Advanced Filtering
LIKE
Wildcard Operators
BETWEEN
IN
Advanced Aggregation
Window Functions
OVER and PARTITION BY
ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE
LAG
LEAD
Manipulating Tables
Basics
CREATE
DROP
ALTER
Views
Tips
Further Research
References

What is SQL
SQL (pronounced S.Q.L. or Sequel, no one really cares) stands for Structured Querying
Language and is a language that is used to query, form, and manipulate databases.

Setting up the Environment

SQL for Data Analysts 2

, Files to Download

SQL Course Public Downloads Folder - Google Drive

https://drive.google.com/drive/folders/1t1l7mcnhxN0rvYH-WTS
SSuwocyTujXAl?usp=sharing

Installation
For this tutorial we're going to be using SQLite which is a database engine that works in
a single application. In order to access it we'll be using DBeaver. DBeaver is an open-
source database manager that connects to almost all database engines.

NOTE: Use DBeaver Community, it's free

DBeaver
Free multi-platform database tool for developers, database administrators, analysts and all people who need to
work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server,
Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. This website uses cookies to
https://dbeaver.io/

Dataset
The dataset we'll be using is from the University of California Irvine's Machine Learning
Repository

Abstract: This data studies whether a person will accept the coupon recommended to him in different driving
scenarios Source: Tong Wang, tong-wang '@' uiowa.edu, University of Iowa Cynthia Rudin, cynthia '@'
cs.duke.edu, Duke University Data Set Information: This data was collected via a survey on Amazon
https://archive.ics.uci.edu/ml/datasets/in-vehicle+coupon+recommendation

Structure of an SQL environment
Servers

SQL for Data Analysts 3

, The computer that contains your database or databases. This is typically your highest
level of "container" for databases.

Databases
A database is a collection of Schemas and Tables that we can interact with.

Schemas
Schemas are the highest level of organization in many Databases and can contain
multiple tables.

Tables
Tables can be thought of in the same way you think about sheets in Excel. It's a
collection of columns and rows that we'll be interacting with.

Different Database Types
I'll be talking about SQL like it's a standardized language and although it technically is,
in practice SQL databases you'll most likely be interacting with are going to created and
run by major corporations who will sprinkle their own flavor of SQL on top of or in lieu of
standard SQL. The commands we'll be focusing in this course are pretty standard and
shouldn't be drastically different from that which you'll be using in most other databases.
Some of the biggest databases are listed below:

MySQL - Open Source - Created by Oracle

SQL Server - Created by Microsoft
PostgreSQL - Open Source

Oracle Database - Created by Oracle

SQL Data Types
Depending on the database type that you use, the datatypes that you'll be working with
will be different. Here are the basic types and what they might be referred to by in your
database.

Text types: Used to store text, can even store numbers as text

CHAR

SQL for Data Analysts 4

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, Bancontact of creditcard en je bent klaar. Geen abonnement nodig.

Focus op de essentie

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.