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

Let's Join Us

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