PostgreSQL: From Beginner to Intermediate

سرفصل های دوره

Learn Database and SQL From Zero to Intermediate, Become Able to Create a Whole Database From Scratch by Coding ONLY!

1. Getting Started

1. Course Introduction

2. Introduction to Database

3. Relational VS Non-Relational Databases

4. Relational Database Management Systems (RDBMS)

5. Introduction to SQL

2. Necessary Softwares (DownloadInstallation)

1. Important Note

2. PostgreSQL Download and Installation

3. How to Initiate PostgreSQL in Command Prompt

4. Ubuntu Download and Installation (Optional)

5. PostgreSQL Package in Ubuntu (Optional)

3. SQL Data Defination Language

1. CREATE DATABASE

2. CREATE TABLE

3. CREATE USER

4. SQL Constraints

5.1 Data Types.pdf

5. Data Types in PostgreSQL

6. DDL Practice Test.html

7. Practice Test 1

8. DROP

9. DROP USER

10. TRUNCATE

11. ALTER

4. SQL Data Control Language

1. GRANT

2. REVOKE

3. DCL Practice Test.html

4. Practice Test 2

5. SQL Data Manipulation Language

1. INSERT

2. DELETE

3. DROP - TRUNCATE - DELETE Summary

4. UPDATE

5. SELECT

6. Practice Test 3

7. ALIAS

8.1 Operators.pdf

8. Operators

9.1 Comparison Operators.pdf

9. Compraison Operators

10. ORDER BY

11.1 Aggregate Functions.docx

11. Aggregate Functions

12. DISTINCT

13. LIMIT

14. GROUP BY and HAVING

15. JOINS INTUITION

16. INNER JOIN

17. OUTER JOIN (Left, Right and Full)

18. CREATE VIEW

6. Coding Exercises

1. Coding Exercise 1.html

2. Coding Exercise 2.html

3. Coding Exercise 3.html

4. Coding Exercise 4.html

5. Coding Exercise 5.html

6. Coding Exercise 6.html

7. Coding Exercise 7.html

8. Coding Exercise 8.html

9. Coding Exercise 9.html

10. Coding Exercise 10.html

11. Coding Exercises Solutions.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training