SKup ROG#2 SQL And PostgreSQL for Beginners – Sabda Maulana

Let's Join Us

SKup ROG#2 SQL And PostgreSQL for Beginners – Sabda Maulana

Hallo Semua ^_^

Pekenalkan nama saya Sabda Maulana, biasa dipanggil sabda, lahir pada 07 Januari 2002. Sabda saat ini sedang mengikuti program ADT yang dimana sabda akan dikasih sebuah materi tambahan dan sabda harus selesaikan dalam output dan batas waktu yang sudah ditentukan.
Kali ini Sabda akan share kepada kalian semua Materi SQL & PostgreSQL For Beginners
Apa itu SQL? SQL adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional. sedangkan PostgreSQL adalah  sebuah
sistem basis data yang disebarluaskan secara bebas menurut Perjanjian lisensi BSD. Peranti lunak ini merupakan salah satu basis data yang paling
banyak digunakan saat ini, selain MySQL dan Oracle
Untuk mengetahui lebih lanjut apa saja pembahasan yang ada pada materi SQL & PostgreSQL For Beginners kalian semua bisa melihat daftar materi beserta materinya itu sendiri pada table dibawah ini…..

 

Section
Materi
Output
1.1
Course Introduction(section 1) Video

RDocs

2.1 What is a Database?
2.2
Relational Databases and SQL
2.3 Installing PostgreSQL
3.1
Section Introduction(section 3)
3.2 Database Tables
3.3
Data Types Explained
3.4 Primary Keys and Foreign Keys
3.5
Unique, Not Null, and Check Constraints
3.6  Creating Our First Table
3.7
Creating the Actors Table
3.8 Creating a Table with a Foreign Key
3.9
Creating the Movie Revenues Table
3.10 Creating a Junction Table
3.11
Modifying Tables Part 1: Adding Columns
3.12 Modifying Tables Part 2: Changing a Columns Data Type
3.13
Deleting Tables from a Database
3.14 Challenge: Data Definition Language
3.15
Solution: Data Definition Language
3.16 Section Summary(section 3)
4.1
Section Introduction(section 4)
4.2 Inserting Data into a Table
4.3
Updating Data in a Table
4.4 Deleting Data from a Table
4.5
Inserting Data into Our Movie Data Database
4.6 Challenge: Data Manipulation Language
4.7
Solution: Data Manipulation Language
4.8 Section Summary (section 4)
5.1
Section Introduction (section 5)
5.2 Select Queries
5.3
Where Clauses
5.4 Logical Operators
5.5
Challenge 1: Select Queries
5.6 Solution 1: Select Queries
5.7
In, Not In
5.8 Like
5.9
Between
5.10 Challenge 2: Select Queries
5.11
Solution 2: Select Queries
5.12 Order By
5.13
Limiting the Number of Results
5.14 Fetch
5.15
Distinct Values
5.16 Challenge 3: Select Queries
5.17
Solution 3: Select Queries
5.18 Null Values
5.19
Setting a Column Name Alias
5.20 Concatenation
5.21
Challenge 4: Select Queries
5.22 Solution 4: Select Queries
5.23
Section Summary (section 5)
6.1 Section Introduction (section 6)
6.2
Aggregate Functions Explained
6.3 Count Aggregate Functions
6.4
Sum Aggregate Function
6.5 Min and Max Aggregate Functions
6.6
Average Aggregate Functions
6.7 Challenge 1: Aggregate Functions
6.8
Solution 1: Aggregate Functions
6.9 Grouping Data
6.10
Having Clauses
6.11 Challenge 2: Aggregate Functions
6.12
Solution 2: Aggregate Functions
6.13 Mathematical Operators
6.14
Section Summary(section 6)
7.1 Section Introduction(section 7)
7.2
What Are Database Relationships?
7.3 One to One Relationships
7.4
One to Many Relationships
7.5 Many to Many Relationships
7.6
(Optional) Challenge: Database Relationships
7.7 Solution: Database Relationships
7.8
Section Summary (section 7)
8.1 Section Introduction (section 8)
8.2
SQL Joins Explained
8.3 Inner Joins Part 1
8.4
Inner Joins Part 2
8.5 Inner Joins Part 3
8.6
Challenge 1: Joins
8.7 Solution 1: Joins
8.8
Left Joins
8.9 Right Joins
8.10
Full Joins
8.11 Challenge 2: Joins
8.12
Solutions 2: Joins
8.13 Joining More Than Two Tables
8.14
Challenge 3: Joins
8.15 Solution 3: Joins
8.16
Union
8.17 Union All
8.18
Challenge 4: Joins
8.19 Solution 4: Joins
8.20
Intersect
8.21 Except
8.22
Challenge 5: Joins
8.23 Solution 5: Joins
8.24
Section Summary. (section 8)
9.1 Section Introduction(section 9) Video

RDocs

9.2 Subqueries Explained Video

RDocs

9.3 Uncorrelated Subqueries Part 1
9.4
Uncorrelated Subqueries Part 2
9.5 Challenge 1: Subqueries
9.6
Solution 1: Subqueries
9.7 Correlated Subqueries
9.8
Challenge 2: Subqueries
9.9 Solution 2: Subqueries
9.10
Summary

 

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x