← All modules
PostgreSQL

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

59 lessons3 hr 42 minQuiz + certificate

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