What is SQL?

RDBMS(Relational Database Management System); 관계형 데이터베이스

 

What is Database?

A database is a set of data stored in a computer.(컴퓨터에 저장된 데이터의 집합)

This data is usually structured in a way that makes the data easily accessible.(데이터에 접근하기 쉬운 상태로 저장된다)

 

What is Relational Database?

It uses a structure that allows us to identify and access data in relation to another piece of data in the database. 

Often, data in a relational database is organized into tables.

행과 열로 이루어진 각각의 테이블을 고유값(Primary Key)을 참조하여 서로 종속되는 관계(=연결하는것)를 표현하는 데이터 베이스 구조

데이터의 종속성을 관계(relationship)으로 표현

 

What is RDBMS?

A relational database management system (RDBMS) is a program that allows you to create, update, and administer a relational database. Most relational database management systems use the SQL language to access the database.

 

SQL 활용 분야

Analyzing User Churn

A churn rate is the percent of subscribers to a monthly service who have canceled.

Determining Web Traffic Attribution

UTM Parameters are special tags that site owners add to their pages to track what website a user was on before they reach the website.