SKuP ROG#7 SQL And PostGresSQL for Beginners – Ilham Hizbuloh

Haiiii Sobat ADT

Hallo semuanya… Dikesempatan kali ini Ilham akan Share semua materi yg ada di mata kuliah kedua ilham yaitu; SQL And PostGresSQL for Beginners. Dengan Output Batch kedua yaitu Indonesian Translation. Jadi dibawah ini akan ada Table yang berisikan materi materi yang ada di Mata Kuliah ini, juga ada Kolom Output yang berisikan RDocs yang bisa kalian akses.

Sebelum Masuk ke Tablenya, ilham mau sedikit jelasin tentang MataKuliah ini. 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 materi lengkapnya bisa kalian cek Table dibawah ini yaaaa…

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

0 0 vote

Article Rating

Ilham Hizbuloh

0 Comments

Inline Feedbacks

View all comments

SKuP ROG#7 SQL And PostGresSQL for Beginners – Ilham Hizbuloh

SKuP ROG#7 SQL And PostGresSQL for Beginners – Ilham Hizbuloh

Recent Comments