전체 글

[SQL 배우기] Section 3. GROUP BY Statements

Aggregate function: take multiple inputs and return a single output AVG(), COUNT(), MAX(), MIN(), SUM() can only happen in the SELECT or HAVING clause ordering result of the aggregate function requires ORDER BY reference to the entire function GROUP BY: allows for the aggregation of columns by some category must appear right after a FROM or WHERE statement you can use an aggregate function with ..

[SQL 배우기] Section 2. SQL Statement Fundamentals

The Complete SQL Bootcamp for the Manipulation and Analysis of Data | Udemy SELECT: most common statement used to retrieve information from a table SELECT column_name FROM table_name using * instead of the column name retrieves all the columns separate column names by a comma for multiple columns using capital letters for SQL keywords helps with visualization SELECT DISTINCT: used to return dist..

[SQL 배우기] Section 1. Course Introduction

The Complete SQL Bootcamp for the Manipulation and Analysis of Data | Udemy Database: systems that allow users to store and organize large amounts of data made up of tables that consist of columns and rows SQL(Structured Query Language): programming language used to communicate with the database pgAdmin: a Query Tool can be used to perform queries on the database

[Kubernetes 배우기] Section 9. Kubernetes on Cloud

Kubernetes for the Absolute Beginners - Hands-on | Udemy The hosted cloud solution allows for the maintenance of VMs, which makes it easy to scale and manage. Microsoft Azure Amazon AWS Google Cloud Google Kubernetes Engine (GKE) The cluster can be created easily by configuring it in the Google Cloud console The load balancer is configured automatically by using Google’s load balancer. Amazon El..