Tutorial SQL - Select statements | Belajar PostgreSQL

Unlock semua videonya, dengan join Premium member di link berikut:
https://www.udemy.com/course/postgresql-pemula-sampai-mahir/?referralCode=8D13D85D4D34027B76BE

Dapatkan diskon Rp. 99,000.- dengan menggunakan kupon GAJIAN_JUNI_2022 untuk semua kelas ku di udemy untuk info lengkapnya kunjugin https://youtube.dimas-maryanto.com

Hai semuanya, di video kali ini kita akan Belajar Object Relational Database Management System (ORDBMS) dengan menggunakan PostgreSQL untuk Pemula sampai Mahir.

Pemateri:
Dimas Maryanto ([email protected])

folow me: https://linktr.ee/dimasm93

Untuk mendukung channel ini, mau donasi: via https://saweria.co/DimasMaryanto Terimakasih ya!
#udemy #database #ordbms #postgresql

TOC:
00:00:00 Introduction
00:01:22 What is SQL
00:10:35 Aturan penulisan SQL di PostgreSQL
00:17:02 Macam-Macam tipe data
00:23:50 What is Object table and schema
00:29:46 Overview Basic SQL of Select Statements
00:31:35 Format penulisan select statement
00:35:10 Query select all from a table
00:40:38 Query select specific columns from a table
00:45:18 Query assign alias to column
00:51:53 Query escape characters
00:59:41 Query using comment and documentation on sql
01:04:11 Query eliminate duplicate rows
01:10:22 Overview of build-in SQL operators
01:11:51 Operators mathematical
01:23:55 Operator concatnation
01:28:01 Operator data type casting
01:36:53 Operator logical
01:41:05 Operator comparison
01:53:07 Overview of build-in SQL Functions
01:55:03 Function for string operation
02:02:50 Function for math operation
02:09:12 Function for date and time operation
02:16:29 Function for handle null value
02:21:44 Function data formating
02:32:28 Overview filter data using where clause
02:36:36 where clause dengan relational predicate
02:43:47 where clause dengan like predicates
02:50:54 where clause dengan between predicates
02:58:12 Where clause dengan null predicates
03:01:11 where clause dengan logical predicates
03:10:47 where clause dengan RegEx predicates
03:20:43 where clause dengan array predicates
03:30:40 Overview sorting a resultset
03:32:06 Order by clause basic usage
03:37:27 Order by clause of the sort expressions
03:44:16 Order by clause for Sort multiple columns
03:48:19 Order by position of null value
03:53:00 Overview limit and offset clause
03:54:09 Pagination limit clause
04:00:04 Pagination offset clause
04:03:16 Pagination limit and offset
04:07:00 Time is your practice part 1
04:09:44 Pembahasan latihan part 1
04:28:11 More advanced select statement
04:29:15 Overview of Single row and group functions
04:30:57 What is Single Row Function
04:37:58 What is Group Functions
04:46:16 Grouping set of Data using Group By clause
04:55:53 Filter data with having clause
05:02:17 Diff between where and having clause
05:09:33 Multiple group by with grouping sets
05:15:16 Overview of Joined tables
05:17:03 What is joined tables
05:20:35 Joined table using natural join
05:32:27 joined tables with cross-join
05:37:31 What is qualified join
05:41:00 Using qualified join with INNER JOIN
05:50:11 Using qualified join with LEFT RIGHT OUTER JOIN
05:57:47 Using qualified join with FULL OUTER JOIN
06:02:38 Using qualified join for self join
06:08:09 The join_condition expressions
06:14:50 Overview queries inside query
06:16:33 What is subquery
06:21:02 Using SubQuery specified in column_list
06:29:22 Correlate SubQuery
06:37:35 Using SubQuery inline view
06:44:05 Using lateral subquery
06:52:59 Using SubQuery as predicates
07:02:00 Using subquery as predicate with single-row comparison
07:11:59 Using SubQuery as predicate with EXISTS Operator
07:18:47 Using SubQuery as predicate with IN operator
07:29:42 Using SubQuery as predicate with ANY-SOME operator
07:40:30 Using SubQuery as predicate with ALL operator
07:49:39 Overview Condition expression
07:50:50 What is Conditional Expression
07:53:39 Using basic CASE-WHEN expression
07:58:42 Using CASE-WHEN-ELSE expression
08:05:54 Using Nested CASE-WHEN expression
08:11:52 Using CASE-WHEN expression in WHERE clause
08:19:21 Materi selanjutnya