PostgreSQL: PostgreSQL Tutorial Full Course 2022
I wrote a Techno-Thriller called Whispers if you're interested: https://amzn.to/4cfdtNW I'd greatly appreciate a review for it if you have time. I provide here in this PostgreSQL tutorial a full course you can use to master PostgreSQL. Postgres is an object relational database that is just as fast as MySQL that adheres more closely to SQL standards and excels at concurrency. Postgres is also superior at avoiding data corruption. Postgres also provides more advanced data types and allows for the creation of custom types, operators and index types. Postgres is normally the best option when
Module 1: Database Fundamentals and Table Creation
- ▶Intro
- ▶What is a Database
- ▶Change Database Theme
- ▶Design a Database
- ▶Turn Invoice into a Database
- ▶Make a Table
- ▶Data Types
- ▶Adding Data to Table
Module 2: Table Relationships and Data Integrity
- ▶To See Data
- ▶Create Custom Type
- ▶Change Column Data Type
- ▶Thinking About Tables
- ▶Breaking Up Tables
- ▶Primary & Foreign Keys
- ▶Foreign & Primary Keys
Module 3: Data Retrieval and Querying
- ▶Getting Data from One Table
- ▶Conditional Operators
- ▶Logical Operators
- ▶Order By
- ▶Limit
- ▶GROUP BY
- ▶Distinct
- ▶Getting Data from Multiple Tables
Module 4: Advanced Query Techniques
- ▶Arithmetic Operators
- ▶Outer Joins
- ▶Cross Joins
- ▶Unions
- ▶Extract
- ▶IS NULL
- ▶GROUP BY
- ▶HAVING
Module 5: Functions and Views
- ▶AGGREGATE FUNCTIONS
- ▶WORKING WITH VIEWS
- ▶SQL Functions
- ▶Dollar Quotes
- ▶Functions that Return Void
- ▶Get Maximum Product Price
- ▶Get Total Value of Inventory
- ▶Named Parameters
Module 6: PL/pgSQL Programming
- ▶Return a Row / Composite
- ▶Get Multiple Rows
- ▶PL/pgSQL
- ▶Variables in Functions
- ▶Store Rows in Variables
- ▶IN INOUT and OUT
- ▶Using Multiple Outs
- ▶Return Query Results
Module 7: Control Structures and Loops
- ▶IF ELSEIF and ELSE
- ▶CASE Statement
- ▶Loop Statement
- ▶FOR LOOP
- ▶Result Sets, Blocks & Raise Notice
- ▶For Each and Arrays
- ▶While Loop
- ▶Continue
Module 8: Advanced Database Features
- ▶Stored Procedures
- ▶Triggers
- ▶Cursors
- ▶Installation
