Главная
Study mode:
on
1
Intro
2
Why Use Postgres?
3
What is a Database
4
Change Database Theme
5
Create a Database
6
Design a Database
7
Turn Invoice into a Database
8
Make a Table
9
Data Types
10
Adding Data to Table
11
To See Data
12
SELECT
13
Create Custom Type
14
Change Column Data Type
15
Thinking About Tables
16
Breaking Up Tables
17
Primary & Foreign Keys
18
Foreign & Primary Keys
19
Altering Tables Many Examples
20
Getting Data from One Table
21
Where
22
Conditional Operators
23
Logical Operators
24
Order By
25
Limit
26
GROUP BY
27
Distinct
28
Getting Data from Multiple Tables
29
Inner Join
30
Join 3 Tables
31
Arithmetic Operators
32
Join with Where
33
Outer Joins
34
Cross Joins
35
Unions
36
Extract
37
IS NULL
38
SIMILAR LIKE & ~
39
GROUP BY
40
HAVING
41
AGGREGATE FUNCTIONS
42
WORKING WITH VIEWS
43
SQL Functions
44
Dollar Quotes
45
Functions that Return Void
46
Get Maximum Product Price
47
Get Total Value of Inventory
48
Get Number of Customers
49
Named Parameters
50
Return a Row / Composite
51
Get Multiple Rows
52
PL/pgSQL
53
Variables in Functions
54
Store Rows in Variables
55
IN INOUT and OUT
56
Using Multiple Outs
57
Return Query Results
58
IF ELSEIF and ELSE
59
CASE Statement
60
Loop Statement
61
FOR LOOP
62
Result Sets, Blocks & Raise Notice
63
For Each and Arrays
64
While Loop
65
Continue
66
Stored Procedures
67
Triggers
68
Cursors
69
Installation
Description:
Learn PostgreSQL from the ground up in this comprehensive tutorial. Dive into database fundamentals, design principles, and advanced features of PostgreSQL. Create and manipulate tables, master data types, and execute complex queries. Explore joins, views, functions, and PL/pgSQL for powerful database programming. Discover how to optimize performance with indexing, triggers, and stored procedures. Gain hands-on experience with practical examples and real-world scenarios. By the end of this course, develop the skills to design, implement, and manage robust PostgreSQL databases for various applications.

PostgreSQL Tutorial Full Course

Derek Banas
Add to list
#Programming #Databases #Relational Databases #PostgreSQL #Data Science #Data Analysis #Domain-Specific Languages (DSL) #SQL #Database Design #Computer Science #Database Management #Stored Procedures
0:00 / 0:00
1 of 69

Intro